Exceptional investment or owner-user opportunity in the heart of Columbia on 1 acre (43,560 sq ft) zoned Commercial C-1. Originally a single-family, this property has been converted into a duplex offering two spacious 3-bedroom, 2-bath units totaling 2,572 sq ft, each w/ access to a private porch or patio area. In 2021, the building was extensively remodeled. Improvements include new kitchens & bathrooms, cabinetry, countertops, appliances, flooring, sheetrock, dual-pane windows, updated plumbing & electrical systems, recently installed mini-split AC/heating units, propane water heaters, & modern lighting & fixtures throughout. Exterior upgrades include professional interior & exterior paint, new well equipment & pump with updated power supply, new propane tanks, fencing, expanded drive & parking area, landscaping & a new roof in 2019. Located along Highway 49 in Tuolumne County, this property offers strong visibility with more than 300sq ft of frontage in a high-traffic corridor near historic Columbia. Close to New Melones Lake, Yosemite National Park, and National Forests, offering fishing, camping, and year-round recreation. With C-1 zoning, it presents potential for owner-occupants, rental income, or possible short-term rental/Airbnb use (buyer to verify permitted uses).