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

1547 Fm 574 W
Mullin, TX 76864
Debra Prescott with GEORGIA DEEDS REAL ESTATE, original listing - (325) 648-2700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,525,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: GEORGIA DEEDS REAL ESTATE
Agency Phone: (325) 648-2700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 156 acre(s)
Property Type: Land-Ranch
Year Built: 1985
Notes: An outdoor paradise awaits you in western Mills County! This 156 acre property has it all with rolling hills, valleys, wet weather creek, various draws, and 4 ponds. The ponds hold well and still have water in spite of sparce run-off rain in the past few months. The rolling terrain has substantial cover consisting of a wide variety of oak trees, cedar, brush, and grasses. All of this meets the needs of the diverse array of wildlife which includes dove, turkey, whitetail deer, and 3 oryx. All of this combines to offer a hunter or recreationalist paradise! Property taxes are minimalized with a wildlife exemption in place. The property is easily traversed with good pasture roads throughout. The scenic and breathtaking views that envelop the property provide ample opportunity for relaxation and rejuvenation. <br /> The updated and cozy, farmhouse is nestled among the hills away from the paved road, offering peace and tranquility. Within the large fenced area with the house, there is also a guest house, shop with garage, and equipment barn. Built in 1985, the main house is just over 2,100 square feet of living space with updated amenities. The first floor has a cozy living area with unique wood ceilings, kitchen and dining room, spacious main suite with on-suite bath, a bonus room with vaulted ceiling that would be perfect for an office or additional bed room, washer and dryer connections, and .5 bath. Upstairs, you will find two other nice-sized guest bedrooms and a guest bathroom. The guest house has nearly 1,000 square feet of living area with open concept living, dining, and kitchen. The comfortable bedroom has an on-suite bathroom as well. <br /> There are two water wells on the property, one for the main house and guest house, and the other for the additional cabin with electricity toward the back of the property. Give us a call if you are ready to embrace the great outdoors and make this slice of paradise yours.
MlsNumber: --
ListingId: 20834089


Listing Provided By: GEORGIA DEEDS REAL ESTATE, original listing
Phone: (325) 451-0170
Office Phone: (325) 648-2700
Agent Name: Debra Prescott
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