Step into stunning with this incredible opportunity just minutes from Niagara Falls, Clifton Hill, casinos, golf, and Niagara's wine country. This 2.5 Storey with full finished basement boasts 6 bedrooms, 3 full baths, and an in-law suite, this property features 2 fully self-contained units with separate entrances and hydro meters, creating outstanding income potential or an ideal multigenerational setup. The open-concept main floor showcases a brand-new kitchen (2022) with quartz countertops, a dining/living area with custom brick gas fireplace, and a hand-crafted black locust mantle and heated towel racks in 2 baths. All four levels have been meticulously renovated top to bottom, with new insulation, updated plumbing and electrical, and a new A/C (2025). Exterior upgrades include new siding, tear off roof, windows, and doors (2020), insulation, plus a new front porch and stairs (2025). The exposed aggregate wraparound driveway and walkway (2022) lead to a large deck overlooking the private fenced yard. A detached 1.5-car garage with new concrete, wood stove and attic, plus shed and garden space, adds even more value. Easy to convert back to a single-family home, this property is a rare blend of character, function, and opportunity. A must-see to truly appreciate. Priced to sell!