Off market jan 2025 for $400K

$478,962

•

1,564

sq ft

838 - 840 Herndon Rd, Modesto, CA 95351

About this home

Welcome to 838-840 Herndon Rd.. Located close to schools, parks, restaurants, shopping and public transportation, this duplex offers a great investment opportunity! Each side is 2 bedrooms, 1 bathroom, 782 square feet, with a 1 car garage, indoor laundry, and backyard. The 838 Herndon side was just completely remodeled! Remodeled items include: kitchen with all new cabinets and microwave, bathroom shower/tub are all new as well as the vanity/sink. The whole home has all new dual pane windows and a new slider! All new flooring, baseboard, doors, fixtures, light switches & outlets round out the remodel. This side is currently vacant and ready for a tenant or a buyer who is looking to move into one side! The 840 Herndon side has a long-term tenant in it. It is a mirror image of the other side. It also just received a new sliding glass door. Come and see this property before it's too late!

Multi-familyProperty Type

1973Year Built

5,998 sq ftLot Size

$306Est. Price/Sq.Ft.

1 garage spacesParking

Listed by Eric Hummel •DRE #01900317 • HomeSmart PV & Associates

Bought with Veronica Ramirez Alba •DRE #01939663 • HomeSmart PV and Associates

Redfin checked: 2 minutes ago

•Source:MetroList #224118951

Listing provided courtesy of Metrolist Services, Inc (Sacramento)

Redfin Estimate

$478,962

$79K since sold in January 2025$2,000 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 11.2% higher than the average sale price ($431K) of 6 comparable homes.

SOLD OCT 15, 2026
$415,000
A
3 beds2 baths1,558 sq ft
1620 Flower Garden Ct, Ceres, CA 95307
PMZ Real Estate
SOLD AUG 18, 2026
$462,000
B
4 beds2 baths1,614 sq ft
940 Allacante Dr, Ceres, CA 95307
E. Rainer Real Estate
SOLD JUL 21, 2026
$545,000
C
4 beds2 baths1,894 sq ft
1405 Marynell Dr, Ceres, CA 95307
HomeSmart PV & Associates, HomeSmart PV & Associates
SOLD JUN 24, 2026
$382,500
D
3 beds2 baths1,435 sq ft
2000 Don Pedro Rd, Ceres, CA 95307
Valley Heritage Realty, Valley Heritage Realty
SOLD MAR 13, 2026
$450,000
E
4 beds2 baths1,727 sq ft
1429 Don Pedro Rd, Ceres, CA 95307
Atlantic Realty
SOLD JUL 30, 2026
$330,000
F
4 beds2 baths1,502 sq ft
1299 Moonlight Dr, Ceres, CA 95307
Merced Homes Realty

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$139,385

Est. take-home

List your home with Redfin and save $4,790

Market trends in 95351, CA

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

97.8%

0.3% MoM

Median sale price

$350K

$31K MoM

Avg. days on market

35d

2 days MoM

Recently sold homes

4 MoM

New listings for sale

NEW 3 HRS AGO
$650,000
3 beds2 baths1,870 sq ft
628 California Ave, Modesto, CA 95351
NEW 7 HRS AGO
$899,000
4 beds3 baths2,472 sq ft
849 River Rd, Modesto, CA 95351
Century 21 Masters
$449,900
3 beds2 baths1,908 sq ft
133 Rosemont Ave, Modesto, CA 95351
$629,000
3 beds2 baths1,918 sq ft
1300 Fruitridge Dr, Modesto, CA 95351
PMZ Real Estate
OPEN SUN, 11AM TO 1PM
$443,000
3 beds2 baths1,240 sq ft
2025 Olive Branch Dr, Modesto, CA 95351
Lifestyle Realty
See all

Provided by Redfin

Sale history for 838 - 840 Herndon Rd

This is a new listing, so no sales records exist yet. As the MLS and public records start to fill up, we'll list the details here.

Public record

Public record
Permits

Beds

—

Baths

—

Stories

—

Lot width

—

Lot depth

—

Lot size

—

Year renovated

—

Sq. Ft.

—

Year built

—

Style

Multi-Family (2-4 Unit)

County

Stanislaus County

APN

039-035-007-000

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 23, 2024.

Property details

Parking

Parking & Garage Information
Parking Total: 2
Garage Spaces: 1
Parking Features: Off Street, Garage

