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;

6819 Oak Avenue
San Gabriel, CA 91775
ANDREW PHU with COLDWELL BANKER DYNASTY/TC, original listing - (626) 309-1900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,998,888
Beds: 7
Baths: Full: 5, ½: 1, ¾: 2
Status: Active
SqFt: 3884 Square Feet
Agency: COLDWELL BANKER DYNASTY/TC
Agency Phone: (626) 309-1900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Welcome Home to San Gabriel's finest Brand New dream home(s) perfectly situated in a highly desirable North SG neighborhood + within the Temple City School District! Don't miss this rare opportunity to purchase (2) Two Detached Homes (Both 2025 Year Built) featuring a Mediterranean/Modern design with elegant & luxurious fixtures & materials throughout. This unique property includes Main SFR House + ADU with separate entrances, driveways, and addresses. Main House (6819 N Oak Ave) has an excellent floor plan featuring 2,686 sq.ft. with a total of 4 bedrooms and 4.5 baths including an en-suite bedroom on main floor. Attached 2 car garage epoxy flooring has direct interior access. Warming fireplace within the bright entry/living room, crown molding & wainscoting, elegant modern chandelier above the stairway. Gourmet kitchen w/white cabinetry, quartz counters & backsplash, high end Thermador appliances, a gorgeous waterfall design center island, and much more. Relax and rest within the primary suite featuring walk-in closet, dual sinks in primary bath with a frameless glass enclosed shower, and separate jetted tub. Bonus: Mini loft with balcony. Both main house & ADU have recessed lighting, fire sprinklers, home security system cameras, tankless water heaters, (2) separate central HVAC systems, auto sprinklers, and both homes fully equipped with solar panels system fully paid off, (2) EV chargers installed each homes garage. ADU Home (9184 E Leroy St.) features a wonderful 1,198 sq.ft. floor plan with 3 bedrooms and 3 bathrooms and one-car attached garage. You will be impressed that both homes have separate motorized gates to access their own private driveway/front door for improved privacy, and separate gas, electricity, & water meters for easier management. Walking distance to schools. Must see to appreciate! Come visit and check out this magnificent property, ideal opportunity to make this dream home yours!
MlsNumber: --
ListingId: WS25060849


Listing Provided By: COLDWELL BANKER DYNASTY/TC, original listing
Phone: (626) 329-1669
Office Phone: (626) 309-1900
Agent Name: ANDREW PHU
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