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;

101 Seascape Place
Los Osos, CA 93402

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,650,000
Beds: 4
Baths: 4
Status: Active
SqFt: 2975
Agency: Stravinsky Holdings Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 60,548 sqft
Property Type: Residential
Year Built: 1994
Notes: Exceptional California Central Coast property with views of several hundred acres of coastal chaparral, sand dunes and eucalyptus grove plus panoramic ocean views. This one-of-a-kind property abuts Montana de Oro State equestrian park with easy access to dozens of horse and hiking trails. Northern views encompass the city of Morro Bay, the Morro Bay estuary and the "Three Stacks" landmark while the northwestern views showcase the Morro Rock bird sanctuary, the idyllic town of Cayucos plus coastal hills and the pacific ocean. Easterly views display the majestic Santa Lucia Coastal mountain range. The spacious, three bedroom, two and a half bath house is situated on 1.3 acres with direct beach access. The open floor plan includes ocean views from the kitchen, dining and living rooms with vaulted ceilings. The remodeled kitchen boasts professional style gas oven combo and newer appliances, dining room and living rooms with vaulted ceilings and ocean views. The owner's suite offers an en-suite bath with walk-in shower, large dressing room and walk-in closet plus access to the new deck. The expansive ocean view deck can also be accessed from the dining and living rooms and features a three person hot tub and built-in water plant garden area. Stand alone three room garage/guest room complex consists of a West room which can hold two cars and offers convenient storage cabinetry. The East room features a high ceiling and is long enough to accommodate the largest RV or two cars. There is also a stacking lift that can hold one additional car. The south facing Guest room overlooks the sun yard and features a king size Murphy bed and bathroom with walk in tub. This unique property also features solar panels, stucco siding, metal roofing plus a stand-up attic in one of the bedrooms and an east facing sunroom overlooking the courtyard with a small greenhouse. Equestrian enthusiasts will appreciate the two southerly situated equestrian corrals...perfect for horseback riding on the beach!
MlsNumber: SC24015841


Listing Provided By: Stravinsky Holdings Inc, original listing
Name: Stravinsky Holdings Inc
Phone: (805) 773-7777
Office Name: Keller Williams Realty Central Coast
Office Phone: (805) 773-7777
Agent Name: Hal Sweasey
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;
Geadell Giatti
ASCIIeXp Realty of California - Romero Home Team
Call Today!: (805) 391-9742

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App