NOT LISTED FOR SALE

Estimated Value: $3,791,000 - $4,517,000

4 Beds
2 Baths
2,688 Sq Ft
$1,542/Sq Ft Est. Value

Last Sold May 08, 2017

Last sale price $2,500,000 $930 Per Sq Ft

Est. 66% increase in value since last sale

Current estimated payment $24,900/month

7 Days on Market

Highlights

  • Wine Cellar
  • Skyline View
  • Vaulted Ceiling
  • Abraham Lincoln Elementary School Rated A-
  • Two Way Fireplace
  • Wood Flooring

About This Home

As of May 2017

Stunning remodeled 4 bedrooms + den & wine cellar nestled on private cul-de-sac street within close proximity to top schools! This single story home offers extraordinary architectural artistry and exquisite craftsmanship to meet the most discriminating buyer's taste. Guests are greeted by the beautiful landscaped front yard opens to a bright, sprawling floor plan. Formal living & dining rooms are appointed with designer features such as bay window, chandelier, vaulted ceiling, recess lights, pictures window showcases backyard views. Gourmet kitchen complete with granite countertops, tile backsplash, large center island, modern cabinets, breakfast bar, gas stovetops, stainless steel appliances, hardwood floor. Family room features fireplace, bay window with bench. Palatial master suite with 2-way fireplace, dual sink, jetted tub, shower & walk-in closet. Gorgeous relaxing backyard, great for entertaining & social gathering. Also includes: double pane windows, 4 skylights, central A/C.

Last Agent to Sell the Property

Mary Tan

Coldwell Banker Realty License #00861682 Listed on: 04/04/2017

Coldwell Banker Realty

Co-Listed By

George Tan

Coldwell Banker Realty License #01891525

Coldwell Banker Realty

Last Buyer's Agent

George Tan

Coldwell Banker Realty License #01891525

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $33,837

Year Built

  • 1968

Lot Details

  • Gated Home
  • Wood Fence
  • Level Lot
  • Sprinklers on Timer
  • Drought Tolerant Landscaping
  • Back Yard

Parking

  • 2 Car Attached Garage
  • Enclosed Parking
  • Garage Door Opener
  • Secured Garage or Parking
  • On-Street Parking

Property Views

  • Skyline
  • Garden

Home Design

  • Pillar, Post or Pier Foundation
  • Wood Frame Construction
  • Ceiling Insulation
  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,688 Sq Ft Home
  • 1-Story Property
  • Vaulted Ceiling
  • Skylights in Kitchen
  • 2 Fireplaces
  • Two Way Fireplace
  • Fireplace With Gas Starter
  • Double Pane Windows
  • Formal Entry
  • Wine Cellar
  • Formal Dining Room
  • Den
  • Finished Basement
  • Sump Drainage
  • Washer and Dryer Hookup
  • Attic

Kitchen

  • Open to Family Room
  • Double Self-Cleaning Oven
  • Electric Oven
  • Gas Cooktop
  • Microwave
  • Plumbed For Ice Maker
  • Dishwasher
  • ENERGY STAR Qualified Appliances
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Remodeled Bathroom
  • 2 Full Bathrooms
  • Granite Bathroom Countertops
  • Dual Sinks
  • Low Flow Toliet
  • Hydromassage or Jetted Bathtub
  • Walk-in Shower
  • Low Flow Shower

Home Security

  • Alarm System
  • Panic Alarm
  • Fire and Smoke Detector

Eco-Friendly Details

  • ENERGY STAR/CFL/LED Lights

Outdoor Features

  • Balcony
  • Shed

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Thermostat
  • Separate Meters
  • Individual Gas Meter

Community Details

  • Security Service
  • Building Fire Escape

Home Details

Home Type

Single Family

Est. Annual Taxes

$33,837

Year Built

1968

Lot Details

0

Parking

2

Listing Details

  • Zoning: CU
  • Subclass: Single Family Home
  • Style: Ranch
  • Age: 49
  • Listing Class: Residential
  • Structure Sq Ft: 2688
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 1968

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Gas Starter, Dual See Thru
  • Dining Room: Dining Area, Formal Dining Room
  • Kitchen: Cooktop - Gas, Countertop - Granite, Dishwasher, Exhaust Fan, Garbage Disposal, Hookups - Gas, Hookups - Ice Maker, Island, Microwave, Oven - Double, Oven - Electric, Oven - Self Cleaning, Pantry Cabinet, Refrigerator, Skylight
  • Fireplace: Yes
  • Living Sq Ft: 2688
  • Stories: 1
  • Security: Fire Alarm, Fire Escape, Panic Alarm, Secured Garage / Parking, Security Alarm, Security Service
  • Laundry: Hookup - Electric, Hookup - Washer/Dryer
  • Flooring: Hardwood, Tile
  • Additional Rooms: Attic, Basement - Finished, Den / Study / Office, Formal Entry, Wine Cellar / Storage
  • Fireplaces Min: 2
  • Maximum Numberof Bedrooms: 4
  • Minimum Numberof Bedrooms: 4
  • Full Bathrooms: 2
  • Total Bedrooms: 4
  • Bathroom: Double Sinks, Granite, Skylight, Stall Shower, Tub, Tub With Jets, Updated Bath

