Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$519,000 Sale Pending

  • For Sale
  • Pending
  • Duplex
See This Home
Save This Home
See This Home
Save This Home
Modesto Duplex, in preferred area of Pleasant View Estates. Private "end of cul-de-sac location" This property consists of one large open design, 2 bedroom, 2 bath unit (2406) and one 2 bedroom, 1 bath unit (2404). Spacious front and side yards for both units provide additional privacy. The large covered porch entry design is most useful during rainy weather. Each unit has it's own garage and additional off street parking. Both units feature new central AC installed in the last few years. Best location for a strong long term rental. Near Highway 99, shopping, schools and major Medical Centers, including Sutter Memorial & Kaiser. Tenants are responsible for gas, electric, and garbage, providing a streamlined expense structure for ownership. Current rents appear to be below market, presenting clear upside through future rent adjustments while maintaining strong in-place tenancy. *** An immediate value-add opportunity exists as one unit is slated to become vacant, allowing the incoming investor to instantly capture current market-rate rents and maximize cash flow. - Call agent for a complete Buyer's Disclosure & Income package -

Full Property Details for 2404-2406 Counts Ct

General

  • Price: $519,000
  • Status: Pending
  • Type: Duplex
  • Source: MAX
  • MLS ID: 41139524
  • Updated: 7/29/2026
  • Added to Site: 63 day(s) ago

Interior

  • Appliances: Gas Water Heater
  • Flooring: Linoleum, Partial Carpeting

Rooms

Other Rooms

  • Laundry: 220 Volt Outlet, In Garage, See Remarks

Additional Information

  • Equipment: See Remarks

Exterior

  • Exterior Features: Back Yard, Front Yard, Side Yard, Landscape Front, Private Entrance, See Remarks

Parking

  • Parking Features: Enclosed, Guest, Off Street, Parking Lot, Side Yard Access, Garage Faces Front, Private, See Remarks

Location

  • Area: Listing
  • County: Stanislaus
  • Subdivision: Other
  • Driving Directions: McHenry Ave (Hwy 108) to Counts Ct to End of court. or Oakdale Rd to Floyd Ave to Counts Ct.

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Central Air, See Remarks
  • Heating Type: Forced Air

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Utility Description: Individual Electric Meter, Individual Gas Meter

Structural Information

  • Exterior Const.: Stucco, Frame, Siding - Stucco
  • Roof: Composition Shingles
  • Year Built: 1974

Lot Features

  • Lot Size (Acres): 0.2
  • Lot Dimensions: 8712
  • Lot Features: Court, Cul-De-Sac, Premium Lot, Other, Street Light(s)
  • Fencing (Description): Fenced

Financial Considerations

  • For Sale: Yes
  • Price Per Sq. Ft.: $244

Disclosures and Reports

  • Property ID: 66002060000

Listed by Realty Services Network, Stacy Adams

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

— 2404-2406 Counts Ct —

  • Stacy Adams

    Realty Services Network

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

Price & Sales History for 2404-2406 Counts Ct Get Price Alerts and Save Property

Date
Details
Price
Change
Source
7/09/2026
Price Reduced
$519,000
-4.77%
MLS
6/24/2026
Listed
$545,000
275.86%
MLS
8/08/1989
Sold
$145,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 2404-2406 Counts Ct

Year
Property Taxes
Change
Tax Assessment
Change
2025
$2,948
4%
$266,747
4%
2023
$2,839
4%
$256,391
2%
2022
$2,724
2%
$251,365
2%
2021
$2,677
1%
$246,437
1%
2020
$2,638
2%
$243,911
2%
2019
$2,590
2%
$239,129
2%
2018
$2,539
2%
$234,441
2%
2017
$2,479
1%
$229,845
2%
2016
$2,464
1%
$225,339
2%
2015
$2,428
9%
$221,955
39%
2014
$2,224
25%
$160,000
—
2013
$1,784
—
$160,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 2404-2406 Counts Ct

$
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 Realty Services Network, Stacy Adams

Just Listed near 2404-2406 Counts Ct

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

3330 E Service Rd, Ceres, CA 95307 - Photo 1 Just Listed
$2,650,000

3330 E Service Rd  Ceres, CA 95307

  • Agricultural Land
  • Active
  • Updated 1 day ago
  • 15.2
    Acres
Listed by 3% Broker.com
3129 Malik Ave, Ceres, CA 95307 - Photo 1 Just Listed
$525,000

3129 Malik Ave  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 6 days ago
  • 4
    Beds
  • 2
    Total Baths
  • 1,691
    Sq. Ft.
Listed by Matel REALTORS
3711 Pomegranate Ave, Ceres, CA 95307 - Photo 1 Just Listed
$509,990
Open House

3711 Pomegranate Ave  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,629
    Sq. Ft.
Listed by HomeSmart PV & Associates
6819 Faith Home Rd, Ceres, CA 95307 - Photo 1 Just Listed
$1,195,000

6819 Faith Home Rd  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 1
    Total Bath
  • 1,550
    Sq. Ft.
Listed by JRP Realty Group

Price Reduced near 2404-2406 Counts Ct

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

Fowler, Ceres, CA 95307 - Photo 1 Price Reduced
-$10,100 (-7.21%)
$129,900

Fowler  #116  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,440
    Sq. Ft.
Listed by J.Peter Realtors
609 E Keyes Rd, Ceres, CA 95307 - Photo 1 Price Reduced
-$9,999 (-2.5%)
$390,000
Open House

609 E Keyes Rd  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 789
    Sq. Ft.
Listed by HomeSmart PV & Associates
1925 Central Park Way, Ceres, CA 95351 - Photo 1 Price Reduced
-$5,000 (-1.14%)
$434,950

1925 Central Park Way  Ceres, CA 95351

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,440
    Sq. Ft.
Listed by Weeks Real Estate
3627 Wild Oak Dr, Ceres, CA 95307 - Photo 1 Price Reduced
-$10,000 (-1.71%)
$575,000

3627 Wild Oak Dr  Ceres, CA 95307

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

Recent Sales near 2404-2406 Counts Ct

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

1819 Bradford Ct, Modesto, CA 95355 - Photo 1 Sold
$545,000

1819 Bradford Ct  Modesto, CA 95355

  • Single Family
  • Closed
  • Updated 7 days ago
  • 1,688
    Sq. Ft.
Listed by HomeSmart PV & Associates
Sold by Non-MLS Office
2401 Ellison Dr, Modesto, CA 95355 - Photo 1 Sold
$475,000

2401 Ellison Dr  Modesto, CA 95355

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,723
    Sq. Ft.
Listed by eXp Realty of California Inc.
Sold by RE/MAX Executive
2502 Rose Ave, Modesto, CA 95355 - Photo 1 Sold
$565,000

2502 Rose Ave  Modesto, CA 95355

  • Single Family
  • Closed
  • 1,876
    Sq. Ft.
Listed by Joslin Real Estate
Sold by Powerhouse Realty
1933 Lifetime Dr, Modesto, CA 95355 - Photo 1 Sold
$490,000

1933 Lifetime Dr  Modesto, CA 95355

  • Single Family
  • Closed
  • 3
    Beds
  • 2
    Total Baths
  • 1,386
    Sq. Ft.
Listed by J.Peter Realtors
Sold by Garin Real Estate and J.Peter Realtors

2404-2406 Counts Ct, Modesto, CA 95355 (MLS# 41139524) is a Duplex property with 0 bedrooms and 0 full bathrooms. 2404-2406 Counts Ct is currently listed for $519,000 and was received on June 24, 2026. Want to learn more about 2404-2406 Counts Ct? Do you have questions about finding other Duplex 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