Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2644 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2644 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2644 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

Calle 20 Nte, Centro, Playa Del Carmen
Playa Del Carmen, TX 77720
Juan Moreno Valle with Engel & Völkers Playa del Carmen, original listing - (529) 841-3189 x79

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,227,500
Beds: 1
Baths: Full: 1
Status: Active
SqFt: 506 Square Feet
Agency: Engel & Völkers Playa del Carmen
Agency Phone: (529) 841-3189 x79

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Other-Apartment
Year Built: 2024
Notes: This project is characterized by the honesty in his architecture, the cleanliness of his facade and the comfort of his spaces. Your new dream home will make you remember the simplicity of life and the movement of waves. The need to return to escape to rest and disconnect from the daily routine.<br /> Located in the heart of the Riviera Maya in Quintana Roo, is a coastal paradise that combines the tranquility of the Caribbean with a vibrant and cosmopolitan lifestyle. This tourist enclave has become a top-tier Real Estate investment destination, offering exceptional properties with panoramic views of the turquoise sea and white sandy beaches.<br /> The modern infrastructure, coupled with lush natural beauty, creates an ideal environment for those seeking an unparalleled real estate investment.<br /> The development is situated in a premium location that blends the serenity of the Caribbean with the vibrant urban life. Just steps away from white sandy beaches and surrounded by the cosmopolitan energy of Fifth Avenue, this project offers an exclusive lifestyle that fuses elegance with convenience.<br /> Wake up each morning in a luxurious environment where attention to detail is reflected in every corner. This one-bedroom condominium features high-quality finishes and exceptional amenities that create a cozy and refined atmosphere. Enjoy the luxury of a home ready to inhabit from day one. Your new chapter begins with everything you need: Bookcase, fridge, electric grill, closets, Air conditioning, electric water heater and microwave. Also, the building features amenities such as reception, 24/7 security, gym, laundry, infinity pool, jacuzzi, sun deck, rooftop bar, coworking, hammock area and more.
MlsNumber: --
ListingId: AM-5051122


Listing Provided By: Engel & Völkers Playa del Carmen, original listing
Office Phone: (529) 841-3189 x79
Agent Name: Juan Moreno Valle
Disclaimer: Copyright © 2025 Engel & Völkers. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2644 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Susan Lewis
Susan Lewis
ASCIIADVANTAGE REAL ESTATE
Mobile: (409) 201-8100

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App