Buy
  • Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (752)
    Mexico Listings (331)
    Central America Listings (627)
    Caribbean Islands Listings (44)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7743017
MLS #41135707
Listing photo

One of the most desirable homes in the Glenmoor neighborhood

5157 Waller Ave, Fremont, California, 94536
$1,599,888
3Beds
2Baths
1,384Sqft
0.161Acres

About this property

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.

Property Features

3 Beds
2 Baths
1,384 Sqft
Built in 1962
0.161 Acres
1 Story
Open
Siding: Composition Shingles, Stone, Stucco
Composition Roof
Has Fireplace
Forced Air
Alameda County
Glenmoor Area Community

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Kurshed Deen

Legacy Real Estate & Associates

510-468-6658

Location

Map
Listing Agent: Kurshed Deen 510-468-6658
Broker: Legacy Real Estate & Associates 510-744-3500 Listing Site
Copyright © 2026 Bay East. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Jul 24, 2026

Photo Gallery

One of the most desirable homes in the Glenmoor neighborhood - photo 1
One of the most desirable homes in the Glenmoor neighborhood - photo 2
One of the most desirable homes in the Glenmoor neighborhood - photo 3
One of the most desirable homes in the Glenmoor neighborhood - photo 4
One of the most desirable homes in the Glenmoor neighborhood - photo 5
One of the most desirable homes in the Glenmoor neighborhood - photo 6
One of the most desirable homes in the Glenmoor neighborhood - photo 7
One of the most desirable homes in the Glenmoor neighborhood - photo 8
One of the most desirable homes in the Glenmoor neighborhood - photo 9
One of the most desirable homes in the Glenmoor neighborhood - photo 10
One of the most desirable homes in the Glenmoor neighborhood - photo 11
One of the most desirable homes in the Glenmoor neighborhood - photo 12
One of the most desirable homes in the Glenmoor neighborhood - photo 13
One of the most desirable homes in the Glenmoor neighborhood - photo 14
One of the most desirable homes in the Glenmoor neighborhood - photo 15
One of the most desirable homes in the Glenmoor neighborhood - photo 16
One of the most desirable homes in the Glenmoor neighborhood - photo 17
One of the most desirable homes in the Glenmoor neighborhood - photo 18
One of the most desirable homes in the Glenmoor neighborhood - photo 19
One of the most desirable homes in the Glenmoor neighborhood - photo 20
One of the most desirable homes in the Glenmoor neighborhood - photo 21
One of the most desirable homes in the Glenmoor neighborhood - photo 22
One of the most desirable homes in the Glenmoor neighborhood - photo 23
One of the most desirable homes in the Glenmoor neighborhood - photo 24
One of the most desirable homes in the Glenmoor neighborhood - photo 25
One of the most desirable homes in the Glenmoor neighborhood - photo 26
One of the most desirable homes in the Glenmoor neighborhood - photo 27
One of the most desirable homes in the Glenmoor neighborhood - photo 28
One of the most desirable homes in the Glenmoor neighborhood - photo 29
One of the most desirable homes in the Glenmoor neighborhood - photo 30
One of the most desirable homes in the Glenmoor neighborhood - photo 31
One of the most desirable homes in the Glenmoor neighborhood - photo 32
One of the most desirable homes in the Glenmoor neighborhood - photo 33
One of the most desirable homes in the Glenmoor neighborhood - photo 34

$1,599,888

3
Beds
2
Baths
1,384
Sqft

5157 Waller Ave, Fremont, California, 94536

By contacting this agent you agree to these Terms and Conditions.
Home California Fremont
One of the most desirable homes in the Glenmoor neighborhood - photo 1
One of the most desirable homes in the Glenmoor neighborhood - photo 2
One of the most desirable homes in the Glenmoor neighborhood - photo 3
One of the most desirable homes in the Glenmoor neighborhood - photo 4
One of the most desirable homes in the Glenmoor neighborhood - photo 5
MLS# 41135707
Home Sale Pending

One of the most desirable homes in the Glenmoor neighborhood

$1,599,888

5157 Waller Ave, Fremont, California, 94536

3
Beds
2
Baths
1,384
Sqft
0.161
Acres
$1,599,888
5157 Waller Ave, Fremont, California, 94536
3 Beds
2 Baths
1,384 Sqft
0.161 Acres
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.
15 days
on BeachHouse.com
20
views
0
saves

