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

23980 Falcons View Drive
Diamond Bar, CA 91765
Faranak Eftekhari with Keller Williams Realty, original listing - (714) 426-3800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $8,800,000
Beds: 9
Baths: Full: 3, ¼: 4, ¾: 6
Status: Active
SqFt: 14818 Square Feet
Agency: Keller Williams Realty
Agency Phone: (714) 426-3800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Welcome to an exquisite sanctuary of luxury and sophistication in the prestigious gated community of The Country, Diamond Bar. This palatial estate spans an impressive 14,818 square feet on over 1.5 acres of meticulously landscaped grounds, offering 9 bedrooms and 13 bathrooms, perfectly designed for grand living and entertaining.<br /> <br /> Step inside to discover a world of elegance and modern convenience, accentuated by custom-made tile flooring throughout and a sleek, contemporary design. The grand foyer opens to a magnificent library, perfect for quiet reflection or working from home. A striking built-in aquarium creates a serene ambiance, leading you to the heart of the home.<br /> <br /> The gourmet kitchen is a chef's dream, featuring top-of-the-line appliances, multiple ovens, a built-in Miele coffee maker, and a spacious walk-in pantry. For more intimate catering, a butler’s kitchen with additional cooking facilities ensures seamless service during lavish events. The property boasts two luxurious master suites, each a private retreat with spa-like bathrooms and walk-in closets. Additionally, there are two in-law suites, providing comfort and privacy for extended family or guests.<br /> <br /> The home features an elevator, providing easy access to all levels. The expansive downstairs entertainment area includes a state-of-the-art movie theater, ideal for private screenings, and a massive entertainment space designed for hosting unforgettable gatherings.<br /> <br /> Every inch of this home is equipped with cutting-edge smart home technology, allowing you to control lighting, climate, and security systems effortlessly. Step outside to find a private oasis, complete with a sparkling pool, spa, firepit, well equipped BBQ and tennis court, perfect for relaxation and recreation.<br /> <br /> The Country in Diamond Bar is renowned for its serene environment and top-notch amenities, including a golf course, clubhouse, and 24-hour security, ensuring an exclusive lifestyle. Conveniently located near premier shopping, dining, and excellent schools, this property epitomizes luxury living.<br /> <br /> Discover unparalleled elegance and modern comforts in this extraordinary estate – a true masterpiece in one of California’s most coveted communities.
MlsNumber: --
ListingId: PW24098208


Listing Provided By: Keller Williams Realty, original listing
Phone: (714) 426-3800
Office Phone: (714) 426-3800
Agent Name: Faranak Eftekhari
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.


Local Real Estate Expert

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','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;
Linda Ojeda
ASCIILinda Ojeda and Associates, JohnHart Real Estate
Call Today!: (818) 442-7504

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App