NOT LISTED FOR SALE

Estimated Value: $3,845,785 - $4,089,000

5 Beds
2.5 Baths
2,750 Sq Ft
$1,454/Sq Ft Est. Value

Last Sold June 12, 2025

Last sale price $4,100,000 $1,491 Per Sq Ft

Est. 2% decrease in value since last sale

Current estimated payment $24,034/month

Highlights

  • Primary Bedroom Suite
  • 0.45 Acre Lot
  • Marble Bathroom Countertops
  • Ralston Intermediate School Rated A
  • Wood Flooring
  • Jetted Tub in Primary Bathroom

About This Home

As of June 2025

Exceptional 2 story residence in Hallmark adjacent to the beloved Water Dog Lake Trail. One of the largest & most expansive flat lots in the area. The formal entry is highlighted by a grand modern curved iron staircase. Upstairs, 4 spacious bedrooms & 2 beautifully appointed full baths. The primary suite is a luxurious retreat featuring an oversized balcony, generous custom closets & a truly spa-like ensuite bath with a soaking tub, steam rm, oversized shower & double vanities. Downstairs is a sleek renovated kitchen opens into the family rm, anchored by a statement gas fireplace with TV mount and elegant picture windows on either side. The chefs kitchen boasts: An abundance of cabinetry, Professional-grade stainless steel appliances, Oversized refrigerator, gas cooktop, modern hood, double ovens, microwave & beverage refrigerator, Double sinks, eat-up breakfast bar & recessed lighting A wall of windows & French doors opening to the backyard. The adjacent living rm features a large picture window & dining room with recessed ceiling & modern designer light fixture. A dramatic powder rm, A spacious laundry rm. and a versatile 5th bedroom, ideal as a guest suite/home office. The lush, private backyard is a dream w/ expansive lawn, elevated wooden deck & a backdrop of mature trees.

Last Agent to Sell the Property

Debbie Wilhelm

Coldwell Banker Realty License #01044009 Listed on: 06/12/2025

Coldwell Banker Realty

Last Buyer's Agent

RECIP

Out of Area Office License #00000000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $32,703

Year Built

  • Built in 1969

Lot Details

  • 0.45 Acre Lot
  • Fenced
  • Level Lot
  • Sprinklers on Timer
  • Back Yard
  • Zoning described as R10006

Parking

  • 2 Car Attached Garage

Home Design

  • Ceiling Insulation
  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,750 Sq Ft Home
  • 2-Story Property
  • Fireplace With Gas Starter
  • Double Pane Windows
  • Formal Dining Room

Kitchen

  • Open to Family Room
  • Self-Cleaning Oven
  • Gas Cooktop
  • Range Hood
  • Warming Drawer
  • Ice Maker
  • Dishwasher
  • Wine Refrigerator
  • ENERGY STAR Qualified Appliances
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • Bathroom on Main Level
  • Marble Bathroom Countertops
  • Dual Sinks
  • Jetted Tub in Primary Bathroom
  • Bathtub with Shower
  • Bathtub Includes Tile Surround
  • Walk-in Shower

Laundry

  • Laundry in unit
  • Washer and Dryer

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan

Additional Features

  • Energy-Efficient Insulation
  • Balcony

Listing and Financial Details

  • Assessor Parcel Number 043-363-040

Home Details

Home Type

Single Family

Est. Annual Taxes

$32,703

Year Built

Built in 1969

Lot Details

0

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Age: 56
  • Listing Class: Residential
  • Structure Sq Ft: 2750
  • Incorporated: Yes
  • Year Built: 1969
  • Zoning Description: R10006
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Gas Starter
  • Dining Room: Formal Dining Room
  • Kitchen: Cooktop - Gas, Countertop - Quartz, Dishwasher, Exhaust Fan, Garbage Disposal, Hood Over Range, Ice Maker, Oven - Self Cleaning, Pantry, Refrigerator, Warming Drawer, Wine Refrigerator
  • Living Sq Ft: 2750
  • Stories: 2
  • Bedrooms: Primary Suite / Retreat, Walk-in Closet
  • Laundry: Inside, Washer / Dryer
  • Flooring: Carpet, Hardwood, Tile
  • Fireplaces Min: 1
  • Maximum Numberof Bedrooms: 5
  • Minimum Numberof Bedrooms: 5
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Bathroom: Double Sinks, Half on Ground Floor, Marble, Primary - Stall Shower(s), Primary - Tub with Jets, Shower over Tub - 1, Tile
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter and Slab
  • Roof: Composition
  • Yard/Grounds: Back Yard, Balcony / Patio, Fenced, Sprinklers - Auto, Sprinklers - Lawn