Property Details

HOME DETAILS

3 Beds
2 Baths
1,384 Sqft
Built in 1962
0.161 Acres
1 Story

EXTERIOR

Open
Siding: Composition Shingles, Stone, Stucco
Composition Roof

INTERIOR

Has Fireplace
Forced Air

FINANCIAL & COMMUNITY

Alameda County
Glenmoor Area Community
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7743017
Viewed
20 times
Listing Status
Pending
Added
Jul 09, 2026
Last Refresh
Jul 24, 2026 04:01:17 PM

Listing Information

Data Source
Bay East
Source Property ID
41135707
Listing Agent: Kurshed Deen 510-468-6658
Broker: Legacy Real Estate & Associates 510-744-3500 Listing Site
Copyright © 2026 Bay East. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
Welcome to this beautifully updated single-story home nestled on - photo 1
Welcome to this beautifully updated single-story home nestled on - photo 2
Welcome to this beautifully updated single-story home nestled on - photo 3
Welcome to this beautifully updated single-story home nestled on - photo 4
Welcome to this beautifully updated single-story home nestled on - photo 5
Welcome to this beautifully updated single-story home nestled on - photo 6
Welcome to this beautifully updated single-story home nestled on - photo 7
Welcome to this beautifully updated single-story home nestled on - photo 8
Welcome to this beautifully updated single-story home nestled on - photo 9
Welcome to this beautifully updated single-story home nestled on - photo 10
Welcome to this beautifully updated single-story home nestled on - photo 11
Welcome to this beautifully updated single-story home nestled on - photo 12
Welcome to this beautifully updated single-story home nestled on - photo 13
Welcome to this beautifully updated single-story home nestled on - photo 14
Welcome to this beautifully updated single-story home nestled on - photo 15
Welcome to this beautifully updated single-story home nestled on - photo 16
Welcome to this beautifully updated single-story home nestled on - photo 17
Welcome to this beautifully updated single-story home nestled on - photo 18
Welcome to this beautifully updated single-story home nestled on - photo 19
Welcome to this beautifully updated single-story home nestled on - photo 20
Welcome to this beautifully updated single-story home nestled on - photo 21
Welcome to this beautifully updated single-story home nestled on - photo 22
Welcome to this beautifully updated single-story home nestled on - photo 23
Welcome to this beautifully updated single-story home nestled on - photo 24
Welcome to this beautifully updated single-story home nestled on - photo 25
Welcome to this beautifully updated single-story home nestled on - photo 26
Welcome to this beautifully updated single-story home nestled on - photo 27
Welcome to this beautifully updated single-story home nestled on - photo 28
Welcome to this beautifully updated single-story home nestled on - photo 29
Welcome to this beautifully updated single-story home nestled on - photo 30
Welcome to this beautifully updated single-story home nestled on - photo 31
Welcome to this beautifully updated single-story home nestled on - photo 32
Welcome to this beautifully updated single-story home nestled on - photo 33
Welcome to this beautifully updated single-story home nestled on - photo 34
Welcome to this beautifully updated single-story home nestled on - photo 35
Welcome to this beautifully updated single-story home nestled on - photo 36
Welcome to this beautifully updated single-story home nestled on - photo 37
Welcome to this beautifully updated single-story home nestled on - photo 38
Welcome to this beautifully updated single-story home nestled on - photo 39
Welcome to this beautifully updated single-story home nestled on - photo 40
Welcome to this beautifully updated single-story home nestled on - photo 41
Welcome to this beautifully updated single-story home nestled on - photo 42
Welcome to this beautifully updated single-story home nestled on - photo 43
Welcome to this beautifully updated single-story home nestled on - photo 44
Welcome to this beautifully updated single-story home nestled on - photo 45
Welcome to this beautifully updated single-story home nestled on - photo 46
Welcome to this beautifully updated single-story home nestled on - photo 47
Welcome to this beautifully updated single-story home nestled on - photo 48
Welcome to this beautifully updated single-story home nestled on - photo 49
Welcome to this beautifully updated single-story home nestled on - photo 50

$1,899,000

3 Beds | 2.0 Baths | 1,633 Sqft

34312 CORNWALLIS CT, Fremont, CA, 94555

Welcome to this beautifully updated single-story home nestled on

