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

22826 Lazy Trail Road
Diamond Bar, CA 91765

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,599,999
Beds: 6
Baths: 7
Status: Active
SqFt: 7570
Agency: Universal Elite Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 101,095 sqft
Property Type: Residential
Year Built: 1990
Notes: Immaculate and impeccable condition home with tons of upgrades up to $500K. This luxurious 7,570 SF Mediterranean inspired estate is located in the prestigious Diamond Bar ‘The Country’, a 24-Hour patrol/guard gated community. Total 6 bedrooms, 6.5 bathrooms. Main residence boasts 5 bedrooms, 5.5 bathrooms (1 bedroom and 1.5 bathroom down). The separate guest house (864 SF) with 1 bedroom and 1 bathroom. Private automatic gate, wrought iron double-door entry opens into a magnificent high-ceiling foyer w/ sweeping staircase & stunning chandeliers. Large living room with custom window draperies, formal dining room with custom chandelier. Home office/library with built-in book shelves, and a fireplace. Gourmet kitchen with granite counter tops, center island, built-in refrigerator, built-in microwave. The super large family room with high ceiling, fireplace, built-in media niche. The bonus room upstairs could be another entertainment area. Each bedroom has its own bathroom. Master bedroom has double sinks with retreat area and a private balcony. Master bathroom has Jacuzzi tub and separate shower room. The detached guest house with full bathroom. Other features include, new floor with Italy tiles and partial engineered wood, triples layers glasses windows, molding walls, all Viking appliances, cork counter top, all bathrooms are frameless glasses, custom drapes & wooden shutters, 4 new A/C , solar system, spacious drive way, crown moldings, two sets of stairs, recessed lights, custom window coverings, flat and useful back yard, panoramic rolling hills views. Three detached garages... All of this plus a top rated schools, close proximity to freeways, shopping & restaurants makes this such a gorgeous & entertaining home that you must see!
MlsNumber: AR24103977


Listing Provided By: Universal Elite Inc., original listing
Name: Universal Elite Inc.
Phone: (626) 230-9655
Office Name: Universal Elite Inc.
Office Phone: (626) 346-3508
Agent Name: Jinxiong Zhou
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