Rarely available, this fee-simple commercial property offers an exceptional combination of retail, residential, and warehouse space in a highly visible Waimea location. The ground floor features two retail units with highway-facing frontage totaling 1,100 square feet, while the second floor includes two studio apartments totaling an additional 1,100 square feet. Behind the retail and residential spaces is a substantial warehouse structure containing three versatile bays totaling 4,000 square feet (approximately 1,333 square feet each). These bays are ideal for storage, garage use, or a wide range of commercial operations. All units across the property are currently leased, providing immediate income potential. Zoned Neighborhood Commercial 7.5, the property is intended for conveniently located centers that serve nearby residents and workers with frequently needed goods and services-distinct from central commercial districts that serve broader, region-wide commercial activity. With its flexible layout, valuable zoning, and strong visibility along Mamalahoa Highway, this mixed-use property represents a rare opportunity just 0.8 miles northeast of Waimea town center. Waimea is the largest town in North Hawai'i with approximately 10,000 residents. Its economy is anchored by ranching, farming, and its role as a support hub for the globally significant telescopes atop Mauna Kea. The town is also home to two well-established private schools and a private hospital offering acute care and emergency services. The world-renowned Parker Ranch is headquartered here, continuing the area's historic ranching tradition rooted in the Waimea/Kohala region-celebrated for its Paniolo (Hawaiian cowboys) and sweeping volcanic grasslands. This property offers an exceptional opportunity for an owner-user or investor seeking a well-positioned, income-producing asset in one of Waimea's most desirable commercial corridors.