Added: 07/06/2026 • Updated: 07/06/2026
For Sale
Beautifully upgraded smart home located in Fremont's desirable - photo 1
Beautifully upgraded smart home located in Fremont's desirable - photo 2
Beautifully upgraded smart home located in Fremont's desirable - photo 3
Beautifully upgraded smart home located in Fremont's desirable - photo 4
Beautifully upgraded smart home located in Fremont's desirable - photo 5
Beautifully upgraded smart home located in Fremont's desirable - photo 6
Beautifully upgraded smart home located in Fremont's desirable - photo 7
Beautifully upgraded smart home located in Fremont's desirable - photo 8
Beautifully upgraded smart home located in Fremont's desirable - photo 9
Beautifully upgraded smart home located in Fremont's desirable - photo 10
Beautifully upgraded smart home located in Fremont's desirable - photo 11
Beautifully upgraded smart home located in Fremont's desirable - photo 12
Beautifully upgraded smart home located in Fremont's desirable - photo 13
Beautifully upgraded smart home located in Fremont's desirable - photo 14
Beautifully upgraded smart home located in Fremont's desirable - photo 15
Beautifully upgraded smart home located in Fremont's desirable - photo 16
Beautifully upgraded smart home located in Fremont's desirable - photo 17
Beautifully upgraded smart home located in Fremont's desirable - photo 18
Beautifully upgraded smart home located in Fremont's desirable - photo 19
Beautifully upgraded smart home located in Fremont's desirable - photo 20
Beautifully upgraded smart home located in Fremont's desirable - photo 21
Beautifully upgraded smart home located in Fremont's desirable - photo 22
Beautifully upgraded smart home located in Fremont's desirable - photo 23
Beautifully upgraded smart home located in Fremont's desirable - photo 24
Beautifully upgraded smart home located in Fremont's desirable - photo 25
Beautifully upgraded smart home located in Fremont's desirable - photo 26
Beautifully upgraded smart home located in Fremont's desirable - photo 27
Beautifully upgraded smart home located in Fremont's desirable - photo 28

$1,898,888

4 Beds | 2.0 Baths | 1,625 Sqft

43225 Mintwood St, Fremont, CA, 94550

Beautifully upgraded smart home located in Fremont's desirable

Added: 07/09/2026 • Updated: 07/09/2026
For Sale
The quintessential Niles home! A polished gem that has been - photo 1
The quintessential Niles home! A polished gem that has been - photo 2
The quintessential Niles home! A polished gem that has been - photo 3
The quintessential Niles home! A polished gem that has been - photo 4
The quintessential Niles home! A polished gem that has been - photo 5
The quintessential Niles home! A polished gem that has been - photo 6
The quintessential Niles home! A polished gem that has been - photo 7
The quintessential Niles home! A polished gem that has been - photo 8
The quintessential Niles home! A polished gem that has been - photo 9
The quintessential Niles home! A polished gem that has been - photo 10
The quintessential Niles home! A polished gem that has been - photo 11
The quintessential Niles home! A polished gem that has been - photo 12
The quintessential Niles home! A polished gem that has been - photo 13
The quintessential Niles home! A polished gem that has been - photo 14
The quintessential Niles home! A polished gem that has been - photo 15
The quintessential Niles home! A polished gem that has been - photo 16
The quintessential Niles home! A polished gem that has been - photo 17
The quintessential Niles home! A polished gem that has been - photo 18
The quintessential Niles home! A polished gem that has been - photo 19
The quintessential Niles home! A polished gem that has been - photo 20
The quintessential Niles home! A polished gem that has been - photo 21
The quintessential Niles home! A polished gem that has been - photo 22
The quintessential Niles home! A polished gem that has been - photo 23
The quintessential Niles home! A polished gem that has been - photo 24
The quintessential Niles home! A polished gem that has been - photo 25
The quintessential Niles home! A polished gem that has been - photo 26
The quintessential Niles home! A polished gem that has been - photo 27
The quintessential Niles home! A polished gem that has been - photo 28
The quintessential Niles home! A polished gem that has been - photo 29
The quintessential Niles home! A polished gem that has been - photo 30
The quintessential Niles home! A polished gem that has been - photo 31
The quintessential Niles home! A polished gem that has been - photo 32
The quintessential Niles home! A polished gem that has been - photo 33
The quintessential Niles home! A polished gem that has been - photo 34
The quintessential Niles home! A polished gem that has been - photo 35
The quintessential Niles home! A polished gem that has been - photo 36
The quintessential Niles home! A polished gem that has been - photo 37
The quintessential Niles home! A polished gem that has been - photo 38
The quintessential Niles home! A polished gem that has been - photo 39
The quintessential Niles home! A polished gem that has been - photo 40
The quintessential Niles home! A polished gem that has been - photo 41
The quintessential Niles home! A polished gem that has been - photo 42
The quintessential Niles home! A polished gem that has been - photo 43
The quintessential Niles home! A polished gem that has been - photo 44
The quintessential Niles home! A polished gem that has been - photo 45
The quintessential Niles home! A polished gem that has been - photo 46
The quintessential Niles home! A polished gem that has been - photo 47
The quintessential Niles home! A polished gem that has been - photo 48
The quintessential Niles home! A polished gem that has been - photo 49
The quintessential Niles home! A polished gem that has been - photo 50

