Seller's Agent in 2024
Lester Belliveau
Coldwell Banker Realty
(510) 676-7900
43 in this area
216 Total Sales
5202 Waller Ave Fremont, CA 94536
Glenmoor NeighborhoodEstimated Value: $1,705,000 - $1,789,000
3
Beds
2
Baths
1,594
Sq Ft
$1,101/Sq Ft
Est. Value
Highlights
- Updated Kitchen
- Stone Countertops
- Skylights
- John G. Mattos Elementary School Rated A
- Formal Dining Room
- 2 Car Attached Garage
About This Home
As of May 2024Introducing a sensational home tucked into the highly sought-after Glenmoor neighborhood! This single-story home has a masterfully designed custom floor plan that draws in natural light to every room. This open design includes a picturesque living room with a perfect view of the yard, spacious kitchen, formal dining room and versatile nook. You’re sure to love the quality details throughout including tasteful laminate floors, beautifully updated bathrooms, central A/C, copper plumbing & recessed lighting. Gorgeously remodeled kitchen has a large skylight, quartz counters, shaker-style cabinets, breakfast bar with seating & stainless steel appliances including a built-in gas stove. Luxurious primary bedroom has private backyard access and a remodeled bathroom with an elegant stall shower & stone-topped vanity. Relax in the idyllic backyard designed to entertain one day and escape to the next. Enjoy the large patio, quality turf lawn and multiple planter boxes to create a garden of your own! This home is in an excellent location, close to Glenmoor’s community parks, playgrounds, tennis courts and pools. Perfect for commuters, nearby 880, Dumbarton Bridge, BART and Centerville Station. Walking distance to great schools, shopping and local eateries! This home is a must see!
Last Agent to Sell the Property
Coldwell Banker Realty License #00997558 Listed on: 03/20/2024
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $16,158
Year Built
- Built in 1962
Lot Details
- 7,070 Sq Ft Lot
- Fenced
- Rectangular Lot
- Back and Front Yard
HOA Fees
- $30 Monthly HOA Fees
Parking
- 2 Car Attached Garage
Home Design
- Stucco
Interior Spaces
- 1-Story Property
- Skylights
- Living Room with Fireplace
- Formal Dining Room
Kitchen
- Updated Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Gas Range
- Free-Standing Range
- Dishwasher
- Stone Countertops
Flooring
- Laminate
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- 2 Full Bathrooms
Laundry
- Laundry in Garage
- Dryer
- Washer
Utilities
- Forced Air Heating and Cooling System
Community Details
- Association fees include common area maintenance, management fee
- Glenmoor Gardens HOA, Phone Number (510) 797-7600
- Glenmoor Subdivision
Listing and Financial Details
- Assessor Parcel Number 5312124
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Mar 20, 2024
Closed on
Apr 30, 2024
Sold by
Jung-Hahn Living Trust and Jung Peter
Bought by
Gupta Anuj and Gannen-Gupta Sneha
Seller's Agent
Lester Belliveau
Coldwell Banker Realty
Buyer's Agent
Josh Uy
Everhome
List Price
$1,699,900
Sold Price
$1,975,000
Premium/Discount to List
$275,100
16.18%
Views
58
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$220,493
Avg. Annual Appreciation
-7.22%
Original Mortgage
$1,580,000
Outstanding Balance
$1,556,146
Interest Rate
6.13%
Mortgage Type
New Conventional
Estimated Equity
$235,476
Purchase Details
Closed on
Dec 4, 2019
Sold by
Jung Peter and Hahn Sara
Bought by
Jung Peter and Hahn Sara
Purchase Details
Closed on
Nov 6, 2017
Sold by
Orca Investments Llc
Bought by
Jung Peter and Hahn Sara
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$976,000
Interest Rate
3.83%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jun 27, 2017
Sold by
Waechtler Carole and Rodrigues Carole Louise
Bought by
Orca Investments Llc
Purchase Details
Closed on
Jun 22, 2017
Sold by
Birkedahl Walter B and Birkedahl Patrice M
Bought by
Poruri Ravi and Rao Jyotsna
Purchase Details
Closed on
Aug 28, 1996
Sold by
Waechtler Arthur H and Waechtler Elsie K
Bought by
Waechtler Arthur Herbert and Waechtler Elsie Katherine
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Gupta Anuj | $1,975,000 | Fidelity National Title Compan | |
| Jung Peter | -- | None Available | |
| Jung Peter | $1,220,000 | Old Republic Title Company | |
| Orca Investments Llc | $879,000 | Old Republic Title Company | |
| Poruri Ravi | $1,222,000 | Old Republic Title Company | |
| Waechtler Arthur Herbert | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Gupta Anuj | $1,580,000 | |
| Previous Owner | Jung Peter | $765,000 | |
| Previous Owner | Jung Peter | $976,000 | |
| Previous Owner | Davis Joan C | $52,300 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 02/04/2025 02/04/25 | Off Market | $1,975,000 | -- | -- |
| 05/03/2024 05/03/24 | Sold | $1,975,000 | +16.2% | $1,239 / Sq Ft |
| 03/29/2024 03/29/24 | Pending | -- | -- | -- |
| 03/20/2024 03/20/24 | For Sale | $1,699,900 | -- | $1,066 / Sq Ft |
Source: Bay East Association of REALTORS®
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $16,158 | $2,007,500 | $805,800 | $1,208,700 |
| 2024 | $16,158 | $1,353,910 | $468,510 | $892,400 |
| 2023 | $15,738 | $1,334,228 | $459,324 | $874,904 |
| 2022 | $15,555 | $1,301,071 | $450,319 | $857,752 |
| 2021 | $15,167 | $1,275,427 | $441,491 | $840,936 |
| 2020 | $15,278 | $1,269,288 | $436,968 | $832,320 |
| 2019 | $15,099 | $1,244,400 | $428,400 | $816,000 |
| 2018 | $14,807 | $1,220,000 | $420,000 | $800,000 |
| 2017 | $1,422 | $78,162 | $23,659 | $54,503 |
| 2016 | $1,381 | $76,630 | $23,195 | $53,435 |
| 2015 | $1,348 | $75,479 | $22,847 | $52,632 |
| 2014 | $1,313 | $74,000 | $22,399 | $51,601 |
Source: Public Records
Agents Affiliated with this Home
-
Lester Belliveau
-
Josh Uy
Buyer's Agent in 2024
Josh Uy
Everhome
(510) 449-7280
1 in this area
31 Total Sales
Map
Source: Bay East Association of REALTORS®
MLS Number: 41053341
APN: 531-0002-124-00
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Bay East ©2025. CCAR ©2025. bridgeMLS ©2025. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Nearby Homes
- 5360 Shelby Ct
- 38532 Cedar Blvd
- 38476 Cedar Blvd
- 38468 Cedar Blvd
- 38450 Cedar Blvd
- 38496 Ambrosia St
- 38450 Ambrosia St
- 38324 Blacow Rd
- 5681 Pandorea Terrace
- 39024 Blacow Rd
- Sierra Plan at Marabel
- Olvera Plan at Marabel
- Ronda Plan at Marabel
- Medina Plan at Marabel
- Sidonia Plan at Marabel
- 5603 Wintergreen Dr
- 38984 Primula Terrace
- 38920 Snapdragon Place
- 4899 Calaveras Ave
- 4670 Eggers Dr
- 5214 Waller Ave
- 5186 Waller Ave
- 5203 Selma Ave
- 5215 Selma Ave
- 5187 Selma Ave
- 5226 Waller Ave
- 5178 Waller Ave
- 5213 Waller Ave
- 5189 Waller Ave
- 5227 Selma Ave
- 5179 Selma Ave
- 5225 Waller Ave
- 5238 Waller Ave
- 5181 Waller Ave
- 5170 Waller Ave
- 5239 Selma Ave
- 5171 Selma Ave
- 5218 Vernon Ave
- 5204 Selma Ave
- 5216 Selma Ave