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

3809 Farm To Market Road 390 N
Brenham, TX 77833
Susan Kiel with MARKET REALTY, INC., original listing - (979) 836-9600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,950,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5290 Square Feet
Agency: MARKET REALTY, INC.
Agency Phone: (979) 836-9600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 37 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 2004
Notes: COMING SOON!! Showings to start on May 1, 2024. Glenmeadow is an impressive 37+ acre property located on The historic ?Texas Independence Trail?, FM 390, conveniently located 15 minutes from Brenham and 20 minutes from Navasota. The driveway meanders to a peaceful setting with many gorgeous trees and rolling scenic views. It is everything that is beautiful about Washington County, the birthplace of Texas. Custom built home with 5,240 SF of living area and amazing 1,700 SF of porches, with oversized 3 car garage. Beautiful Austin stone exterior with standing seam metal roof. Custom mahogany wood doors throughout with lots of built ins, wood trimmed windows and custom classic design touches. The foyer welcomes you into a grand space with living, music and sitting areas with high ceilings. Enjoy the hand-crafted fireplace year-round in this amazing space. Gourmet kitchen with gorgeous cherrywood, Italian tile backsplash, granite island, 6 burner commercial cooktop, subzero refrigerator, double oven, huge walk-in pantry and more. The gallery area with lovely window seats guides you to the expansive primary suite. The primary bedroom also has a custom-built fireplace and double ceiling fans. Spa like primary bathroom with extra-large jacuzzi tub, shower cave and double vanities. Study has custom built bookcases and coffee bar area with refrigerator and sink. Large utility room has 2 dryers, washer, and cabinets. Mud room has dog wash area and a wall of cabinets for all your storage needs. So many custom features in this home including California Closet Designed Primary Closet and Kitchen Pantry. Outside the beauty continues with pastoral views of the rolling topography, pond with fishing pier and irrigated pecan orchard. The 1,100 SF guest house is perfect for family and friends to have their own private space while visiting. Everyone will gather to enjoy the extra-large family style pool with waterfall and covered porches. The horse enthusiast will appreciate the concrete block horse barn with custom cedar sliding doors and dividers. The four stalls have automatic waterers and separate fenced paddocks. The tack room comes equipped with a rotating saddle wall to the alleyway for easy access when saddling your horse. Also included in the barn is a separate storage area for all your equipment and tools. The pastures are fenced and crossed fence with water troughs to each. Property has 2 water wells and community water in place ready for use. Glenmeadow is a property that has it all! Don?t miss your opportunity to live the country dream.
MlsNumber: --
ListingId: 146498


Listing Provided By: MARKET REALTY, INC., original listing
Phone: (979) 251-4078
Office Phone: (979) 836-9600
Agent Name: Susan Kiel
Disclaimer: Copyright © 2024 South Central Texas 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.


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 = 2760 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;
Chris Cernosek
ASCIICentex Realty Services
Call Today!: (979) 966-2597

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App