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), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen, 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) >= 1942750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2147250 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` = 1697854 OR `props-main`.`id` = 1707084 OR `props-main`.`id` = 1705253 OR `props-main`.`id` = 1703104 OR `props-main`.`id` = 1711168 OR `props-main`.`id` = 1697714 OR `props-main`.`id` = 1710987 OR `props-main`.`id` = 1708218 OR `props-main`.`id` = 1706866 OR `props-main`.`id` = 1710812 OR `props-main`.`id` = 1704885 OR `props-main`.`id` = 1697447 OR `props-main`.`id` = 1707027 OR `props-main`.`id` = 1686997 OR `props-main`.`id` = 1706068 OR `props-main`.`id` = 1703452 OR `props-main`.`id` = 1708276 OR `props-main`.`id` = 1703802 OR `props-main`.`id` = 1708028 OR `props-main`.`id` = 1692060 OR `props-main`.`id` = 1697497 OR `props-main`.`id` = 1710184 OR `props-main`.`id` = 1702925 OR `props-main`.`id` = 1693498 OR `props-main`.`id` = 1675168 OR `props-main`.`id` = 1709941 OR `props-main`.`id` = 1707869 OR `props-main`.`id` = 1707870 OR `props-main`.`id` = 1711065 OR `props-main`.`id` = 1703775 OR `props-main`.`id` = 1710082 OR `props-main`.`id` = 1710666 OR `props-main`.`id` = 1650045 OR `props-main`.`id` = 1697741 OR `props-main`.`id` = 1677502 OR `props-main`.`id` = 1705464 OR `props-main`.`id` = 1709417 OR `props-main`.`id` = 1705737 OR `props-main`.`id` = 1705563 OR `props-main`.`id` = 1694288 OR `props-main`.`id` = 1694287 OR `props-main`.`id` = 1709943 OR `props-main`.`id` = 1655893 OR `props-main`.`id` = 1695535 OR `props-main`.`id` = 1702757 OR `props-main`.`id` = 1704378 OR `props-main`.`id` = 1655863 OR `props-main`.`id` = 1701961 OR `props-main`.`id` = 1710558 OR `props-main`.`id` = 1705423 OR `props-main`.`id` = 1694239 OR `props-main`.`id` = 1702881 OR `props-main`.`id` = 1704280 OR `props-main`.`id` = 1709518 OR `props-main`.`id` = 1710723 OR `props-main`.`id` = 1710733)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226020188' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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.
