Seller's Agent in 2023
CrumConstantino Team
Intero Real Estate Services
(650) 334-0126
1 in this area
46 Total Sales
55 Treetop Ln San Mateo, CA 94402
Baywood-Aragon NeighborhoodEstimated Value: $2,612,000 - $3,159,000
3
Beds
2.5
Baths
2,353
Sq Ft
$1,197/Sq Ft
Est. Value
Highlights
- City Lights View
- Deck
- Main Floor Primary Bedroom
- Baywood Elementary School Rated A
- Marble Flooring
- Stone Countertops
About This Home
As of December 2023Price improvement. This is your chance! Indulge in San Mateo living within this captivating 2-story residence on the border of Hillsborough! This luxurious haven w/top-tier craftsmanship & comfort, all while embracing nature's serenity. A freshly painted exterior & a fantastic floorplan filled w/tons of natural light pouring in through expansive windows, accentuating the vibrant hardwood flooring. The well-equipped kitchen boasts quartz counters, abundant cabinetry & skylight. Main flr offers a large LR/DR w/ beautiful views, separate FR & primary bedroom complete w/ an opulent ensuite. Upstairs are 2 generously sized bdrms w/ custom closet built-ins & an updated guest bathroom. Escape the city life & relax on your expansive serene deck. Addl amenities incld an attached 2car garage & an impressively sized unfinished basement. Prime location within close proximity to top-rated schools, fine dining, shopping & more!
Last Agent to Sell the Property
Intero Real Estate Services License #70010257 Listed on: 08/25/2023
Home Details
Home Type
- Single Family
Year Built
- Built in 1958
Lot Details
- 8,499 Sq Ft Lot
- Fenced
- Sprinklers on Timer
- Grass Covered Lot
- Back Yard
- Zoning described as R10006
Parking
- 2 Car Attached Garage
- Garage Door Opener
Property Views
- City Lights
- Hills
- Neighborhood
Home Design
- Composition Roof
- Concrete Perimeter Foundation
Interior Spaces
- 2,353 Sq Ft Home
- 2-Story Property
- Skylights
- Wood Burning Fireplace
- Double Pane Windows
- Formal Entry
- Separate Family Room
- Formal Dining Room
- Unfinished Basement
Kitchen
- Breakfast Area or Nook
- Gas Oven
- Microwave
- Dishwasher
- Stone Countertops
- Disposal
Flooring
- Wood
- Marble
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Primary Bedroom on Main
- Walk-In Closet
- Bathroom on Main Level
Laundry
- Laundry in Garage
- Washer and Dryer
Outdoor Features
- Balcony
- Deck
Utilities
- Forced Air Heating System
- Vented Exhaust Fan
Listing and Financial Details
- Assessor Parcel Number 038-230-070
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 25, 2023
Closed on
Dec 22, 2023
Sold by
Ahuja Aman Deep Singh and Tyagi Swati
Bought by
Ahuja Aman Deep Singh and Tyagi Swati
Seller's Agent
CrumConstantino Team
Intero Real Estate Services
Buyer's Agent
Satya Dasari
Keller Williams Thrive
List Price
$2,375,000
Sold Price
$2,325,000
Premium/Discount to List
-$50,000
-2.11%
Views
337
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
$491,842
Avg. Annual Appreciation
8.94%
Original Mortgage
$1,860,000
Outstanding Balance
$1,813,181
Interest Rate
5.25%
Mortgage Type
New Conventional
Estimated Equity
$1,003,661
Purchase Details
Listed on
Aug 25, 2023
Closed on
Dec 1, 2023
Sold by
Lumenti-Garty Living Trust
Bought by
Ahuja Aman Deep Singh and Tyagi Swati
Seller's Agent
CrumConstantino Team
Intero Real Estate Services
Buyer's Agent
Satya Dasari
Keller Williams Thrive
List Price
$2,375,000
Sold Price
$2,325,000
Premium/Discount to List
-$50,000
-2.11%
Views
337
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,860,000
Outstanding Balance
$1,813,181
Interest Rate
5.25%
Mortgage Type
New Conventional
Estimated Equity
$1,003,661
Purchase Details
Closed on
Mar 23, 2017
Sold by
Lumenti Laurie and Garty Kevin
Bought by
Lumenti Laurie and Garty Kevin
Purchase Details
Closed on
Aug 27, 2012
Sold by
Garty Kevin and Lumenti Laurie
Bought by
Lumenti Laurie and Garty Kevin
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,064,000
Interest Rate
3.12%
Mortgage Type
New Conventional
Purchase Details
Closed on
Nov 9, 2004
Sold by
Gupta Gitanjali K and Gupta Anurag W
Bought by
Garty Kevin and Lumenti Laurie
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$900,000
Interest Rate
5%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Mar 27, 1997
Sold by
Phillips Steven G and Curkendall Suellen M
Bought by
Gupta Anurag W and Gupta Gitanjali K
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$401,600
Interest Rate
7.62%
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 |
|---|---|---|---|
| Ahuja Aman Deep Singh | -- | Chicago Title Company | |
| Ahuja Aman Deep Singh | $2,325,000 | Chicago Title Company | |
| Lumenti Laurie | -- | None Available | |
| Lumenti Laurie | -- | Chicago Title Company | |
| Garty Kevin | $1,200,000 | Old Republic Title Company | |
| Gupta Anurag W | $502,000 | Fidelity National Title Co |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Ahuja Aman Deep Singh | $1,860,000 | |
| Previous Owner | Lumenti Laurie | $1,064,000 | |
| Previous Owner | Garty Kevin | $900,000 | |
| Previous Owner | Gupta Anurag W | $401,600 | |
| Closed | Garty Kevin | $180,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 12/21/2023 12/21/23 | Sold | $2,325,000 | -2.1% | $988 / Sq Ft |
| 11/27/2023 11/27/23 | Pending | -- | -- | -- |
| 11/23/2023 11/23/23 | For Sale | $2,375,000 | +2.2% | $1,009 / Sq Ft |
| 11/23/2023 11/23/23 | Off Market | $2,325,000 | -- | -- |
| 11/14/2023 11/14/23 | Price Changed | $2,375,000 | -3.0% | $1,009 / Sq Ft |
| 11/12/2023 11/12/23 | Price Changed | $2,449,000 | -2.0% | $1,041 / Sq Ft |
| 10/20/2023 10/20/23 | Price Changed | $2,498,000 | -3.6% | $1,062 / Sq Ft |
| 08/25/2023 08/25/23 | For Sale | $2,590,000 | -- | $1,101 / Sq Ft |
Source: MLSListings
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 | $28,627 | $2,371,500 | $1,387,200 | $984,300 |
| 2023 | $28,627 | $1,607,732 | $803,866 | $803,866 |
| 2022 | $19,884 | $1,576,208 | $788,104 | $788,104 |
| 2021 | $19,482 | $1,545,302 | $772,651 | $772,651 |
| 2020 | $18,940 | $1,529,458 | $764,729 | $764,729 |
| 2019 | $18,414 | $1,499,470 | $749,735 | $749,735 |
| 2018 | $17,660 | $1,470,070 | $735,035 | $735,035 |
| 2017 | $17,271 | $1,441,246 | $720,623 | $720,623 |
| 2016 | $16,880 | $1,412,988 | $706,494 | $706,494 |
| 2015 | $16,314 | $1,391,764 | $695,882 | $695,882 |
| 2014 | $16,015 | $1,364,502 | $682,251 | $682,251 |
Source: Public Records
Agents Affiliated with this Home
-
CrumConstantino Team
-
Satya Dasari
Buyer's Agent in 2023
Satya Dasari
Keller Williams Thrive
(408) 666-6231
1 in this area
194 Total Sales
Map
Source: MLSListings
MLS Number: ML81939805
APN: 038-230-070
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 © 2026 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
- 0 Parrott Dr
- 638 Oregon Ave
- 0 Crystal Springs Rd
- 250 Harvard Rd
- 1321 Vernon Terrace
- 140 Tobin Clark Dr
- 915 Link Rd
- 729 Chiltern Rd
- 141 & 141B 15th Ave
- 339 Hobart Ave
- 225 Virginia Ave Unit PH-D
- 340 Arden Rd
- 212 Eaton Rd Unit 1
- 523 Maple St
- 141 W 3rd Ave
- 1919 Alameda de Las Pulgas Unit 23
- 1919 Alameda de Las Pulgas Unit 140
- 115 Hobart Ave Unit E
- 20 W 3rd Ave Unit 202
- 112 Madison Ave Unit 108
Your Personal Tour Guide
Ask me questions while you tour the home.