Phone619-634-1895
Login or sign up for new accountLogin / Register
Email MeEmail Me
  • Search Listings
    • Residential
    • Lease
  • 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
    • Doyle
    • 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
  • Home
  • 5157 Waller Ave

5157 Waller Ave, Fremont, CA 94536

$1,599,888 Approx. USD 3 beds, 2 baths
1,384 sqft

  VIRTUAL TOUR
Save My Notes
Share
  • Copy Link
  • Facebook
  • Twitter
  • Pinterest
Source MLS Verified
MORE INFO
BrochureBrochure Virtual Tour

Photo of Daniel Alonso

Daniel Alonso REALTOR® - Sales Associate 619-634-1895 m
619-634-1895 o
Lic#: 02209782
NRDS ID: 196590735
DanielAlonso@bhhscal.com Text Me
Call My Cell
Call My Office
Lic#: 02209782
NRDS ID: 196590735
DanielAlonso@bhhscal.com San Diego Central Office
2355 Northside Drive, Suite 180
San Diego, CA 92108
Phone: 619-294-3113
Fax: 619-521-0100
 San Diego Central 2355 Northside Drive, Suite 180
San Diego, CA 92108
Call Branch Office
Fax: 619-521-0100
Mortgage Calculator
GET PRE-APPROVED
Interested in This Property? Your message will be sent to Daniel.
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

Listing Agent


Kurshed Deen | kurshed82@gmail.com
Lic#: 01312517
Broker: Courtesy of Legacy Real Estate & Assoc.
Phone: 510-468-6658

Agent Remarks

One of the most desirable homes in the Glenmoor neighborhood, this well-maintained single-story residence offers a bright, open floor plan with 3 bedrooms and 2 remodeled bathrooms. Features include dual-pane windows, vaulted ceilings, recessed lighting, ceiling fans, skylights, central A/C, and a combination of laminate flooring and carpet. The open kitchen features granite countertops, stainless steel appliances, and is perfect for everyday living and entertaining. This home has been extremely well maintained and offers a spacious, inviting atmosphere. The beautiful backyard includes mature fruit trees and a covered pergola, ideal for relaxing or hosting gatherings. Conveniently located with easy access to I-880, I-680, and the Dumbarton Bridge. Close to BART, ACE Train, shopping centers, and Centerville Station—making commuting simple and efficient.

Listing Details

Property type: Single Family Residence (Single Family)
Status: Pending
MLS# 41135707
Price: $1,599,888
HOA Fee is $540.00
Beds: 3
Baths: 2 (2 full)
Family Room,Wood Burning fireplaces
Built in 1962
1,384 sqft
1 story
0.16 acres
Lot size: 0.1607
Subdivision: GLENMOOR AREA
County: Alameda
Property style: Ranch
Construction: Stone,Stucco
Interior features: Eat-in Kitchen
Appliances: Gas Water Heater
Parking description: Garage,Garage Door Opener
Lot description: Back Yard,Front Yard,Sprinklers In Rear,Sprinklers In Front,Sprinklers Timer,Street Level,Yard
Heating/cooling: Central Air
Heating description: Forced Air

Last Updated: 6/4/2026

 Days On Market (DOM): 9

 Find more Fremont homes and real estate

 Find more homes in 94536 zip code

 Find more homes in the GLENMOOR AREA subdivision

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

Lat/Long: 37.537523, -122.004805.
Find nearby listings

DISCLAIMER: There is NO WARRANTY, expressed or implied, for the accuracy of this information or its applicability to your financial situation. Please consult your financial and/or tax advisor. GET PRE-APPROVED The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

94536 Area Map

Demographics

Schools

CLICK TO VIEW MAP

Similar Listings

Next Listing
5157 Eggers Dr VIRTUAL TOUR
5157 Eggers Dr ,
$1,699,900 Approx. USD 4 beds, 2 baths

List Date: 6/23/2026
 Status: Active
 MLS #: 41139353

My Notes Save
Listing courtesy of
5352 Selma Avenue VIRTUAL TOUR
5352 Selma Avenue ,
$1,699,999 Approx. USD 3 beds, 2 baths

List Date: 6/12/2026
 Status: Active
 MLS #: ML82049059

My Notes Save
Listing courtesy of
5346 Brophy Dr VIRTUAL TOUR
5346 Brophy Dr ,
$1,600,000 Approx. USD 4 beds, 2 baths

List Date: 6/24/2026
 Status: Active
 MLS #: 41139485

My Notes Save
Listing courtesy of
38811 Bonnie Way VIRTUAL TOUR
38811 Bonnie Way ,
$1,675,000 Approx. USD 4 beds, 2 baths

List Date: 5/7/2026
 Status: Active
 MLS #: 41133851

My Notes Save
Listing courtesy of
38850 Bonnie Way VIRTUAL TOUR
38850 Bonnie Way ,
$1,748,888 Approx. USD 4 beds, 2 baths

List Date: 5/29/2026
 Status: Pending
 MLS #: 41136595

My Notes Save
Listing courtesy of
37822 Granville Drive VIRTUAL TOUR
37822 Granville Drive ,
$1,550,000 Approx. USD 4 beds, 2 baths

List Date: 5/18/2026
 Status: Active
 MLS #: ML82047719

My Notes Save
Listing courtesy of
38475 Jacaranda Dr VIRTUAL TOUR
38475 Jacaranda Dr ,
$1,649,000 Approx. USD 4 beds, 3 baths

List Date: 5/14/2026
 Status: Active
 MLS #: 41132603

My Notes Save
Listing courtesy of
4457 Sacramento Avenue VIRTUAL TOUR
4457 Sacramento Avenue ,
$1,600,000 Approx. USD 4 beds, 2 baths

List Date: 6/22/2026
 Status: Active
 MLS #: 41139226

My Notes Save
Listing courtesy of
4436 Amador Road VIRTUAL TOUR
4436 Amador Road ,
$1,499,888 Approx. USD 3 beds, 2 baths

List Date: 6/15/2026
 Status: Active
 MLS #: SW26130330

My Notes Save
Listing courtesy of
4403 Amador VIRTUAL TOUR
4403 Amador ,
$1,498,000 Approx. USD 4 beds, 2 baths

List Date: 5/7/2026
 Status: Active
 MLS #: 41133933

My Notes Save
Listing courtesy of
Previous Listing
  • Search
    • 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
    • Doyle
    • Agents Only

Photo of Daniel Alonso

Daniel Alonso REALTOR® - Sales Associate 619-634-1895 m
619-634-1895 o
Lic#: 02209782
NRDS ID: 196590735
DanielAlonso@bhhscal.com Text Me
Call My Cell
Call My Office
Lic#: 02209782
NRDS ID: 196590735
DanielAlonso@bhhscal.com
San Diego Central Office
2355 Northside Drive, Suite 180
San Diego, CA 92108
hsoa-logo

© 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