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','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 = 227 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 = 227 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;

1110 Burnt Rock Way
Templeton, CA 93465
Alicia Bartlett with RE/MAX Parkside Real Estate, original listing - (805) 239-3310

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,599,000
Beds: 4
Baths: Full: 2, ½: 1, ¾: 1
Status: Active
SqFt: 3858 Square Feet
Agency: RE/MAX Parkside Real Estate
Agency Phone: (805) 239-3310

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Welcome to this beautifully renovated single-level custom home in the exclusive Santa Ysabel Ranch. Situated on 1.55 +/- acres, this exquisite 3,858 +/- sq. ft. home with a casita offers an ideal blend of indoor & outdoor living. The main house features 3 spacious bedrooms, 2 offices, a gym & a versatile flex room, providing ample space for work, leisure, and relaxation. The casita is a private retreat, seamlessly connected to the main home by a breezeway & features a kitchenette, granite countertops & a spacious bathroom with a frameless glass shower. This versatile space adds flexibility to meet evolving living needs. Recent renovations in the main home include newer wood plank flooring and tile, updated light fixtures on the front of the home, entry, kitchen, & dining room, custom curtain rods, curtains, wood shutters, automated shades, ceiling fans in the living room & primary suite, newer perimeter fencing, resurfaced pool and spa & a solar energy system. The powder bathroom has been updated with a newer vanity & illuminated mirror, while the Jack & Jill bathroom was upgraded with a leathered quartzite countertop, mirrors, & new plumbing fixtures. The gourmet kitchen boasts a newer Wolf range, a newer undercounter KitchenAid ice maker, soft water & reverse osmosis systems. The oversized granite island is perfect for meal prep and gathering, while the adjacent living room features a stone accent wall, gas fireplace, & large sliding doors leading to the patio.The primary suite offers a cozy gas fireplace & access to the patio and pool. The en-suite bathroom includes dual vanities, illuminated mirrors, a soaking tub, walk-in shower with dual shower heads, two walk-in closets, and a bonus room suitable for a gym or nursery. The home also includes a wet bar, a climate controlled wine room, walk-in pantry, surround sound featuring indoor and outdoor speakers & a inside laundry room with a sink. Outside you'll enjoy a pool, spa and stunning views of the Salinas River Valley, along with breathtaking sunsets creating a serene backdrop for your evenings, offering a truly idyllic setting for relaxation. Santa Ysabel Ranch is a gated and guarded community offering 24/7 security, tennis & pickleball courts, and walking trails, providing both privacy and convenient access to Paso Robles, Templeton, and local wineries.
MlsNumber: --
ListingId: NS24217677


Listing Provided By: RE/MAX Parkside Real Estate, original listing
Phone: (805) 239-3310
Office Phone: (805) 239-3310
Agent Name: Alicia Bartlett
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.


Local Real Estate Expert

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','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;
Kay Storrs
ASCIICOMPASS
Call Today!: (805) 550-1206

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App