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;

253 Aspen Drive
Monrovia, CA 91016
Debbie Pock with Berkshire Hathaway HomeService, original listing - (626) 355-1600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,415,000
Beds: 4
Baths: Full: 1, ¾: 2
Status: Active
SqFt: 2246 Square Feet
Agency: Berkshire Hathaway HomeService
Agency Phone: (626) 355-1600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1977
Notes: Striking two story Contemporary on a quiet cul-de-sac north of Foothill. Dramatic double door opens to a tile foyer leading to a sunken living room, a cozy brick fireplace, wide planked flooring, vaulted ceiling, a charming bay window and built-in entertainment center. Delightful family/dining room with granite topped buffet, tile floors & paneled French exit doors. Fourth downstairs bedroom, is ideal for visiting family or guests with an adjacent three quarter updated bath. Fabulous the gourmet kitchen encompasses lovely Cherrywood cabinets, granite counters, porcelain sink, Bosch dishwasher, Jade professional 6 burner range with warmer, grill and hood, a seperate breakfast bar, custom intricate tilework & dramatic coved ceiling inset. Expansive the walk-in pantry houses the stainless refrigerator & a myriad of storage. Wrap around the custom Oak staircase, detailed with wrought iron balusters up to the generous master suite with a dual set of mirrored closets, sunny window and beautifully remodeled three-quarter bath with his & hers antiqued vanities, marble countertops, custom tile floors and large glass enclosed shower. Down the hall two additional amply sized bedrooms share an upgraded shower/tub combination bath with porcelain flooring. Retreat to your own Shangri-la and linger on the shady covered patio with dual ceiling fans, cool paver floors and a convenient kitchen pass-through. Relax and take in the scent of apple, orange, avocado & pomegranate trees amidst a variety of colorful flora…all surrounded by your own private block wall. Further amenities include 2015 HVAC System, recessed lighting, crown molding, separate laundry room, automatic sprinkler system, mature landscaping, double direct access garage and concrete drive. A sparkling gem nestled against the desirable backdrop of the majestic Monrovia mountains!!! Ask for Debbie Pock BHHS Text (626-824-4114)
MlsNumber: --
ListingId: AR24209276


Listing Provided By: Berkshire Hathaway HomeService, original listing
Phone: (626) 824-4114
Office Phone: (626) 355-1600
Agent Name: Debbie Pock
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