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','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 = 3131 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 = 3131 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;

531 Esplanade
Redondo Beach, CA 90277

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,695,000
Beds: 2
Baths: 3
Status: Active
SqFt: 1246
Agency: Beach City Brokers

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 24,174 sqft
Property Type: Residential
Year Built: 1974
Notes: This Oceanfront, Panoramic View Condominium is located in The Tallest Building On The South Redondo Oceanfront. There are Panoramic Whitewater Views of The Ocean and Coastline all the way to Palos Verdes and Catalina. There are Full Walls of Sliding Windows on Both Levels from the Living Room and the Master Bedroom which Opens to Large Balcony/Decks with Stunning Views and Ocean Breezes. This Unit Originally was a Two Bedroom, which was converted to a Large One Bedroom with Two Bathrooms and Two Closets Offering Separate Areas. The Spacious Living Room is Flooded with Light and can Accomodate a Large Living Room Suite And Dining Table Adjacent to the Kitchen. There is also a Guest Bathroom off of The Living Room. The Ocean Plaza Development is a Highly Secure Building Located Near The Pier, The International Boardwalk, The Harbor, The Breakwater, The Bike Path and The Beach. There are Many Fine Restaurants, Entertainment Venues and Shopping Just Steps Away. Ocean Plaza has Many Amenities including Direct Beach Access from The Garage, an Outdoor Pool, Spa and Large Deck. There is also a Party/Event Room with Bath Rooms, a Pool Table, and Kitchen Facilites. There is Secure Subterranean Parking with Two Parking Spaces for The unit and Storage. Enjoy the Vacation Like Setting and Coastal Lifestyle Every Day At The Beach. See The Matterport 3-D Walkthrough. Contact Listing Agent Jonathan Coleman / Beach City Brokers BRE#00808758 for a Private Showing (310) 991-0929 E-Mail [email protected]. Website: www.531Esplanade708.com
MlsNumber: SB24082834


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: Jonathan Coleman
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