Exceptional investment or owner-user opportunity combining Commercial C-1 frontage along Highway 49 with residential flexibility on a full 1-acre (43,560 sq ft) parcel in the heart of Columbia. The property features an occupied primary single-family residence and attached vacant secondary living area totaling 2,438 sq ft, currently configured as two 3-bedroom, 2-bath living areas, each with private porch or patio access. Extensively rebuilt in 2021 down to the studs, upgrades include updated kitchens and bathrooms, cabinetry, countertops, appliances, flooring, sheetrock, dual-pane windows, updated plumbing and electrical systems, propane water heaters, modern lighting and fixtures, and recently installed mini-split AC/heating units. New roof in 2019. Exterior improvements include professional interior and exterior paint, updated well equipment and pump, new propane tanks, fencing, expanded drive and parking area, landscaping, and a functioning septic system. Located along Highway 49 in Tuolumne County, the property offers strong visibility near historic Columbia. Close to New Melones Lake, Yosemite National Park, and National Forests for fishing, camping, and recreation. Commercial C-1 zoning enhances long-term versatility for permitted uses (buyer to verify with county).