SELECT p.*, p.id as propertyid, pl.propertylocation as location, pl.seo_name as location_url, pl.description as locationdesription FROM pm_properties p INNER JOIN pm_propertylocations pl on (p.propertylocation=pl.id) WHERE p.seo_name='casa-gennys' AND propertyshow=1 LIMIT 1 | Progreso, Yucatan Rentals

1
*click on the thumbnail to see larger image
Inquiry
*(denotes required field)

Bedrooms: , Bathrooms:

Bedding

Amenities

Nearby Attractions & Activities

Purchase a travel insurance and travel worry free. It has coverage for flight cancellations, medical services, medical assistance, reschedule of flights until the return home.
About Location

 

Rates

Season