Opportunity to remodel on this water-adjacent home as well as the nearby vacant lots! Other Lots 241-250-19/18/16 for sale right next to this home as well. Large compound? Also right down the road 856 E. Willow - ALL priced to sell - this parcel offers the setting ideal to fix-flip or keep home as investment property due to the property's proximity to water. Buyer to independently verify all flood zone designations and building restrictions with the applicable city/county planning and building departments prior to close of escrow.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Attached
Property Condition
Fixer
Year Built
1961
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
2
Home Warranty
No
Directions to Property
Woodward to Williamson
Cross Street
Woodward
County
San Joaquin
Special Listing Conditions
Trust
Main Level
Street Entrance
Construction Materials
Frame, Wood
Foundation
Combination, Other, Slab
Roof
Composition
Heating
See Remarks, Other
Cooling
See Remarks, Other
Laundry Features
Other
Full Bathrooms
1
Bath Features
Other
Flooring
See Remarks, Other
Kitchen Features
Other Counter
Dining Room Features
Other
Living Room Features
Other
Family Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
See Remarks, Other
Electric
See Remarks, Other
Irrigation
Other
Water Source
Other, See Remarks
Sewer
See Remarks, Other
Parking Features
RV Possible
Garage Spaces
2.00
Lot Features
See Remarks, Other
APN
241 250 17
Horse Property
No
Zoning Description
AG40
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
San Joaquin
Elementary School District
Manteca Unified
Middle or Junior School District
Manteca Unified
Senior High School District
Manteca Unified
Census Tract
51.22
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 275452.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 304447.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 770 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1270 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` = 1722104 OR `props-main`.`id` = 1764343 OR `props-main`.`id` = 1764303 OR `props-main`.`id` = 1764299 OR `props-main`.`id` = 1750324 OR `props-main`.`id` = 1764341 OR `props-main`.`id` = 1750325 OR `props-main`.`id` = 1759480 OR `props-main`.`id` = 1722188 OR `props-main`.`id` = 1761993 OR `props-main`.`id` = 1759478 OR `props-main`.`id` = 1746317 OR `props-main`.`id` = 1739110 OR `props-main`.`id` = 1764252 OR `props-main`.`id` = 1764342 OR `props-main`.`id` = 1754568 OR `props-main`.`id` = 1754459 OR `props-main`.`id` = 1743928 OR `props-main`.`id` = 1737013 OR `props-main`.`id` = 1763562 OR `props-main`.`id` = 1763299 OR `props-main`.`id` = 1730034 OR `props-main`.`id` = 1741804 OR `props-main`.`id` = 1754866 OR `props-main`.`id` = 1709829 OR `props-main`.`id` = 1764127 OR `props-main`.`id` = 1762131 OR `props-main`.`id` = 1752561 OR `props-main`.`id` = 1761714 OR `props-main`.`id` = 1731268 OR `props-main`.`id` = 1758785 OR `props-main`.`id` = 1760661 OR `props-main`.`id` = 1748462 OR `props-main`.`id` = 1764233 OR `props-main`.`id` = 1762412 OR `props-main`.`id` = 1744811 OR `props-main`.`id` = 1728074 OR `props-main`.`id` = 1743917 OR `props-main`.`id` = 1750950 OR `props-main`.`id` = 1762205 OR `props-main`.`id` = 1755104 OR `props-main`.`id` = 1724763 OR `props-main`.`id` = 1716386 OR `props-main`.`id` = 1747730 OR `props-main`.`id` = 1752872)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226104931' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-19' 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 Ryan Sherman, Sherman & Associates RE 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.
