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 = 3132 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 = 3132 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 = 3132 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;

2586 Turnbull Canyon Rd.
Hacienda Heights, CA 91745
PAUL WONG with RE/MAX 2000 REALTY, original listing - (626) 956-0188

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,996,000
Beds: 9
Baths: Full: 7, ½: 1
Status: Active
SqFt: 5888 Square Feet
Agency: RE/MAX 2000 REALTY
Agency Phone: (626) 956-0188

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: MILLION-DOLLAR VIEWS!!! This custom-built home offers panoramic, majestic mountain and city lights views, nestled in the hills of Hacienda Heights. Situated on a private cul-de-sac, this expansive lot spans over half an acre, offering endless potential for a sport court or pool. The impressive 5,888 sq. ft. interior features 9 bedrooms, 7.5 bathrooms, and balconies that extend from almost every room, embracing the stunning views. Large windows flood each space with natural light from multiple angles. The home boasts neutral paint tones inside and out. Step beyond the manicured landscaping and oversized driveway into a grand foyer and living room with soaring ceilings, crown molding, and a cozy fireplace. The gourmet chef’s kitchen is a culinary delight, featuring granite countertops, sleek white cabinetry, a stainless steel cooktop, double oven, microwave, pantry, skylight, and abundant storage and counter space. The luxurious master suite includes a private balcony, fireplace, spa-like bathroom, and a spacious walk-in closet. The second floor features a massive family/entertainment room, two bedroom suites with full baths, a laundry room, and two additional bedrooms. The third level offers two more bedroom suites, two additional bedrooms, and a convenient laundry hookup. Soak in breathtaking city lights, 4th of July fireworks, and stunning mountain views, all with the backdrop of romantic sunsets. This entertainer’s dream home is close to the Hsi Lai Temple, supermarkets, restaurants, parks, shopping centers, and schools, with easy access to the 60 and 605 Freeways. Don’t miss this opportunity! Come see it to truly appreciate all it has to offer.
MlsNumber: --
ListingId: WS24205063


Listing Provided By: RE/MAX 2000 REALTY, original listing
Phone: (626) 328-6336
Office Phone: (626) 956-0188
Agent Name: PAUL WONG
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