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;

515 W Gardena Boulevard
Gardena, CA 90248

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $529,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1235
Agency: Redfin Corporation

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 180,669 sqft
Property Type: Residential
Year Built: 1984
Notes: Discover convenience and space as you enter this modern and tastefully remodeled condo. This traditional floor plan condo features three bedrooms, all on the top level, one and a half bathrooms, a formal dining room, open and bright living room, remodeled kitchen, and an oversized garage.<br /> Unit has waterproof vinyl plank flooring and modern LED recessed lighting though out with WIFI enabled switches letting you turn on/off/dim the lights on your cellphone! Home HVAC system is synced to a Nest thermostat with programmable settings that can also be accessed on your cellphone. Turn on central heat or A/C before driving home to the perfect temperature!<br /> First floor is an oversized garage fitting two cars, extra storage, and a large extended area for either more storage or even a home gym (see pictures). Second floor includes the kitchen, dining room, living room, and a half bath. All three bedrooms are located on the third/top floor along with the full bath. Washer and dryer hook-ups are also conveniently located on the top floor.<br /> All three bedrooms and laundry room include newer paint and staircase has newer stained treads. Both bathrooms include newer vanities, toilets, flooring, mirrors, paint, and baseboards. Unit includes newer bath/laundry room vents and a newer water heater. Home has also been updated to reflect Dual Pane Windows and Air Conditioning!<br /> Unit is located near 110, 91, and 405 freeways. Also located near Sam’s Club, Albertsons, Vons, 99 Ranch Market, Tokyo Center, Ikea and many local restaurants with various types of cuisine for all the foodies. Do not delay....be in your new home by summer!
MlsNumber: SB24063938


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