EXCEPTIONAL MIXED - USED Opportunity in MODESTO - Residential + Commercial - OFFERED AS ONE PACKAGE! This is A RARE offering includes two parcels to be sold together as one unique property in a rapidly developing area of Modesto. The residential parcel features approximately l acre with a solid home built in 1970. Home Features 2,358 sq.ft. offering space but needs a little love to bring it back. The commercial building exceeds 20,000 sq.ft. providing substantial operational & storage. Combined offering all within a growing Modesto market.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Custom
Year Built
1970
Year Built Source
Owner
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
Sylvan Ave to Roselle. Property is on the westside of Roselle
Cross Street
SYLVAN AVE
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Living Room, Primary Bedroom, Street Entrance
Construction Materials
Block, Brick, Frame
Foundation
Raised, Slab
Roof
Composition
Heating
Other
Cooling
Other
Laundry Features
Cabinets, Sink, Inside Room
Property Faces
East
Full Bathrooms
3
Bath Features
Tile, Tub
# of Fireplaces
1
Fireplace Features
Other
Flooring
Carpet, Tile
Appliances
Dishwasher, Electric Cook Top
Kitchen Features
Ceramic Counter
Dining Room Features
Breakfast Nook, Formal Area
Living Room Features
Other
Family Room Features
Great Room
Primary Bathroom Features
Shower Stall(s), Tile
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Other
Electric
Other
Irrigation
None
Water Source
Shared Well
Sewer
Other
Parking Features
Attached, Garage Facing Side
Garage Spaces
2.00
Lot Features
Shape Regular
APN
083 004 086 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
4.05
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1800250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1989750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 12350 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 12850 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` = 1726442 OR `props-main`.`id` = 1752442 OR `props-main`.`id` = 1757731 OR `props-main`.`id` = 1758105 OR `props-main`.`id` = 1737270 OR `props-main`.`id` = 1760183 OR `props-main`.`id` = 1760182 OR `props-main`.`id` = 1759041 OR `props-main`.`id` = 1751303 OR `props-main`.`id` = 1750460 OR `props-main`.`id` = 1749945 OR `props-main`.`id` = 1752476 OR `props-main`.`id` = 1754614 OR `props-main`.`id` = 1746744 OR `props-main`.`id` = 1725328 OR `props-main`.`id` = 1725327 OR `props-main`.`id` = 1725326 OR `props-main`.`id` = 1722553 OR `props-main`.`id` = 1725329 OR `props-main`.`id` = 1758286 OR `props-main`.`id` = 1740841 OR `props-main`.`id` = 1753282 OR `props-main`.`id` = 1744580 OR `props-main`.`id` = 1759880 OR `props-main`.`id` = 1757391 OR `props-main`.`id` = 1757059 OR `props-main`.`id` = 1728179 OR `props-main`.`id` = 1747706 OR `props-main`.`id` = 1755085 OR `props-main`.`id` = 1754654 OR `props-main`.`id` = 1758955 OR `props-main`.`id` = 1728945 OR `props-main`.`id` = 1754753 OR `props-main`.`id` = 1743992 OR `props-main`.`id` = 1759983 OR `props-main`.`id` = 1733603 OR `props-main`.`id` = 1757571 OR `props-main`.`id` = 1759548 OR `props-main`.`id` = 1750769 OR `props-main`.`id` = 1752868 OR `props-main`.`id` = 1735300 OR `props-main`.`id` = 1751957 OR `props-main`.`id` = 1737854 OR `props-main`.`id` = 1720853 OR `props-main`.`id` = 1721984 OR `props-main`.`id` = 1721978 OR `props-main`.`id` = 1748119 OR `props-main`.`id` = 1751493 OR `props-main`.`id` = 1751494 OR `props-main`.`id` = 1738185 OR `props-main`.`id` = 1739235 OR `props-main`.`id` = 1757597 OR `props-main`.`id` = 1738197 OR `props-main`.`id` = 1754565 OR `props-main`.`id` = 1757588 OR `props-main`.`id` = 1755822 OR `props-main`.`id` = 1752068 OR `props-main`.`id` = 1747859 OR `props-main`.`id` = 1748978 OR `props-main`.`id` = 1757596 OR `props-main`.`id` = 1754682 OR `props-main`.`id` = 1751457 OR `props-main`.`id` = 1755009 OR `props-main`.`id` = 1728139 OR `props-main`.`id` = 1735305 OR `props-main`.`id` = 1753939 OR `props-main`.`id` = 1710082 OR `props-main`.`id` = 1755705 OR `props-main`.`id` = 1752580 OR `props-main`.`id` = 1741309 OR `props-main`.`id` = 1650045 OR `props-main`.`id` = 1741096 OR `props-main`.`id` = 1741116 OR `props-main`.`id` = 1746307 OR `props-main`.`id` = 1736606 OR `props-main`.`id` = 1758686 OR `props-main`.`id` = 1754268 OR `props-main`.`id` = 1739423 OR `props-main`.`id` = 1728791 OR `props-main`.`id` = 1741197 OR `props-main`.`id` = 1749483 OR `props-main`.`id` = 1746992 OR `props-main`.`id` = 1747334 OR `props-main`.`id` = 1755186 OR `props-main`.`id` = 1733151 OR `props-main`.`id` = 1758102 OR `props-main`.`id` = 1655863 OR `props-main`.`id` = 1744847 OR `props-main`.`id` = 1759281 OR `props-main`.`id` = 1754643 OR `props-main`.`id` = 1741242)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226020188' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-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();
0
Courtesy of Pamela Harmon, PMZ 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.