Interior

Heating & Cooling
Cooling: Central
Heating: Central

Interior Features
Accessibility Features: None
Appliances: Microwave, Free Standing Electric Oven
Flooring: Laminate
Laundry Features: Washer/Dryer Hookups
Patio And Porch Features: Uncovered Patio
Window Features: Dual Pane Partial
Levels: One
# of Stories: 1
# of Stories (Total): 1

Room Information
Basement: None

Multi-Unit Information
# of Units (Total): 2

Unit 1
# of Bedrooms (Total): 2
# of Bathrooms (Full): 1

Unit 2
# of Bedrooms (Total): 2
# of Bathrooms (Full): 1

Exterior

Exterior Features
Roof: Flat

Property Information
Property Type: Residential Income
Property Sub Type: Duplex
Subtype Description: Apartments
Property Condition: Varies By Unit
Year Built: 1,973

Lot Information
Lot Features: Sidewalk
Lot Size Square Feet: 5,998
Lot Size Acres: 0.1377

Utilities

Utility Information
Electric: 220 Volts
Sewer: In & Connected
Irrigation Source: None
Water Source: Public

Location

HOA Information
Association YN: No

School Information
School District County: Stanislaus
Elementary School District: Modesto City
Middle Or Junior School District: Modesto City
High School District: Modesto City

Location Information
Postal Code Plus 4: 4213
Postal Code: 95351
County Or Parish: Stanislaus
CrossStreet: Pecos St.
Directions: From Highway 99 Exit Hatch Rd. East to Herndon Rd. North to Herndon and Pecos. No sign on the property.
State Or Province: CA
Street Number Numeric: 838
Unparsed Address: 838-840 Herndon Rd, Modesto, CA 95351-4213
Street Address Filtered: 838-840 Herndon Rd

Public facts

Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Multi-Family (2-4 Unit)
Year Built: —
Year Renovated: —
County: Stanislaus County
APN: 039-035-007-000

Home facts updated by county records on Oct 23, 2024

Other

Selling Agent
Buyer Agent Full Name: Veronica G Ramirez Alba

Around this home

Schools

K - 12
Preschool & daycare

Tuolumne Elementary School

Public K-8 • Assigned • 0.2mi

3/10

Peter Johansen High School

Public 9-12 • Assigned • 3.8mi

3/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

7/10 Heat Factor

7 days above 102° expected this year, 15 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

10/10 Air Factor

33 unhealthy days expected this year, 38 days in 30 years

Provided by First Street

Historical weather

Modesto, CA • 95351

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 13 hours in June and 4.5 hours in December, placing it above the U.S. average for solar exposure.

13 hrs

4.5 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$456,000 – $551,000

Reach more buyers when you sell with Redfin. Save up to $4,790 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$675,000

5 beds3.5 baths2,204 sq ft

358 S Third Ave, Oakdale, CA 95361

Two homes on one lot • Heart of oakdale • Near schools

Barrios Realty Consultants

$799,999

3 beds3 baths2,260 sq ft

917 9th St, Turlock, CA 95380

Over half an acre • Recent renovations • Vacant adu

Adroit Real Estate

$529,500

4 beds2 baths1,536 sq ft

2508 Carver Rd, Modesto, CA 95350

6,199 sq ft lot • 2 garage spots • Built 1968

Ralph Gresham Real Estate, Ralph Gresham Real Estate

$1,200,000

8 beds8 baths5,348 sq ft

203 Jones St, Modesto, CA 95354

Approved by city • 0.26 acre lot • 8 parking spots

$550,000

1 bed1 bath646 sq ft

148 Frances Ave, Modesto, CA 95354

Two homes on one lot • Indoor laundry • 9,052 sq ft lot

RE/MAX Executive, RE/MAX Executive

$479,999

4 beds2 baths1,450 sq ft

1232 Fresno St, Newman, CA 95360

Updated flooring • Quartz countertops • Updated cabinetry

Berkshire Hathaway HomeServices-Drysdale Properties, Berkshire Hathaway HomeServices-Drysdale Properties

New listings for sale in 95351

NEW 3 HRS AGO

$650,000

3 beds2 baths1,870 sq ft

628 California Ave, Modesto, CA 95351

Covered front porch • Wrought iron fence • Granite countertops

NEW 7 HRS AGO

