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

1447 Lcr 760 Road
Groesbeck, TX 76642

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $629,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1382
Agency: Twin Bends, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 32 acre(s)
Property Type: Residential
Year Built: 1976
Notes: Hilltop Ranch is a charming property located in rural Limestone County. It features a beautiful farmhouse that has been meticulously cared for and loved. The house itself is a 3-bedroom, 2-bathroom home with a closed-in back porch. Recent updates include a new AC/Heating system and a new metal roof, ensuring that the house is in great shape and move-in ready.<br /> The ranch also offers several outbuildings and amenities that make it an ideal property for various purposes. There is a spacious 60 x 40 shop with 14-foot walls, two 12-foot roll-up doors, and an insulated roof, providing ample space for storage or workshop activities. Additionally, a 20-foot covered carport, a patio, a dog kennel, and a covered metal gazebo are available for your convenience and enjoyment.<br /> For livestock and equipment needs, the property boasts a 40 x 30 barn with a covered loafing area, perfect for housing your animals and machinery. There is also a working pen and a spring-fed stock tank that has never gone dry, ensuring a reliable water source for your animals.<br /> The landscape of Hilltop Ranch is adorned with large mature pecan trees and fruit trees, adding natural beauty and shade to the surroundings. The property is fully fenced and cross-fenced, in excellent condition, and even features a metal fence around the house for added security for small pets. The improved grass, specifically Coastal Bermuda, is currently in hay production, offering an opportunity for agricultural activities or simply enjoying the lush green fields.<br /> If 32 acres of land isn't enough, there is an option to acquire additional acreage, allowing you to expand your property further.<br /> One of the standout features of Hilltop Ranch is its peaceful and tranquil setting. The secluded location provides a quiet retreat, and the breathtaking sunrises and sunsets add to the overall beauty and serenity of the property.<br /> In summary, Hilltop Ranch offers a well-maintained farmhouse, various outbuildings, ample amenities, beautiful surroundings, and the potential for additional acreage. It is an idyllic place to call home, embrace a rural lifestyle, or create a peaceful getaway.
MlsNumber: 216617


Listing Provided By: Twin Bends, LLC, original listing
Name: Twin Bends, LLC
Phone: (254) 723-1248
Office Name: Twin Bends, LLC
Office Phone: (254) 723-1248
Agent Name: Bryan Cross
Disclaimer: Copyright © 2024 Waco 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App