London Properties Atwater Real Estate

2788 Herrod

Atwater, CA 95301

Copy Link Get Directions

Photo Gallery

$895,000

3 bd

2 ba

2,394 sq ft

1.10 acres

2788 Herrod

Atwater, CA 95301

Get Directions

Listed On: 08/27/2026

Status: Active

Listing Number: MC26187407 (CRMLS)

Schedule a Tour

Contact Info

Advertising Agent:

London Properties, Ltd. 209.358.0222 Email Agent

Property Description

Listing Agent: Terry Priest, Roberta Flanagan Realtor, Inc
Listing Co-Agent: Pegeen Flanagan Priest, Roberta Flanagan Realtor, Inc

Hard to find home on 1.1 acre, on the corner of Orchid and Herrod, This HOME sports 5 Bedrooms, 3 Bath 3,657 sq ft, sets on just over 1 acre in the McSwain area. Home is ideal for extended family; north end of home has a 3/4 kitchen. FYI, current appraisal (6/13/2026) for the asking price. 2 fireplaces, wood and tile flooring, Very stunning in ground fiberglass swimming pool, security fencing, and rock waterfall. Lots of Cool decking, Screened in patio,plus a delightful lattice roofed patio. The Roof was replaced in 2015. Also, approx 2015 Solar & 2022 increased Solar was installed, solar is Owner Owned. The domestic well replaced in 2006, new pump in approx 2016. Kitchen has top of the line oven, numerous fixtures / Capabilities. Large eating bar and very spacious dining room/area. Water softener that is owned. Garage has 2 pull down storage areas in the ceiling, Auto door opener with roll up door. Septic was pumped in December 2025. Circle driveway with TONS of concrete/parking, large section of the property on the north side contain solar panels, was once used for 4'H animals. PG&E supplied natural gas. Home has two HVAC systems. Please be property has ring camara's.

Property Sub Type

Single Family Residence

Structure Type

House

Year Built

1987

Year Built Source

Assessor

Special Listing Conditions

Standard

Stories Total

Levels

One

Number Of Units Total

Entry Level

Price Per Square Foot

$374

Days On London

Cumulative Days On London

County Or Parish

Merced

New Construction Y/N

Property Attached Y/N

Cooling Y/N

Yes

Heating Y/N

Yes

Directions

Mulberry to Herrod

Disclosures

CC And R's

Architectural Style

Ranch

Room Type

All Bedrooms Down

Heating

Central

Cooling

Central Air

Laundry Y/N

Yes

Laundry Features

Inside

Roof

Composition

Construction Materials

Unknown

Main Level Bedrooms

Bathrooms Full

Bathrooms Full And Three Quarter

Main Level Bathrooms

Eating Area

Breakfast Counter / Bar, Dining Room, Area

Appliances Y/N

Yes

Appliances

Gas Cooktop, Water Heater, Disposal, Microwave, Gas Range, Dishwasher

Interior Features

Ceramic Counters, High Ceilings, Ceiling Fan(s), Pantry, Tile Counters, Cathedral Ceiling(s)

Flooring

Tile, Wood

Common Walls

No Common Walls

Fireplace Y/N

Yes

Fireplace Features

See Remarks, Family Room

Pool Features

Waterfall, Private, Fiberglass

Pool Private Y/N

Yes

Spa Y/N

Spa Features

None

Patio Y/N

Yes

Patio And Porch Features

Wood, Screened, See Remarks

Electric

Photovoltaics Seller Owned, 220 Volts in Garage, 220 Volts in Kitchen, 220 Volts in Laundry

Utilities

Natural Gas Connected, See Remarks

Water Source

Well

Sewer

Septic Type Unknown

Parking Total

2.00

Attached Garage Y/N

Yes

Garage Spaces

2.00

Lot Features

Corner Lot, Rectangular Lot, Front Yard, Horse Property, Sprinkler System

Lot Size Area

47916.0000

Lot Size Units

Square Feet

View Y/N

Yes

View

Neighborhood

Sprinklers Y/N

Yes

Common Interest

None

Parcel Number

207090028000

Additional Parcels Y/N

Community Features

Rural

Senior Community Y/N

Association Y/N

High School District

Atwater

Lease Considered Y/N

Land Lease Y/N

Assessments

Unknown

Tax Lot

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 850250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 939750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2144 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2644 AND ((`props-main`.`PropertyType` = 'Residential' AND ( `props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR `props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR `props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR `props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR `props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR `props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR `props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1766612 OR `props-main`.`id` = 274199 OR `props-main`.`id` = 1691442 OR `props-main`.`id` = 1766189 OR `props-main`.`id` = 1750431 OR `props-main`.`id` = 1722925 OR `props-main`.`id` = 1750429 OR `props-main`.`id` = 1691448 OR `props-main`.`id` = 1722924 OR `props-main`.`id` = 1766080 OR `props-main`.`id` = 1691443 OR `props-main`.`id` = 1722926 OR `props-main`.`id` = 1750430 OR `props-main`.`id` = 221849 OR `props-main`.`id` = 1767118 OR `props-main`.`id` = 1767140 OR `props-main`.`id` = 1702364 OR `props-main`.`id` = 144493 OR `props-main`.`id` = 236633 OR `props-main`.`id` = 1749484 OR `props-main`.`id` = 1752838 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1702939 OR `props-main`.`id` = 1702920 OR `props-main`.`id` = 1750486 OR `props-main`.`id` = 1730748 OR `props-main`.`id` = 1730840 OR `props-main`.`id` = 1727530 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 1768525 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1749152 OR `props-main`.`id` = 1754407 OR `props-main`.`id` = 1727719 OR `props-main`.`id` = 1728599 OR `props-main`.`id` = 1720310 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1723863 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 1723150 OR `props-main`.`id` = 1717926 OR `props-main`.`id` = 1740557 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1754746 OR `props-main`.`id` = 1755088 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1723302 OR `props-main`.`id` = 1757399 OR `props-main`.`id` = 1723280 OR `props-main`.`id` = 1767661 OR `props-main`.`id` = 1761743 OR `props-main`.`id` = 1767550 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1753457 OR `props-main`.`id` = 1760406 OR `props-main`.`id` = 1723294 OR `props-main`.`id` = 1757408 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 1723293 OR `props-main`.`id` = 1743898 OR `props-main`.`id` = 1742833 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1752153 OR `props-main`.`id` = 1744330 OR `props-main`.`id` = 1723297 OR `props-main`.`id` = 1740956 OR `props-main`.`id` = 1763777 OR `props-main`.`id` = 1766009 OR `props-main`.`id` = 1766028 OR `props-main`.`id` = 1766036 OR `props-main`.`id` = 1761954 OR `props-main`.`id` = 1727284 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1766829 OR `props-main`.`id` = 1766851 OR `props-main`.`id` = 1766891 OR `props-main`.`id` = 1725250 OR `props-main`.`id` = 1724879 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1726183 OR `props-main`.`id` = 1763877)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26187407' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-27' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();

Similar Properties

$905,000

4
3
2,313
1.02

1060 Stratford Ave

Atwater, CA 95301

The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

2788 Herrod

Atwater, CA 95301

Photo Gallery

$895,000

2788 Herrod

Atwater, CA 95301

Schedule a Tour

Contact Info

Advertising Agent:

Similar Properties

$905,000

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

2788 Herrod

Atwater, CA 95301

Photo Gallery

$895,000

2788 Herrod

Atwater, CA 95301

Schedule a Tour

Contact Info

Advertising Agent:

Similar Properties

$905,000

Loading...

Saving...

Deleting...

Searching...