• buy
  • rent
  • sell
  • agents
new developmentWORLD OF ELLIMAN
The latest in luxury property, lifestyle & culture, curated just for you.

company

  • about us
  • leadership
  • offices
  • press & news
  • elliman cares
  • join as an agent
  • careers
  • INTERNATIONAL PARTNERSHIP
  • investors

resources

  • WORLD OF ELLIMAN
  • elliman insider
  • magazines
  • market reports
  • research reports
  • Elliman Exclusives
  • Featured Cities
  • guides to buying & selling

brand portfolio

  • new development
  • commercial
  • relocation
  • property management
  • sports & entertainment
  • farm & ranch
  • building broker specialists
  • title services
  • master trust & probate

  • California
  • Colorado
  • Connecticut
  • Florida
  • Massachusetts
  • Mid-Atlantic
  • Nevada
  • New Jersey
  • New York
  • New York City
  • Texas
  • Vermont
  • SITE MAP
  • TERMS
  • PRIVACY
  • COOKIE PREFERENCES
  • DO NOT SELL OR SHARE MY PERSONAL INFORMATION
  • NYS Housing Discrimination Disclosure Notice & Form
  • NYS Standard Operating Procedure
  • NYS Tenants' Rights to Reasonable Accommodations for persons with disabilities
  • California Consumer Privacy Act Notice
  • Texas Consumer Protection Notice
  • Texas Real Estate Commission Information About Brokerage Services
  • text of new york city human rights law
  • new york city commission on human rights
  • nyc source of income discrimination information
  • nyc source of income discrimination tenant faqs

THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. FOR COLORADO VIEWERS, INFORMATION ABOUT NON-COMMERCIAL PROPERTIES IS PROVIDED EXCLUSIVELY FOR YOUR PERSONAL, NON-COMMERCIAL USE.

575 MADISON AVENUE, NEW YORK, NY 10022. 212.891.7000 © 2025 DOUGLAS ELLIMAN REAL ESTATE. EQUAL EMPLOYMENT OPPORTUNITY PROVIDER. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES, OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS, AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT, OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY.LISTING DATA REFRESHED ON SEP 19 2025 AT 4:58 PM.

DOUGLAS ELLIMAN IS A LICENSED REAL ESTATE BROKER IN CALIFORNIA WITH LICENSE # 01947727, COLORADO WITH LICENSE # EC100053892, CONNECTICUT WITH LICENSE # REB.0314827, THE DISTRICT OF COLUMBIA WITH LICENSE # REO40000160, FLORIDA WITH LICENSE # CQ1020232, MARYLAND WITH LICENSE # 645270, MASSACHUSETTS WITH LICENSE # 422764, NEVADA WITH LICENSE # 1454643, NEW JERSEY WITH LICENSE # 0572105, NEW YORK WITH LICENSE # 10991211812, TEXAS WITH LICENSE # 9008706, AND VIRGINIA WITH LICENSE # 0226035659.

POWERED BY PURLIN.AI

46925 Aloe Ct

fremont, CA 94539

$3,998,000

  • 5 BR
    3 BA, 1 HALF BA
    APPROX. 4,598 SF
  • contract signed

INTERESTED? LET'S CONNECT

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.

Details

4,598 Sq Ft

0.5266 Private Acres Exterior Space

Single Family Home

Built in 1983

MLS/Listing ID 41104716

2 Stories

Amenities & Features

Style - Contemporary

Construction - Stucco

Cooling - Central Air

Family Room Fireplace

Gas Starter Fireplace

Carpet

Tile

Natural Wood

Heating - Forced Air

Breakfast Area

Eat-in Kitchen

Lot - Backyard

Lot - Front Yard

Lot - Sprinklers on Timer

Hills View

Bay View

Parking - Garage Door Opener

Parking - Garage

Lot - Yard

Listing Courtesy of GOLDEN GATE SOTHEBY'S INT'L, JOSEPH SABEH JR - 415-385-6442

CRMLS

Source of Data: CALIFORNIA REGIONAL MULTIPLE LISTING SERVICE

Interested in 46925 Aloe Ct?