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;

425 Greenbank Avenue
Duarte, CA 91010
Luther Tsinoglou with Compass, original listing - (626) 355-2384

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,298,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2568 Square Feet
Agency: Compass
Agency Phone: (626) 355-2384

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1954
Notes: Charming North Duarte Home with Endless Possibilities.<br /> Welcome to this stunning 3-bedroom, 2-bath home in Duarte. With just under 2,575 square feet of beautifully designed living space, this property is perfect for entertaining and for extended family. The main area of the home offers a spacious layout that measures approximately 1,800 square feet and includes a formal living room with a cozy fireplace, a large kitchen with built-in appliances, and a dining and family room with a second fireplace and access to the backyard. The primary suite is a relaxing retreat, featuring a custom walk-in closet and a spa-like bathroom with dual vanities, an oversized shower, and a soaking tub. Step outside from the primary bedroom to a private yard with an above-ground hot tub. <br /> The 768-square-foot fully permitted addition, used as an entertaining area is complete with a half bath and kitchenette, an attached covered patio and its own entry. Multiple options offered for this space as it can be used to host guests or used as a game room, home office and a potential auxiliary dwelling unit (ADU). The home offers multiple seating areas, two covered patios, a barbecue zone and a pond.<br /> Other features include hardwood and LVT flooring, built-in sound system, updated windows, custom built wood fencing, professionally landscaped grounds, two separate covered patio areas, pond, a BBQ island and bar. In addition, the home offers upgraded plumbing and electrical systems, air conditioning, ample onsite parking and an attached 2-car garage. Sitting on a 10,368-square-foot lot, there’s even space to add a pool!
MlsNumber: --
ListingId: AR25016040


Listing Provided By: Compass, original listing
Phone: (626) 695-8650
Office Phone: (626) 355-2384
Agent Name: Luther Tsinoglou
Disclaimer: Copyright © 2025 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