Top Mexico Real Estate Facebook
Back to advent calendar
21 Puerto Aventuras

Puerto Aventuras

Hello!

Only 4 days left for Christmas and we are so thrilled to share our 21st surprise! This beautiful postcard of Puerto Aventuras, a gorgeous gated community in the Riviera Maya with some of the most stunning beaches.

Save this postcard and use it as a reminder of how calming the Caribbean sea can be!

Fill the form below to open your surprise!

By downloading this postcard, you agree to receive our newsletter. You can unsubscribe at any time. Check out our Privacy Policy.

Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''(1,6,3)')LIMIT 5' at line 1
SQL: SELECT prop_mls,prop_id,prop_rets_id,prop_price,prop_priceS,bedrooms,baths,prop_land,prop_name,prop_construction,city_name,area_name,prop_image,prop_style,prop_currency FROM Listing LEFT JOIN Cities ON Listing.prop_city=Cities.city_id LEFT JOIN Areas ON Cities.city_area=Areas.area_id WHERE (prop_city = 'city_id' and city_area = 'area_id' and area_id = '19' and prop_status in '(1,6,3)')LIMIT 5