Listing Agent: John Ballard, ELM Realty and Property Mgmt. Inc.
HOME IS BUILT ON CUL DE SAC, GREAT FOR KIDS. THIS HOME HAS A LARGE BACKYARD, SCREENED IN PATIO, ABOVE GROUND POOL, RV ACCESS, AND VERY CLOSE TO SCHOOL, CHURCH AND SHOPPING.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1976
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
GROUND
Price Per Square Foot
$277
Days On London
20
Cumulative Days On London
20
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
FAY TO ANGELUS
Room Type
All Bedrooms Down
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Main Level Bedrooms
3
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
2
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Pool Features
Private, Above Ground
Pool Private Y/N
Yes
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
0-1 Unit/Acre
Lot Size Area
12070.0000
Lot Size Units
Square Feet
View Y/N
No
View
None
Common Interest
None
Parcel Number
001180017000
Additional Parcels Y/N
No
Community Features
Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Merced Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
13
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 422750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 467250 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) >= 1359 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1859 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` = 1727719 OR `props-main`.`id` = 1720310 OR `props-main`.`id` = 1737752 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1723863 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 1723150 OR `props-main`.`id` = 1717926 OR `props-main`.`id` = 1723060 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1731188 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 1723302 OR `props-main`.`id` = 1721065 OR `props-main`.`id` = 1723280 OR `props-main`.`id` = 1726742 OR `props-main`.`id` = 1713318 OR `props-main`.`id` = 1713316 OR `props-main`.`id` = 1713327 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1726641 OR `props-main`.`id` = 1727618 OR `props-main`.`id` = 1723294 OR `props-main`.`id` = 1724484 OR `props-main`.`id` = 1724483 OR `props-main`.`id` = 1723293 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1731003 OR `props-main`.`id` = 1736161 OR `props-main`.`id` = 1723297 OR `props-main`.`id` = 1732522 OR `props-main`.`id` = 1726751 OR `props-main`.`id` = 1736031 OR `props-main`.`id` = 1715714 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1734911 OR `props-main`.`id` = 1737000 OR `props-main`.`id` = 1727284 OR `props-main`.`id` = 1725386 OR `props-main`.`id` = 1723279 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1732272 OR `props-main`.`id` = 1732285 OR `props-main`.`id` = 1725250 OR `props-main`.`id` = 1724879 OR `props-main`.`id` = 1727965 OR `props-main`.`id` = 1737493 OR `props-main`.`id` = 1727164 OR `props-main`.`id` = 1727181 OR `props-main`.`id` = 1723056 OR `props-main`.`id` = 1723051 OR `props-main`.`id` = 1723046 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1726183 OR `props-main`.`id` = 1738012 OR `props-main`.`id` = 1734786 OR `props-main`.`id` = 1732098 OR `props-main`.`id` = 1728911 OR `props-main`.`id` = 1732524 OR `props-main`.`id` = 1724453 OR `props-main`.`id` = 1732735 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1734262 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1714397 OR `props-main`.`id` = 1731191 OR `props-main`.`id` = 1731165 OR `props-main`.`id` = 1731179 OR `props-main`.`id` = 1726708 OR `props-main`.`id` = 1737256 OR `props-main`.`id` = 1736193 OR `props-main`.`id` = 1734541 OR `props-main`.`id` = 1737170 OR `props-main`.`id` = 1726817 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1732022 OR `props-main`.`id` = 1731998 OR `props-main`.`id` = 1732027 OR `props-main`.`id` = 1708105 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 1733376 OR `props-main`.`id` = 1721198 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 1717457 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 1720828 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1707011 OR `props-main`.`id` = 1716394 OR `props-main`.`id` = 1694847 OR `props-main`.`id` = 1732939 OR `props-main`.`id` = 1731156 OR `props-main`.`id` = 1696793 OR `props-main`.`id` = 1737048 OR `props-main`.`id` = 1737199 OR `props-main`.`id` = 1718564 OR `props-main`.`id` = 1718572 OR `props-main`.`id` = 1733585 OR `props-main`.`id` = 1735912 OR `props-main`.`id` = 1718575 OR `props-main`.`id` = 1725512 OR `props-main`.`id` = 1737828 OR `props-main`.`id` = 1711370)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26114023' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-15' 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();
7
Similar Properties
$449,000
3
2
1,729
0.16
380 Tammy Dr
Atwater, CA 95301
$448,000
4
2
1,548
0.19
3330 Virginia St
Atwater, CA 95301
$425,000
3
2
1,712
0.19
2390 Fruitland Ave
Atwater, CA 95301
$425,000
3
2
1,564
0.14
1813 Redwood
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.
