My choice is Villa Boheme, or Casa Ensenada. Both are waterfront, but still need to get a vehicle for the beach.
The ones closest to the beach, are Tamarindo Estates, or Culebra Beach Villas.
You may look for more info under lodging or shelter in this forum.