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 = 3372 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 = 3372 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 = 3372 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;

505 Saint John Pl
Inglewood, CA 90301

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,290,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2836
Agency: Rodeo Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1961
Notes: Welcome to Saint John Place! This 4-bedroom, 3-bathroom, 2-story home is located in one of the most prestigious and sought-after neighborhoods in Inglewood. This residence offers a harmonious blend of comfort, style, and functionality. Here's what makes it truly exceptional: As you step inside the entryway, the family room beckons with its warm ambiance and abundant space. Perfect for cozy evenings or lively gatherings. The family room is the heart of this home, offering generous space for relaxation, entertainment, and quality time with loved ones. The formal living room with gas burning fireplace is located just to the left of the family room. The large windows throughout this home flood the living spaces with natural light, creating an inviting ambiance which gives this home a special flare. Adjacent to the family room, the wet bar area adds a touch of elegance. Imagine hosting stylish gatherings here, serving up your favorite drinks. Just across from the wet bar area, the formal dining room awaits. Whether it's a festive holiday dinner or an intimate gathering, this space sets the stage for memorable meals. The kitchen boasts a charming breakfast nook, ideal for enjoying morning coffee or casual meals. The main floor also features a bedroom, perfect for guests or a home office. Adjacent to it, you'll find a bathroom with a shower and nearby, the laundry area. Upstairs, the primary bedroom awaits. It features an ensuite bathroom and a walk-in closet. The other two bedrooms are also located on this level, ensuring privacy and comfort for everyone. The grounds are just waiting for your creative touch. There is space to enjoy al fresco dining on the patio, host BBQs, or create a cozy fire pit area. In addition, green thumbs will appreciate the space for an urban garden where you can grow your own herbs, flowers, and vegetables. Also, there is plenty of room for your pets to play and explore. There are also a couple of fruit trees for your enjoyment. The large attached garage allows you to park your vehicles securely or use the extra space for storage. This property is conveniently located near SoFi Stadium, home to thrilling sports events and concerts, and the Kia Forum, which is a hub for entertainment and community gatherings. In addition, there are nearby parks where you can enjoy picnics and outdoor activities, transportation hubs, Downtown Inglewood, and the LAX airport. This property offers the perfect blend of convenience and community. Don't miss the opportunity to call this wonderful house your home! This property has a new roof, has been recently replumbed and has many electrical upgrades! Come and reinvent this diamond in the rough!
MlsNumber: 24-399625


Listing Provided By: Rodeo Realty, original listing
Name: Rodeo Realty
Phone: (310) 471-2600
Office Name: Rodeo Realty- Brentwood
Office Phone: (310) 873-4100
Agent Name: Rhonda Payne
Disclaimer: Copyright © 2024 TheMLSCLAW. 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