NOT LISTED FOR SALE

400 Hamden Ln Modesto, CA 95350

Central Modesto Neighborhood

Estimated Value: $743,000 - $812,000

4 Beds
2.5 Baths
3,026 Sq Ft
$252/Sq Ft Est. Value

Sale Details

Date Sold: September 11, 2025

Last sale price $749,000 $248 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $4,642 / mo

7 Days on Market

Highlights

  • RV Access or Parking
  • Granite Countertops
  • Breakfast Area or Nook
  • Corner Lot
  • No HOA
  • 3-minute walk to Woodrow Park

About This Home

As of September 2025

Back on market with a HUGE price improvement. 400 Hamden Lane is beautifully updated 4 Bedroom 2.5 Bath home that is designed for both comfort and entertainment. Perfectly situated on a .26 acre corner lot in one of Modesto's most desirable neighborhoods. You'll enjoy wonderful curb appeal as well as quick access to McHenry's shopping, dining, and many family parks. With over 3,000 square feet of living space and plenty of parking, there is no shortage of room for entertaining. This home is truly a rare find. Don't miss your chance to make 400 Hamden Lane yours!

Last Agent to Sell the Property

Aaron Zwahlen

RE/MAX Executive License #02209965 Listed on: 08/19/2025

RE/MAX Executive

Last Buyer's Agent

Debbi Agresti

PMZ Real Estate License #01358241

PMZ Real Estate

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1972

Lot Details

  • 11,382 Sq Ft Lot
  • Corner Lot

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • RV Access or Parking

Home Design

  • Raised Foundation
  • Composition Roof
  • Cement Siding
  • Stucco

Interior Spaces

  • 3,026 Sq Ft Home
  • 1-Story Property
  • Beamed Ceilings
  • Ceiling Fan
  • Fireplace
  • Family Room
  • Living Room
  • Formal Dining Room

Kitchen

  • Breakfast Area or Nook
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops

Flooring

  • Laminate
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Secondary Bathroom Double Sinks
  • Bathtub

Laundry

  • Laundry in unit
  • Dryer
  • Washer
  • Sink Near Laundry
  • 220 Volts In Laundry

Home Security

  • Video Cameras
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Covered Courtyard
  • Shed

Utilities

  • Central Heating and Cooling System
  • 220 Volts in Kitchen
  • Tankless Water Heater

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 059-038-001-000

Home Details

Home Type

Single Family

Year Built

Built in 1972

Lot Details

0.26 Acres

Parking

3

Listing Details

  • Property Type: Residential
  • Subtype Description: Detached
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: Unknown
  • Stories: 1
  • Year Built: 1972
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Microwave, Tankless Water Heater
  • Interior Amenities: Open Beam Ceiling
  • Flooring: Laminate, Vinyl
  • Total Bathrooms: 3
  • Bathroom Features: Double Sinks, Tub
  • Dining Room Features: Breakfast Nook, Formal Area
  • Kitchen Features: Breakfast Area, Granite Counter, Island
  • Living Room Features: Open Beam Ceiling
  • Main Level: Bedroom(s), Living Room, Dining Room, Family Room, Master Bedroom, Full Bath(s), Garage, Kitchen
  • Price Per Square Foot: 247.52
  • Square Footage: 3026.00

Exterior Features

  • Other Structures: Shed(s), Storage
  • Construction Materials: Cement Siding, Stucco, Wood
  • Exterior Features: Covered Courtyard
  • Foundation: Raised
  • Home Warranty: No
  • Horse Property: No
  • Listing Price: 749000.00
  • Lot Features: Corner
  • New Construction: No
  • Pool: No
  • Roof: Composition
  • Spa: No

Garage/Parking

  • Garage Spaces: 3.00
  • Parking Features: Attached, RV Possible, Garage Door Opener

Utilities

  • Security: Carbon Mon Detector, Smoke Detector, Video System
  • Sewer: Public Sewer
  • Utilities: Public
  • Cooling: Ceiling Fan(s), Central
  • Electric: 220 Volts in Kitchen, 220 Volts in Laundry
  • Heating: Central, Fireplace(s)
  • Laundry Features: Dryer Included, Sink, Electric, Gas Hook-Up, Washer Included, Inside Room
  • Water Source: Public

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Fee Information

  • Land Lease: No

Schools

  • Senior High School District: Modesto City

Lot Info

  • Zoning: R-1
  • Irrigation: Public District
  • Lot Size Acres: 0.2613
  • Lot Size Sq Ft: 11382.00

