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

406 Cr 2600
Lometa, TX 76853

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 4
Baths: 3
Status: Active
SqFt: 4133
Agency: Coldwell Banker United REALTOR

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential
Year Built: 1999
Notes: "House back on the market - Due to buyer's personal emergency, this lovely home is available for sale again. Don't miss this opportunity!" Lone Oak Ranch! Embraced by a majestic live oak that graces the property, this estate spans over 50 acres and showcases a stunning custom-built brick home encompassing approximately 4,133 square feet. The residence comprises 4 bedrooms, 2 full bathrooms, 1 half bathroom, 2 expansive living areas, 2 dining areas, a private flex space, 2 charming, covered porches, wide hallways, and grand doorways. The expansive primary suite is a retreat, featuring dual bathroom entrances, 3 generous walk-in closets, 2 elongated separate vanities, and direct access to the rear porch. Each bedroom offers ample space and comfort. The second bedroom boasts 2 walk-in closets and a Jack and Jill bathroom with dual sinks leading to the third bedroom with its own walk-in closet. The fourth bedroom is ideal for guests. Additionally, a versatile flex space or gym with an external entrance can also be accessed through the garage. Step outside onto the generous covered porches and soak in the picturesque country views. The property also includes a detached two-car garage and a large shed. Conveniently located 15 minutes from Lampasas HEB and 75 minutes from Cedar Park. The property is available as a package with either the house and 20 acres for $525,000 or the house and the full 50 acres for $725,000. Experience the tranquility and luxury of Lone Oak Ranch – your slice of country living awaits! **PROPERTY HAS AG EXEMPTION IN PLACE!** *** BUYERS CHOICE - SELLERS ARE OFFERING $10,000 -REDUCE THE PRICE, PAY TOWARDS CLOSING COSTS OR BUY DOWN INTEREST RATE *** BRING OFFERS
MlsNumber: 485210


Listing Provided By: Coldwell Banker United REALTOR, original listing
Name: Coldwell Banker United REALTOR
Phone: (254) 200-3800
Office Name: Coldwell Banker Realty
Office Phone: (254) 200-3800
Agent Name: Connie Wood
Disclaimer: Copyright © 2024 Central Texas Multiple Listing Service. 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