Start 2026 with a freshly remodeled home to call our own! This conveniently located light and bright home is move-in ready and waiting for it's new owner. Close to schools hospital, medical offices, shopping and easy access to main streets for commuters. With 4 bedrooms and 2 baths this home has been meticulously remodeled. New roof and dual pane windows throughout. Beautiful wide plank Republic flooring flows through the whole house giving a seamless and timeless look that is easy to care for. All new baseboards. Interior has been completely painted in a soft white offering a clean slate. the kitchen was reconfigured and designed for efficiency with new appliances including gas range, dishwasher and microwave; plumbed for ice maker. Upgraded stainless sink includes cutting board, drainage rack and more. All new cabinets in kitchen and bathrooms with soft closing doors and drawers. Updated brushed nickel finishes for all hardware, faucets and lighting for a cohesive and custom touch. Both bathrooms were remodeled in keeping with the rest of the home. Built-in storage cabinet was left but given a new coat of paint giving additional storage space. Large lot allowing plenty of room for a pool, ADU or outdoor oasis. RV access with cement strips in place allowing you to pull in from the street. Second gate and large side yard. Front elevation was spruced up with new gutters and shutters for clean and appealing curb appeal. This one is a must see!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached, Tract
Year Built
1974
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Kitchen 0-5YR, Bed 0-5YR, Other-Rmks 0-5YR
Stories
1
Home Warranty
No
Directions to Property
Take either Sylvan or Briggsmore to Coffee Rd. Head east on Celeste to property.
Cross Street
Coffee
County
Stanislaus
Special Listing Conditions
Trust
Main Level
Bedroom(s), Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco, Frame
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
In Garage
Other Structures
Shed(s), Storage
Full Bathrooms
2
Bath Features
Tub w/Shower Over, See Remarks
Flooring
See Remarks
Appliances
Free Standing Gas Range, Dishwasher, Disposal, Microwave, See Remarks
Kitchen Features
Quartz Counter
Dining Room Features
Dining/Family Combo
Living Room Features
Other
Family Room Features
Great Room
Patio And Porch Features
Covered Patio
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
220 Volts in Laundry
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, RV Access, Garage Door Opener
Garage Spaces
2.00
Lot Features
Curb(s)/Gutter(s), See Remarks
APN
066 009 073 000
Driveway/Sidewalks
Sidewalk/Curb/Gutter
Fencing
Back Yard, See Remarks
Horse Property
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Sylvan Union
Middle or Junior School District
Sylvan Union
Senior High School District
Modesto City
Census Tract
9.10
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 437000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 483000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 907 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1407 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` = 1698760 OR `props-main`.`id` = 1696210 OR `props-main`.`id` = 1701160 OR `props-main`.`id` = 1697766 OR `props-main`.`id` = 1701055 OR `props-main`.`id` = 1697393 OR `props-main`.`id` = 1698031 OR `props-main`.`id` = 1697495 OR `props-main`.`id` = 1673085 OR `props-main`.`id` = 1697572 OR `props-main`.`id` = 1688348 OR `props-main`.`id` = 1659614 OR `props-main`.`id` = 1701007 OR `props-main`.`id` = 1694822 OR `props-main`.`id` = 1701446 OR `props-main`.`id` = 1691042 OR `props-main`.`id` = 1698163 OR `props-main`.`id` = 1694051 OR `props-main`.`id` = 1689410 OR `props-main`.`id` = 1698730 OR `props-main`.`id` = 1680147 OR `props-main`.`id` = 1698442 OR `props-main`.`id` = 1692578 OR `props-main`.`id` = 1697527 OR `props-main`.`id` = 1701000 OR `props-main`.`id` = 1671549 OR `props-main`.`id` = 1701498 OR `props-main`.`id` = 1701361 OR `props-main`.`id` = 1689437 OR `props-main`.`id` = 1701138 OR `props-main`.`id` = 1695807 OR `props-main`.`id` = 1685955 OR `props-main`.`id` = 1701071 OR `props-main`.`id` = 1695660 OR `props-main`.`id` = 1698830 OR `props-main`.`id` = 1691275 OR `props-main`.`id` = 1698492 OR `props-main`.`id` = 1698797 OR `props-main`.`id` = 1671828 OR `props-main`.`id` = 1697583 OR `props-main`.`id` = 1698192 OR `props-main`.`id` = 1700632 OR `props-main`.`id` = 1698955 OR `props-main`.`id` = 1687792 OR `props-main`.`id` = 1702472 OR `props-main`.`id` = 1701370 OR `props-main`.`id` = 1701553 OR `props-main`.`id` = 1694103 OR `props-main`.`id` = 1697854 OR `props-main`.`id` = 1701730 OR `props-main`.`id` = 1702884 OR `props-main`.`id` = 1690336 OR `props-main`.`id` = 1676376 OR `props-main`.`id` = 1702040 OR `props-main`.`id` = 1694651 OR `props-main`.`id` = 1690897 OR `props-main`.`id` = 1701731 OR `props-main`.`id` = 1702945 OR `props-main`.`id` = 1697714 OR `props-main`.`id` = 1702807 OR `props-main`.`id` = 1702319 OR `props-main`.`id` = 1693421 OR `props-main`.`id` = 1702026 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1701866 OR `props-main`.`id` = 1699061 OR `props-main`.`id` = 1698871 OR `props-main`.`id` = 1694983 OR `props-main`.`id` = 1697473 OR `props-main`.`id` = 1701637 OR `props-main`.`id` = 1695775 OR `props-main`.`id` = 1702457 OR `props-main`.`id` = 1697912 OR `props-main`.`id` = 1695782 OR `props-main`.`id` = 1697633 OR `props-main`.`id` = 1701775 OR `props-main`.`id` = 1690717 OR `props-main`.`id` = 1691048 OR `props-main`.`id` = 1684643 OR `props-main`.`id` = 1691594 OR `props-main`.`id` = 1698734 OR `props-main`.`id` = 1694279 OR `props-main`.`id` = 1695600 OR `props-main`.`id` = 1691545 OR `props-main`.`id` = 1701444 OR `props-main`.`id` = 1697814 OR `props-main`.`id` = 1701082 OR `props-main`.`id` = 1702664 OR `props-main`.`id` = 1702186 OR `props-main`.`id` = 1702560 OR `props-main`.`id` = 1695421 OR `props-main`.`id` = 1702925 OR `props-main`.`id` = 1681349 OR `props-main`.`id` = 1693498 OR `props-main`.`id` = 1694229 OR `props-main`.`id` = 1675168 OR `props-main`.`id` = 1693884 OR `props-main`.`id` = 1679086 OR `props-main`.`id` = 1690524 OR `props-main`.`id` = 1646600 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1692488 OR `props-main`.`id` = 1701987 OR `props-main`.`id` = 1702458 OR `props-main`.`id` = 1697901 OR `props-main`.`id` = 1688192 OR `props-main`.`id` = 1699570 OR `props-main`.`id` = 1695116 OR `props-main`.`id` = 1699149 OR `props-main`.`id` = 1700922)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226004946' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-15' 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 Debbie Kelly, HomeSmart PV & Associates 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.
