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','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 = 205 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 = 205 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;

3020 Windmill Drive
Diamond Bar, CA 91765
Fuqiang Yun with Homequest Real Estate, original listing - (909) 606-0888

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,680,000
Beds: 6
Baths: Full: 5, ½: 2
Status: Active
SqFt: 7785 Square Feet
Agency: Homequest Real Estate
Agency Phone: (909) 606-0888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1991
Notes: This property is one of the most beautiful castles in the famous community in Diamond Bar: The Country Community, known as the Beverly Hills of the East. (1)Situated at one of the highest points in the community, with an elevation of over 1,100 feet, the house offers spectacular mountain and city views. (2)The total lot size is 109,000 square feet, with 75,000 square feet of usable land. The house has a frontage of 242 feet, with sufficient space from neighboring properties, ensuring exceptional privacy. (3) Since 2019, the owner has spent nearly $1.5 million in interior and exterior renovations, including replacing all windows and doors, appliances, lighting, curtains, plumbing, air conditioning, pool, and upgrading the gym, fireplace, and garage. All renovations come with invoices and receipts. (4)The grand European-style double circular staircase exudes elegance and nobility. (5)The magnificent and impressive 20-foot-high family room and living room, offering direct mountain and city views from the backyard, are perfect places for family gathering and meeting guests. (6)Top kitchen appliances: a built-in Sub-Zero double-door refrigerator, Wolf oven and steam oven, Cove dishwasher, etc. The house has premium Omega cabinetry, a wine cellar, and a bar connected to the family room, ideal for family gatherings. (7)The first floor includes a bedroom suite, a study room, a gym, a laundry room, and two half baths. (8)The second floor has five bedrooms, four bathrooms, and a loft. The spacious and luxury master bedroom features a walk-in closet with custom cabinetry, a fireplace, and an extensive balcony overlooking the backyard. The loft, currently used as a game room, has a balcony and stairs leading directly to the backyard. (9)The pool is located in the side yard, a favorite summer play area for children. (10)The property has a private double-door iron gate, a four-car garage (with upgraded flooring), and a driveway that can accommodate nearly 10 cars. (11)The front yard, backyard, and side yard are flat and extensive, perfect for your dogs to run around. (12)The house was meticulously designed and built for the owner by JCC, the original developer of "The Country." (13)The front and back yards feature a total of 21 King Palm trees worth nearly a million dollars, showing luxury and individuality. (14)The gated community offers 24-hour security. The property is located in Walnut Valley United School District, with a top-rated Diamond Bar High School (10/10).
MlsNumber: --
ListingId: TR24198115


Listing Provided By: Homequest Real Estate, original listing
Phone: (909) 606-0888
Office Phone: (909) 606-0888
Agent Name: Fuqiang Yun
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','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;
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