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
- Lake Front
- Solar Power System
- Updated Kitchen
- Parkmont Elementary School Rated A
- Chain Of Lake Views
- Contemporary Architecture
About This Home
As of July 2025Gorgeous Riverwalk home with 630k in updates sits on a prime court location with picturesque views. Huge floor plan with 4 bedrooms and 3 baths, high ceilings, natural light, and more! Inviting formal living area and open kitchen/family combo. Large master suite and spacious master bath features dual vanities, frameless shower, and soaker tub. Enjoy a backyard oasis with a full Lynx kitchen and gas fire pit. Luxurious features throughout include Porcelonosa tiles, high-grade faucets/rain showers, rift & quartered white oak hardwoods, pirouette window shades, and a heat/glow gas fireplace. 4.2KW solar with micro inverters allows for near net zero electricity consumption! Top of the line appliances highlight a Henrybuilt custom kitchen that includes a built-in sub-zero fridge, Wolf range top and hood, convection and steam oven, low decibel triple rack dishwasher, and premium stainless steel sink. Excellent Parkmont attendance, easy access to Facebook, Tesla, Bart, 680/880, and downtown.
Last Agent to Sell the Property
Golden Gate Sotheby's Int'l License #01295925 Listed on: 10/27/2020
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $25,884
Year Built
- Built in 2001
Lot Details
- 6,512 Sq Ft Lot
- Lake Front
- Wood Fence
- Landscaped
- Rectangular Lot
- Front Yard Sprinklers
- Garden
- Back and Front Yard
HOA Fees
- $85 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Garage Door Opener
Property Views
- Chain Of Lake
- Hills
Home Design
- Contemporary Architecture
- Brick Exterior Construction
- Slab Foundation
- Stucco
Interior Spaces
- 2-Story Property
- Sound System
- Fireplace With Gas Starter
- Stone Fireplace
- Family Room Off Kitchen
- Living Room with Fireplace
- Formal Dining Room
- Home Office
- Bonus Room
Kitchen
- Updated Kitchen
- Breakfast Bar
- Double Self-Cleaning Oven
- Gas Range
- Microwave
- Plumbed For Ice Maker
- Kitchen Island
- Stone Countertops
- Disposal
Flooring
- Wood
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- 3 Full Bathrooms
Laundry
- Dryer
- Washer
Home Security
- Smart Thermostat
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Eco-Friendly Details
- Solar Power System
- Solar owned by seller
Utilities
- Forced Air Heating and Cooling System
- 220 Volts in Kitchen
- Tankless Water Heater
- Satellite Dish
Community Details
- Association fees include common area maintenance, management fee, reserves
- Association Phone (925) 743-3080
- Built by PACIFIC UNION
- Riverwalk Subdivision, Spectacular Floorplan
- Greenbelt
Listing and Financial Details
- Assessor Parcel Number 5015286
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: 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 | $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: Bay East Association of REALTORS®
MLS Number: 40927072
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.
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
- 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