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 = 2441 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 2441 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 = 2441 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;

2 Lib. José Manuel Zavala
San Miguel De Allende, TN 37713
Turquesa Chipman with Engel & Völkers San Miguel de Allende, original listing - (524) 151-5459 x44

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,680,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 1728 Square Feet
Agency: Engel & Völkers San Miguel de Allende
Agency Phone: (524) 151-5459 x44

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Other-Condominium
Year Built: --
Notes: Perfect combination of luxury, confort and convenience<br /> This luxury condominium for sale is a dream home for anyone looking for a spacious living space to add your personal touch. Nestled within a cluster of homes, this 4 bedroom, 4 bathroom house offers everything your could ever want in a home. Located in the gated Residencial Tierra Adentro, within the cluster of Mineral de Valenciana, just across the road from Vista Antigua, and 2 min drive from Ventanas Golf Course.<br /> <br /> Upon entering the house, you are greeted with a well designed floor plan that seamlessly connects the living, dining, and kitchen areas, making it perfect for entertaining guests or spending quality time with family. The easy access from the kitchen, dining area to the outside patio/garden makes the indoor/outdoor living so accessible.<br /> <br /> The bedrooms are generously sized and boast ample natural light, creating a warm and inviting atmosphere. This home offers a bedroom on the main floor with a full bathroom, as you reach the second floor your principal bedroom with a private balcony terrace is situated, as well as a second guest bedroom with ensuite bathroom. On your third floor; you have the 4th bedroom, that could easily be an office space, a full bathroom is located just out the door. The rooftop terrace, equipped with a grill and a pergola; ready for the perfect climbing vine, has beautiful wrap around views.<br /> <br /> But it does not stop there. This condominium also comes with exclusive access to amenities such as a pool, paddle court, and a gym, providing endless options for leisure and recreation. And if that was not enough, the property offers views of the mountains and stunning sunsets which can be enjoyed from either the private balcony terrace or rooftop terrace.<br /> <br /> Overall, this house in the condominium for sale offers the perfect combination of luxury, confort and convenience, making it the ideal place to call home. Don’t miss out on this incredible opportunity to own your dream home in this quiet, secure, community.<br /> <br /> The price is of $5,680,000.00 mxn pesos. The exchange rate may vary
MlsNumber: --
ListingId: AM-5048756


Listing Provided By: Engel & Völkers San Miguel de Allende, original listing
Office Phone: (524) 151-5459 x44
Agent Name: Turquesa Chipman
Disclaimer: Copyright © 2024 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 = 2441 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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 Robert Tucker, Making Your Realty Dreams Reality
Robert Tucker, Making Your Realty Dreams Reality
ASCIIWeichert, Realtors - Tiger Real Estate
Call Today!: (865) 919-6831

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App