Seller's Agent in 2024
Rajeev Awasty
Intero Real Estate Services
(510) 703-7332
1 in this area
131 Total Sales
34036 Webfoot Loop Fremont, CA 94555
Ardenwood NeighborhoodEstimated Value: $1,931,000 - $2,213,223
4
Beds
3
Baths
2,102
Sq Ft
$988/Sq Ft
Est. Value
Highlights
- Updated Kitchen
- Fireplace in Primary Bedroom
- Engineered Wood Flooring
- Ardenwood Elementary Rated A
- Contemporary Architecture
- Corner Lot
About This Home
As of May 2024Spectacular single family corner home in Ardenwood . Large well appointed 4 beds 3 baths with 1 bed 1 bath down stairs.High ceilings in Living room. 2 Car attached garage. Top rated schools close by. Easy access to Meta and Dumbarton bridge-shops-restaurants .Lots of updates in this home from new interior wall to ceiling paint-quartz counter tops and updated Kitchen with all appliances-master bathroom updated as well- recessed lights through out-new wood flooring in kitchen and family room. 3 fire places in the home.Beautifully landscaped back yard with water feature-zen like space for relaxing with family and entertaining. Ample parking around the home.2 Car attached garage with laundry in there and new epoxy floor finish.You got to see this beautiful home to appreciate it.
Last Agent to Sell the Property
Intero Real Estate Services License #01272705 Listed on: 04/03/2024
Home Details
Home Type
- Single Family
Year Built
- Built in 1990
Lot Details
- 4,625 Sq Ft Lot
- Landscaped
- Corner Lot
- Front and Back Yard Sprinklers
- Back Yard Fenced and Front Yard
HOA Fees
- $220 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Garage Door Opener
Home Design
- Contemporary Architecture
- Slab Foundation
- Shingle Roof
- Wood Siding
Interior Spaces
- 2-Story Property
- Family Room Off Kitchen
- Living Room with Fireplace
- 3 Fireplaces
- Formal Dining Room
Kitchen
- Updated Kitchen
- Plumbed For Ice Maker
- Stone Countertops
- Disposal
Flooring
- Engineered Wood
- Carpet
- Tile
Bedrooms and Bathrooms
- 4 Bedrooms
- Fireplace in Primary Bedroom
- 3 Full Bathrooms
Utilities
- Forced Air Heating and Cooling System
Community Details
- Association fees include management fee, reserves
- California Crest II Association, Phone Number (510) 780-8587
- Ardenwood Subdivision
Listing and Financial Details
- Assessor Parcel Number 543460147
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 3, 2024
Closed on
Apr 30, 2024
Sold by
Tandon Neeraj and Tandon Neelema
Bought by
Pansari Nishant and Gupta Shilpa
Seller's Agent
Rajeev Awasty
Intero Real Estate Services
Buyer's Agent
Viva Bakshi
List Price
$1,799,000
Sold Price
$2,150,000
Premium/Discount to List
$351,000
19.51%
Views
78
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
-$100,872
Avg. Annual Appreciation
-1.99%
Original Mortgage
$1,150,000
Outstanding Balance
$1,131,843
Interest Rate
6.25%
Mortgage Type
New Conventional
Estimated Equity
$944,963
Purchase Details
Closed on
Dec 13, 1999
Sold by
Hauff Charles B and Hauff Kathy M
Bought by
Tandon Neeraj and Tandon Neelema
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$360,000
Interest Rate
7.12%
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 |
|---|---|---|---|
| Pansari Nishant | $2,150,000 | Fidelity National Title Compan | |
| Tandon Neeraj | $450,000 | Chicago Title Co |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Pansari Nishant | $1,150,000 | |
| Previous Owner | Tandon Neeraj | $360,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 02/04/2025 02/04/25 | Off Market | $2,150,000 | -- | -- |
| 05/06/2024 05/06/24 | Sold | $2,150,000 | +19.5% | $1,023 / Sq Ft |
| 04/11/2024 04/11/24 | Pending | -- | -- | -- |
| 03/04/2024 03/04/24 | For Sale | $1,799,000 | -- | $856 / Sq Ft |
Source: Bay East Association of REALTORS®
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 | $8,575 | $2,193,000 | $657,900 | $1,535,100 |
| 2024 | $8,575 | $684,479 | $203,412 | $481,067 |
| 2023 | $8,342 | $671,060 | $199,424 | $471,636 |
| 2022 | $8,229 | $657,905 | $195,515 | $462,390 |
| 2021 | $8,030 | $645,008 | $191,682 | $453,326 |
| 2020 | $8,035 | $638,398 | $189,718 | $448,680 |
| 2019 | $7,945 | $625,882 | $185,998 | $439,884 |
| 2018 | $7,790 | $613,613 | $182,352 | $431,261 |
| 2017 | $7,596 | $601,583 | $178,777 | $422,806 |
| 2016 | $7,465 | $589,791 | $175,273 | $414,518 |
| 2015 | $7,364 | $580,932 | $172,640 | $408,292 |
| 2014 | $7,237 | $569,553 | $169,258 | $400,295 |
Source: Public Records
Agents Affiliated with this Home
-
Rajeev Awasty
-
Viva Bakshi
Buyer's Agent in 2024
Viva Bakshi
(510) 506-5845
6 in this area
60 Total Sales
Map
Source: Bay East Association of REALTORS®
MLS Number: 41051687
APN: 543-0460-147-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 ©2026. CCAR ©2026. bridgeMLS ©2026. 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
- 5331 Cowboy Ct
- 34198 Tony Terrace
- 34203 Petard Terrace
- 34294 Dunhill Dr
- 5405 Quebec Common
- 34192 Firenze Terrace
- 34355 Windsong Terrace
- 5220 Fairbanks Common
- 4510 Lodovico Ct
- 34565 Pueblo Terrace
- 6004 Pisa Terrace Unit 119
- 34607 Pueblo Terrace
- 34791 Dorado Common
- 4725 Mallard Common
- 4808 Mendocino Terrace
- 33787 Shylock Dr
- 34794 Williams Way
- 4141 Deep Creek Rd Unit 89
- 4141 Deep Creek Rd Unit 106
- 4141 Deep Creek Rd Unit 180
- 34040 Webfoot Loop
- 34032 Webfoot Loop
- 34044 Webfoot Loop
- 34028 Webfoot Loop
- 34043 Webfoot Loop
- 34063 Webfoot Loop
- 34039 Webfoot Loop
- 34067 Webfoot Loop
- 34048 Webfoot Loop
- 34047 Webfoot Loop
- 34035 Webfoot Loop
- 34071 Webfoot Loop
- 34024 Webfoot Loop
- 34075 Webfoot Loop
- 34051 Webfoot Loop
- 34031 Webfoot Loop
- 34052 Webfoot Loop
- 34055 Webfoot Loop
- 34079 Webfoot Loop
- 34027 Webfoot Loop