$880,000
SOLD FEB 26, 2025

542 Dutch Elm Dr Hercules, CA 94547

4 Beds
3 Baths
2,394 Sq Ft
5,202 Sq Ft Lot

Recently Sold

$368 Per Sq Ft

5% Below List Price

20 Days on Market

Highlights

  • Craftsman Architecture
  • Corner Lot
  • 2 Car Detached Garage
  • Hercules High School Rated 9+
  • Stone Countertops
  • Cul-De-Sac

About This Home

As of February 2025

Welcome to Your Dream Home in the Sycamore Villas Community of Hercules! This impressive 2,394 sq ft, two-story residence features 4 bedrooms and 3 bathrooms, including a convenient bedroom and bath on the primary level. Enjoy the elegance of a formal living room and dining area, complemented by a modern kitchen with Silestone countertops, maple oak cabinets, and all major appliances. Additional highlights include a durable tile roof and a detached garage. This home perfectly balances tranquility and accessibility, conveniently located near public transportation and the freeway. Plus, you’ll be within walking distance to the Hercules Library, Civic Center, and retail shopping, including the new Safeway and Chase Bank. Don’t miss your chance to make this beautiful home yours!

Last Agent to Sell the Property

Vanessa Cruz

Re/max Accord License #2155164 Listed on: 01/17/2025

Re/max Accord

Co-Listed By

Viktor Manrique

Re/max Regency License #01224855

Last Buyer's Agent

Akel Hillany

Luxe Realty Group License #02078207

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,430

Year Built

  • Built in 2001

Lot Details

  • 5,202 Sq Ft Lot
  • Cul-De-Sac
  • Street terminates at a dead end
  • Corner Lot
  • Back and Front Yard

HOA Fees

  • $215 Monthly HOA Fees

Parking

  • 2 Car Detached Garage

Home Design

  • Craftsman Architecture
  • Stucco

Kitchen

  • Built-In Oven
  • Built-In Range
  • Microwave
  • Dishwasher
  • Stone Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 3 Full Bathrooms

Laundry

  • Laundry on upper level
  • Dryer
  • Washer

Additional Features

  • 2-Story Property
  • Forced Air Heating and Cooling System

Community Details

  • Association fees include ground maintenance
  • Sycamore Villas HOA, Phone Number (800) 557-5179
  • Sycamore Villas Subdivision

Listing and Financial Details

  • Assessor Parcel Number 4065400279

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,430

Year Built

Built in 2001

Lot Details

0

HOA Fees

$215 per month

Parking

2

Listing Details

  • Stories: 2
  • Year Built: 2001
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.12
  • Co List Office Mls Id: CCWRWREG
  • Subdivision Name: Sycamore Villas
  • Directions: GPS
  • Architectural Style: Craftsman
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: Two Story
  • New Construction: No
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: None

Interior Features

  • Flooring: Laminate, Tile, Carpet
  • Appliances: Dishwasher, Disposal, Gas Range, Microwave, Oven, Range, Refrigerator, Dryer, Washer
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Fireplace Features: None
  • Fireplace: No
  • Interior Amenities: No Additional Rooms, Stone Counters
  • Room Kitchen Features: Counter - Stone, Dishwasher, Garbage Disposal, Gas Range/Cooktop, Microwave, Oven Built-in, Range/Oven Built-in, Refrigerator

Exterior Features

  • Lot Features: Corner Lot, Court, Cul-De-Sac, Dead End
  • Pool Features: None
  • Pool Private: No
  • Construction Type: Stucco
  • Exterior Features: Back Yard, Front Yard
  • Property Condition: Existing

Garage/Parking

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

Utilities

  • Heating: Forced Air
  • Cooling: Central Air
  • Laundry Features: Dryer, Washer, Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: No Solar
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Amenities: Other
  • Association Fee: 215
  • Association Fee Frequency: Monthly
  • Association Name: Sycamore Villas HOA
  • Phone: 800-557-5179
  • Association: Yes
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Association Fee Includes: Maintenance Grounds

Lot Info

  • Lot Size Sq Ft: 5202
  • Parcel Number: 4065400279
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 17, 2025
Closed on
Feb 19, 2025
Sold by
Yu Stephen
Bought by
Unpingco Katrina and Unpingco Joel
Seller's Agent
Vanessa Cruz
Re/max Accord
Buyer's Agent
Akel Hillany
Luxe Realty Group
List Price
$929,000
Sold Price
$880,000
Premium/Discount to List
-$49,000
-5.27%
Views
32
Current Estimated Value
$885,995

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$5,995
Avg. Annual Appreciation
1.37%
Original Mortgage
$792,000
Outstanding Balance
$788,742
Interest Rate
7.04%
Mortgage Type
New Conventional
Estimated Equity
$97,997

Purchase Details

Closed on
Feb 15, 2002
Sold by
Kb Home South Bay Inc
Bought by
Yu Stephen and Yu Anita C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$300,000
Interest Rate
6.94%
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 Type Sale Price Title Company
Grant Deed $880,000 Old Republic Title
Grant Deed $426,000 First American Title Guarant
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $792,000 New Conventional
Previous Owner $268,000 New Conventional
Previous Owner $300,000 Unknown
Previous Owner $120,000 Credit Line Revolving
Previous Owner $322,700 Unknown
Previous Owner $300,700 Unknown
Previous Owner $300,000 Purchase Money Mortgage
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/26/2025 02/26/25 Sold $880,000 -2.1% $368 / Sq Ft
02/06/2025 02/06/25 Pending -- -- --
01/24/2025 01/24/25 Price Changed $899,000 -3.2% $376 / Sq Ft
01/17/2025 01/17/25 For Sale $929,000 -- $388 / Sq Ft
Source: Contra Costa 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 $9,430 $629,015 $295,451 $333,564
2024 $9,430 $616,682 $289,658 $327,024
2023 $9,268 $604,591 $283,979 $320,612
2022 $9,165 $592,737 $278,411 $314,326
2021 $9,157 $581,115 $272,952 $308,163
2019 $8,678 $563,881 $264,857 $299,024
2018 $8,419 $552,825 $259,664 $293,161
2017 $8,288 $541,986 $254,573 $287,413
2016 $8,120 $531,360 $249,582 $281,778
2015 $7,991 $512,000 $240,489 $271,511
2014 $6,899 $422,500 $198,450 $224,050
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Contra Costa Association of REALTORS®

MLS Number: 41082791

Contra Costa Association of REALTORS®

APN: 406-540-027-9