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

3117 Fm-1238
Iredell, TX 76649
Heidi Olsen with BROOKS LAND GALLERY, INC., original listing - (254) 965-5051

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $795,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1800 Square Feet
Agency: BROOKS LAND GALLERY, INC.
Agency Phone: (254) 965-5051

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 37 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 2015
Notes: Looking for a serene country setting and magnificent views? Kickstart your day with coffee on the porch, overlooking your fenced and cross fenced 37 acres of lightly rolling hills, gorgeous green grass and friendly grazing cows, and then complete your day with the unbelievable sunsets highlighting the perfectly placed groves of trees, offering the peace and tranquility that beautiful Bosque County is known for. The efficient one-owner, 3-2 Rock and Metal Roofed home is ideal, from the stained concrete flooring to the high-pitched ceilings, large split bedrooms and closets, and the open floor plan from the spacious living room with wood burning fireplace, to the ample dining and kitchen with island and plentiful cabinetry. The laundry room has its own exterior access, with added storage and drip-dry areas. Back outside, the shop has just been added on to, complete with roll up door and decking for that much needed storage. There is enough covered parking for the biggest of families, with 5 carport spaces and one shop space, all flanked by a circle drive for added convenience. This home is truly a dream setting, just a few miles from charming, small-town Iredell TX but not so far from Hico, Meridian, Stephenville and Waco for those weekly shopping trips and then fast and complete escape of that city life. Hurry with this one!
MlsNumber: --
ListingId: 20912088


Listing Provided By: BROOKS LAND GALLERY, INC., original listing
Phone: (254) 965-5051
Office Phone: (254) 965-5051
Agent Name: Heidi Olsen
Disclaimer: Copyright © 2025 North Texas Real Estate Information Systems, Inc. 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