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

615 Esplanade
Redondo Beach, CA 90277

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $889,000
Beds: 1
Baths: 1
Status: Pending
SqFt: 719
Agency: Beach City Brokers

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 31,695 sqft
Property Type: Residential
Year Built: 1971
Notes: Welcome to your own private oasis in the heart of Redondo Beach! This<br /> stunning beachfront condominium on the iconic Esplanade offers the<br /> perfect combination of comfort, style, and panoramic ocean views.<br /> Step inside and be captivated by the open and airy living space, featuring<br /> floor-to-ceiling windows that flood the home with natural light and showcase<br /> the stunning views of the Pacific Ocean all from the comfort of your own<br /> private balcony. The spacious living room is complete with a stunning fluted<br /> wood fireplace and is the perfect spot to relax and unwind. Here you will<br /> find an incredible space for hosting intimate dinner parties or enjoying a<br /> casual meal with loved ones.<br /> The modern kitchen is a chef's dream, with high-end stainless steel<br /> appliances, plenty of white quartz counter space, and sleek white oak<br /> cabinetry. Imagine preparing gourmet meals while being inspired by the<br /> magnificent ocean backdrop - it's truly a culinary paradise.<br /> The master suite is a tranquil haven, offering a peaceful retreat with its own<br /> spacious walk in closet. Wake up to the soothing sound of waves and<br /> indulge in the breathtaking views from the comfort of your own home. The<br /> luxurious bathroom is a spa-like oasis, featuring a gorgeous shower and<br /> soaking tub, expansive vanity, tied together with a timeless aesthetic.<br /> Additional features of this exceptional condominium include hardwood<br /> floors, recessed lighting, an in-unit european washer & dryer, and secured<br /> parking.<br /> Located in the highly coveted Redondo Beach neighborhood, this property<br /> is just a few steps away from pristine beaches, trendy restaurants, boutique<br /> shops, and excellent schools. With its prime location, luxurious finishes,<br /> and unparalleled ocean views, this truly is coastal living at its finest!
MlsNumber: SB24091156


Listing Provided By: Beach City Brokers, original listing
Name: Beach City Brokers
Phone: (310) 292-0332
Office Name: Beach City Brokers
Office Phone: (310) 543-3536
Agent Name: Holly Kauffman
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App