Please provide the following information and Tricia Zarate will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.zarateproperties.com/agent/16765/tricia-zarate/property/link/crmls/MC25177548/7790-7810-Rose-Ave/Atwater/https://www.zarateproperties.com/images/props/crmls/full/MC25177548.jpgLondon Properties Atwater Real Estate | 7790 7810 Rose Ave
Listing Agent: Serina Vargas, Tinetti Realty Group
Incredible opportunity to own 5.35 acres spread across two separate parcels in a prime location. Whether you're seeking a serene horse ranch a multi generational family compound or a savvy investment with strong income potential this property offers flexibility to bring your vision to life. The property includes 2 homes the main House is a one bedroom one bath with a detached bedroom /utility room. The second home is a one bedroom one bath. Both homes are on one parcel. The property also offers a four horse stable a functioning outhouse and multiple storage buildings and a dedicated plot with its own irrigation system ideal for crops or pastures. Live, build and invest all in one property! Enjoy rural tranquility without sacrificing city access and take full advantage of the land's flexibility for agriculture, animals or generate income. Properties like this don't come around often. The possibilities are endless, Seller Financing available! Any and all pertinent details of property, should be verified with the appropriate county authorities for accuracy and compliance.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1952
Year Built Source
Public Records
Special Listing Conditions
Trust
Stories Total
1
Levels
One
Number Of Units Total
2
Entry Level
1
Entry Location
front
Price Per Square Foot
$923
Days On Market
33
Cumulative Days On Market
33
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
No
Directions
Bellevue to Rose Ave
Architectural Style
Ranch
Room Type
Kitchen, Living Room
Heating
None
Cooling
Wall/Window Unit(s)
Laundry Y/N
Yes
Laundry Features
Inside
Roof
Composition
Other Structures
Outbuilding, Shed(s), Storage
Main Level Bedrooms
1
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
1
Accessibility Features
None
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Utilities
Cable Available, Electricity Available, Propane
Water Source
Well
Sewer
Septic Type Unknown
Parking Y/N
Yes
Parking Features
Carport, Detached Carport
Lot Features
2-5 Units/Acre,Agricultural,Horse Property,Sprinkler System
Lot Size Area
5.3500
Lot Size Units
Acres
View Y/N
Yes
View
Pasture
Sprinklers Y/N
Yes
Fencing
Livestock
Common Interest
None
Parcel Number
056340009000
Additional Parcels Y/N
Yes
Additional Parcels Description
056340008
Zoning
A-1
Community Features
Rural
Senior Community Y/N
No
Association Y/N
No
High School District
Atwater
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
41
Tax Census Tract
7.02
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 617500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 682500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 454 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 954 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` = 1672903 OR `props-main`.`id` = 1678355 OR `props-main`.`id` = 1678365 OR `props-main`.`id` = 1673917 OR `props-main`.`id` = 1674850 OR `props-main`.`id` = 236633 OR `props-main`.`id` = 1682295 OR `props-main`.`id` = 1682552 OR `props-main`.`id` = 1682554 OR `props-main`.`id` = 1683889 OR `props-main`.`id` = 1659503 OR `props-main`.`id` = 1659457 OR `props-main`.`id` = 1674115 OR `props-main`.`id` = 1674068 OR `props-main`.`id` = 1679145 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1674113 OR `props-main`.`id` = 1674316 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 1683888 OR `props-main`.`id` = 1683921 OR `props-main`.`id` = 1681613 OR `props-main`.`id` = 1684357 OR `props-main`.`id` = 1681501 OR `props-main`.`id` = 1627752 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1676559 OR `props-main`.`id` = 1682532 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1650510 OR `props-main`.`id` = 1683145 OR `props-main`.`id` = 1682973 OR `props-main`.`id` = 1684591 OR `props-main`.`id` = 1684629 OR `props-main`.`id` = 1679979 OR `props-main`.`id` = 1679963 OR `props-main`.`id` = 1679970 OR `props-main`.`id` = 1683616 OR `props-main`.`id` = 1663964 OR `props-main`.`id` = 1663966 OR `props-main`.`id` = 1645529 OR `props-main`.`id` = 1622885 OR `props-main`.`id` = 1663976 OR `props-main`.`id` = 1683518 OR `props-main`.`id` = 1683549 OR `props-main`.`id` = 1683581 OR `props-main`.`id` = 1682782 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1668924 OR `props-main`.`id` = 1684367 OR `props-main`.`id` = 1683927)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25177548' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-09' 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();
0
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.