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` = 1749005 OR `props-main`.`id` = 1725762 OR `props-main`.`id` = 1746135 OR `props-main`.`id` = 1730684 OR `props-main`.`id` = 1751729 OR `props-main`.`id` = 1730997 OR `props-main`.`id` = 1745645 OR `props-main`.`id` = 1737270 OR `props-main`.`id` = 1739113 OR `props-main`.`id` = 1742643 OR `props-main`.`id` = 1751303 OR `props-main`.`id` = 1750460 OR `props-main`.`id` = 1749945 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` = 1741904 OR `props-main`.`id` = 1740841 OR `props-main`.`id` = 1742585 OR `props-main`.`id` = 1744580 OR `props-main`.`id` = 1715680 OR `props-main`.`id` = 1728232 OR `props-main`.`id` = 1749943 OR `props-main`.`id` = 1728179 OR `props-main`.`id` = 1747706 OR `props-main`.`id` = 1746930 OR `props-main`.`id` = 1728945 OR `props-main`.`id` = 1743992 OR `props-main`.`id` = 1733603 OR `props-main`.`id` = 1743738 OR `props-main`.`id` = 1727945 OR `props-main`.`id` = 1750769 OR `props-main`.`id` = 1749888 OR `props-main`.`id` = 1751629 OR `props-main`.`id` = 1735300 OR `props-main`.`id` = 1727422 OR `props-main`.`id` = 1737854 OR `props-main`.`id` = 1720853 OR `props-main`.`id` = 1721984 OR `props-main`.`id` = 1721978 OR `props-main`.`id` = 1751826 OR `props-main`.`id` = 1730671 OR `props-main`.`id` = 1725189 OR `props-main`.`id` = 1748119 OR `props-main`.`id` = 1751493 OR `props-main`.`id` = 1707870 OR `props-main`.`id` = 1751494 OR `props-main`.`id` = 1738185 OR `props-main`.`id` = 1739235 OR `props-main`.`id` = 1738197 OR `props-main`.`id` = 1746339 OR `props-main`.`id` = 1747859 OR `props-main`.`id` = 1748978 OR `props-main`.`id` = 1751457 OR `props-main`.`id` = 1728139 OR `props-main`.`id` = 1735305 OR `props-main`.`id` = 1740601 OR `props-main`.`id` = 1751440 OR `props-main`.`id` = 1710082 OR `props-main`.`id` = 1749499 OR `props-main`.`id` = 1749740 OR `props-main`.`id` = 1741701 OR `props-main`.`id` = 1741309 OR `props-main`.`id` = 1746400 OR `props-main`.`id` = 1650045 OR `props-main`.`id` = 1741096 OR `props-main`.`id` = 1741116 OR `props-main`.`id` = 1729197 OR `props-main`.`id` = 1746307 OR `props-main`.`id` = 1736606 OR `props-main`.`id` = 1739423 OR `props-main`.`id` = 1747887 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` = 1744631 OR `props-main`.`id` = 1733151 OR `props-main`.`id` = 1655863 OR `props-main`.`id` = 1744847 OR `props-main`.`id` = 1741242)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226020188' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-20' 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.