Multi Family

Tax Info

  • Assessor Parcel Number: 059-038-001-000
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): Stanislaus

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 19, 2025
Closed on
Sep 5, 2025
Sold by
Tyson William Manuel and Tyson Alicia
Bought by
Elias Y Aywas Revocable Trust and Aywas
Seller's Agent
Aaron Zwahlen
RE/MAX Executive
Buyer's Agent
Debbi Agresti
PMZ Real Estate
List Price
$749,000
Sold Price
$749,000
Views
29
Current Estimated Value
$753,789

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$4,789
Avg. Annual Appreciation
3.35%

Purchase Details

Listed on
Jun 3, 2022
Closed on
Jul 21, 2022
Sold by
Neugebauer Robert B and Neugebau Betty
Bought by
Tyson William Manuel and Tyson Alicia
Seller's Agent
Damien Wilson
PMZ Real Estate
Buyer's Agent
Herbert Simmons
D R Horton America's Builder
List Price
$675,000
Sold Price
$645,000
Premium/Discount to List
-$30,000
-4.44%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.91%
Original Mortgage
$412,750
Interest Rate
5.38%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 14, 2009
Sold by
Neugebauer Betty L and The Robert B Neugebauer And Be
Bought by
Neugebauer Betty B and Neugebauer Robert B

Purchase Details

Closed on
Jun 11, 2004
Sold by
Juarez Sharon and Juarez Keith Linda
Bought by
Neugebauer Robert B and Neugebauer Betty L

Purchase Details

Closed on
Feb 1, 2001
Sold by
Berg Carl J and Berg Virginia L
Bought by
Berg Carl J and Berg Virginia L
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Elias Y Aywas Revocable Trust $749,000 Wfg National Title Insurance C
Tyson William Manuel $645,000 New Title Company Name
Neugebauer Betty B -- None Available
Neugebauer Robert B $460,000 First American Title Co
Berg Carl J -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Tyson William Manuel $412,750
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
09/11/2025 09/11/25 Sold $749,000 0.0% $248 / Sq Ft
08/26/2025 08/26/25 Pending -- -- --
08/19/2025 08/19/25 For Sale $749,000 +16.1% $248 / Sq Ft
07/29/2022 07/29/22 Sold $645,000 -4.4% $213 / Sq Ft View Prior Sale
06/28/2022 06/28/22 Pending -- -- --
06/03/2022 06/03/22 For Sale $675,000 -- $223 / Sq Ft
Source: MetroList

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 $7,415 $671,058 $234,090 $436,968
2024 $7,282 $657,900 $229,500 $428,400
2023 $7,788 $645,000 $225,000 $420,000
2022 $1,877 $180,217 $78,902 $101,315
2021 $1,843 $176,684 $77,355 $99,329
2020 $1,816 $174,873 $76,562 $98,311
2019 $1,781 $171,445 $75,061 $96,384
2018 $1,745 $168,085 $73,590 $94,495
2017 $1,702 $164,791 $72,148 $92,643
2016 $1,690 $161,561 $70,734 $90,827
2015 $1,664 $159,135 $69,672 $89,463
2014 $1,657 $156,019 $68,308 $87,711
Source: Public Records

Agents Affiliated with this Home

  • A

    Seller's Agent in 2025

    Aaron Zwahlen

    RE/MAX

    (209) 577-2121

    1 in this area

    5 Total Sales

    Aaron Zwahlen
    Section Image
  • Debbi Agresti

    Buyer's Agent in 2025

    Debbi Agresti

    PMZ Real Estate

    (209) 608-3992

    4 in this area

    63 Total Sales

    Debbi Agresti
    Section Image
  • Damien Wilson

    Seller's Agent in 2022

    Damien Wilson

    PMZ Real Estate

    (209) 505-1530

    15 in this area

    162 Total Sales

    Damien Wilson
    Section Image
  • Aaron West

    Seller Co-Listing Agent in 2022

    Aaron West

    PMZ Real Estate

    (209) 484-1651

    52 in this area

    510 Total Sales

    Aaron West
    Section Image

  • H

    Buyer's Agent in 2022

    Herbert Simmons

    D R Horton America's Builder

    (415) 999-1194

    1 in this area

    15 Total Sales

    Herbert Simmons
    Section Image
See All Agents

Map

Source: MetroList

MLS Number: 225109306

MetroList

APN: 059-38-01

California Stanislaus County Modesto 95350 Central Modesto

400 Hamden Ln, Modesto, CA

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.

MetroList IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.