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;

5101 W 133rd Street
Hawthorne, CA 90250

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,399,000
Beds: 5
Baths: 4
Status: Active
SqFt: 2323
Agency: Redfin Corporation

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6,106 sqft
Property Type: Residential
Year Built: 2009
Notes: Stunning custom-built 5 BED / 4 BATH 2,323 sqft home located in the highly coveted neighborhood of Del-Aire within the WISEBURN SCHOOL DISTRICT. This deluxe home features a charming living area on the first level with a generously proportioned kitchen with dining area. Recent updates include new windows and luxury vinyl plank flooring providing a contemporary and inviting atmosphere. Three well-equipped bedrooms share two updated bathrooms plus a large laundry room for convenience. Direct access to a spacious 2-car oversized garage equipped with a large storage room. Ascend to the second level, where an open family room area with a bar area with center island provides the perfect space for social gatherings. Enjoy views of the city lights and mountains from the balcony. The main bedroom suite provides a serene retreat, featuring a large walk-in closet and a luxurious bathroom designed for indulgence. The 5th bedroom utilizes the full bathroom across the hallway, complete with a hidden laundry chute to the downstairs laundry room. Outside, on the expansive corner lot, you'll find ample space for relaxation and recreation. A paved patio, lush lawn, fruit trees, storage shed, and a pad plumbed for a hot tub offer diverse options for outdoor enjoyment. The stylish gated driveway ensures privacy and security, making this property a truly exceptional find. Located in the West Hawthorne's coveted Wiseburn School District with easy access to freeways, LAX, dining, and shopping. Don't miss the chance to experience the comfort, versatility, and charm that this dual-home residence provides – schedule your viewing today!
MlsNumber: SB24028561


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: Rick Wilkinson
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