NOT LISTED FOR SALE

Estimated Value: $2,082,000 - $2,316,000

4 Beds
4 Baths
3,709 Sq Ft
$591/Sq Ft Est. Value

Last Sold December 07, 2023

Last sale price $2,050,000 $553 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $13,685/month

14 Days on Market

Highlights

  • Spa
  • Craftsman Architecture
  • Family Room with Fireplace
  • Arroyo Seco Elementary School Rated A-
  • Secluded Lot
  • 5-minute walk to Bruno Canziani Neighborhood Park

About This Home

As of December 2023

Gorgeous Private Reserve home! Hardwood floors flow throughout most of the first floor, w/plush carpet in the formal living room, main level bedroom & all upstairs bedrooms. Kitchen has slab granite counter-tops, island & full backsplash, prof. grade Wolf SS appliances & Sub-Zero built-in refrigerator. Other items include, veggie sink in island, Bosch dishwasher, breakfast nook w/ built-in desk, breakfast bar & butler pantry w/additional counter space, sink & driveway access. The family room has a gas fireplace, entertainment niche & flush mounted speakers. There is one bedroom and bath downstairs, plantation shutters throughout, crown molding, solar electricity, wine bar w/two under counter wine refrigerators, formal living room w/ fireplace, new interior paint, upstairs built-in tech center & laundry room. Spacious master suite w/ flushed mounted speakers & large walk-in closet. Luxurious travertine tiled bath with walk-in block shower. All upstairs bedrooms with ensuite baths. Backyard has large flagstone patio w/ two overhangs for shade, outdoor rock fireplace and large sitting wall. Drought resistant grass, fountain & spa. There is a detached three car garage w/epoxy floors and cabinets for storage. The extended driveway has a porte cochere & side entry into home.

Last Agent to Sell the Property

Christopher Tarantino

Tarantino Real Estate, Inc. License #01387331 Listed on: 11/01/2023

Last Buyer's Agent

Lavanya Duvvi

Radius Agent Realty License #01901376

Radius Agent Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $25,192

Year Built

  • Built in 2009

Lot Details

  • 0.25 Acre Lot
  • Fenced
  • Secluded Lot
  • Garden
  • Back and Front Yard

HOA Fees

  • $8 Monthly HOA Fees

Parking

  • 3 Car Detached Garage

Home Design

  • Craftsman Architecture
  • Slab Foundation
  • Shingle Roof
  • Stucco

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Sound System
  • Gas Fireplace
  • Double Pane Windows
  • Family Room with Fireplace
  • 3 Fireplaces
  • Family Room Off Kitchen
  • Living Room with Fireplace
  • Formal Dining Room
  • Fire Sprinkler System
  • Washer and Dryer Hookup

Kitchen

  • Breakfast Area or Nook
  • Breakfast Bar
  • Built-In Double Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Stone Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 4 Full Bathrooms

Utilities

  • Zoned Heating and Cooling
  • Gas Water Heater

Additional Features

  • Solar owned by a third party
  • Spa

Community Details

  • Association fees include management fee
  • Association Phone (925) 824-2888
  • Built by Signature
  • Dunsmuir Subdivision, Cremant Floorplan

Listing and Financial Details

  • Assessor Parcel Number 099A29329

Home Details

Home Type

Single Family

Est. Annual Taxes

$25,192

Year Built

Built in 2009

Lot Details

0

HOA Fees

$8 per month

Parking

3

Listing Details

  • Stories: 2
  • Year Built: 2009
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.25
  • Subdivision Name: DUNSMUIR
  • Directions: Charlotte to Stockton Loop
  • Architectural Style: Craftsman
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: Two Story
  • New Construction: No
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Carpet, Hardwood, Tile
  • Private Spa: Yes
  • Appliances: Dishwasher, Double Oven, Disposal, Gas Range, Microwave, Oven, Refrigerator, Gas Water Heater
  • Full Bathrooms: 4
  • Total Bedrooms: 4
  • Door Features: Mirrored Closet Door(s)
  • Fireplace Features: Family Room, Gas, Living Room, Other, See Remarks
  • Fireplaces: 3
  • Fireplace: Yes
  • Interior Amenities: Family Room, Formal Dining Room, Kitchen/Family Combo, Breakfast Bar, Breakfast Nook, Stone Counters, Kitchen Island, Wet Bar, Sound System
  • Window Features: Double Pane Windows, Window Coverings
  • Room Kitchen Features: Breakfast Bar, Breakfast Nook, Counter - Stone, Dishwasher, Double Oven, Garbage Disposal, Gas Range/Cooktop, Island, Microwave, Oven Built-in, Refrigerator, Wet Bar