Exterior Features

  • Foundation: Concrete Perimeter And Slab, Post And Pier
  • Roof: Composition
  • View: Garden / Greenbelt
  • Yard/Grounds: Back Yard, Balcony / Patio, Drought Tolerant Plants, Fenced, Sprinklers - Auto, Sprinklers - Lawn, Storage Shed / Structure
  • Fencing: Fenced, Gate, Wood
  • Construction Type: Wood Frame

Garage/Parking

  • Garage Spaces: 2
  • Garage Max: 2
  • Garage Min: 2
  • Garage Parking Features: Attached Garage, Enclosed, Gate / Door Opener, On Street

Utilities

  • Cooling System: Central Ac
  • Heating System: Central Forced Air - Gas, Fireplace
  • Sewer/Septic System: Drainage - Sump, Sewer - Public

Association/Amenities

  • Amenities Miscellaneous: High Ceiling, Skylight, Vaulted Ceiling, Walk-In Closet

Schools

  • School District: Fremont Union High
  • Elementary School: Abraham Lincoln Elementary
  • Middle School: John F. Kennedy Middle
  • High School: Monta Vista High
  • High School: 260
  • Elementary School: 85
  • Middle School: 84

Lot Info

  • Lot Description: Grade - Level
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 9462.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 9462.00

Green Features

  • Energy Features: Ceiling Insulation, Double Pane Windows, Energy Star Appliances, Energy Star Lighting, Low Flow Shower, Low Flow Toilet, Skylight, Thermostat Controller

Multi Family

  • Utilities: Individual Electric Meters, Individual Gas Meters

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 2, 2025
Sold by
Mahajan Saurabh and Mahajan Rima
Bought by
Mahajan Family Revocable Trust and Mahajan
Current Estimated Value
$4,144,251

Purchase Details

Listed on
Apr 4, 2017
Closed on
May 2, 2017
Sold by
Byrne William M and Byrne Teresa
Bought by
Mahajan Saurabh and Mahajan Rima
Seller's Agent
Mary Tan
Coldwell Banker Realty
Buyer's Agent
George Tan
Coldwell Banker Realty
List Price
$2,188,000
Sold Price
$2,500,000
Premium/Discount to List
$312,000
14.26%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.92%
Original Mortgage
$2,000,000
Interest Rate
4.23%
Mortgage Type
New Conventional
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
Mahajan Family Revocable Trust -- None Listed On Document
Mahajan Saurabh -- None Listed On Document
Mahajan Saurabh $2,500,000 Cornerstone Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Mahajan Saurabh $1,633,000
Previous Owner Mahajan Saurabh $2,000,000
Previous Owner Byrne William M $385,000
Previous Owner Byrne William M $250,000
Previous Owner Byrne William M $385,000
Previous Owner Byrne William M $392,650
Previous Owner Byrne William M $408,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/08/2017 05/08/17 Sold $2,500,000 +14.3% $930 / Sq Ft
04/12/2017 04/12/17 Pending -- -- --
04/04/2017 04/04/17 For Sale $2,188,000 -- $814 / Sq Ft
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 $33,837 $2,901,462 $2,321,170 $580,292
2024 $33,837 $2,844,571 $2,275,657 $568,914
2023 $33,837 $2,788,796 $2,231,037 $557,759
2022 $33,075 $2,734,115 $2,187,292 $546,823
2021 $32,740 $2,680,505 $2,144,404 $536,101
2020 $32,347 $2,653,020 $2,122,416 $530,604
2019 $31,579 $2,601,000 $2,080,800 $520,200
2018 $30,752 $2,550,000 $2,040,000 $510,000
2017 $9,949 $762,810 $280,368 $482,442
2016 $9,621 $747,854 $274,871 $472,983
2015 $9,537 $736,622 $270,743 $465,879
2014 $9,286 $722,194 $265,440 $456,754
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81645394

MLSListings

APN: 362-01-002