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 = 2596 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 = 2596 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 = 2596 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;

2103 Fm 1965
Lagrange, TX 78945

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,750,000
Beds: 4
Baths: 5
Status: Active
SqFt: 4965
Agency: Phillips & Associates Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 56 acre(s)
Property Type: Residential
Year Built: 2019
Notes: Country living with exceptional property amenities, all in a peaceful and private setting. This spectacular, custom built Hill County style home is located on 56 partially wooded acres and features panoramic hilltop views and exceptional privacy. (There are too many upgrades and improvements for this space. Call for a complete list.) Located between Weimar and La Grange, and centrally located between Austin, San Antonio, and Houston with short drives to big city amenities. Built in 2019, this home was designed for family gatherings and entertaining. The open family room features high ceilings, expansive windows and an impressive stone fireplace with built ins. The kitchen has custom cabinets with Quartz countertops, KitchenAid appliances, large island with farm sink and eating area. Adjoining the kitchen is a wine closet and butlers' panty, large mud room and laundry room. Beautiful, relaxing view of the Fayette County valley from the expansive, covered back porch. Two first level bedrooms each feature an adjoining full bath and large closets. Also, a home office located on the first level offers a work from home environment. An elegant, curved staircase takes you to an upstairs bedroom with full bath and an amazing theater room, equipped with projector, screen, high-end sound system and lighting. Walk across the open balcony and take in a fantastic view of your property before entering the owner's suite, featuring a large bedroom with cove ceiling, large his and hers walk-in closets and a spa like bath. The bath has dual vanities, free standing soaking tub, and a large shower with a rain shower head feature and two benches. A covered breezeway takes you to an oversized three car garage with a large, parking pad. A game/exercise room with a half bath is located on the backside of the garage. Approximately one acre around the house is fenced and completely sodded with St. Augustine grass and is fully irrigated with an automated sprinkler system. A propane powered backup generator supplies power to essential parts of the house in the event of a long-term power outage. Also located on the property are a water well, two barns and a small farm pond. This county estate must be seen to be fully appreciated!
MlsNumber: 1668906


Listing Provided By: Phillips & Associates Realty, original listing
Name: Phillips & Associates Realty
Phone: (210) 571-0330
Office Name: Phillips & Associates Realty
Office Phone: (210) 571-0330
Agent Name: Allan Anders
Disclaimer: Copyright © 2024 San Antonio Board of Realtors ®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App