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;

460 County Road 1010
Lampasas, TX 76550

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3246
Agency: Mossy Oak Properties of Texas

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 23 acre(s)
Property Type: Residential
Year Built: 2009
Notes: BREATHTAKING, best describes this amazing custom-built home nestled on 23 acres featuring some of the prettiest Post Oak Trees you will ever see. No exaggeration here, the iron gated entrance and long driveway takes you through a park-like setting up to the home that’s HGTV worthy. This exquisite property is located at the dead-end of CR 1010 offering amazing privacy. The owners spared no expense with upgraded features when constructing the home, including custom molding and trim; high-end light fixtures, beautiful custom-built cabinets and gorgeous stained concrete floors to name a few. Both the formal living and family room feature their own stone wood-burning fireplace that are perfect for entertaining family and friends. The fabulous kitchen features an oversized breakfast bar, decorative island and gorgeous Granite countertops. To impress even the most avid cooks, the kitchen also features plenty of cabinets and countertop space, stainless steel appliances and a large pantry. The master bedroom suite is split from the secondary bedrooms to allow privacy and features a massive walk-in closet. The master bathroom is on another level, with its oversized walk-in/out shower (with dual shower heads) separate custom vanities and elevated freestanding tub that is the perfect statement piece for this amazing room. The secondary bedrooms are also very spacious and offer oversized closets as well. The massive back patio is as good as it gets and offers fantastic hill country sunsets. But it doesn’t end there, it also features an open custom-stone patio that overlooks a breathtaking pool with an infinity hot tub, stone waterfall and large gazebo just perfect for summertime BBQ’s—truly a sanctuary! Other features of this amazing property include: high-end standing seam roof, oversized 3-car carport, multiple iron-fenced holding pens for farm animals and a 1200 sq ft insulated shop with an attached covered area for UTV and farm equipment storage and much much more!
MlsNumber: 538770


Listing Provided By: Mossy Oak Properties of Texas, original listing
Name: Mossy Oak Properties of Texas
Phone: (940) 781-8475
Office Name: Mossy Oak Properties of Texas
Office Phone: (512) 734-1204
Agent Name: Ronald Bumpus
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