Bring your vision for this vintage beauty. Home offers endless potential. Located on a massive lot with a detached two car garage. Arched ceilings and built in cabinets. Old sewer line and water hook ups in garage offer even more potential. With a little love and attention she will sing again!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1947
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
Miller Ave West to North on Ferguson.
Cross Street
Miller Ave
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Street Entrance
Construction Materials
Stucco, Frame
Foundation
Raised
Roof
Shingle, Composition
Heating
Central
Cooling
Central
Laundry Features
Inside Room
Full Bathrooms
1
Bath Features
Tub w/Shower Over
Flooring
Linoleum, Wood
Kitchen Features
Laminate Counter
Dining Room Features
Other
Living Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Sewer Connected
Electric
220 Volts in Laundry
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
RV Possible, Detached
Garage Spaces
2.00
Lot Features
Shape Regular
APN
116 004 025 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
19.00
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 308750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 341250 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) >= 707 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1207 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` = 1723693 OR `props-main`.`id` = 1722049 OR `props-main`.`id` = 1716590 OR `props-main`.`id` = 1716375 OR `props-main`.`id` = 1711332 OR `props-main`.`id` = 1714350 OR `props-main`.`id` = 1699060 OR `props-main`.`id` = 1723143 OR `props-main`.`id` = 1721110 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1704117 OR `props-main`.`id` = 1725979 OR `props-main`.`id` = 1718874 OR `props-main`.`id` = 1725711 OR `props-main`.`id` = 1715825 OR `props-main`.`id` = 1720669 OR `props-main`.`id` = 1717586 OR `props-main`.`id` = 1714442 OR `props-main`.`id` = 1714507 OR `props-main`.`id` = 1720268 OR `props-main`.`id` = 1725735 OR `props-main`.`id` = 1725725 OR `props-main`.`id` = 1714305 OR `props-main`.`id` = 1723275 OR `props-main`.`id` = 1722016 OR `props-main`.`id` = 1722023 OR `props-main`.`id` = 1717281 OR `props-main`.`id` = 1725611 OR `props-main`.`id` = 1725294 OR `props-main`.`id` = 1726102 OR `props-main`.`id` = 1681376 OR `props-main`.`id` = 1714322 OR `props-main`.`id` = 1721700 OR `props-main`.`id` = 1724142 OR `props-main`.`id` = 1724822 OR `props-main`.`id` = 1723662 OR `props-main`.`id` = 1726265 OR `props-main`.`id` = 1722224 OR `props-main`.`id` = 1713155 OR `props-main`.`id` = 1725389 OR `props-main`.`id` = 1709971 OR `props-main`.`id` = 1721078 OR `props-main`.`id` = 1722030 OR `props-main`.`id` = 1725976 OR `props-main`.`id` = 1725955 OR `props-main`.`id` = 1714764 OR `props-main`.`id` = 1718929 OR `props-main`.`id` = 1725322 OR `props-main`.`id` = 1720697 OR `props-main`.`id` = 1725439 OR `props-main`.`id` = 1719395 OR `props-main`.`id` = 1724872 OR `props-main`.`id` = 1725741 OR `props-main`.`id` = 1724355 OR `props-main`.`id` = 1725715 OR `props-main`.`id` = 1722882 OR `props-main`.`id` = 1724679 OR `props-main`.`id` = 1721924 OR `props-main`.`id` = 1723551 OR `props-main`.`id` = 1725708 OR `props-main`.`id` = 1698031 OR `props-main`.`id` = 1721904 OR `props-main`.`id` = 1723228 OR `props-main`.`id` = 1721817 OR `props-main`.`id` = 1725704 OR `props-main`.`id` = 1722611 OR `props-main`.`id` = 1722133 OR `props-main`.`id` = 1724813 OR `props-main`.`id` = 1721157 OR `props-main`.`id` = 1725395 OR `props-main`.`id` = 1725523 OR `props-main`.`id` = 1720304 OR `props-main`.`id` = 1725325 OR `props-main`.`id` = 1723565 OR `props-main`.`id` = 1723651 OR `props-main`.`id` = 1680147 OR `props-main`.`id` = 1713035 OR `props-main`.`id` = 1714720 OR `props-main`.`id` = 1723305 OR `props-main`.`id` = 1714510 OR `props-main`.`id` = 1725510 OR `props-main`.`id` = 1703336 OR `props-main`.`id` = 1721848 OR `props-main`.`id` = 1723779 OR `props-main`.`id` = 1712373)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226059042' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-10' 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();
1
Similar Properties
$340,000
2
1
1,149
0.18
109 Calaveras
Modesto, CA 95354
Courtesy of Dena Moore, Fathom Realty Group, Inc. 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.
