NOT LISTED FOR SALE

Estimated Value: $1,881,000 - $2,340,414

5 Beds
4 Baths
3,947 Sq Ft
$529/Sq Ft Est. Value

Last Sold December 01, 2023

Last sale price $2,150,000 $545 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $13,837/month

13 Days on Market

Highlights

  • Guest House
  • Spa
  • Updated Kitchen
  • Arroyo Seco Elementary School Rated A-
  • Solar Power System
  • Craftsman Architecture

About This Home

As of December 2023

Welcome Home to 5524 Stockton Loop! This stunning single level home boasts over 3,900 SF of living space with a 3,423 SF 4 bedroom, 3 bathroom Main home and a detached 524 SF ADU with a full kitchen, bedroom, and bathroom. Owned solar and recently upgraded finishes and fixtures make this meticulously maintained home efficient and beautiful. Imagine how much you’ll enjoy the open-concept design, spacious Family Room, well appointed Kitchen, and private backyard with relaxing hot tub. Nestled in the heart of Livermore’s Wine Country yet conveniently located close to parks, schools, golf courses, the lively downtown, and easy freeway access. Schedule a showing today! This is more than a home, it is the lifestyle you deserve.

Last Listed By

Jo Ann Luisi

Compass License #01399250 Listed on: 10/18/2023

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $27,054

Year Built

  • Built in 2006

Lot Details

  • 0.25 Acre Lot
  • Rectangular Lot
  • Back Yard

HOA Fees

  • $8 Monthly HOA Fees

Parking

  • 3 Car Detached Garage
  • Tandem Parking

Home Design

  • Craftsman Architecture
  • Slab Foundation
  • Shingle Roof
  • Stucco

Interior Spaces

  • 1-Story Property
  • Gas Fireplace
  • Family Room with Fireplace
  • Family Room Off Kitchen
  • Formal Dining Room
  • Fire Sprinkler System

Kitchen

  • Updated Kitchen
  • Eat-In Kitchen
  • Built-In Double Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Disposal

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • 4 Full Bathrooms

Laundry

  • Dryer
  • Washer

Eco-Friendly Details

  • Solar Power System
  • Solar owned by seller

Utilities

  • Zoned Heating and Cooling
  • Gas Water Heater

Additional Features

  • Spa
  • Guest House

Community Details

  • Association fees include common area maintenance
  • Call Listing Agent Association, Phone Number (925) 824-2888
  • Dunsmuir Subdivision
  • Greenbelt

Listing and Financial Details

  • Assessor Parcel Number 99A293321

Home Details

Home Type

Single Family

Est. Annual Taxes

$27,054

Year Built

Built in 2006

Lot Details

0

HOA Fees

$8 per month

Parking

3

Listing Details

  • Stories: 1
  • Year Built: 2006
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.25
  • Subdivision Name: DUNSMUIR
  • Directions: Charlotte Way to Stockton Loop (R)
  • Architectural Style: Craftsman
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: One Story
  • New Construction: No
  • Green Power: Solar
  • Power Production Type: Photovoltaics
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: VirtualTour

Interior Features

  • Flooring: Carpet, Tile, Vinyl
  • Spa Features: Private
  • Private Spa: Yes
  • Appliances: Dishwasher, Double Oven, Disposal, Gas Range, Microwave, Oven, Refrigerator, Dryer, Washer, Gas Water Heater
  • Full Bathrooms: 4
  • Total Bedrooms: 5
  • Fireplace Features: Family Room, Gas, Gas Starter
  • Fireplaces: 1
  • Fireplace: Yes
  • Interior Amenities: Family Room, Formal Dining Room, Kitchen/Family Combo, Counter - Solid Surface, Eat-in Kitchen, Kitchen Island, Pantry, Updated Kitchen
  • Room Kitchen Features: Counter - Solid Surface, Dishwasher, Double Oven, Eat In Kitchen, Garbage Disposal, Gas Range/Cooktop, Island, Microwave, Oven Built-in, Pantry, Refrigerator, Updated Kitchen

Exterior Features

  • Roof: Shingle
  • Lot Features: Regular
  • Pool Private: No
  • Construction Type: Stucco
  • Exterior Features: Back Yard, Sprinklers Automatic
  • Foundation Details: Slab
  • Other Structures: Guest House
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 3
  • Attached Garage: No
  • Covered Parking Spaces: 3
  • Parking Features: Detached, Tandem
  • Total Parking Spaces: 3

