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;

24503 Ravenna Avenue
Carson, CA 90745

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 5
Baths: 3
Status: Active
SqFt: 2197
Agency: Keller Williams Coastal Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4,758 sqft
Property Type: Residential
Year Built: 1968
Notes: Welcome home 24503 Ravenna Avenue, an upgraded 4 bedroom, 2.5 bathroom home nestled in the charming Carousel neighborhood of Carson. Boasting 2,197 square feet of living space and sitting on a 4,758 square foot lot, this home offers the perfect blend of space and comfort. Unwind in the inviting courtyard, where enjoying your morning coffee and relaxing at ease are elevated. Experience the light-filled and expansive floor plan, effortlessly connecting each room. The fireside living room seamlessly transitions into the dining area with backyard access, providing an unparalleled indoor/outdoor living experience. The gourmet kitchen showcases a second dining/conversation space, stainless steel appliances, crisp cabinets and backsplash, an oversized bar countertop, ample cabinet space, and more. The spacious backyard is an added bonus with low maintenance landscaping, drip irrigation, a gas BBQ line, grassy areas, multiple entertaining spaces and more. The main level is completed with one bedroom and a half bath. Journey upstairs for the additional 3 bedrooms, including the luxurious primary ensuite with a full bath, two closets, large patio with views, and shared balcony. One of the secondary bedrooms also enjoys the balcony too. Upgrades include kitchen cabinets, backsplash, and stove, vinyl plank flooring throughout, interior paint, fence, gates, irrigation, and front walkway. Enjoy close proximity to freeway access, parks, and everyday conveniences. This home offers a prime location for easy living!
MlsNumber: PW23223456


Listing Provided By: Keller Williams Coastal Properties, original listing
Name: Keller Williams Coastal Properties
Phone: (562) 843-1017
Office Name: Keller Williams Coastal Prop.
Office Phone: (562) 843-1017
Agent Name: Cynthia Hinderberger
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