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 = 3132 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 = 3132 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 = 3132 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;

68 Playa Azul
Avalon, CA 90704
Cherie Juengst with Better Homes and Gardens Real Estate Registry, original listing - (951) 383-4343

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,000,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 977 Square Feet
Agency: Better Homes and Gardens Real Estate Registry
Agency Phone: (951) 383-4343

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 100,000 acre(s)
Property Type: Residential-Condominium
Year Built: 1988
Notes: RARE OCEAN FRONT VILLA IN DESIRABLE HAMILTON COVE: Enter through gorgeous carved mahogany door to this beautiful end unit with 2 bedrooms/2 bathrooms with incredible ocean front views! You don't have to worry about seeing red roof tops of other units from your balcony. There are no steps if you enter from the opposite end of building or take the few steps up to the front door. ONLY building in community to have an elevator. Building is closest to beach for easy access. Tile throughout the entire unit. Enjoy cool breezes and sound of the waves as you sleep in your bedroom with double French doors that open to your own private balcony. Master Bath has dual vanities and large walk-in shower. Living room also has double French doors that open to the balcony with ocean front views. There's a second private balcony for BBQs and just relaxing with family and friends with views also. Kitchen has upgraded tile travertine counters, dishwasher, refrigerator and microwave and lots of storage. Beautiful pendant lighting over counter. Cozy wood burning fireplace for cool evenings to enjoy. Ceiling fans in living and master bedroom. Large secondary bedroom with full bath and large mirrored closet doors for guests and family. Golf cart included! This unit is permitted as a rental and will convey to new buyer. Community features 24/7 guard gate, BBQ's, kids playground, croquet, 2-lighted tennis courts, putting green, Club-house, Meeting room, heated pool and jacuzzi, full gym with sauna, showers, lockers and restrooms, sandy beaches with volleyball court. Available storage for kayaks/boats/dingy and moorings available through HOA. Year round activities on the island. Enjoy snorkeling, paddle boarding, hiking, golfing, dining, watch dolphins off your balcony. Come...LIVE THE DREAM! Call Cherie Juengst for private showing at 951.775.0156
MlsNumber: --
ListingId: SW24014695


Listing Provided By: Better Homes and Gardens Real Estate Registry, original listing
Phone: (951) 775-0156
Office Phone: (951) 383-4343
Agent Name: Cherie Juengst
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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