Discover the inviting comfort of 2032 Boise Ave, Modesto, CA. This home offers a seamless blend of classic style and modern convenience, providing an ideal setting for relaxed living. The living room, a focal point of this home, provides a welcoming atmosphere, centered around a cozy fireplace perfect for gatherings. Complementing the interior, the exterior features a classic ranch architectural style. An attached garage offers convenience, while the private yard and patio provide ample space for outdoor enjoyment and entertaining. This property presents a wonderful opportunity to embrace a comfortable and convenient lifestyle.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1987
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
Hatch to Ustick, to Boise.
Cross Street
Ustick
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Construction Materials
Wood
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Central
Laundry Features
In Garage, Inside Area
Full Bathrooms
2
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Gas Piped
Flooring
Laminate
Kitchen Features
Synthetic Counter
Dining Room Features
Space in Kitchen
Living Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Sewer In & Connected
Electric
220 Volts
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Curb(s)/Gutter(s)
APN
056 066 023 000
Horse Property
No
Zoning Description
R
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
23.03
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 394250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435750 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) >= 1210 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1710 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` = 1787507 OR `props-main`.`id` = 1764176 OR `props-main`.`id` = 1769016 OR `props-main`.`id` = 1717238 OR `props-main`.`id` = 1786019 OR `props-main`.`id` = 1728779 OR `props-main`.`id` = 1785448 OR `props-main`.`id` = 1777836 OR `props-main`.`id` = 1790259 OR `props-main`.`id` = 1751542 OR `props-main`.`id` = 1782537 OR `props-main`.`id` = 1773094 OR `props-main`.`id` = 1780856 OR `props-main`.`id` = 1789358 OR `props-main`.`id` = 1775342 OR `props-main`.`id` = 1734142 OR `props-main`.`id` = 1734141 OR `props-main`.`id` = 1789263 OR `props-main`.`id` = 1776026 OR `props-main`.`id` = 1788757 OR `props-main`.`id` = 1788755 OR `props-main`.`id` = 1787073 OR `props-main`.`id` = 1778142 OR `props-main`.`id` = 1783807 OR `props-main`.`id` = 1783809 OR `props-main`.`id` = 1781934 OR `props-main`.`id` = 1737121 OR `props-main`.`id` = 1786865 OR `props-main`.`id` = 1777024 OR `props-main`.`id` = 1783453 OR `props-main`.`id` = 1781426 OR `props-main`.`id` = 1786460 OR `props-main`.`id` = 1768659 OR `props-main`.`id` = 1778552 OR `props-main`.`id` = 1789225 OR `props-main`.`id` = 1781766 OR `props-main`.`id` = 1760650 OR `props-main`.`id` = 1786648)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226111196' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-13' 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();
4
Similar Properties
$430,000
3
2
1,387
0.14
1616 Ironside Dr
Modesto, CA 95358
$420,000
3
2
1,650
0.20
217 Rio Grande Ave
Modesto, CA 95351
$415,000
3
2
1,331
0.14
208 Yosemite Ave
Modesto, CA 95351
$399,000
3
2
1,246
0.15
1305 Mayette Ave
Modesto, CA 95351
Courtesy of Adrian Zavala, RE/MAX Executive 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.
