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.
For sale
$2,488,000
45399 Little Foot Pl, Fremont, CA 94539
4beds
2,140sqft
Residential, Single Family Residence
Built in 1978
6,579 Square Feet Lot
$2,403,900 Zestimate®
$1,163/sqft
$-- HOA
What's special
Play areaProfessionally landscaped backyardUpdated fenceFlagstone front porchGourmet kitchenBreakfast bar center islandCustom cabinetry
- 1 day
- 391
- 22
Zillow last checked:
Listing updated:
Listed by:
Joe Schembri DRE #00890599 510-608-7667,
Coldwell Banker Realty
Source: Bay East AOR,MLS#: 41149201
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- Partial bathrooms: 1
Rooms
- Room types: 0.5 Bath, Main Entry, 4 Bedrooms, 2 Baths, Dining Room, Family Room, Dining Area, Laundry, Living Room
Bathroom
- Features: Stall Shower, Tile, Updated Baths, Tub
Kitchen
- Features: Stone Counters, Electric Range/Cooktop, Kitchen Island, Refrigerator, Updated Kitchen
Heating
- Forced Air, Central, Fireplace(s)
Cooling
- Central Air
Appliances
- Included: Electric Range, Refrigerator, Dryer, Washer
- Laundry: Laundry Room
Features
- Updated Kitchen
- Flooring: Hardwood, Tile
- Windows: Window Coverings
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas, Stone
Interior area
- Total structure area: 2,140
- Total interior livable area: 2,140 sqft
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached, Direct Access, Electric Vehicle Charging Station(s), Garage Faces Front, Garage Door Opener
- Garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio
- Pool features: None
- Fencing: Fenced
- Has view: Yes
- View description: Hills
Lot
- Size: 6,579 Square Feet
- Features: Court, Premium Lot, Back Yard, Front Yard, Landscaped
Details
- Parcel number: 519165615
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Foundation: Raised
- Roof: Tile
Condition
- Existing
- New construction: No
- Year built: 1978
Utilities & green energy
- Electric: Photovoltaics Seller Owned
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Security: Carbon Monoxide Detector(s), Smoke Detector(s)
- Subdivision: Weibel
HOA
- Has HOA: No
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $1,163/sqft
- Tax assessed value: $1,344,997
- Price range: $2.5M - $2.5M
- Date on market: 9/24/2026
- Listing agreement: Excl Right
- Listing terms: Cash,Conventional
Estimated market value
$2,403,900
$2.21M - $2.60M
$5,369/mo
Price history
| Date | Event | Price |
|---|---|---|
| 9/24/2026 | Listed for sale | $2,488,000+157.8%$1,163/sqft |
Source: | ||
| 6/9/2006 | Sold | $965,000+10.3%$451/sqft |
Source: Public Record Report a problem | ||
| 9/12/2005 | Sold | $875,000$409/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $1,344,997 +2% |
| 2025 | $16,180 +5.1% | $1,318,633 +2% |
| 2024 | $15,391 +2.7% | $1,292,780 +2% |
| 2023 | $14,991 +1.2% | $1,267,440 +2% |
| 2022 | $14,815 +2.6% | $1,242,591 +2% |
| 2021 | $14,446 -0.7% | $1,218,234 +1% |
| 2020 | $14,545 +1.2% | $1,205,748 +2% |
| 2019 | $14,376 +4.6% | $1,182,114 +2% |
| 2018 | $13,744 | $1,158,945 +2% |
| 2017 | $13,744 +1.7% | $1,136,229 +2% |
| 2016 | $13,519 +3% | $1,113,957 +1.5% |
| 2015 | $13,126 | $1,097,233 +2% |
| 2014 | $13,126 | $1,075,743 +15.7% |
| 2013 | -- | $930,000 +2.2% |
| 2012 | -- | $910,000 |
| 2011 | -- | $910,000 +3.8% |
| 2010 | -- | $877,000 -9.1% |
| 2009 | -- | $965,000 |
| 2008 | -- | $965,000 |
| 2007 | -- | $965,000 +10.3% |
| 2006 | -- | $875,000 +221.1% |
| 2005 | -- | $272,509 +2% |
| 2004 | -- | $267,167 +1.9% |
| 2003 | -- | $262,271 +2% |
| 2002 | -- | $257,129 +2% |
| 2001 | $2,817 | $252,087 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: Weibel
Nearby schools
Schools provided by the listing agent
- District: Fremont (510) 657-2350
Source: Bay East AOR. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.



