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

260 Waterfall Road
Templeton, CA 93465

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 3
Baths: 3
Status: Pending
SqFt: 2312
Agency: Richardson Properties, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4,900 sqft
Property Type: Residential
Year Built: 2017
Notes: This stunning Spanish-style home resides in the sought-after Templeton Ranch community, offering easy access to downtown dining, the Farmer’s Market, Concerts in the Park, wine tasting, schools, healthcare, and US 101. Situated perfectly to take advantage of Templeton's rich history, this upscale residence boasts a design that seamlessly blends functionality with versatility. The open floor plan encompasses three spacious bedrooms, including a ground-level primary suite, three luxurious bathrooms, and a versatile loft/bonus area. Upon entry through the double doors, guests are welcomed into inviting living and dining spaces featuring cathedral ceilings, a cozy fireplace with forced fan, and luxury vinyl plank flooring. The gourmet kitchen, complete with premium cabinetry, quartz countertops, GE stainless steel appliances, and a generous island with pendant lighting, is ideal for culinary adventures. The tranquil primary suite offers rear patio access, a walk-in closet, and an indulgent en-suite bathroom with dual sinks, a soaking tub, and a tiled shower with mosaic details. Two additional bedrooms with ample closets and window coverings provide space for family and guests, while the loft offers flexibility as a game room, home office, or fitness area. Outside, the fully fenced rear yard beckons with a large concrete patio, lush lawn, automatic retractable awning, raised garden beds, and pre-plumbed conduit for a future spa. Additional amenities include an energy-efficient on-demand tankless water heater, owned water softener, LED recessed lighting, remote controlled ceiling fans in three locations, community picnic and play areas, and a two-car garage with smart opener. Don’t miss out on the chance to make 260 Waterfall Road your new home!
MlsNumber: SC24094605


Listing Provided By: Richardson Properties, Inc., original listing
Name: Richardson Properties, Inc.
Phone: (805) 781-6040
Office Name: Richardson Sotheby's International Realty
Office Phone: (805) 781-6040
Agent Name: David Campa
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, 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