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
- Not Listed Association, Phone Number (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
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%
Similar Homes in Fremont, CA
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,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 | $70,000 | New Conventional | |
| Open | $1,529,500 | New Conventional | |
| Previous Owner | $406,000 | New Conventional | |
| Previous Owner | $409,000 | New Conventional | |
| Previous Owner | $417,000 | New Conventional | |
| Previous Owner | $548,000 | Unknown | |
| Previous Owner | $550,000 | Unknown | |
| Previous Owner | $550,000 | Unknown | |
| Previous Owner | $550,000 | Unknown | |
| Previous Owner | $550,000 | Unknown | |
| Previous Owner | $550,000 | Unknown | |
| Previous Owner | $550,000 | Unknown | |
| Previous Owner | $550,000 | Unknown | |
| 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 |
|---|---|---|---|---|
| 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
-
M
Seller's Agent in 2025
Matthew Luan
Intero Real Estate Services
(408) 823-3219
1 in this area
55 Total Sales
-
Buyer's Agent in 2025
Sandhya Paramel
Compass
(510) 565-6021
3 in this area
81 Total Sales
-
Seller's Agent in 2020
Joseph Sabeh
Golden Gate Sotheby's Int'l
(415) 385-6442
1 in this area
175 Total Sales
-
Buyer's Agent in 2020
Allie Whalen
eXp Realty of California Inc.
(530) 919-0666
1 in this area
33 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
- 37993 Ponderosa Terrace
- 38101 Cambridge Ct
- 37337 Ortega Common
- 38228 Paseo Padre Pkwy Unit 24
- 3282 Canterbury Ct
- 37357 Sequoia Rd
- 38179 Acacia Ct
- 38030 Dundee Common
- 3413 Foxtail Terrace Unit LU245
- 38039 Dundee Common
- 1513 Shinn Ct
- 3388 Red Cedar Terrace
- 38043 Buxton Common
- 38455 Bronson St Unit 325
- 38455 Bronson St Unit 128
- 38500 Paseo Padre Pkwy Unit 102
- 38500 Paseo Padre Pkwy Unit 215
- 3570 Dalton Common
- 2755 Country Dr Unit 233