Utilities

  • Heating: Zoned
  • Cooling: Zoned
  • Laundry Features: Dryer, Laundry Room, Washer
  • Security: Fire Sprinkler System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: Photovoltaics Seller Owned
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

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

Fee Information

  • Association Fee Includes: Common Area Maint

Schools

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

Lot Info

  • Lot Size Sq Ft: 10992
  • Parcel Number: 99A293321
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 18, 2023
Closed on
Nov 14, 2023
Sold by
Mackin George H and Mackin Linda
Bought by
Sharma Shailendra and Sagar Swati
Seller's Agent
Jo Ann Luisi
Compass
Buyer's Agent
Mollie Nierhake
Wr Properties
List Price
$2,150,000
Sold Price
$2,150,000
Total Days on Market
13
Views
99
Current Estimated Value
$2,087,604

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$62,396
Avg. Annual Appreciation
-2.01%
Original Mortgage
$1,612,500
Interest Rate
7.63%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 25, 2011
Sold by
Mamaoag Nelson E and Mamaoag Josphine G
Bought by
Mackin Geroge H and Mackin Linda

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 23, 2006
Sold by
South Livermore Development Co
Bought by
Mamaoag Nelson E and Mamaoag Josephine G

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$964,900
Interest Rate
6.75%
Mortgage Type
Negative Amortization

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

