- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
Listed by: Joe Schembri (510) 608-7667 DRE #00890599 | Coldwell Banker Realty (510) 608-7600
$2,488,000
Monthly Est:$12,384
4 Beds
- 3 Baths
2 full baths + 1 half bath
2,140sqft
45399 Little Ft Pl, Fremont, CA 94539
$2,488,000
$12,384/moEst:
Get Pre-Approved
Single Family Residence
Built in 1978
$-- HOA
6,579 sqft lot
$1,163/sq.ft
Description
Introducing this rarely available NE-facing Weibel home in one of Fremont’s most sought-after neighborhoods. This property is situated in a serene and private court location with beautiful views of the Mission Hills. The desirable 4-bedroom, 2.5-bathroom home boasts extensive upgrades and a modern floor plan. The custom double-door entry with soaring ceilings opens to a very bright formal living room and a large formal dining room. You will love the gourmet kitchen featuring custom cabinetry, granite slab countertops and backsplash, a breakfast bar center island, and quality stainless-steel appliances. The generous family room with a beautifully updated gas fireplace opens to the professionally landscaped backyard. Relax in the spacious primary suite featuring a completely remodeled bathroom with new tile, dual-sink vanity, and a walk-in shower with dual shower heads and body sprays. The remodeled hall bathroom offers new tile, dual-sink vanity, and a deep cast-iron soaking tub. Additional highlights include engineered hardwood flooring throughout, beautiful custom front door, updated solid wood interior doors, plantation shutters downstairs, LED recessed lighting, updated crown molding, updated chandeliers in the entryway and dining room, commercial-grade updated central air conditioning and furnace, attic and underfloor insulation, indoor laundry room with new washer and dryer, solar panels, an EV charger and finished and insulated garage. The exterior has been extensively upgraded with an updated red tile roof with radiant barrier sheathing, remodeled stucco façade, exterior paint, custom colored front concrete driveway, flagstone front porch, custom stamped concrete backyard patio, beautiful backyard lawn, play area, and updated fence. The property also offers additional parking space including side RV/boat parking. Enjoy the beautifully landscaped grounds, privacy, and peaceful setting while remaining close to top-rated Weibel schools, parks, hiking trails, shopping, dining, BART, and major commuter routes including I-680 and I-880, providing convenient access to Silicon Valley.
- Houzeo last checked: 7 minutes ago
- Listing updated: October 6, 2026 at 4:59 pm
- Source: California Regional MLS-CA | MLS#: 41149201

Property Details
Status
Active
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
Year Built
1978
HOA Fees
-
Finished Area
2,140 sqft
Lot Size
6,579 sqft lot
Basement Area
- sqft
MLS Name
California Regional MLS
MLS Number
41149201
MLS Status
Active
Days on Market
14
Cumulative Days on Market
13
Open House

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 3
Interior
Flooring
Tile, Wood
Cooling
Central Air
Heating
Forced Air
Appliances
Dryer, Washer
Construction
Year Built
Year Built: 1978
Home type
Single Family Residence
Architectural Style
Contemporary
Foundation Details
Raised
Construction Materials
Stucco
Roof
Tile
Utilities & Energy
Fireplace Features
Family Room, Gas
Parking Features
Garage, Garage Door Opener
Pool Features
None
Other Features
Lot Features
Back Yard, Front Yard
Patio And Porch Features
Patio
Subdivision Name
Weibel
Price History
| Date | Event | Price |
|---|---|---|
09/23/2026 Source: | Listed for Sale | $2,488,000 $1,163/sqft |
Nearby Homes
Find Homes by Property Features in Fremont, CA
Based on information from California Regional Multiple Listing Service, Inc. as of Oct 09, 2026, 08:15AM and /or other sources. 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 being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 California Regional Multiple Listing Service. All Rights Reserved.
Advertising Broker: William Johnson DRE #01463271 | William Johnson Brokerage