Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$485,000 Sale Pending

  • For Sale
  • Pending
  • Single Family
  • 3 Beds
  • 2 Full Baths
  • 1,648 Sq. Ft.
  • 2 Car Garage
  • Updated 12 days ago
See This Home
Save This Home
See This Home
Save This Home
Welcome to 506 Duncan! Experience refined living in this beautifully appointed 3-bedroom, 2-bath residence spanning 1,648 sq ft, perfectly situated on a picturesque, mature tree-lined street in the heart of Modesto. This timeless home balances classic character with curated upgrades, creating an ambiance of understated elegance. Hardwood floors and an architectural tray ceiling set the tone in the living room, offering a warm yet sophisticated space for gathering and entertaining. The thoughtfully updated kitchen boasts shaker cabinetry, generous storage, and premium quartz countertopsan elevated blend of style and functionality. Retreat to the spacious primary suite, where a luxe bath with an expansive walk-in shower provides spa-inspired comfort. Enjoy modern conveniences throughout, including recessed lighting, a WiFi-enabled thermostat, a low-maintenance landscape, and a newly installed roof for added peace of mind. A private front courtyard offers an intimate outdoor sanctuary, perfect for quiet mornings or evening unwinding. Ideally positioned just minutes from several parks, Dry Creek Trail, and an array of dining and shopping. Classic charm meets modern sophisticationwelcome home

Full Property Details for 506 Duncan Ave

General

  • Price: $485,000
  • Status: Pending
  • Type: Single Family
  • Source: METROLIST_Cali
  • MLS ID: 225147999
  • Updated: 1/4/2026
  • Added to Site: 46 day(s) ago

Interior

  • Fireplace: Yes
  • Number of Fireplaces: 2
  • Fireplace(s): Living Room, Master Bedroom, Family Room
  • Appliances: Hood Over Range, Ice Maker, Dishwasher, Microwave
  • Flooring: Tile, Wood

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2

Bedrooms

  • Total Bedrooms: 3

Other Rooms

  • Kitchen: Quartz Counter, Stone Counter
  • Dining Room: Space in Kitchen
  • Laundry: Inside Area, Inside Room

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Parking: Detached

Location

  • County: Stanislaus
  • Cross Streets: High St
  • Driving Directions: Use GPS

School Information

  • School District: Stanislaus
  • Elem School District: Modesto City
  • Midd School District: Modesto City
  • High School District: Modesto City

Heating & Cooling

  • Cooling Type: Ceiling Fan(s), Central
  • Heating Type: Central, Fireplace(s)
  • Heating Fuel: Central, Fireplace(s)

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Utility Description: Public

Structural Information

  • Construction: Frame
  • Basement: Yes
  • Foundation: Raised
  • Roof: Shingle
  • Stories/Levels: 1
  • Square Feet: 1,648
  • Sq. Ft. Source: Assessor Auto-Fill
  • Year Built: 1946

Lot Features

  • Lot Size (Acres): 0.171
  • Lot Size (Sq. Ft.): 7,449
  • Irrigation System: None
  • Zoning: SFR
  • Lot Description: Shape Regular

Disclosures and Reports

  • Special Conditions: Offer As Is
  • APN: 112-042-019-000

Listed by Wedgewood Homes Realty

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 506 Duncan Ave —

  • Wedgewood Homes Realty

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 506 Duncan Ave

School Districts:Modesto City Elementary School District, Modesto City High School District
NameGradesDistance
John Muir Elementary School, Modesto, CA
1215 Lucerne Ave., Modesto, CA 95350
K-60.6 mi
La Loma Junior High School
1800 Encina Avenue, Modesto, CA 95354
7-81.3 mi
Thomas Downey High School
1000 Coffee Road, Modesto, CA 95355
9-120.8 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 506 Duncan Ave Get Price Alerts and Save Property

Date
Details
Price
Change
Source
12/01/2025
Listed
$485,000
62.21%
MLS
8/14/2015
Sold
$299,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 506 Duncan Ave

Year
Property Taxes
Change
Tax Assessment
Change
2025
$4,139
5%
$353,948
2%
2024
$3,954
1%
$347,008
2%
2023
$3,896
2%
$340,204
2%
2022
$3,801
6%
$333,535
2%
2021
$3,575
-2%
$326,996
1%
2020
$3,645
2%
$323,644
2%
2019
$3,561
5%
$317,299
2%
2018
$3,390
2%
$311,079
2%
2017
$3,309
2%
$304,980
2%
2016
$3,246
67%
$299,000
67%
2015
$1,943
2%
$178,696
13%
2014
$1,913
11%
$158,000
—
2013
$1,726
—
$158,000
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 506 Duncan Ave

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Wedgewood Homes Realty

Similar Properties near 506 Duncan Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

3505 Havenwood Way, Ceres, CA 95307 - Photo 1
$489,000

