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

3023 Ironwood Rd.
Gilmer, TX 75644
WENDY WEST with Coldwell Banker Lenhart-Gilmer, original listing - (903) 680-2400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,500,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3174 Square Feet
Agency: Coldwell Banker Lenhart-Gilmer
Agency Phone: (903) 680-2400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 56 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: 56+ acre Ranch, family owned since 1978! This beautiful, 3,174 square foot, 4 bedroom, 3 1/2 bath, two-story ranch house situated in the middle of this beautiful property with views of the 3 ponds. The kitchen has stainless-steel appliances. Lots of cabinets in the kitchen, bar/dining. Large walkin pantry with buffets and recesses lights, dining room with a full bar and sink. Living room has beautiful fireplace. Tons of large windows all through the home. Awesome Views looking out every window in the home. Master suite down stairs. Master bath has airjet tub and floor to ceiling tile walkin shower with 4 jets, rain shower and hand held shower, his and her closets with a gun room inside one. Guest bedroom suite downstairs with full bath and floor to ceiling tile walkin shower. Big laundry room with tons of cabinets and half bath. Upstairs are 2 bedrooms with jack-n-jill bathroom. Each room has its own vanity/sink area and share a floor to ceiling tile walk in shower. Large loft area for play area and overlooks living area. Walkin attic off of the loft that is partially floored. This Ranch has 3 large ponds and is currently separated into 3 pastures for cattle. Full working pens and head gate. Riding pen for horses and boxcar with 2 stalls attached used for barn. All TV's, appliances stay. Seller will negotiate estate contents and animals with sell. Currently have 22 head of cattle, 2 horses and 5 cattle dogs.
MlsNumber: --
ListingId: 20252313


Listing Provided By: Coldwell Banker Lenhart-Gilmer, original listing
Phone: (903) 790-2015
Office Phone: (903) 680-2400
Agent Name: WENDY WEST
Disclaimer: Copyright © 2025 Longview Area Association 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 = 2751 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;
Shelley Latham
ASCIIQuality Choice Solutions, LLC
Call Today!: (903) 985-6599

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App