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

885 Del Goehring Road
Yorktown, TX 78164

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $684,500
Beds: 3
Baths: 3
Status: Active
SqFt: 2487
Agency: Coldwell Banker D'Ann Harper, REALTORS®

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2020
Notes: Welcome to this stunning 10 acre country estate just outside of Yorktown, TX! Built in 2020, this custom-designed home offers modern comfort and rustic charm. Boasting 3 bedrooms and 2.5 bathrooms, with an office that could easily serve as a 4th bedroom, this property provides ample space for your family's needs. Step inside to discover an inviting open-concept layout, perfect for entertaining guests or relaxing with loved ones. The heart of the home features a spacious gourmet kitchen with custom cabinetry, granite tops, breakfast bar, and walk in pantry. The oversized living area features a beamed ceiling and 3 large picture windows that provide for great natural lighting. The split floorplan ensures privacy, with the primary bedroom featuring a great en suite bath with large walk-in shower, soaking tub, and double vanities. Don’t miss the Texas sized walk-in closet. Secondary bedrooms are connected with a jack and jill bath and both have walk in closets providing ample storage space. Outside, you'll find plenty of room to roam. Relax and unwind on the large front and back porches, where you can soak in the serene views of the surrounding countryside. The piped entrance and yard fencing provide a nice touch. This property offers the perfect blend of comfort, functionality, and outdoor space, making it an ideal place to call home. Don't miss your chance to make this picturesque retreat yours!
MlsNumber: 532465


Listing Provided By: Coldwell Banker D'Ann Harper, REALTORS®, original listing
Name: Coldwell Banker D'Ann Harper, REALTORS®
Phone: (210) 483-7004
Office Name: Coldwell Banker D'Ann Harper, REALTORS®
Office Phone: (210) 483-7004
Agent Name: The Zaplac Group
Disclaimer: Copyright © 2024 Central Texas Multiple Listing Service. 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