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

556 Cliff View Loop
Harper, TX 78631
Nychole Fung with Keller Williams - Austin SW, original listing - (512) 448-4111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,649,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: 8384 Square Feet
Agency: Keller Williams - Austin SW
Agency Phone: (512) 448-4111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Opportunity Still Awaits!! In The Heart of TX Hill Country, within the prestigious Maverick community, lies a luxurious lakeside 8,384sqft ranch home. Perfectly situated between the historic towns of Fredericksburg & Kerrville, this property offers the ideal blend of country solitude with easy access to urban conveniences, vibrant local culture,& renowned wineries. The Lake House: surrounded by 21.14acres of mature live oaks, live water, exotic wildlife, and rolling terrain, this unique 3-story 5bed 6bath Ranch Home with Guest House, sits hilltop with an expansive wrap-around deck overlooking its private lake with mile-long creek views. 2 spring-fed converging live water creeks, Klein & Stevens, intersect home-front where a large concrete dam gives this property a beautiful year-around lake. Maverick community enriches living with high-end amenities including: High-fenced perimeter & grand gated entrance, diverse exotic wildlife, On-site groundskeeping, high-speed fiber, underground utilities. 7miles paved roads, Resort-style clubhouse, pool, pavilion area, & entertainment area. Sports enthusiasts will appreciate the BB & pickleball courts, while the Naturalist enjoys expansive green spaces & hiking trails leading the scenic Overlook. The kids are sure to be found at the famous live water Blue Hole or creek bottom exploring. Home itself marries architectural elegance with functional luxury. Cathedral ceilings, grand stone fireplaces, floor-to-ceiling windows, gourmet kitchen equipped with top-tier appliances, and the dual master suites provide sumptuous privacy. Property also features a guest house, an equestrian barn, workshop, and garage. This estate is not just a home but a lifestyle, offering an unparalleled blend of rural tranquility & luxury amenities.Updates: New Paint, Decking, & many restorations.
MlsNumber: --
ListingId: 5422365


Listing Provided By: Keller Williams - Austin SW, original listing
Phone: (214) 240-2473
Office Phone: (512) 448-4111
Agent Name: Nychole Fung
Disclaimer: Copyright © 2024 Keller Williams Realty, 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