Similar Homes in Livermore, CA

  • 2611 Kellogg Ct, Livermore, CA 94550

    $1,898,000

    • 4 Beds
    • 3 Baths
    • 3,003 Sq Ft
    • 2611 Kellogg Ct
    • Livermore, CA

    Nestled in the heart of wine county, this stunning home is located at the end of a cul-de-sac, surrounded by vineyards in the desirable Dunsmuir neighborhood. With its charming curb appeal, you’ll feel at home the minute you step onto the front porch. As you enter, high ceilings and gorgeous wood floors set the tone for elegance. The main floor includes a bedroom and full bathroom, dining and

    Jeannine Rinetti

    Section Image
  • 2130 Staghorn Way, Livermore, CA 94550

    $1,949,000

    • 5 Beds
    • 4 Baths
    • 3,541 Sq Ft
    • 2130 Staghorn Way
    • Livermore, CA

    Welcome to your dream home in the desirable Lindenwood development! This luxury residence blends style, comfort, and functionality. Begin your evenings unwinding on the inviting west-facing front porch, perfect for soaking in stunning sunsets. Inside, newer flooring flows passed the open Living and Dining area into a Gourmet Kitchen featuring a walk-in pantry, granite counters, a massive

    Tracey Esling Legacy Real Estate & Assoc.

    Section Image
  • 2410 Robinson Cir, Livermore, CA 94550

    $1,699,000

    • 4 Beds
    • 3 Baths
    • 2,460 Sq Ft
    • 2410 Robinson Cir
    • Livermore, CA

    Must see this premium CORNER LOT home in one of the area's most sought-after SOUTH LIVERMORE neighborhoods with OWNED ELECTRIC SOLAR! From the minute you arrive you will appreciate the large covered front porch and nearby open space. As you step inside the EAST facing front door you will see a modern updated interior with stunning wide-plank flooring, crown molding, plantation shutters, and

    Miranda Mattos Compass

    Section Image
  • 2741 Whitehall Ct, Livermore, CA 94550

    $2,400,000

    • 4 Beds
    • 4.5 Baths
    • 3,758 Sq Ft
    • 2741 Whitehall Ct
    • Livermore, CA

    Welcome to this stunning estate in the highly sought-after Vineyard Gates subdivision, offering an unparalleled blend of elegance and modern comfort. Boasting 3,758 sq. ft. of living space on an expansive 13,000+ sq. ft. lot, this home features 4 bedrooms and 4.5 bathrooms, including a private downstairs suite—ideal for guests or multi-generational living. Step inside to find luxury vinyl plank

    Trina Batterson Homesmart PV & Assoc.

    Section Image
  • 738 Hazel St, Livermore, CA 94550

    $1,575,000

    • 5 Beds
    • 3 Baths
    • 2,698 Sq Ft
    • 738 Hazel St
    • Livermore, CA

    Experience the warmth and character of this one-of-a-kind designer’s home—lovingly renovated as a personal residence—not an investor flip—crafted for comfort, functionality, and style. Ideally located near downtown Livermore, award-winning wineries, and I-580. Over $400K in quality upgrades make this home truly move-in ready. The 1,634 sq ft main level offers 3 bedrooms, 2 full baths, and an

    James Dye Heritage Properties

    Section Image
  • 618 Loyola Way, Livermore, CA 94550

    $1,550,000

    • 4 Beds
    • 3 Baths
    • 2,472 Sq Ft
    • 618 Loyola Way
    • Livermore, CA

    SO SPECIAL!!! AS YOU ENTER THE HOME YOU WILL APPRECIATE THE GLEAMING WOOD FLOORS AND THE GRACIOUS LIVING AND DINING ROOMS WITH HIGH CEILINGS AND A VIEW OVERLOOKING THE LUSH BACKYARD. FULL BEDROOM AND BATH DOWNSTAIRS, AN INCREDIBLE REMODELED KITCHEN WITH EXTENSIVE DETAIL INCLUDING A BEVERAGE REFRIGERATOR. A DRAMATIC STAIRWAY LEADS YOU TO THE 3 UPSTAIRS BEDROOMS--THE PRIMARY BEDROOM OVERLOOKS THE

    Rosie Yandwell

    Section Image
  • 5642 Arlene Way, Livermore, CA 94550

    $1,550,000

    • 4 Beds
    • 3 Baths
    • 2,268 Sq Ft
    • 5642 Arlene Way
    • Livermore, CA

    Welcome to this beautifully maintained 4-bedroom, 3-bath home situated on a spacious 9,000 sq ft lot in one of Livermore’s most convenient locations. This thoughtfully designed home features a first-floor bedroom and full bath, ideal for guests or multi-gen living. Step inside to soaring vaulted ceilings and a light-filled formal living space that flows into a large dining area with a cozy

    Roland Osage Real Brokerage Technologies

    Section Image
  • 1456 Melanie Way, Livermore, CA 94550

    $1,699,000

    • 5 Beds
    • 3.5 Baths
    • 3,149 Sq Ft
    • 1456 Melanie Way
    • Livermore, CA

    Step into this beautifully updated WEST FACING home to see soaring two-story vaulted ceilings and a grand formal living and dining room. The kitchen has been thoughtfully updated with gorgeous quartz countertops and backsplash, sleek white cabinetry, stainless gas cooktop, stainless steel sink, island with seating, and a walk-in pantry. Enjoy brand new wide plank flooring, fresh two-toned paint,

    Miranda Mattos Compass

    Section Image
  • 4588 Phyllis Ct, Livermore, CA 94550

    $1,689,000

    • 4 Beds
    • 3 Baths
    • 2,472 Sq Ft
    • 4588 Phyllis Ct
    • Livermore, CA

    Move-in Ready! Unlock the door to your dream home where modern design meets unparalleled comfort. This exquisite residence boasts 4 spacious bedrooms and 3 luxuriously updated bathrooms across 2,472 square feet of beautifully designed living space. From the moment you step inside, you'll be greeted by an abundance of natural light, enhanced by upgraded flooring throughout and elegantly updated

    Peter Mcdowell Compass

    Section Image

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
Sharma Shailendra $2,150,000 First American Title
Mackin Geroge H $751,000 Fidelity National Title Co
Mamaoag Nelson E $1,287,000 Chicago Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Sharma Shailendra $1,618,000
Closed Sharma Shailendra $1,612,500
Previous Owner Mackin George H $286,000
Previous Owner Mackin Geroge H $284,000
Previous Owner Mamaoag Nelson E $1,000,000
Previous Owner Mamaoag Nelson E $229,000
Previous Owner Mamaoag Nelson E $964,900
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/04/2025 02/04/25 Off Market $2,150,000 -- --
12/01/2023 12/01/23 Sold $2,150,000 0.0% $545 / Sq Ft
10/31/2023 10/31/23 Pending -- -- --
10/18/2023 10/18/23 For Sale $2,150,000 -- $545 / 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
2024 $27,054 $2,150,000 $645,000 $1,505,000
2023 $12,929 $906,628 $271,988 $634,640
2022 $12,037 $888,853 $266,656 $622,197
2021 $11,073 $871,430 $261,429 $610,001
2020 $11,462 $862,500 $258,750 $603,750
2019 $11,599 $845,595 $253,678 $591,917
2018 $11,314 $829,020 $248,706 $580,314
2017 $10,958 $812,768 $243,830 $568,938
2016 $10,611 $796,833 $239,050 $557,783
2015 $9,989 $784,870 $235,461 $549,409
2014 $9,830 $769,496 $230,849 $538,647
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 41042345

Bay East Association of REALTORS®

APN: 099A-2933-021-00