No Mello Roos!! This is the one you've been waiting for! Conveniently located close to schools, shopping and main roads. This beautiful home boasts 4 good sized bedrooms, 2 1/2 baths and over 2200 sq ft of living space. Open kitchen with granite counters, bar seating and mostly stainless steel appliances. Spacious master with dual sinks, granite counters and a walk-in closet. Separate living and family rooms, formal dining area plus dining space in the kitchen. Low maintenance front yard. Don't delay, call today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached, Tract
Year Built
1988
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Unknown
Stories
2
Levels
Two
Pets Allowed
Yes, Cats OK, Dogs OK
Home Warranty
No
Other Equipment
Water Filter System
Directions to Property
From Sperry Avenue, go South on S 9th St, right onto Bonneau Ct.
Cross Street
S 9th Street
County
Stanislaus
Special Listing Conditions
None
Lower Level
Living Room, Dining Room, Family Room, Partial Bath(s), Garage, Kitchen
Main Level
Living Room, Dining Room, Family Room, Partial Bath(s), Garage, Kitchen
Construction Materials
Stucco, Frame, Wood
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Cabinets, Inside Room
Window Features
Dual Pane Full
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Granite, Tile, Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Family Room, Wood Burning
Flooring
Carpet, Laminate, Tile
Appliances
Dishwasher, Disposal, Microwave, Free Standing Electric Range
Room Type
Primary Bathroom, Primary Bedroom, Dining Room, Family Room, Kitchen, Laundry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 441655 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 488145 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1995 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2495 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` = 1714781 OR `props-main`.`id` = 1714778 OR `props-main`.`id` = 1721016 OR `props-main`.`id` = 1716277 OR `props-main`.`id` = 1724179 OR `props-main`.`id` = 1719550 OR `props-main`.`id` = 1724545 OR `props-main`.`id` = 1724657 OR `props-main`.`id` = 1673075 OR `props-main`.`id` = 1722773 OR `props-main`.`id` = 1723827 OR `props-main`.`id` = 1716373 OR `props-main`.`id` = 1714051 OR `props-main`.`id` = 1722556 OR `props-main`.`id` = 1720776 OR `props-main`.`id` = 1720670 OR `props-main`.`id` = 1717988 OR `props-main`.`id` = 1725436 OR `props-main`.`id` = 1717687 OR `props-main`.`id` = 1689927 OR `props-main`.`id` = 1723807 OR `props-main`.`id` = 1722955 OR `props-main`.`id` = 1719247 OR `props-main`.`id` = 1714209 OR `props-main`.`id` = 1714784 OR `props-main`.`id` = 1718602 OR `props-main`.`id` = 1699122 OR `props-main`.`id` = 1649515 OR `props-main`.`id` = 1723901 OR `props-main`.`id` = 1714414 OR `props-main`.`id` = 1721940 OR `props-main`.`id` = 1715615 OR `props-main`.`id` = 1723903 OR `props-main`.`id` = 1723862 OR `props-main`.`id` = 1718842 OR `props-main`.`id` = 1724633 OR `props-main`.`id` = 1722234 OR `props-main`.`id` = 1701580 OR `props-main`.`id` = 1707875 OR `props-main`.`id` = 1723015 OR `props-main`.`id` = 1705572 OR `props-main`.`id` = 1723016)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225011138' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-05' 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 Troy Ross, Century 21 Select 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.
