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;

149 Grand Avenue
Monrovia, CA 91016

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,078,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1248
Agency: RE/MAX Premier Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5,779 sqft
Property Type: Residential
Year Built: 1924
Notes: This well maintained Craftsman Style Bungalow Home is nestled in the Beautiful Foothills of Monrovia. You can enjoy Peace and Tranquility while still being close enough to the charming Shops and Dining of Myrtle Avenue. The home has 3 Bedrooms and 2 Baths, a Formal Living Room, Dining Room, Kitchen with Breakfast Area, and space for stackable Washer/Dryer. Added features are the converted Attic that has built in Bookshelves lots of natural light a wall AC and could be a charming Art Studio and there is a Basement with plenty space for a Wine Cellar and room for extra storage as well. The Oversized Garage is newer and has many features which include an enclosed secured room and a large workshop area. This classic Craftsman home has been updated and remodeled while keeping the Craftsman style intact and restored. There are Hardwood Floors, Stylish Tile in newer Kitchen and Baths, Built-in cabinets all reminiscent of the Craftsman Era. Improvements were done with high quality materials,fixtures, appliances and lighting. The home has been recently painted inside and out. The long and widened Driveway has room for extra parking. Deck and Spa are Conveniently located off the Ensuite for a relaxing end to those busy days. This home is ready to move right in!!! A quality remodeled home in a great neighborhood nestled in the quiet foothills is just the plan for enjoyable living.
MlsNumber: P1-17224


Listing Provided By: RE/MAX Premier Properties, original listing
Name: RE/MAX Premier Properties
Phone: (626) 229-2200
Office Name: RE/MAX Premier Properties
Office Phone: (626) 660-1100
Agent Name: Dioni Rovello
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