• Facebook
  • Instagram
Phone310-890-6928
Login or sign up for new accountLogin / Register
Email MeEmail Me
  • Search Listings
    • Residential
    • Lease
  • My Listings
  • Previous Sales
  •   Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Onepoint
    • Home Financing
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PRESALE/STAGING
    • Relocation
  •     About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Agents Only
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
VIRTUAL TOUR
45399 Little Foot Pl Fremont, CA 94539
$2,488,000 4 beds, 3 baths
2, 140 sqft
Save My Notes
 

Photo of Jesse Hlubik

Jesse Hlubik REALTOR® - Sales Associate 310-890-6928 m
310-890-6928 o
Lic#: 01801928
NRDS ID: 207054480
Jesse@HomeSearchLA.com
Text Me
Call My Cell
Call My Office
Lic#: 01801928
NRDS ID: 207054480
Jesse@HomeSearchLA.com
Sherman Oaks Office
14141 Ventura Blvd., Ste. 8
Sherman Oaks, CA 91423
Phone: 818-528-3200
Fax: 818-386-9007
Sherman Oaks 14141 Ventura Blvd., Ste. 8
Sherman Oaks, CA 91423
Call Branch Office
Fax: 818-386-9007
Interested in This Property? Your message will be sent to Jesse.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Agent Remarks

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.

Listing Details

Property type: Single Family Residence (Single Family)
Status: Active
MLS# 41149201
List price is $2,488,000
Beds: 4
Baths: 3 (2 full) (1 half)
Family Room,Gas fireplaces
Built in 1978
2,140 sqft
2 stories
0.15 acres
Lot size: 0.1510
Subdivision: WEIBEL
County: Alameda
Property style: Contemporary
Construction: Stucco
Appliances: Dryer,Washer
Parking description: Garage,Garage Door Opener
Lot description: Back Yard,Front Yard
Heating/cooling: Central Air
Heating description: Forced Air

Last Updated: 10/6/2026

 Find more Fremont homes and real estate

 Find more homes in 94539 zip code

 Find more homes in the WEIBEL subdivision

The style of this listing is Contemporary.
Find more Contemporary style homes for sale

Lat/Long: 37.504996, -121.922158.
Find nearby listings


Listing Agent: Joe Schembri
Lic#: 01801928
Office Name: Sherman Oaks

Area Map

CLICK TO VIEW MAP

Nearby Schools

No schools were found in the area

Area Overview

Total population of , which has changed by % since 1990.
The median age of the population is , while the median age of dwellings is .
Out of households, are families.

Community Characteristics:

Occupancy Type

White/Blue Collar Jobs

Population by Gender

Hispanic/Non-Hispanic Population

Compared to National:

  • Search
    • My Active Listings
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Agents Only

Photo of Jesse Hlubik

Jesse Hlubik REALTOR® - Sales Associate 310-890-6928 m
310-890-6928 o
Lic#: 01801928
NRDS ID: 207054480
Jesse@HomeSearchLA.com
Text Me
Call My Cell
Call My Office
Lic#: 01801928
NRDS ID: 207054480
Jesse@HomeSearchLA.com

Sherman Oaks Office
14141 Ventura Blvd., Ste. 8
Sherman Oaks, CA 91423
hsoa-logo
  • Facebook
  • Instagram

© 2026 BHH Affiliates, LLC. An independently operated subsidiary of HomeServices of America, Inc., a Berkshire Hathaway affiliate, and a franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status