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

46 San Antonia Street
Avila Beach, CA 93424
Kim Conti DeGroot with Kimberly's Global Real Estate Corp, original listing - (805) 540-5200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $15,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2623 Square Feet
Agency: Kimberly's Global Real Estate Corp
Agency Phone: (805) 540-5200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential Lease-Single Family Residence
Year Built: 2002
Notes: Situated in Avila Beach, this property boasts breathtaking panoramic ocean views and convenient beach access. It is ideally located near the Bob Jones Trail, local shops, and dining establishments. The well-appointed property comprises three bedrooms (two California king beds and one queen bed), two and a half bathrooms, a fully equipped kitchen, a comfortable living area, and a deck with ocean views for tranquil moments at sunrise and sunset. Accommodating up to six guests, it offers amenities such as wireless internet and three Apple TV boxes (streaming services not included). The home has a two-car garage with a 50-amp charging station, along with parking for two additional vehicles and an EV charger. For added convenience, there is a stairlift for easy access to the upper floor and a dumbwaiter from the garage to the kitchen. Its prime location allows for easy exploration of nearby attractions, wineries, dining spots, and a variety of outdoor activities like golf, biking, swimming, surfing, and hiking. Nestled in downtown Avila Beach, this property provides a unique opportunity to relax and unwind in a serene environment. The picturesque coastal views enhance the tranquility of the area, making it an ideal place to rejuvenate. Whether you're discovering local attractions, indulging in delectable cuisine at nearby eateries, or simply basking in the beauty of the beach, this property offers versatility and unforgettable experiences. This beach home offers stunning vistas of the waves, bay, and Port San Luis. it also provides easy access to San Luis Obispo, Paso Robles wine country, and Pismo Beach. <br /> <br /> Lease Details:<br /> Available June 1 - September 30, 2024, minimum stay 31 days. <br /> Rent per Month - $15,000<br /> Security Deposit - $15,000<br /> Utilities: Owner covers with caps for Water/Electric<br /> $49 Move-In Fee for Digital Images and Walk-Through<br /> Contact: [email protected] for additional information or visit kimberlysre.com for application, video and information
MlsNumber: --
ListingId: SC24063961


Listing Provided By: Kimberly's Global Real Estate Corp, original listing
Phone: (805) 550-5333
Office Phone: (805) 540-5200
Agent Name: Kim Conti DeGroot
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','ilhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ilhud', 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;
Mario Estrada
ASCIIeXp Realty of California Inc.
Call Today!: (805) 748-9044

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App