Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$1,599,888 Just Listed

  • For Sale
  • Active
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 2 Car Garage
  • Updated 1 day ago

Next open house:

Open House: 1:00 PM - 4:30 PM

Saturday 5/30 1:00 PM - 4:30 PM

5157 Waller Ave,Fremont, CA 94536

5157 Waller AveFremontCA94536

Get directions

View more dates

Join us at 5157 Waller Ave on:

  • Open House: 1:00 PM - 4:30 PM

    Sunday 5/31 1:00 PM - 4:30 PM

    5157 Waller Ave,Fremont, CA 94536
    5157 Waller AveFremontCA94536
See This Home
Save This Home
See This Home
Save This Home
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.

Full Property Details for 5157 Waller Ave

General

  • Price: $1,599,888
  • HOA FEE: $45/month
  • HOA FEE FREQ.: Annually
  • Status: Active
  • Type: Single Family
  • Source: MAX
  • MLS ID: 41135707
  • Updated: 5/26/2026
  • Added to Site: 2 day(s) ago

Interior

  • Number of Rooms: 6
  • Interior Features: Family Room, Formal Dining Room
  • Number of Fireplaces: 1
  • Fireplace(s): Family Room, Wood Burning
  • Appliances: Dishwasher, Gas Range, Microwave, Refrigerator, Gas Water Heater
  • Flooring: Laminate, Tile, Carpet

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2

Bedrooms

  • Total Bedrooms: 3

Other Rooms

  • Kitchen: 220-Volt Outlet, Stone Counters, Tile Counters, Dishwasher, Eat-in Kitchen, Gas Range/Cooktop, Microwave, Refrigerator, Skylight(s)
  • Laundry: Hookups Only, In Garage

Additional Information

  • Shared Amenities: Greenbelt, Playground, Pool, Tennis Court(s)
  • Pool: Yes
  • Pool Description: None, Community

Exterior

  • Exterior Features: Back Yard, Front Yard, Side Yard, Sprinklers Automatic, Sprinklers Front

Parking

  • Attached garage: Yes
  • Garage Spaces: 2
  • Parking Features: Attached, Garage Door Opener

Location

  • Area: Listing
  • County: Alameda
  • Subdivision: Glenmoor Area
  • Driving Directions: Farwell- Waller.

Community

  • Association: Yes
  • Assoc. Name: GLENMOOR GARDENS HOA

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Ceiling Fan(s), Central Air
  • Heating Type: Forced Air

Utilities

  • Sewer: Public Sewer
  • Water: Public

Structural Information

  • Architectural Style: Ranch
  • Exterior Const.: Composition Shingles, Stone, Stucco
  • Roof: Composition Shingles
  • Windows: Double Pane Windows, Skylight(s)
  • Stories/Levels: One Story
  • Year Built: 1962

Lot Features

  • Lot Size (Acres): 0.16
  • Lot Dimensions: 7000
  • Lot Features: Level, Sprinklers In Rear

Financial Considerations

  • For Sale: Yes
  • Price Per Sq. Ft.: $1,156
  • Association Fee: $540
  • Assoc Fee Freq.: Annually

Disclosures and Reports

  • Property ID: 531280

Listed by Legacy Real Estate & Assoc., Kurshed Deen

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 5157 Waller Ave —

  • Kurshed Deen

    Legacy Real Estate & Assoc.

Off: 510-744-3500

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 5157 Waller Ave

School District:Fremont Unified School District
NameGradesDistance
John G. Mattos Elementary School
37944 Farwell Drive, Fremont, CA 94536
K-60.4 mi
G. M. Walters Middle School
39600 Logan Drive, Fremont, CA 94538
7-81.1 mi
John F. Kennedy High School, Fremont, CA
39999 Blacow Road, Fremont, CA 94538
9-121.1 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 5157 Waller Ave Get Price Alerts and Save Property

Date
Details
Price
Change
Source
5/26/2026
Listed
$1,599,888
6.66%
MLS
9/22/2021
Sold
$1,500,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 5157 Waller Ave

Year
Property Taxes
Change
Tax Assessment
Change
2025
$10,811
5%
$861,824
2%
2024
$10,313
3%
$844,930
2%
2023
$10,036
1%
$828,368
2%
2022
$9,906
-10%
$812,125
-12%
2021
$11,062
—
$919,779
1%
2020
$11,111
1%
$910,350
2%
2019
$10,982
2%
$892,507
2%
2018
$10,768
3%
$875,012
2%
2017
$10,498
10%
$857,858
11%
2016
$9,550
11%
$775,000
12%
2015
$8,621
7%
$695,000
8%
2014
$8,055
23%
$646,000
19%
2013
$6,556
—
$545,000
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 5157 Waller Ave

$
Down Payment
%
$
%

$
$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Legacy Real Estate & Assoc., Kurshed Deen

Similar Properties near 5157 Waller Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

5107 Royal Palm Dr, Fremont, CA 94538 - Photo 1 Just Listed
$1,599,999

5107 Royal Palm Dr  Fremont, CA 94538

  • Single Family
  • Active
  • Updated 6 hours ago
  • 3
    Beds
  • 2
    Total Baths
Listed by Fohl Realty & Investments, Kerissa Calvo and Fohl Realty & Investments, Les Fohl
41868 Gifford St, Fremont, CA 94538 - Photo 1
$1,600,000
Open House

