Beach Homes Realty
Enter City or Zip

46925 aloe court

Fremont, CA 94539

$3,998,000

5 BEDS 4 BATHS
4,598 SQFT0.52 AC LOT
Residential - Single Family
Image 1
Image 2
Image 3
Image 4
Bedrooms 5
Total Baths 4
Full Baths 3
Square Feet 4598
Acreage 0.5266
Status Pending
MLS # 41104716
County Alameda
More Info
Category Residential - Single Family
Status Pending
Square Feet 4598
Acreage 0.5266
MLS # 41104716
County Alameda
Magnificent Weibel custom home on half-acre premium lot offers sophisticated luxury in 4,598 sq. ft. Featuring 5 bedrooms, 3.5 baths, and 3-car epoxy-finished garage. Gourmet kitchen boasts custom cabinetry, granite surfaces, walk-in pantry, and new electric cooktop with breakfast nook capturing Bay views. Family room with vaulted ceilings and gas fireplace connects to covered patio. Primary suite includes walk-in closet, sitting area, and updated designer bath with dual sinks, glass shower and skylight. Four additional bedrooms with walk-in closets, one with private balcony. Formal living area features soaring ceilings and stained-glass windows; dining room showcases crystal chandelier and wet bar. Versatile in-law quarters with separate entrance includes kitchen, wine cellar, and full bath. Resort-style backyard with B&W speakers, stone pavers, panoramic views, mature landscaping and fountain pond. Premium features: Acacia hardwood, crown molding, dual-pane windows, fresh paint, updated secondary bath, efficient HVAC. Top-rated Weibel/Horner/Irvington schools. Minutes to 680/880, BART, and Silicon Valley tech companies.
Location not available

Exterior Features

  • Style Contemporary
  • Construction Single Family
  • Siding Stucco
  • Roof Tile
  • Garage Yes
  • Garage Description Garage, GarageDoorOpener
  • Sewer PublicSewer
  • Lot Description BackYard, FrontYard, SprinklersTimer, Yard

Interior Features

  • Heating ForcedAir
  • Cooling CentralAir
  • Fireplaces Yes
  • Fireplaces Description FamilyRoom, GasStarter
  • Living Area 4,598 SQFT
  • Year Built 1983

Neighborhood & Schools

  • Subdivision WEIBEL

Financial Information

  • Parcel ID 51916613

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Golden Gate Sotheby's Int'l
The data for this listing came from the California Regional MLS
Listing data is current as of 11/01/2025.
California DRE #02247371

Contact our Agent !

By clicking “Submit”, you agree that Beach Homes Realty, its affiliates, and real estate professionals may contact you by phone, text, or email to any phone number and email address you provided, including by automated means, even if your number is on a federal, state, or our internal Do Not Call list. You also agree to our Terms of Use and Privacy Policy.