Investor special on a corner lot in the heart of Hughson! Prime opportunity for cash buyers, contractors, and flippers looking for their next project. Centrally located near schools, shopping, restaurants, and downtownstrong location with excellent upside potential. This fixer-upper is a true value-add opportunity and ready for renovation. Ideal for investors, builders, or anyone looking to create equity through improvements. Property offers a blank canvas to renovate, redesign, or rebuild to maximize returns. Being sold as-is. Cash offers preferred. Don't miss this contractor special with endless potential in an established neighborhood.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1930
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Levels
One
Home Warranty
No
Directions to Property
From Fox Rd turn south, corner of Locust and 5th, from Hughson Ave turn norht, corner of Locust and 5th
Cross Street
Locust
County
Stanislaus
Special Listing Conditions
Offer As Is
Main Level
Bedroom(s), Kitchen
Construction Materials
Brick, Wood
Foundation
Raised
Roof
Composition
Heating
Fireplace(s), Other
Cooling
Ceiling Fan(s), Window Unit(s)
Laundry Features
Inside Area
Property Faces
East
Other Structures
Other
Full Bathrooms
1
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Other
Flooring
Carpet, Linoleum
Appliances
Microwave, Free Standing Electric Oven, Other
Kitchen Features
Other Counter
Dining Room Features
Other
Living Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
Other
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Other
Lot Features
Corner
APN
018 035 033 000
Fencing
Wood
Horse Property
No
Zoning Description
SFR
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Hughson Union
Middle or Junior School District
Hughson Union
Senior High School District
Hughson Union
Census Tract
29.03
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 177650 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 196350 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) >= 518 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1018 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` = 1695940 OR `props-main`.`id` = 1713545 OR `props-main`.`id` = 1714811 OR `props-main`.`id` = 1721766 OR `props-main`.`id` = 1721385 OR `props-main`.`id` = 1709990 OR `props-main`.`id` = 1717201 OR `props-main`.`id` = 1695536 OR `props-main`.`id` = 1715498 OR `props-main`.`id` = 1718009 OR `props-main`.`id` = 1719494 OR `props-main`.`id` = 1709176 OR `props-main`.`id` = 1697906 OR `props-main`.`id` = 1721789 OR `props-main`.`id` = 1704432 OR `props-main`.`id` = 1718196 OR `props-main`.`id` = 1713417 OR `props-main`.`id` = 1707873 OR `props-main`.`id` = 1713006 OR `props-main`.`id` = 1718007 OR `props-main`.`id` = 1712462 OR `props-main`.`id` = 1703146 OR `props-main`.`id` = 1714636)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226045589' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-14' 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 Robin Sexton, Keller Williams Property Team Turlock 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.