Exterior Features

  • Roof: Shingle
  • Fencing: Fenced
  • Lot Features: Level, Secluded
  • Pool Features: Spa
  • Pool Private: No
  • Builder Name: Signature
  • Construction Type: Stucco
  • Exterior Features: Back Yard, Front Yard, Garden/Play
  • Foundation Details: Slab
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 3
  • Attached Garage: No
  • Covered Parking Spaces: 3
  • Parking Features: Detached

Utilities

  • Heating: Zoned
  • Cooling: Ceiling Fan(s), Zoned
  • Laundry Features: Hookups Only
  • Security: Fire Sprinkler System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: Photovoltaics Third-Party Owned
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Amenities: Other
  • Association Fee: 99
  • Association Fee Frequency: Annually
  • Association Name: CALL LISTING AGENT
  • Phone: 925-824-2888
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Fee Information

  • Association Fee Includes: Management Fee

Schools

  • Senior High School District: Livermore Valley (925) 606-3200

Lot Info

  • Lot Size Sq Ft: 10993
  • Parcel Number: 099A29329
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 1, 2023
Closed on
Nov 30, 2023
Sold by
Bartelt Joseph and Bartelt Jeanne
Bought by
Upadhyayula Family Revocable Trust and Upadhyayula
Seller's Agent
Christopher Tarantino
Tarantino Real Estate, Inc.
Buyer's Agent
Lavanya Duvvi
Radius Agent Realty
List Price
$1,998,000
Sold Price
$2,050,000
Premium/Discount to List
$52,000
2.6%
Views
71
Current Estimated Value
$2,192,422

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$142,422
Avg. Annual Appreciation
3.53%
Original Mortgage
$1,640,000
Outstanding Balance
$1,610,919
Interest Rate
6.88%
Mortgage Type
New Conventional
Estimated Equity
$571,286

Purchase Details

Closed on
Dec 17, 2012
Sold by
Bartelt Joseph
Bought by
Bartelt Joseph and Bartelt Jeanne

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$415,000
Interest Rate
3.27%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 14, 2012
Sold by
Bartelt Jeanne
Bought by
Bartelt Joseph

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$415,000
Interest Rate
3.27%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 5, 2012
Sold by
Bartelt Jeanne
Bought by
Bartelt Joseph

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
3.86%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 20, 2009
Sold by
South Livermore Development Company
Bought by
Bartelt Joseph and Bartelt Jeanne

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$625,000
Interest Rate
4.91%
Mortgage Type
Purchase Money Mortgage
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
Upadhyayula Family Revocable Trust $2,050,000 Chicago Title
Bartelt Joseph -- None Available
Bartelt Joseph -- Old Republic Title Company
Bartelt Joseph -- Old Republic Title Company
Bartelt Joseph $855,000 Chicago Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Upadhyayula Family Revocable Trust $1,640,000
Previous Owner Bartelt Joseph $415,000
Previous Owner Bartelt Joseph $417,000
Previous Owner Bartelt Joseph $625,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/04/2025 02/04/25 Off Market $2,050,000 -- --
12/07/2023 12/07/23 Sold $2,050,000 +2.6% $553 / Sq Ft
11/07/2023 11/07/23 Pending -- -- --
10/24/2023 10/24/23 For Sale $1,998,000 -- $539 / Sq Ft
Source: Bay East Association of REALTORS®

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 $25,192 $2,091,000 $627,300 $1,463,700
2024 $25,192 $2,050,000 $615,000 $1,435,000
2023 $13,890 $1,058,215 $317,464 $740,751
2022 $13,672 $1,030,473 $311,242 $726,231
2021 $12,679 $1,010,133 $305,140 $711,993
2020 $13,025 $1,006,710 $302,013 $704,697
2019 $13,172 $986,977 $296,093 $690,884
2018 $12,857 $967,628 $290,288 $677,340
2017 $12,458 $948,656 $284,597 $664,059
2016 $12,062 $930,060 $279,018 $651,042
2015 $11,345 $916,097 $274,829 $641,268
2014 $11,162 $898,160 $269,448 $628,712
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 41042777

Bay East Association of REALTORS®

APN: 099A-2932-009-00