Garage/Parking

  • Garage Spaces: 2
  • Parking Spaces: 2
  • Garage Max: 2
  • Garage Min: 2
  • Garage Parking Features: Attached Garage

Utilities

  • Cooling System: Central AC
  • Heating System: Central Forced Air, Central Forced Air - Gas
  • Sewer/Septic System: Sewer - Public

Association/Amenities

  • Amenities Miscellaneous: Walk-in Closet

Schools

  • School District: Sequoia Union High
  • Middle School: Ralston Intermediate
  • High School: Carlmont High
  • High School: 617
  • Middle School: 669

Lot Info

  • Lot Description: Grade - Level
  • Parcel Number: 043-363-040
  • Lot Acres: 0.4462
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 19436.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 19436.00

Green Features

  • Energy Features: Ceiling Insulation, Double Pane Windows, Energy Star Appliances, Walls Insulated

Multi Family

  • Utilities: Public Utilities

MLS Schools

  • High School District Text: Sequoia Union High
  • High School Text: Carlmont High
  • Middle School Text: Ralston Intermediate

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 12, 2025
Closed on
Jun 9, 2025
Sold by
Gupta Family Revocable Trust and Gupta Karan Mohan
Bought by
Metzler Joshua and Metzler Erin Joy
Seller's Agent
Debbie Wilhelm
Coldwell Banker Realty
Buyer's Agent
RECIP
Out of Area Office
List Price
$4,100,000
Sold Price
$4,100,000
Views
4
Current Estimated Value
$3,999,446

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$100,554
Avg. Annual Appreciation
-26.86%

Purchase Details

Closed on
Jul 12, 2017
Sold by
Ambrose Jill K and Ambrose John M
Bought by
Gupta Karan Mohan and Gupta Rashmi Wadhwa

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,000,000
Interest Rate
3.25%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Jan 17, 2007
Sold by
Heard Lorraine P
Bought by
Ambrose John M and Ambrose Jill K

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,120,000
Interest Rate
6.09%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Apr 10, 2003
Sold by
Heard Patrick C and Heard Lorraine P
Bought by
Heard Patrick C and Heard Lorraine P

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
4.75%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Mar 25, 2003
Sold by
Heard Patrick C and Heard Lorraine P
Bought by
Heard Patrick C and Heard Lorraine P

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
4.75%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Mar 21, 2000
Sold by
Heard Patrick C and Heard Lorraine P
Bought by
Revoca Patrick C and Revoca Lorraine P Heard 2000
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Metzler Joshua $4,100,000 Lawyers Title Company
Gupta Karan Mohan $2,501,000 Chicago Title Company
Ambrose John M $1,420,000 North American Title Company
Heard Patrick C -- --
Heard Patrick C -- Fidelity National Title
Revoca Patrick C -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Gupta Karan Mohan $1,868,800
Previous Owner Wadhwa Gupta Karen Mohan $1,942,900
Previous Owner Gupta Karan Mohan $2,000,000
Previous Owner Ambrose Jill K $970,000
Previous Owner Ambrose Jill K $985,000
Previous Owner Ambrose Jill K $1,048,000
Previous Owner Ambrose John M $1,120,000
Previous Owner Heard Patrick C $100,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/12/2025 06/12/25 Sold $4,100,000 0.0% $1,491 / Sq Ft
06/12/2025 06/12/25 Pending -- -- --
06/12/2025 06/12/25 For Sale $4,100,000 0.0% $1,491 / Sq Ft
07/04/2022 07/04/22 Rented $8,000 0.0% --
06/13/2022 06/13/22 Under Contract -- -- --
05/25/2022 05/25/22 For Rent $8,000 -- --
Source: MLSListings

Tax History Compared to Growth

Source: Public Records

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 $32,703 $2,845,705 $1,991,994 $853,711
2023 $32,703 $2,735,205 $1,914,644 $820,561
2022 $31,062 $2,681,574 $1,877,102 $804,472
2021 $30,742 $2,628,996 $1,840,297 $788,699
2020 $30,406 $2,602,040 $1,821,428 $780,612
2019 $29,778 $2,551,020 $1,785,714 $765,306
2018 $28,892 $2,501,000 $1,750,700 $750,300
2017 $19,516 $1,639,258 $819,629 $819,629
2016 $19,118 $1,607,116 $803,558 $803,558
2015 $19,230 $1,582,976 $791,488 $791,488
2014 $17,548 $1,470,000 $735,000 $735,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML82010705

MLSListings

APN: 043-363-040