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

Undefined Undefined
Villa Donato Guerra, IA 51045
Carla Mendiburu with Engel & Völkers Mexico City, original listing - (525) 520-6656 x88

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $11,500,000
Beds: --
Baths: --
Status: Active
SqFt: --
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: Land-Mixed Use
Year Built: --
Notes: LARES (from the Latin "Lar"), meaning home, is a wonderful and unique place, designed to be exclusive and family-friendly. In ancient Rome, the Lares were the gods of the hearth and the house, and that is where the inspiration to create this property comes from.<br /> Located in La Asunción, Donato Guerra, 20 minutes from Valle de Bravo, is a distinctive concept that presents ten small farms or properties on 10 hectares, completely enclosed by walls, with an additional ecological reserve of 400 hectares in a forest environment surrounded by nature, activities and a relaxed atmosphere.<br /> Being in Lares means immersing yourself in nature: springs, lakes, lush trees, mountain views, and the sound of birds.<br /> Its rustic style, complemented by the exquisite and tasteful concept of the development, allows you to imagine that you are in paradise.<br /> Site planning was chosen for its location, to consolidate various recreational activities in one location. There are options for all tastes, as it has an ATV track, mountain biking, jogging trail, zip line, stables, horses, riding track, saddles, equestrian track, and a camping area. In addition to all these activities, there are tennis, soccer and volleyball courts.<br /> It also seeks to provide ample social areas for family and friends to enjoy. The central element is a clubhouse called "EL JACALÓN", so called because it is open on one or more sides. This wonderful area features a bar, billiards, several living rooms, a dining area, a kitchen, and bathrooms. It is complemented by snack corners, entertainment venues, and traditional bonfires.<br /> This beautiful circular lot has great views, and you can start building soon and have the property of your dreams.<br /> LARES is a significant project, with a philosophy of enjoying your family and friends, sharing recreational activities, both collective and individual, and participating in social events. This uniqueness sets it apart. 
<br /> The proximity to Valle de Bravo allows you to add recreational activities, from restaurants and spas to sailing trips and water skiing to mention some of the wonderful offers that this magical town offers.<br /> 

MlsNumber: --
ListingId: AM-5044498


Listing Provided By: Engel & Völkers Mexico City, original listing
Office Phone: (525) 520-6656 x88
Agent Name: Carla Mendiburu
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 = 868 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App