$899,000

4 beds3 baths2,472 sq ft

849 River Rd, Modesto, CA 95351

Direct river access • Private setting • Majestic oak trees

Century 21 Masters

$449,900

3 beds2 baths1,908 sq ft

133 Rosemont Ave, Modesto, CA 95351

Expansive backyard • Investment property • Conveniently located

$629,000

3 beds2 baths1,918 sq ft

1300 Fruitridge Dr, Modesto, CA 95351

Gorgeous kitchen • Walk-in closet • Tandem garage

PMZ Real Estate

OPEN SUN, 11AM TO 1PM

$443,000

3 beds2 baths1,240 sq ft

2025 Olive Branch Dr, Modesto, CA 95351

Fully remodeled • Brand-new kitchen • Quartz countertops

Lifestyle Realty

Home values near 838 - 840 Herndon Rd

Data from public records.

Address	Redfin Estimate
834 Herndon Rd, Modesto, CA 4 Beds \| 2 Baths \| 1500 Sq. Ft.	$408,336
824 Herndon Rd, Modesto, CA 2 Beds \| 1 Baths \| 961 Sq. Ft.	$292,962
813 Herndon Rd, Modesto, CA 3 Beds \| 2 Baths \| 1120 Sq. Ft.	$374,639
825 Wesley Dr, Modesto, CA 4 Beds \| 2 Baths \| 1212 Sq. Ft.	$397,408
1311 Pecos Ave, Modesto, CA 4 Beds \| 2 Baths \| 1564 Sq. Ft.	$420,943
1300 Pecos Ave, Modesto, CA 4 Beds \| 2 Baths \| 1680 Sq. Ft.	$436,629
1225 Pecos Ave, Modesto, CA 4 Beds \| 2 Baths \| 1216 Sq. Ft.	$363,509

Address	Redfin Estimate
828 Herndon Rd, Modesto, CA 2 Beds \| 1 Baths \| 952 Sq. Ft.	$289,687
821 Herndon Rd, Modesto, CA 3 Beds \| 2 Baths \| 1120 Sq. Ft.	$387,990
820 Herndon Rd, Modesto, CA 4 Beds \| 2 Baths \| 1430 Sq. Ft.	$536,082
829 Wesley Dr, Modesto, CA 3 Beds \| 2 Baths \| 1014 Sq. Ft.	$342,067
1304 Pecos Ave, Modesto, CA - Beds \| - Baths \| 1680 Sq. Ft.	$468,934
1228 Valente Way, Modesto, CA 3 Beds \| 2 Baths \| 1216 Sq. Ft.	$279,440
1229 Pecos Ave, Modesto, CA 3 Beds \| 2 Baths \| 1120 Sq. Ft.	$352,198

Address	Redfin Estimate
832 Herndon Rd, Modesto, CA 2 Beds \| 1 Baths \| 952 Sq. Ft.	$310,893
817 Herndon Rd, Modesto, CA 3 Beds \| 2 Baths \| 1120 Sq. Ft.	$359,750
844 Herndon Rd Apt 846, Modesto, CA 4 Beds \| 2 Baths \| 1564 Sq. Ft.	$243,518
1300 Orlando Dr, Modesto, CA 3 Beds \| 2 Baths \| 1040 Sq. Ft.	$351,235
905 Mock Ave, Modesto, CA 3 Beds \| 2 Baths \| 1056 Sq. Ft.	$343,338
1220 Cavel Ct, Modesto, CA 3 Beds \| 2 Baths \| 1404 Sq. Ft.	$391,137
1221 Pecos Ave, Modesto, CA 3 Beds \| 2 Baths \| 1120 Sq. Ft.	$367,410

Property information provided by MetroList when last listed in 2024. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

95358 homes for sale
95307 homes for sale
95351 homes for sale
95354 homes for sale

Houses for rent in Ceres	Agents near me	Irvine, CA homes for sale	Ceres Housing Market
Houses for sale near me	San Diego, CA homes for sale	Fremont, CA homes for sale
Land for sale near me	San Francisco, CA homes for sale	Sacramento, CA homes for sale
Open Houses near me	Los Angeles, CA homes for sale	Ceres Property Records
Condos for sale near me	San Jose, CA homes for sale	CA New Listings

Modesto homes for sale
Turlock homes for sale
Manteca homes for sale