WELCOME TO 1547 MADDUX AVE, THIS 3 BED, 1 BATH move in ready home, perfect for the first time buyer. Kitchen features corian counter tops and new diswasher. Newer vanity in bath, dual pane windows, and nice brick fireplace for cozy evenings. This home is situated on a 8000 sq ft lot including RV parking, alley access and low mainantence yard. Two storage sheds, ADU possible! (buyer to verify with county/city) Near shopping, MJC west campus and minutes from HWY 99 for commuters.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1955
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Kitchen 6-10YR
Stories
1
Home Warranty
No
Directions to Property
CARPENTER TO WEST ON BLUEGUM, SOUTH ON PRICHARD, WEST ON PARR TO MADDUX
Cross Street
Parr
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Primary Bedroom, Garage, Kitchen, Street Entrance
Architectural Style
Ranch
Construction Materials
Brick, Stucco
Foundation
Slab
Roof
Composition
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central
Laundry Features
In Garage
Window Features
Dual Pane Full
Full Bathrooms
1
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Brick, Living Room
Flooring
Carpet, Laminate
Appliances
Dishwasher, Disposal
Kitchen Features
Synthetic Counter
Dining Room Features
Dining/Living Combo
Living Room Features
Great Room
Patio And Porch Features
Uncovered Patio
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
See Remarks
Electric
220 Volts in Laundry
Irrigation
None
Water Source
Public
Sewer
Septic System
Parking Features
Attached, RV Access, Garage Door Opener, Garage Facing Side
Garage Spaces
2.00
Lot Features
Auto Sprinkler F&R, Low Maintenance
APN
081 022 034 000
Horse Property
No
Zoning Description
R-1
Subdivision
LEO C HAMMETT
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
6.02
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 351500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 388500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 790 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1290 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` = 1738013 OR `props-main`.`id` = 1742377 OR `props-main`.`id` = 1718216 OR `props-main`.`id` = 1714372 OR `props-main`.`id` = 1741452 OR `props-main`.`id` = 1727978 OR `props-main`.`id` = 1721058 OR `props-main`.`id` = 1712761 OR `props-main`.`id` = 1723038 OR `props-main`.`id` = 1703306 OR `props-main`.`id` = 1723999 OR `props-main`.`id` = 1722033 OR `props-main`.`id` = 1734542 OR `props-main`.`id` = 1727150 OR `props-main`.`id` = 1734257 OR `props-main`.`id` = 1736670 OR `props-main`.`id` = 1728820 OR `props-main`.`id` = 1744027 OR `props-main`.`id` = 1742340 OR `props-main`.`id` = 1732948 OR `props-main`.`id` = 1746384 OR `props-main`.`id` = 1743437 OR `props-main`.`id` = 1720456 OR `props-main`.`id` = 1746376 OR `props-main`.`id` = 1743351 OR `props-main`.`id` = 1728393 OR `props-main`.`id` = 1746044 OR `props-main`.`id` = 1738753 OR `props-main`.`id` = 1723554 OR `props-main`.`id` = 1746043 OR `props-main`.`id` = 1723223 OR `props-main`.`id` = 1744792 OR `props-main`.`id` = 1727299 OR `props-main`.`id` = 1741722 OR `props-main`.`id` = 1745742 OR `props-main`.`id` = 1745125 OR `props-main`.`id` = 1738695 OR `props-main`.`id` = 1727864 OR `props-main`.`id` = 1738667 OR `props-main`.`id` = 1734187 OR `props-main`.`id` = 1725851 OR `props-main`.`id` = 1709443 OR `props-main`.`id` = 1729851 OR `props-main`.`id` = 1722841 OR `props-main`.`id` = 1721846 OR `props-main`.`id` = 1737124 OR `props-main`.`id` = 1725720 OR `props-main`.`id` = 1740572 OR `props-main`.`id` = 1736579 OR `props-main`.`id` = 1728472 OR `props-main`.`id` = 1726184 OR `props-main`.`id` = 1745415 OR `props-main`.`id` = 1735346 OR `props-main`.`id` = 1714244 OR `props-main`.`id` = 1737840 OR `props-main`.`id` = 1724418 OR `props-main`.`id` = 1725187 OR `props-main`.`id` = 1743874 OR `props-main`.`id` = 1745353)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226082650' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-07' 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 Debra Cole, Weeks Real Estate 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.
