Home | Alameda County | Fremont | 94538 | 4754 Bret Harte Ct
MLS: ML82048076 | Status: Active | Price: $1,848,000
Beds/Baths: 4 / 3
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 3 | 1,898 | 6,693 | 1959 |
| Date | Time | Hosted By |
|---|---|---|
| Saturday, May 23 | 1:00 pm - 4:00 pm | Dinesh Nagar |
| Sunday, May 24 | 1:00 pm - 4:00 pm | Dinesh Nagar |
Rare Dual Primary Suites & Bonus Office in an Unbeatable Location! Experience modern luxury in this meticulously transformed 4-bed, 3-bath cul-de-sac home in the heart of Fremont. Spanning 1,898 sq. ft. on a generous 6,693 sq. ft. lot, this turn-key residence is completely reimagined with high-end finishes, new kitchen, all-new flooring, and fresh interior and exterior paint. * KEY FEATURES * ULTIMATE LAYOUT FLEXIBILITY: A highly desirable, one-level floor plan with TWO primary suites. Ideal for multi-generational living or extended family or long-term guests. TRUE WORK-FROM-HOME SPACE: A private bonus office creates an ideal remote work environment without sacrificing a bedroom. DESIGNED FOR ENTERTAINING: A stunning open kitchen flows seamlessly into the family room, complemented by a separate, expansive formal living room filled with natural light. MODERN COMFORTS: The property flows beautifully with abundant ambient light and fresh air from all sides. Enjoy year-round efficiency with multi-zone AC, a 2-car garage, and thoughtful updates. COMMUTERS DREAM: Minutes to 880, 237, 84, 680, and BART. Close to top-tier shopping and dining at Costco, Pacific Commons, NewPark Mall, and the Fremont Hub.
| Field | Value |
|---|---|
| MLS # | ML82048076 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 1 |
| Feature | Details |
|---|---|
| Bedrooms | Ground Floor Bedroom, Primary Suite/Retreat, Primary Suite/Retreat - 2+, Primary Bedroom on Ground Floor, More than One Bedroom on Ground Floor, More than One Primary Bedroom, More than One Primary Bedroom on Ground Floor |
| Bathrooms | Bidet, Double Sinks, Dual Flush Toilet, Granite, Primary - Stall Shower(s), Shower and Tub, Shower over Tub - 1, Stall Shower - 2+, Tile, Updated Bath(s) |
| Kitchen | 220 Volt Outlet, Countertop - Marble, Exhaust Fan, Hookups - Gas, Hookups - Ice Maker, Island |
| Appliances | Cooktop - Gas, Dishwasher, Exhaust Fan, Hood Over Range, Oven - Electric, Oven - Self Cleaning, Oven Range, Refrigerator, Dryer, Washer, Washer/Dryer |
| Dining Room | Breakfast Bar, Breakfast Nook, Dining Area, Dining Area in Living Room, Eat in Kitchen |
| Family Room | Kitchen/Family Room Combo |
| Flooring | Laminate, Tile |
| Laundry | In Garage, Inside, In Utility Room |
| Cooling | Multi-Zone, Window/Wall Unit |
| Heating | Central Forced Air, Central Forced Air - Gas, Forced Air |
| Feature | Details |
|---|---|
| Roof | Shingle |
| Foundation | Block, Combination, Crawl Space |
| Pool | None |
| Style | Ranch, Traditional |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage: 2 Car(s) |
| Elementary District | Fremont Unified |
| High School District | Fremont Unified |
| Sewer | Public Sewer |
| E.V. Hookup | Electric Vehicle Hookup Level 1 (120 volts) |
| Water | Public |
| Zoning | R-1 (Single-Family Reside |
Dinesh Nagar
Doorlight Inc
License #: 02339624
Phone: (408) 802-1524
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Young Adult Program | public | 9-12 | 0.21 mi | N/A |
| Fremont Adult | public | UG | 0.22 mi | N/A |
| Joseph Azevada Elementary School | public | TK,KG,1,2,3,4,5 | 0.50 mi | 7 |
| Glankler Early Learning Center | public | KG | 0.52 mi | N/A |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 0.55 mi | 7 |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 0.56 mi | 5 |
| G. M. Walters Middle School | public | 6-8 | 0.62 mi | 8 |
| Glenmoor Elementary School | public | K-5 | 0.71 mi | 8 |
| John F. Kennedy High School | public | 9-12 | 0.78 mi | 7 |
| John G. Mattos Elementary School | public | K-5 | 0.92 mi | 8 |
| Mission Valley Rocp School | public | 9-12 | 0.93 mi | N/A |
| Washington High School | public | 9-12 | 0.98 mi | 9 |
| Newark Memorial High School | public | 9-12 | 1.26 mi | 6 |
| Centerville Middle School | public | 6-8 | 1.29 mi | 8 |
| John Blacow Elementary School | public | TK,KG,1,2,3,4,5 | 1.31 mi | 7 |
| Birch Grove Primary | public | KG,1,2 | 1.32 mi | N/A |
| Birch Grove Intermediate | public | 3,4,5 | 1.52 mi | 7 |
| J. Haley Durham Elementary School | public | TK,KG,1,2,3,4,5 | 1.64 mi | 9 |
| Parkmont Elementary School | public | TK,KG,1,2,3,4,5 | 1.67 mi | 9 |
| Steven Millard Elementary School | public | TK,KG,1,2,3,4,5 | 1.73 mi | 8 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 38475 Jacaranda Dr | $1,649,000 | 4 | 3 | 1,678 | Active |
| 35924 Nicolet Ct | $2,188,000 | 4 | 3 | 2,160 | Active |
| 41868 Gifford Street | $1,600,000 | 3 | 2 | 1,310 | Active |
| 39734 Tomcod St | $2,180,000 | 4 | 3 | 2,300 | Active |
©2026 MLSListings Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of May 21, 2026. For the most current information, please contact Dinesh Nagar, (408) 802-1524.