M
Seller's Agent in 2025
Matthew Luan
Intero Real Estate Services
(408) 823-3219
1 in this area
55 Total Sales
37808 Appletree Ct Fremont, CA 94536
Parkmont Neighborhood
4
Beds
3
Baths
2,754
Sq Ft
6,512
Sq Ft Lot
Highlights
- Wood Flooring
- Stone Countertops
- Open to Family Room
- Parkmont Elementary School Rated A
- Formal Dining Room
- 2 Car Attached Garage
About This Home
As of July 2025Meticulously updated single family home in the heart of Fremont! This property is located in the picturesque Riverwalk Community and boasts 4 bedrooms and 3 bathrooms spread across 2,754 square feet of living space. Step inside where you will find soaring ceilings, a freshly painted interior, hardwood floors throughout the home, and a custom designed Henrybuilt kitchen featuring top of the line appliances from Sub Zero, Wolf, and Miele. A ground floor bedroom and full bathroom provide an ideal layout for multigenerational families with individuals who may have trouble with stairs. All 3 bathrooms in the property have been remodeled while the primary bathroom showcases a luxurious bathtub and walls covered with floor to ceiling stone. The home sits on a 6,512 square foot lot with the highlight being a low maintenance, landscaped backyard with an outdoor kitchen, fire pit, and hot tub. Other improvements include a SPAN EV charger and solar panels to help with utility costs. Outdoor enthusiasts will appreciate the property's close proximity to Quarry Lakes Regional Recreation Area and the Alameda Creek Trail. Extremely convenient location with easy access to major Bay Area employers, BART, grocery stores, shops, and restaurants. Enrollment to Fremont Unified School District.
Last Agent to Sell the Property
Intero Real Estate Services License #01962892 Listed on: 05/14/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $25,884
Year Built
- Built in 2001
Lot Details
- 6,512 Sq Ft Lot
- Zoning described as P-99-1
Parking
- 2 Car Attached Garage
- Electric Vehicle Home Charger
- On-Street Parking
Home Design
- Slab Foundation
- Shake Roof
- Concrete Roof
Interior Spaces
- 2,754 Sq Ft Home
- 2-Story Property
- Living Room with Fireplace
- Formal Dining Room
- Wood Flooring
- Laundry in Utility Room
Kitchen
- Open to Family Room
- Gas Cooktop
- Range Hood
- Dishwasher
- Kitchen Island
- Stone Countertops
Bedrooms and Bathrooms
- 4 Bedrooms
- 3 Full Bathrooms
Additional Features
- Solar owned by seller
- Forced Air Heating and Cooling System
Community Details
- Property has a Home Owners Association
- Association fees include insurance - common area, maintenance - common area, management fee, reserves
- Riverwalk Association
- The community has rules related to parking rules
Listing and Financial Details
- Assessor Parcel Number 501-0528-006
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 14, 2025
Closed on
Jul 11, 2025
Sold by
Hansjee Kaushik and Mmanthole Mpho
Bought by
Kant Nitesh and Aralappa Mary Sunitha
Seller's Agent
Matthew Luan
Intero Real Estate Services
Buyer's Agent
Sandhya Paramel
Compass
List Price
$2,688,000
Sold Price
$2,600,000
Premium/Discount to List
-$88,000
-3.27%
Views
72
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.11%
Original Mortgage
$1,820,000
Outstanding Balance
$1,817,963
Interest Rate
5.38%
Mortgage Type
New Conventional
Estimated Equity
$787,205
Purchase Details
Listed on
Oct 27, 2020
Closed on
Nov 10, 2020
Sold by
Pramanick Shekhar and Pramanick Anna Mantykentta
Bought by
Hansjee Kaushik and Hansjee Mmanthole Mpho
Seller's Agent
Joseph Sabeh
Golden Gate Sotheby's Int'l
Buyer's Agent
Allie Whalen
eXp Realty of California Inc.
List Price
$2,098,000
Sold Price
$2,085,000
Premium/Discount to List
-$13,000
-0.62%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.83%
Purchase Details
Closed on
Nov 15, 2000
Sold by
Riverwalk Fremont Llc
Bought by
Pramanick Shekhar and Pramanick Anna Mantykentta
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$550,000
Interest Rate
7.25%
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 | Type | Sale Price | Title Company |
|---|---|---|---|
| Grant Deed | $2,600,000 | Orange Coast Title Company | |
| Grant Deed | $2,085,000 | Chicago Title Company | |
| Grant Deed | $900,500 | First American Title Guarant |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,820,000 | New Conventional | |
| Previous Owner | $550,000 | No Value Available |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 07/21/2025 07/21/25 | Sold | $2,600,000 | 0.0% | $944 / Sq Ft |
| 06/20/2025 06/20/25 | Pending | -- | -- | -- |
| 06/16/2025 06/16/25 | Price Changed | $2,599,000 | -3.3% | $944 / Sq Ft |
| 05/14/2025 05/14/25 | For Sale | $2,688,000 | +28.9% | $976 / Sq Ft |
| 02/04/2025 02/04/25 | Off Market | $2,085,000 | -- | -- |
| 11/17/2020 11/17/20 | Sold | $2,085,000 | -0.6% | $757 / Sq Ft |
| 11/02/2020 11/02/20 | Pending | -- | -- | -- |
| 10/27/2020 10/27/20 | For Sale | $2,098,000 | -- | $762 / Sq Ft |
Source: MLSListings
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 | $25,884 | $2,256,844 | $677,053 | $1,579,791 |
| 2024 | $25,884 | $2,212,601 | $663,780 | $1,548,821 |
| 2023 | $25,229 | $2,169,233 | $650,770 | $1,518,463 |
| 2022 | $24,959 | $2,126,700 | $638,010 | $1,488,690 |
| 2021 | $24,333 | $2,085,000 | $625,500 | $1,459,500 |
| 2020 | $15,454 | $1,284,464 | $372,262 | $912,202 |
| 2019 | $15,273 | $1,259,282 | $364,964 | $894,318 |
| 2018 | $14,977 | $1,234,595 | $357,809 | $876,786 |
| 2017 | $14,602 | $1,210,393 | $350,795 | $859,598 |
| 2016 | $14,364 | $1,186,665 | $343,918 | $842,747 |
| 2015 | $14,184 | $1,168,849 | $338,755 | $830,094 |
| 2014 | $13,171 | $1,080,000 | $324,000 | $756,000 |
Source: Public Records
Agents Affiliated with this Home
-
Matthew Luan
-
Sandhya Paramel
Buyer's Agent in 2025
Sandhya Paramel
Compass
(510) 565-6021
3 in this area
80 Total Sales
-
Joseph Sabeh
Seller's Agent in 2020
Joseph Sabeh
Golden Gate Sotheby's Int'l
(415) 385-6442
1 in this area
177 Total Sales
-
Allie Whalen
Buyer's Agent in 2020
Allie Whalen
eXp Realty of California Inc.
(530) 919-0666
1 in this area
34 Total Sales
Map
Source: MLSListings
MLS Number: ML82006813
APN: 501-0528-006-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.
Property Information © 2025 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.
Nearby Homes
- 2579 Bishop Ave
- 37709 Arlene Ct
- 37993 Ponderosa Terrace
- 38043 Miller Place
- 38099 Miller Place
- 38101 Cambridge Ct
- 38228 Paseo Padre Pkwy Unit 24
- 37373 Sequoia Rd
- 38179 Acacia Ct
- 38012 Dover Common
- 1554 Gilbert Place
- 37502 Zephyr Terrace
- 3397 Foxtail Terrace
- 3413 Foxtail Terrace Unit LU245
- 38455 Bronson St Unit 325
- 38455 Bronson St Unit 128
- 38500 Paseo Padre Pkwy Unit 306
- 3443 Pepperwood Terrace Unit 301
- 3507 Buttonwood Terrace Unit 203
- 3416 Deerwood Terrace Unit 113