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='puesta-del-sol-apartments' AND propertyshow=1 LIMIT 1 | Progreso, Yucatan Rentals
Join us on facebook
Follow us on Twitter

1

    Warning: Invalid argument supplied for foreach() in /home/sanmi5/public_html/progresovacationrentals/_vacationrentals.php on line 187
*click on the thumbnail to see larger image
Promotions
Inquiry
Name:
Email:
Phone:
People (including childs):
Arrival Date:
Nights:
Comments:
Send Inquiry

Bedrooms: , Bathrooms:

Bedding


Warning: Invalid argument supplied for foreach() in /home/sanmi5/public_html/progresovacationrentals/_vacationrentals.php on line 335

Amenities


Warning: Invalid argument supplied for foreach() in /home/sanmi5/public_html/progresovacationrentals/_vacationrentals.php on line 358

* Satellite TV (English Channels) available. Order this service at the Online Store.
* High Speed Internet available upon request. Order this service at the Online Store.
* BBQ Rental available upon request.Order this service at the Online Store.
* CHEF Service available upon request.Order this service at the Online Store.

Nearby Attractions & Activities


Warning: Invalid argument supplied for foreach() in /home/sanmi5/public_html/progresovacationrentals/_vacationrentals.php on line 392

 

Rates


Warning: Invalid argument supplied for foreach() in /home/sanmi5/public_html/progresovacationrentals/_vacationrentals.php on line 435

Warning: Invalid argument supplied for foreach() in /home/sanmi5/public_html/progresovacationrentals/_vacationrentals.php on line 461
Season