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','mdhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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','mdhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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','mdhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mdhud', 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;

1928 Avinger Drive
Rosemead, CA 91770

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,900
Beds: 3
Baths: 3
Status: Pending
SqFt: 1358
Agency: Evergreen Realty & Associates, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1,218 sqft
Property Type: Residential
Year Built: 1987
Notes: Hello, 1928 Avinger Drive, Rosemead! Step into this 1,358 sq.ft. home with 3 bedroom 2.5 bath & be greeted by modern living! You will step into a spacious open living space that flows into the dining area. The kitchen offers sleek white cabinetry, quartz countertops, a stainless steel sink & faucet, and stainless steel appliances. The main level also features closet space and a powder room. You can also entertain your friends by opening up the sliding glass door from the living space to the patio. As you walk up the stairs you'll be greeted with beautiful natural light from the hall skylight. The extra large main room offers vaulted high ceilings with lighting, a walk-in closet, a balcony with storage space, and a full modern restroom. The other 2 bedrooms are also both a great size with ceiling fans, nice mountain views and good size closets. Upstairs there are also hallway cabinets and a full restroom. Throughout the home enjoy upgraded lighting, newer paint, and luxurious wide plank vinyl flooring. There is also an extra amped 2 car attached garage with washer and dryer hookups. The community was recently repaved, is gated, and offers relaxing walking/biking paths with plenty of green space, and bbq and picnic areas for you to enjoy. Grab your hunny and run because this one won't last!
MlsNumber: SR24092769


Listing Provided By: Evergreen Realty & Associates, Inc, original listing
Name: Evergreen Realty & Associates, Inc
Phone: (562) 505-8400
Office Name: Homesmart Evergreen Realty
Office Phone: (818) 812-5990
Agent Name: Linda Mendoza Razo
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