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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

186 High Sierra Drive
Exeter, CA 93221

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,298,000
Beds: 6
Baths: 5
Status: Pending
SqFt: 4852
Agency: The Equity Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1992
Notes: Situated within the highly desirable Badger Hill Estates in Exeter I present to you a nearly 5000 square foot overlooking the central valley palace. From an impressive elevation. The spectacular views of the valley's agricultural patchwork is a stunning art piece. The park like setting on this property will make you wonder why you would want to go anywhere else. With two, not one lot on Badger Hill Estates. As you enter this home you will be greeted by an expansive, two-story high living room. Windows and French doors overlook the upper and lower covered patios. Take a stroll down the steps leading to the oversize swimming pool. The formal dining room is perfect for dinner parties or enjoy a billiard table for nights of casual entertaining. The remodeled kitchen will leave you speechless. Featuring 9 pull outs, 2 under cabinet appliance lifts, and an enclosed coffee station. The kitchen is sleek and clean with maximum storage and easy access to the appliances you use everyday and on occasion. The cabinetry and storage are a chef's dream, and many will be envious. High end JennAir and Thermador appliances throughout. The bedrooms are large and each has an incredible view. Wake up to birdsong and bright, sunny spaces. With multiple bedroom's on both levels and office space, the number of amenities this palace offers is immense. Most of the bathrooms have a towel warmer for those cool evenings coming out to dry. And on those cool Mornings, just open those windows, turn on the whole house fans and take full advantage of the mountain breeze. The only true way to fully appreciate the grandeur of the home is for you to take a personal tour. The seller will also pay for one year of the Badger Hill Home Owner Association Dues at the close of escrow for the new owner. with an acceptable offer.
MlsNumber: 224728


Listing Provided By: The Equity Group, original listing
Name: The Equity Group
Phone: (559) 259-2036
Office Name: The Equity Group
Office Phone: (559) 732-0800
Agent Name: Carlos Aleman
Disclaimer: Copyright © 2024 Tulare County MLS. 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