Discover this exceptional 2.2-acre property at Netherby Road and the Niagara River Parkway, boasting approximately 300 feet of road frontage on a prominent corner lot, panoramic Niagara River views, direct Friendship Trail access, and incredible versatility! The spacious main residence features 7 bedrooms, 3 bathrooms, 2 kitchens, and a sunroom, with potential for a bachelor unit and two separate 3-bedroom living spaces, ideal for multigenerational living or income opportunities. Interior highlights include updated kitchens, renovated bathrooms, a wood-burning fireplace, and an impressive 500 sq. ft. great room perfect for entertaining. Relax on the large covered front porch overlooking the beautiful surroundings. Two furnaces provide forced-air and in-floor heating beneath elegant Italian tile flooring. Additional features include a 2024 steel roof, septic system, and cistern. A detached, heated and air-conditioned office provides year-round workspace, while a completely renovated second dwelling offers 3 additional bedrooms, ideal for extended family, guests, or rental potential. Adding historic charm is a heated conservatory greenhouse built in 1901, complete with in-floor heating and previously used as a yoga studio. This unique space offers endless possibilities for wellness, hobbies, entertaining, or a home business. With multiple living areas, a separate residence, private office, historic conservatory, and expansive grounds, this property offers outstanding flexibility. Potential exists to sever an additional lot, subject to municipal approval. A truly one-of-a-kind Niagara River property with endless possibilities that must be seen to be appreciated!