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

280 San Miguel Street
Avila Beach, CA 93424

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,199,000
Beds: 4
Baths: 4
Status: Active
SqFt: 2547
Agency: Sullivan & Associates Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9,230 sqft
Property Type: Residential
Year Built: 2018
Notes: This Avila Beach home is a licensed short term rental (STR) and is being offered fully furnished. Nestled against the mountain side in downtown Avila Beach, and is ready to occupy! <br /> <br /> The home has an open great room floor plan. The great room has cathedral ceilings, wood cased windows, Shaker style cabinetry, Viking appliances, Quartzite slab counters, European Oak floors. The open living room, kitchen, and dining areas are on the second level. Sliding glass doors just off the kitchen open to front and rear dining and entertaining decks for fresh ocean breeze and panoramic mountain views. There is a third upper deck nestled among big oak trees that has picturesque harbor views. The home has several outdoor entertaining decks to host group gatherings. Take in evening sunsets on the upper deck or BBQ taste morsels and after a day at the beach. The home is in the heart of Avila Beach, and nearby the Bob Jones trail. <br /> <br /> The home has two master en-suites, two additional bedrooms + fifth office/bedroom for a total of 5 private sleeping areas. At ground level there is a master en-suite. This ground level master en-suite is a studio suite just off the entry with a separate private side entry door, mini-kitchenette and full walk-in shower. The second and third bedrooms, also at ground level. Up a flight of stairs to the second master en-suite and another office/bedroom. The second master en-suite is on the second level. The second master en-suite has a large walk-in shower and separate soaking bath tub. The fifth room can be a bedroom or office. <br /> <br /> The home is professionally landscaped. The outdoor decks are tucked into the hillside under 100 year old oak trees. There is an outdoor shower to wash away sandy feet and beach toys. There is an oversized garage with room for bike, kayak, surf board storage, plus additional auto parking in the driveway. The home has a full laundry center.
MlsNumber: SC24084150


Listing Provided By: Sullivan & Associates Real Estate, original listing
Name: Sullivan & Associates Real Estate
Phone: (805) 439-3600
Office Name: Sullivan & Associates Real Est
Office Phone: (805) 439-3600
Agent Name: Terri Hicks
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','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;
Real Estate Expert Photo for Autumn Burnett
Autumn Burnett
ASCIIKeller Williams
Call Today!: (805) 904-4079

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App