$1,898,000

3 Beds | 2.0 Baths | 1,529 Sqft

37955 2nd St, Fremont, CA, 94536

The quintessential Niles home! A polished gem that has been

Added: 04/17/2026 • Updated: 06/02/2026
For Sale
Total 1,694 SF of living area, including additional 260 SF bonus - photo 1
Total 1,694 SF of living area, including additional 260 SF bonus - photo 2
Total 1,694 SF of living area, including additional 260 SF bonus - photo 3
Total 1,694 SF of living area, including additional 260 SF bonus - photo 4
Total 1,694 SF of living area, including additional 260 SF bonus - photo 5
Total 1,694 SF of living area, including additional 260 SF bonus - photo 6
Total 1,694 SF of living area, including additional 260 SF bonus - photo 7
Total 1,694 SF of living area, including additional 260 SF bonus - photo 8
Total 1,694 SF of living area, including additional 260 SF bonus - photo 9
Total 1,694 SF of living area, including additional 260 SF bonus - photo 10
Total 1,694 SF of living area, including additional 260 SF bonus - photo 11
Total 1,694 SF of living area, including additional 260 SF bonus - photo 12
Total 1,694 SF of living area, including additional 260 SF bonus - photo 13
Total 1,694 SF of living area, including additional 260 SF bonus - photo 14
Total 1,694 SF of living area, including additional 260 SF bonus - photo 15
Total 1,694 SF of living area, including additional 260 SF bonus - photo 16
Total 1,694 SF of living area, including additional 260 SF bonus - photo 17
Total 1,694 SF of living area, including additional 260 SF bonus - photo 18
Total 1,694 SF of living area, including additional 260 SF bonus - photo 19
Total 1,694 SF of living area, including additional 260 SF bonus - photo 20
Total 1,694 SF of living area, including additional 260 SF bonus - photo 21
Total 1,694 SF of living area, including additional 260 SF bonus - photo 22
Total 1,694 SF of living area, including additional 260 SF bonus - photo 23
Total 1,694 SF of living area, including additional 260 SF bonus - photo 24
Total 1,694 SF of living area, including additional 260 SF bonus - photo 25
Total 1,694 SF of living area, including additional 260 SF bonus - photo 26
Total 1,694 SF of living area, including additional 260 SF bonus - photo 27
Total 1,694 SF of living area, including additional 260 SF bonus - photo 28
Total 1,694 SF of living area, including additional 260 SF bonus - photo 29
Total 1,694 SF of living area, including additional 260 SF bonus - photo 30
Total 1,694 SF of living area, including additional 260 SF bonus - photo 31
Total 1,694 SF of living area, including additional 260 SF bonus - photo 32
Total 1,694 SF of living area, including additional 260 SF bonus - photo 33
Total 1,694 SF of living area, including additional 260 SF bonus - photo 34
Total 1,694 SF of living area, including additional 260 SF bonus - photo 35
Total 1,694 SF of living area, including additional 260 SF bonus - photo 36

$1,888,000

3 Beds | 2.0 Baths | 1,434 Sqft

41441 Paseo Padre PKWY, Fremont, CA, 94539

Total 1,694 SF of living area, including additional 260 SF bonus

Added: 06/22/2026 • Updated: 06/22/2026
View more View More
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.24
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Fremont

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Fremont Real Estate Agent Info

About Fremont

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.24
Terms & Policy