


Listing Courtesy of:
bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty 45399 Little Foot Pl Fremont, CA 94539
Active (2 Days)
$2,488,000 (USD)
OPEN HOUSE TIMES
-
OPENSat, Sep 261:00 pm - 5:00 pm
-
OPENSun, Sep 271:00 pm - 5:00 pm
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.
MLS #:
41149201
41149201
Lot Size
6,579 SQFT
6,579 SQFT
Type
Single-Family Home
Single-Family Home
Year Built
1978
1978
Style
Contemporary
Contemporary
Views
Hills
Hills
School District
Fremont (510) 657-2350
Fremont (510) 657-2350
County
Alameda County
Alameda County
Community
Weibel
Weibel
Listed By
Joseph "Joe" Schembri, DRE #00890599 CA, Coldwell Banker Realty
Source
bridgeMLS
Last checked Sep 25 2026 at 10:00 AM GMT+0000
bridgeMLS
Last checked Sep 25 2026 at 10:00 AM GMT+0000
Bathroom Details
- Full Bathrooms: 2
- Partial Bathroom: 1
Interior Features
- Refrigerator
- Dryer
- Washer
- Laundry: Dryer
- Laundry: Laundry Room
- Laundry: Washer
- Windows: Window Coverings
- Dining Area
- Family Room
- Updated Kitchen
- Electric Range
Kitchen
- Electric Range/Cooktop
- Refrigerator
- Updated Kitchen
- Stone Counters
- Kitchen Island
Subdivision
- Weibel
Lot Information
- Back Yard
- Front Yard
- Court
- Premium Lot
- Landscaped
Property Features
- Fireplace: Family Room
- Fireplace: Stone
- Fireplace: Gas
- Fireplace: 1
- Foundation: Raised
Heating and Cooling
- Forced Air
- Central
- Fireplace(s)
- Central Air
Pool Information
- None
Flooring
- Hardwood Flrs Throughout
- Tile
Exterior Features
- Roof: Tile
Utility Information
- Sewer: Public Sewer
Garage
- Garage
Parking
- Attached
- Int Access From Garage
- Garage Door Opener
- Garage Faces Front
- Electric Vehicle Charging Station(s)
Stories
- 2
Living Area
- 2,140 sqft
Location
Estimated Monthly Mortgage Payment
*Based on Fixed Interest Rate withe a 30 year term, principal and interest only
Listing price
Down payment
%
Interest rate
%Mortgage calculator estimates are provided by Coldwell Banker Real Estate LLC and are intended for information use only. Your payments may be higher or lower and all loans are subject to credit approval.
Disclaimer: Bay East© 2026. CCAR ©2026. bridgeMLS ©2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated at: 9/25/26 03:00