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;

2759 Starpine Drive
Duarte, CA 91010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,195,000
Beds: 5
Baths: 6
Status: Active
SqFt: 3333
Agency: Rodeo Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 17,296 sqft
Property Type: Residential
Year Built: 2011
Notes: Discover a splendid Tuscan-style residence with a Junior ADU tucked away in the private cul-de-sac of Ridgecrest Estates, nestled harmoniously near the coveted community of Bradbury within the tranquil foothills. This exceptional home is a masterpiece of elegance, graced with an expansive open floor plan, majestic cathedral ceilings, and opulent finishes. For culinary enthusiasts, the chef's kitchen is a dream come true, equipped with top-of-the-line stainless steel appliances, a wine fridge, a central island, and a convenient walk-in pantry. It seamlessly flows into the adjacent breakfast area and family room, where a warm fireplace creates a cozy ambiance. The grand living and dining rooms add a touch of formality, perfect for hosting exquisite gatherings. With two master bedrooms, one on the first floor for added convenience, and three additional bedrooms upstairs, each with its own beautifully appointed en-suite bath, this home ensures comfort and privacy for all residents and guests. Step into the outdoor oasis, where a resort-like setting awaits, perfect for entertaining. A striking fountain and meticulously designed landscaping provide a picturesque backdrop. The generously sized flat side yard offers ample space for a potential swimming pool, further enhancing the property's allure. This Tuscan-inspired haven combines sophistication and luxury, making it a truly exceptional residence in one of the most sought-after neighborhoods. Currently Tenant Occupied with Valid lease through 12/31/24. 5th 'bedroom' is the adu bedroom.
MlsNumber: SR24024571


Listing Provided By: Rodeo Realty, original listing
Name: Rodeo Realty
Phone: (310) 471-2600
Office Name: Rodeo Realty
Office Phone: (818) 986-7300
Agent Name: Poupee Komenkul
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