Opportunity awaits with this 3-bedroom, 2-bath HUD home offering approximately 1,252 square feet of potential. Featuring a functional floor plan, spacious living areas, and a generous lot, this property provides a great foundation for buyers ready to make it their own. With the right vision, this home offers the chance to personalize and enhance to fit your style and needs. FHA 203(k) financing may be an excellent option for buyers looking to finance eligible improvements and updates into one convenient loan. HUD may also contribute up to 3% toward buyer's closing costs when negotiated in the purchase contract. A valuable opportunity for owner-occupants or buyers seeking affordability, flexibility, and future potential. Don't miss the chance to explore the possibilities this property has to offer.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1966
Year Built Source
Appraiser
Remodeled/Updated
No
Stories
1
Levels
One
Home Warranty
No
Directions to Property
Kansas to Emerald to ELm turn right then right on Custer.
Cross Street
Elm
County
Stanislaus
Special Listing Conditions
HUD Owned
Main Level
Bedroom(s), Family Room, Full Bath(s), Kitchen
Architectural Style
Other
Construction Materials
Other
Foundation
Other
Roof
Other
Heating
Other
Cooling
Ceiling Fan(s), None
Laundry Features
In Garage
Full Bathrooms
2
Bath Features
Tub
# of Fireplaces
1
Fireplace Features
Family Room
Flooring
Carpet, Concrete, Tile, Other
Appliances
Hood Over Range
Kitchen Features
Laminate 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
Attached, Garage Facing Side
Garage Spaces
2.00
Lot Features
Other
APN
029 035 024 000
Horse Property
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Modesto City
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
Census Tract
15.00
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 180500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 199500 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) >= 1002 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1502 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` = 1705396 OR `props-main`.`id` = 1722094 OR `props-main`.`id` = 1715604 OR `props-main`.`id` = 1722048 OR `props-main`.`id` = 1720400 OR `props-main`.`id` = 1722854 OR `props-main`.`id` = 1724277 OR `props-main`.`id` = 1722392 OR `props-main`.`id` = 1718874 OR `props-main`.`id` = 1709553 OR `props-main`.`id` = 1715937 OR `props-main`.`id` = 1724943 OR `props-main`.`id` = 1718915 OR `props-main`.`id` = 1722899 OR `props-main`.`id` = 1714442 OR `props-main`.`id` = 1714507 OR `props-main`.`id` = 1720687 OR `props-main`.`id` = 1721598 OR `props-main`.`id` = 1720268 OR `props-main`.`id` = 1724251 OR `props-main`.`id` = 1724242 OR `props-main`.`id` = 1714305 OR `props-main`.`id` = 1723275 OR `props-main`.`id` = 1722016 OR `props-main`.`id` = 1724689 OR `props-main`.`id` = 1724254 OR `props-main`.`id` = 1723705 OR `props-main`.`id` = 1721292 OR `props-main`.`id` = 1713155 OR `props-main`.`id` = 1722686 OR `props-main`.`id` = 1714764 OR `props-main`.`id` = 1722687 OR `props-main`.`id` = 1722688 OR `props-main`.`id` = 1718216 OR `props-main`.`id` = 1714262 OR `props-main`.`id` = 1714263 OR `props-main`.`id` = 1714264 OR `props-main`.`id` = 1714372 OR `props-main`.`id` = 1724355 OR `props-main`.`id` = 1723216 OR `props-main`.`id` = 1724942 OR `props-main`.`id` = 1721058 OR `props-main`.`id` = 1712484 OR `props-main`.`id` = 1724319 OR `props-main`.`id` = 1712761 OR `props-main`.`id` = 1723038 OR `props-main`.`id` = 1703306 OR `props-main`.`id` = 1724679 OR `props-main`.`id` = 1723551 OR `props-main`.`id` = 1724222 OR `props-main`.`id` = 1723999 OR `props-main`.`id` = 1722033 OR `props-main`.`id` = 1711111 OR `props-main`.`id` = 1720711 OR `props-main`.`id` = 1717837 OR `props-main`.`id` = 1724217 OR `props-main`.`id` = 1724505 OR `props-main`.`id` = 1720304 OR `props-main`.`id` = 1722989 OR `props-main`.`id` = 1710068 OR `props-main`.`id` = 1717982 OR `props-main`.`id` = 1715582 OR `props-main`.`id` = 1721404 OR `props-main`.`id` = 1723007 OR `props-main`.`id` = 1714720 OR `props-main`.`id` = 1719435 OR `props-main`.`id` = 1723505 OR `props-main`.`id` = 1723305 OR `props-main`.`id` = 1720456 OR `props-main`.`id` = 1724353 OR `props-main`.`id` = 1723991 OR `props-main`.`id` = 1705434 OR `props-main`.`id` = 1724219 OR `props-main`.`id` = 1702533 OR `props-main`.`id` = 1723554 OR `props-main`.`id` = 1722670 OR `props-main`.`id` = 1722317 OR `props-main`.`id` = 1720637 OR `props-main`.`id` = 1723223 OR `props-main`.`id` = 1723417 OR `props-main`.`id` = 1724184 OR `props-main`.`id` = 1725073 OR `props-main`.`id` = 1725005)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226055725' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-03' 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 Robyn Brown, Dream Chasers Realty 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.
