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

1609 S Atlantic Boulevard
Alhambra, CA 91803
Andrew Homs with H & M Realty Group, original listing - (949) 625-4533

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,600,000
Beds: 11
Baths: Full: 7, ¾: 1
Status: Active
SqFt: 6415 Square Feet
Agency: H & M Realty Group
Agency Phone: (949) 625-4533

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential Multi Family-Single Family Residence
Year Built: 1947
Notes: Rare 22,978 sq foot property in the heart of Alhambra. Possibilities are endless. Currently a beautifully maintained Large 8 unit multifamily open garden property. This could be an investor/developers dream come true, so many options here! 5 Buildings spaced throughout the property to create a quiet and peaceful setting with mature fruit trees in the courtyard areas, open spaces, and green landscaping. A mix of units including a studio, 1bed/1bath duplexes, and TWO detached SFR homes- one is a 3bed with basement and fenced yard. All units have laundry hookups inside except studio and upstairs unit has a laundry room downstairs. Contact City/County to explore possibilities of adding square footage and/or additional units or ADUs. Parking on site includes 5 single car garages (standalone building with nothing above), a two-car garage (with studio attached and unit above), a carport, and a parking space off the alley. Attached Owner's unit/shed with bathroom and separate access. Plenty of street parking is located nearby. Buildings range in age, being built between 1947-1954. All tenants are month to month, most have been at the property long term. All units are currently rented with no back rent owed; this property rarely has vacancies. Situated in a prime location close to Pasadena, San Marino and the San Gabriel with close freeway access, public transportation, highly rated restaurants, entertainment, Dodger Stadium, Hollywood, Golf Courses, Downtown LA, Santa Anita, The Rose bowl, retail shops, parks, Cal State LA, USC, UCLA and more. Private Property - do not enter without written permission.
MlsNumber: --
ListingId: OC24025079


Listing Provided By: H & M Realty Group, original listing
Phone: (949) 229-2704
Office Phone: (949) 625-4533
Agent Name: Andrew Homs
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