41868 Gifford St  Fremont, CA 94538

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 2
    Total Baths
Listed by BHHS Drysdale Properties, Joanne Mendoza
4309 Jessica Cir, Fremont, CA 94555 - Photo 1
$1,599,000

4309 Jessica Cir  Fremont, CA 94555

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
Listed by Intero Real Estate Services, Megan Sharif
38590 Canyon Heights Dr, Fremont, CA 94536 - Photo 1
$1,648,000
Open House

38590 Canyon Heights Dr  Fremont, CA 94536

  • Single Family
  • Active
  • Updated 9 days ago
  • 3
    Beds
  • 2
    Total Baths
Listed by Joe Schembri (CalRE#: 00890599) (510) 774-4328

Just Listed near 5157 Waller Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

7995 Peachtree Ave, Newark, CA 94560 - Photo 1 Just Listed
$1,150,000
Open House

7995 Peachtree Ave  Newark, CA 94560

  • Single Family
  • Active
  • Updated 11 hours ago
  • 3
    Beds
  • 2
    Total Baths
Listed by Crossland Group (510) 608-7600
38912 Spicebush Pl, Newark, CA 94560 - Photo 1 Just Listed
$1,090,000

38912 Spicebush Pl  Newark, CA 94560

  • Townhouse
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 4
    Total Baths
  • 1,652
    Sq. Ft.
Listed by Xiaozhu Kang Daydreamer Team (408) 252-1133
6266 Joaquin Murieta Ave, Newark, CA 94560 - Photo 1 Just Listed
$575,000
Open House

6266 Joaquin Murieta Ave  #G  Newark, CA 94560

  • Condo
  • Active
  • Updated 11 hours ago
  • 2
    Beds
  • 1
    Total Bath
Listed by Crossland Group (510) 608-7600
37517 Bay Crest Rd, Newark, CA 94560 - Photo 1 Just Listed
$1,399,000

37517 Bay Crest Rd  Newark, CA 94560

  • Single Family
  • Active
  • Updated 4 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,364
    Sq. Ft.
Listed by Real Estate Avenue, Tim Truong and Real Estate Avenue, Minh Bui

Price Reduced near 5157 Waller Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

37231 Sand Bar Pl, Newark, CA 94560 - Photo 1 Price Reduced
-$30,000 (-1.62%)
$1,819,000

37231 Sand Bar Pl  Newark, CA 94560

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 4
    Total Baths
Listed by Excel Realty, Yusuf Nafey
37723 Cedar Blvd, Newark, CA 94560 - Photo 1 Price Reduced
-$19,112 (-2.33%)
$799,888
Open House

37723 Cedar Blvd  Newark, CA 94560

  • Townhouse
  • Active
  • Updated 19 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,478
    Sq. Ft.
Listed by Compass, Devon Stout
8553 Schooner Way, Newark, CA 94560 - Photo 1 Price Reduced
-$50,000 (-3.71%)
$1,298,000
Open House

8553 Schooner Way  Newark, CA 94560

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 3
    Total Baths
Listed by Intero Real Estate Services, Blanche Canio
35345 Cheviot Ct, Newark, CA 94560 - Photo 1 Price Reduced
-$49,888 (-2.94%)
$1,649,000
Open House

35345 Cheviot Ct  Newark, CA 94560

  • Single Family
  • Active
  • Updated 11 hours ago
  • 4
    Beds
  • 3
    Total Baths
Listed by Alliance Bay Realty, Fahao Qiao and Alliance Bay Realty, Marie Tara

Recent Sales near 5157 Waller Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

5233 Vernon Ave, Fremont, CA 94536 - Photo 1 Sold
$1,785,000

5233 Vernon Ave  Fremont, CA 94536

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
Listed by Belliveau Realty Group
Sold by Re/Max Accord, Sudhir Matthew
38465 Blacow Rd, Fremont, CA 94536 - Photo 1 Sold
$1,450,000

38465 Blacow Rd  Fremont, CA 94536

  • Single Family
  • Closed
  • 5
    Beds
  • 3
    Total Baths
Listed by Joe Schembri (CalRE#: 00890599)
Sold by Alliance Bay Realty, Manpreet Dhaday
5229 Sabin Ave, Fremont, CA 94536 - Photo 1 Sold
$1,815,000

5229 Sabin Ave  Fremont, CA 94536

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
Listed by Everhome, Patty Nunez
Sold by Fifty Hills Real Estate, Tu Thang Nguyen
38573 Farwell Dr, Fremont, CA 94536 - Photo 1 Sold
$1,652,000

38573 Farwell Dr  Fremont, CA 94536

  • Single Family
  • Closed
  • 4
    Beds
  • 2
    Total Baths
Listed by Legacy Real Estate & Assoc., Kathy Bartle
Sold by Golden State Realty, Jaswinder Gill

5157 Waller Ave, Fremont, CA 94536 (MLS# 41135707) is a Single Family property with 3 bedrooms and 2 full bathrooms. 5157 Waller Ave is currently listed for $1,599,888 and was received on May 26, 2026. Want to learn more about 5157 Waller Ave? Do you have questions about finding other Single Family real estate for sale in Fremont? You can browse all Fremont real estate or contact a Coldwell Banker agent to request more information.

Tour this property