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;

113 Vista Del Parque
Redondo Beach, CA 90277

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,299,000
Beds: 2
Baths: 2
Status: Pending
SqFt: 1061
Agency: 3 Leaf Realty, inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5,767 sqft
Property Type: Residential
Year Built: 1949
Notes: Welcome to this charming two bedroom cottage located within walking distance of the shops/ restaurants in the Riviera and just across from El Retiro Park/ public library. The front gate invites you to a serene and private courtyard surrounded by mature trees. That privacy continues on thru the yard space which wraps around the house. Grab fresh lemons from the tree in the rear yard. Sliding double doors off the family room look out to the courtyard offering indoor/ outdoor living and pleasant breezes. Vaulted ceilings in the family and dining room add to the spacious feel. The peninsula counter in the kitchen provides ample counter space overlooking the family room. The vaulted ceilings continue in the two bedrooms and secondary bath. The large primary suite has deep closets providing lots of storage space. The second bedroom is currently being used as a den with a Murphy bed that has convenient built in shelving and cabinetry on both sides. French doors open to the courtyard with a large bay window looking out to the front of the home. This lovingly cared for home has was repiped with PEX in 2020, new A/C in 2018, FAU 2014, counters/ backsplashes in kitchen/ baths, gas range and dishwasher in 2014, water heater 2017, perimeter fencing 2017, metal roof from 2010 and has newer vinyl windows. Whether you love this outdoor oasis the way it is, are looking for a home you can add on to and make your own or want to build your own dream home, don’t let this opportunity in such a highly desired neighborhood pass you by!
MlsNumber: SB24098927


Listing Provided By: 3 Leaf Realty, inc., original listing
Name: 3 Leaf Realty, inc.
Phone: (310) 714-1416
Office Name: 3 Leaf Realty Inc
Office Phone: (310) 546-6300
Agent Name: Paul Kerza
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