3505 Havenwood Way  Ceres, CA 95307

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
  • 1,602
    Sq. Ft.
Listed by Keller Williams Realty
126 Wilson Ave, Modesto, CA 95354 - Photo 1
$480,000

126 Wilson Ave  Modesto, CA 95354

  • Single Family
  • Active
  • 3
    Beds
  • 2
    Total Baths
  • 1,887
    Sq. Ft.
Listed by EXIT Realty Consultants
1417 Concord Ave, Modesto, CA 95350 - Photo 1
$479,999
Open House

1417 Concord Ave  Modesto, CA 95350

  • Single Family
  • Active
  • Updated 8 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,838
    Sq. Ft.
Listed by 3Sixty Real Estate
1307 Sycamore Ave, Modesto, CA 95350 - Photo 1 Price Reduced
-$10,000 (-2.04%)
$479,000
Open House

1307 Sycamore Ave  Modesto, CA 95350

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,446
    Sq. Ft.
Listed by HomeSmart PV & Associates

Just Listed near 506 Duncan Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2511 E Hatch, Ceres, CA 95351 - Photo 1 Just Listed
$135,000

2511 E Hatch  Ceres, CA 95351

  • Commercial Land
  • Active
  • Updated 3 days ago
  • 0.3851
    Acres
Listed by Rand Commercial Properties
Central Ave, Ceres, CA 95307 - Photo 1 Just Listed
$150,000

Central Ave  #178  Ceres, CA 95307

  • Manufactured Home
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,187
    Sq. Ft.
Listed by Allison James Estates & Homes
1530 Kinser, Ceres, CA 95307 - Photo 1 Just Listed
$425,000

1530 Kinser  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,537
    Sq. Ft.
Listed by Pacific Real Estate
Faith Home Rd, Ceres, CA 95307 - Photo 1 Just Listed
$99,888

Faith Home Rd  #4  Ceres, CA 95307

  • Manufactured Home
  • Active
  • Updated 7 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,368
    Sq. Ft.
Listed by J.Peter Realtors

Price Reduced near 506 Duncan Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

Faith Home Rd, Ceres, CA 95307 - Photo 1 Price Reduced
-$5,000 (-3.88%)
$124,000
Open House

Faith Home Rd  #162  Ceres, CA 95307

  • Manufactured Home
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,536
    Sq. Ft.
Listed by EXIT Realty Consultants
3599 Waynesboro Dr, Ceres, CA 95307 - Photo 1 Price Reduced
-$1,000 (-0.19%)
$517,900

3599 Waynesboro Dr  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,841
    Sq. Ft.
Listed by HomeSmart PV & Associates
5201 Bora Ct, Salida, CA 95368 - Photo 1 Price Reduced
-$5,001 (-0.8%)
$619,999
Open House

5201 Bora Ct  Salida, CA 95368

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,039
    Sq. Ft.
Listed by PMZ Real Estate
2137 Candlewood Pl, Riverbank, CA 95367 - Photo 1 Price Reduced
-$25,000 (-3.57%)
$675,000

2137 Candlewood Pl  Riverbank, CA 95367

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,047
    Sq. Ft.
Listed by Real Broker

Recent Sales near 506 Duncan Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

618 Chabot Ave, Modesto, CA 95354 - Photo 1 Sold
$455,000

618 Chabot Ave  Modesto, CA 95354

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,770
    Sq. Ft.
Listed by KW Patterson
Sold by EXIT Realty Consultants
610 Auburn St, Modesto, CA 95350 - Photo 1 Sold
$415,000

610 Auburn St  Modesto, CA 95350

  • Single Family
  • Closed
  • 2
    Beds
  • 1
    Total Bath
  • 1,045
    Sq. Ft.
Listed by Century 21 Select Real Estate
Sold by JRP Realty Group
311 High St, Modesto, CA 95354 - Photo 1 Sold
$415,000

311 High St  Modesto, CA 95354

  • Single Family
  • Closed
  • 5
    Beds
  • 3
    Total Baths
  • 1,780
    Sq. Ft.
Listed by West Coast Marketing Group
Sold by Cornerstone Homes
301 N High St, Modesto, CA 95354 - Photo 1 Sold
$444,000

301 N High St  Modesto, CA 95354

  • Single Family
  • Closed
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,648
    Sq. Ft.
Listed by EXIT Realty Consultants
Sold by Century 21 Select Real Estate

506 Duncan Avenue, Modesto, CA 95354 (MLS# 225147999) is a Single Family property with 3 bedrooms and 2 full bathrooms. 506 Duncan Avenue is currently listed for $485,000 and was received on December 01, 2025. Want to learn more about 506 Duncan Avenue? Do you have questions about finding other Single Family real estate for sale in Modesto? You can browse all Modesto real estate or contact a Coldwell Banker agent to request more information.

Tour this property