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

929 Cr 300
Hamilton, TX 76531

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 4
Baths: 5
Status: Active
SqFt: 3040
Agency: Davidson Craig Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 1993
Notes: This beautiful family home sits on 3.631 Acres at the dead end of CR 300, just outside of Hamilton. The location could not be better! Your property also backs up to the Hamilton City Lake, so the seclusion is unmatched. You will also see an abundance of wildlife in this area. The home features 4 bedrooms and 4 full bathrooms, as well as a half bath downstairs for guests. The home also has a secondary living area, perfect for the kids to hang out. The home has a very welcoming feeling from the moment you walk through the door, and this continues throughout. The primary bedroom is located on the bottom floor, as well as another bedroom with attached bathroom. The primary bathroom is spacious and features a soaking tub, separate shower, and dual walk in closets. There is also a laundry area downstairs, and a laundry area upstairs so you don't have to haul baskets up and down the stairs. Upstairs has a bedroom with walk-in closet and bathroom on either side of the stairs, as well as a nice sized storage closet. Outside you are welcomed by the beautiful pool and patio area, perfect for entertaining. The oversized double carport has a basketball goal mounted underneath, with a half court painted on the concrete. Let the kids play basketball, no matter what the weather is doing. At the front of this area is a small storage space, or it could be used as a man cave area, as well as a workshop area. The attic of this space is all decked out for storage. Also outside is another outbuilding that is currently used to house chickens in one portion, as a stall area for a horse, and lawnmower/ATV storage. This space has so many options. This entire property is set up and ready to go...add your touches and make it your own!
MlsNumber: 11186315


Listing Provided By: Davidson Craig Real Estate, original listing
Name: Davidson Craig Real Estate
Phone: (254) 386-6812
Office Name: Davidson Craig Real Estate
Office Phone: (254) 386-6812
Agent Name: Juliann Watson
Disclaimer: Copyright © 2024 My State 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