Title Page Background
DEBUG FN args: Array ( [0] => 2226 [1] => [2] => [3] => agent ) BEFORE: Site: 2226 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2226 Igate: njhud LocID: 2226 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2226 AND i.igate IN ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2226 [1] => [2] => [3] => lender ) BEFORE: Site: 2226 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2226 Igate: njhud LocID: 2226 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2226 AND i.igate IN ('vahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2226 [1] => [2] => [3] => other ) BEFORE: Site: 2226 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2226 Igate: njhud LocID: 2226 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2226 AND i.igate IN ('vahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | All Cities

29x8+p6, Sin Nombre De Col 27, 97302 Mérida, Yuc., México
Mérida, OR 97302
Carla Mendiburu with Engel & Völkers Mexico City, original listing - (525) 520-6656 x88
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $5,741,197
Beds: 1
Baths: Full: 1, ½: 1
Status: Active
SqFt: 818 Square Feet
Agency: Engel & Völkers Mexico City
Agency Phone: (525) 520-6656 x88

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 0 sqft
Property Type: Other-Apartment
Year Built: --
Notes: Discover Light Towers by Pininfarina: A New Standard of Luxury in Mérida<br /> <br /> Located in the heart of Mérida, Light Towers by Pininfarina redefines the concept of exclusivity and avant-garde design. This luxury development merges architectural elegance with modern functionality, offering impeccably designed residences that capture the essence of well-being and sophistication.<br /> <br /> Each apartment is designed to maximize natural light and connection with the surroundings, thanks to floor-to-ceiling windows and spacious private terraces with spectacular views. With smart layouts and cutting-edge technology, these spaces elevate the living experience to another level. From one- to four-bedroom residences, Light Towers offers options that adapt to different lifestyles, always with the quality and exclusivity that define Pininfarina.<br /> <br /> Apartment 304 – Level 3<br /> Located on the third floor, this elegant residence offers 125.62 m² of total space, with 76 m² of interior construction. Designed for comfort and functionality, it features one bedroom, 1.5 bathrooms, a spacious living-dining area, a modern kitchen, and a laundry room. One of its standout features is the 50 m² corner terrace, which provides a seamless indoor-outdoor living experience and breathtaking views.<br /> <br /> <br /> Exclusive Amenities:<br /> <br /> PoolsAn oasis of tranquility designed for relaxation and recreation. Enjoy a refreshing swim, exercise with lap swimming, or unwind in an environment that seamlessly blends luxury and nature.<br /> <br /> Lounge & TerracesCarefully designed spaces offering uninterrupted views of the sky and surrounding landscape. Perfect for relaxing at sunset with a cocktail or hosting intimate gatherings with friends and family.<br /> <br /> Spa & Wellness CenterA sanctuary of well-being with a fully equipped gym, sauna, jacuzzi, and a selection of treatments designed to revitalize body and mind.<br /> <br /> Kids RoomA safe and stimulating environment that fosters creativity and learning for children, with areas designed for their entertainment and development.<br /> <br /> Coworking SpaceAn innovation and collaboration hub offering flexible spaces for meetings, networking, and professional events in an inspiring setting.<br /> <br /> Storage SpacesElegant and functional solutions to keep your home organized and clutter-free, maximizing harmony and efficiency in every space.<br /> <br /> Design & Sustainability<br /> <br /> Light Towers by Pininfarina stands out not only for its impeccable aesthetics but also for its commitment to sustainability. Natural materials, energy efficiency, and eco-friendly design come together to offer a conscious and forward-thinking lifestyle.<br /> <br /> Discover the unique experience of living at Light Towers by Pininfarina, where every detail is designed to provide maximum comfort, exclusivity, and connection with nature. Contact us to learn more about these exceptional residences.
MlsNumber: --
ListingId: AM-5068625


Listing Provided By: Engel & Völkers Mexico City, original listing
Office Phone: (525) 520-6656 x88
Agent Name: Carla Mendiburu
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => marion-south [3] => OR [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: marion-south State: OR Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: marion-south State: OR Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2226 AND i.igate IN ('vahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Tina Smith
Tina Smith
ASCIIColdwell Banker Professional Group
Call Today!: (971) 232-1444

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App