Attention Investors 3/2 in Atwater with Pool--Priced Right and Ready for upgrades. Pictures speak for themselves. Bring all offers. NO FHA, NO Conventional-CASH/Hard Money Only-Investor Special/Rental/Flip/Handyman Sq Ft may be more than Tax records.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1991
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$174
Price Per Acre
$1,093,035
Days On London
0
Cumulative Days On London
0
County
Merced
REO / Bank Owned
No
Cross Street Address
5th
Directions
Take 5th N to Tamarack-L on Tamarack property is on your right
Heating & Cooling
Evaporative Cool
Laundry
In Garage
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Lower
# of Fireplaces
1
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
022 041 003 000
School District
Atwater
School Type 1
High School
School Name 1
Buhach Colony
School Type 2
Junior High School
School Name 2
Mitchell SR
School Type 3
Grade School
School Name 3
Thomas Olaetan
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 204250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 225750 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) >= 983 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1483 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` = 1728853 OR `props-main`.`id` = 1725506 OR `props-main`.`id` = 1741038 OR `props-main`.`id` = 1707991 OR `props-main`.`id` = 1727532 OR `props-main`.`id` = 1752570 OR `props-main`.`id` = 1752837 OR `props-main`.`id` = 1750509 OR `props-main`.`id` = 1752329 OR `props-main`.`id` = 1752269 OR `props-main`.`id` = 1752274 OR `props-main`.`id` = 1752394 OR `props-main`.`id` = 1683262 OR `props-main`.`id` = 1739798 OR `props-main`.`id` = 1622858 OR `props-main`.`id` = 1744909 OR `props-main`.`id` = 1726330 OR `props-main`.`id` = 1707898 OR `props-main`.`id` = 1707910 OR `props-main`.`id` = 1750550 OR `props-main`.`id` = 1753065 OR `props-main`.`id` = 1638025 OR `props-main`.`id` = 1750350 OR `props-main`.`id` = 1726780 OR `props-main`.`id` = 1723792 OR `props-main`.`id` = 1734140 OR `props-main`.`id` = 1720332 OR `props-main`.`id` = 1718094 OR `props-main`.`id` = 1725956 OR `props-main`.`id` = 1750534 OR `props-main`.`id` = 1742161 OR `props-main`.`id` = 1716602 OR `props-main`.`id` = 1738224 OR `props-main`.`id` = 1725213 OR `props-main`.`id` = 1737266 OR `props-main`.`id` = 1728931 OR `props-main`.`id` = 1728942 OR `props-main`.`id` = 1750391 OR `props-main`.`id` = 1677807 OR `props-main`.`id` = 1742342 OR `props-main`.`id` = 1746693 OR `props-main`.`id` = 1746737 OR `props-main`.`id` = 1748029)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652465' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-23' 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
Last modified 2 hours ago Fresno MLS last checked for updates 6 minutes ago
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.
