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 = 241 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 241 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 241 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

16435 Goat Ranch Road
Springville, CA 93265
Quinn Atherton with BHGRE Bloom Group, original listing - (559) 625-9500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $874,000
Beds: 4
Baths: Full: 3, ¾: 1
Status: Active
SqFt: 3314 Square Feet
Agency: BHGRE Bloom Group
Agency Phone: (559) 625-9500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Up a winding palm tree-lined driveway over the 2.21 acres of property, sits this luxury hilltop Springville estate! There are 3341 sq. ft. and 4 bedrooms, an office and 4 bathrooms. The stunning entry doors are 9 ft custom leaded glass with matching leaded side-lights and transom. They open onto a grand foyer flanked by built-in lighted mirrors, coffered ceiling and intricate inlaid tilework. The formal dining room ahead has floor to ceiling views of the valley and mountains beyond. The living room has a magnificent gas fireplace and built-in custom cabinetry. The extra thick crown molding, coronado baseboards and soaring ceilings are throughout the home. The living room opens on one side to the kitchen, separated only by an enormous granite topped island complete with a prep sink. The kitchen has custom cabinetry with leaded glass cabinet doors and heavy duty pull-out storage drawers for pots and pans. There are double ovens, a Bosch dishwasher and a large pantry. The living room also opens onto the back under-roofline patio that has a large sitting area and a grand water feature. The ample sized bedrooms are all en-suites, and each feel like a luxury hotel room. The primary bedroom has a fireplace and a bathroom with a jetted tub, separate shower, double vanity and intricate custom tile work. It also has a morning kitchen, perfect for coffee in bed. There is a separate under roofline patio off of this bedroom as well. The oversized 3 car garage has weather-resistant removable tile flooring, a workbench and plenty of storage and extra space for a pool table and ping pong! There is an OWNED SOLAR system, built-in vacuum system, 2 whole house fans, and a sound system throughout! Everything about this home is custom, and the view from almost every room is unmatched! It will be my absolute pleasure to show you this home!
MlsNumber: --
ListingId: 232549


Listing Provided By: BHGRE Bloom Group, original listing
Phone: (559) 289-1589
Office Phone: (559) 625-9500
Agent Name: Quinn Atherton
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