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

19252 County Road 377
Marquez, TX 77865

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $400,000
Beds: 4
Baths: 2
Status: Active
SqFt: 1802
Agency: Keller Williams Brazos Valley

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2016
Notes: Reel in Your Dream Home!<br /> This stunning custom-built stone home (by American Classic in 2016) is your chance to live your lake life dreams. Nestled in the peaceful Lakewood Shores community of Marquez, TX, this hidden gem offers the perfect blend of relaxation and world-class fishing.<br /> <br /> This home boasts a spacious 1,802 square feet, with 4 bedrooms, 2 bathrooms, and an open-concept living and dining area – perfect for entertaining family and friends. Unwind by the cozy wood-burning fireplace on chilly evenings, or enjoy the peace and quiet of the surrounding woods on your back porch. This home is built for year-round comfort with spray foam insulation, and even has a head start on your gardening dreams with a garden already in progress! Privacy seekers will love the seclusion offered by the mature trees, while the stone exterior adds a touch of rustic charm. <br /> <br /> But wait, there’s more! Imagine casting a line from the private community park or launching your boat from the community boat ramp, just minutes from your doorstep. Lake Limestone is an off-the-beaten-path anglers paradise which means less competition and more time reeling in the big ones! Crappie and white bass can be found in the spring, making this lake a dream come true for fishermen. <br /> <br /> This hidden gem won't last long, so contact us today to schedule a showing and start living your lake life dream! Want more space? The neighbors are selling their adjoining lots too! Give us a call for more information.
MlsNumber: 24007003


Listing Provided By: Keller Williams Brazos Valley, original listing
Name: Keller Williams Brazos Valley
Phone: (979) 693-9100
Office Name: Keller Williams Realty B/V
Office Phone: (979) 693-9100
Agent Name: James Hammond
Disclaimer: Copyright © 2024 Bryan-College Station Regional MLS. 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