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;

707 N Prospect Avenue
Redondo Beach, CA 90277

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,249,000
Beds: 5
Baths: 5
Status: Active
SqFt: 2672
Agency: Redfin Corporation

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7,433 sqft
Property Type: Residential
Year Built: 1959
Notes: Don't miss these SWEEPING panoramic Ocean and PV views!!! As soon as you pull up, you'll find ample parking (5-6 spaces at the beach!!) and as you walk into the private gated entry way, you will leave Prospect as a distant memory and walk far back through your lush tropical pathway to your front door. Once you walk inside, you'll be struck by the beautiful coastal style wide plank hard wood floors throughout this Traditional floor plan home. You'll find a massive great room, including a cozy fireplace Family Room and massively high ceilings through the ballroom size living and dining space. Recessed lighting throughout, powder room convenient for your guests, modernized fans and direct access to your Tropical Oasis back yard! This yard....with it's mature palms and plants, turf, built in bar with granite counter tops, sink, kegerator and fridge with bar stools make this the epitome of the best entertainment home! Exhibition kitchen has been updated with Granite counter tops, LG Stainless Steel appliances, double sink and a walk through "pantry" with lots of extra cabinet and counter space, and don't miss the formal walk in pantry as well as direct access to the back yard from here as well! Downstairs you will find 3 ample sized bedrooms w/good closet space plus 2 full bathrooms to house these bedrooms. The third bedroom conveniently has direct access to the garage, where you will find the laundry area and plenty of storage here as well. Come upstairs to find your Primary Suite plus a Junior Suite. Both boast sweeping ceilings, ceiling fans, walk in closets and en suite bathrooms. The primary Suite has direct access to your balcony and a soaking tub with jets! From here, take the easy walk up to your massive roof top deck with fantastic OCEAN and PV views w/a bonus upper deck for sunbathing, an outdoor gym or dining al fresco....just wait for the fireworks view!! Just a stones throw from Award Winning Beryl Elementary, Redondo High, 10 min walk to the beach, restaurants and coffee houses....Don't miss the side yard w/charming vegetable garden, extra wide side gate opening and brick pad to park yet another car or add another storage unit!
MlsNumber: SB24091243


Listing Provided By: Redfin Corporation, original listing
Name: Redfin Corporation
Phone: (949) 294-6186
Office Name: Redfin Corporation
Office Phone: (310) 409-2885
Agent Name: Heidi Ludwig
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