Please provide the following information and Tiffany Wilson will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.3brosmom-realestate.com/agent/16607/tiffany-wilson/property/link/metrolist/225120832/3888-W-Avenue-1/Atwater/https://www.3brosmom-realestate.com/images/props/metrolist/full/225120832.jpgLondon Properties Atwater Real Estate | 3888 W Avenue 1
Sprawling country property with ENDLESS POTENTIAL! Not to be missed this nearly 26 acre property offers income potential, horse property ready with 6 stall barn (3 stalls have outside runs), w/ metal roofing, tack room and wash racks. Irrigated field w/ crops (currently leased). Main home features separate living and family rooms, bonus room could be office, gym or game room. In-ground pool and spa w/ new sand filter & separate propane tank. Spacious covered patio. Main home needs some TLC but has giant potential. Separate mobile home on property is 3/2, partially re-roofed, newer water heater, needs some TLC as well. 4 pen dog kennel and more! Experience country living yet just minutes to HWY 99.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country
Year Built
1981
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Unknown
Stories
1
Pets Allowed
Yes
Home Warranty
No
Directions to Property
HWY 99 to Atwater-Merced Expressway to Green Sands to Gurr to Ave one.
Cross Street
Gurr
County
Merced
Special Listing Conditions
Offer As Is, Probate Listing
Main Level
Bedroom(s), Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen, Street Entrance
Construction Materials
Stucco, Wood
Foundation
Raised
Roof
Composition
Heating
Propane, Fireplace(s), Wood Stove
Cooling
Ceiling Fan(s), Central
Full Bathrooms
2
Bath Features
Shower Stall(s), Tub
Possible Bedrooms
4
# of Fireplaces
2
Fireplace Features
Living Room, Family Room, Wood Burning, Wood Stove
Flooring
Laminate, Tile, Vinyl
Appliances
Dishwasher, Microwave, Free Standing Electric Oven, Free Standing Electric Range
Room Type
Office, Dining Room, Family Room, Kitchen, Living Room
Kitchen Features
Stone Counter, Kitchen/Family Combo
Dining Room Features
Dining Bar, Dining/Family Combo
Living Room Features
Cathedral/Vaulted
Primary Bedroom Features
Closet
Primary Bathroom Features
Sunken Tub, Tile, Tub w/Shower Over
Patio And Porch Features
Covered Patio
Pool
No
Pool Features
Built-In, Fenced
Spa
No
ADU/2nd Unit
Yes
2nd Unit Type
Detached
2nd Unit Description
Modular Home
2nd Unit Bedrooms
3
2nd Unit Full Baths
2
2nd Unit Kitchen
Yes
2nd Unit Occupied
No
2nd Unit Private Entry
Yes
Utilities
Electric, Propane Tank Leased
Electric
220 Volts
Irrigation
Irrigation District
Water Source
Well
Sewer
Septic System
2nd Unit Approx SqFt
1100
2nd Unit SqFt Source
Not Verified
Parking Features
Attached, RV Access, RV Possible, RV Storage, Garage Facing Side
Garage Spaces
2.00
Lot Features
Manual Sprinkler F&R, Shape Regular
APN
005 130 034 000
Land Use
Agricultural
View Description
Pasture
Driveway/Sidewalks
Paved Sidewalk
Horse Property
Yes
Horse Property Features
1-6 Stalls,Tack Room,Wash Rack
Zoning Description
A1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Atwater Elementary
Middle or Junior School District
Atwater Elementary
Senior High School District
Merced Union High
Census Tract
9.04
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 902500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 997500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2925 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3425 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` = 1646767 OR `props-main`.`id` = 1682283 OR `props-main`.`id` = 1687943 OR `props-main`.`id` = 1687870 OR `props-main`.`id` = 1688917 OR `props-main`.`id` = 1688921 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1687150 OR `props-main`.`id` = 1654918 OR `props-main`.`id` = 1687171 OR `props-main`.`id` = 1676251 OR `props-main`.`id` = 1689687 OR `props-main`.`id` = 1687278 OR `props-main`.`id` = 1687269 OR `props-main`.`id` = 1677931 OR `props-main`.`id` = 1683767 OR `props-main`.`id` = 1684475 OR `props-main`.`id` = 1684473 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1688404 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687248 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1687267 OR `props-main`.`id` = 1680386 OR `props-main`.`id` = 1680392 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1686457 OR `props-main`.`id` = 1686562 OR `props-main`.`id` = 1679715 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1688612 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 1682226 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1689533 OR `props-main`.`id` = 1682874 OR `props-main`.`id` = 1679233 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1684138 OR `props-main`.`id` = 1673216 OR `props-main`.`id` = 1673221 OR `props-main`.`id` = 1686760 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1689674 OR `props-main`.`id` = 1689667 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1683304 OR `props-main`.`id` = 1687151 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 1667834 OR `props-main`.`id` = 1677069)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225120832' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-12' 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
Courtesy of Brandon Joaquin, RE/MAX Executive IDX provided by Reliance Marketing
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.
