A rare opportunity to own a versatile Main Street property in the heart of Jordan Village-equally suited to life as a distinctive family home, live/work setting, boutique retail space, artisan studio, office, personal-service business, or bed and breakfast. Set in one of Niagara's most picturesque and walkable villages, 3804 Main Street offers over 250000 sq. ft. with three bedrooms, three full bathrooms, inviting principal rooms, a grand central staircase, and a private backyard for outdoor entertaining. A new asphalt driveway provides parking for four vehicles. At the rear, a solid two-storey barn offers potential as a garage, workshop, studio, or additional flexible space, subject to required approvals. Its mixed-use zoning creates a rare range of possibilities: live here full-time while operating a business from home, establish a retail or service concept, revive its former bed and breakfast use, or simply enjoy the convenience and character of a landmark Jordan Village address. For families, this is a village built around community. The Lincoln Museum & Cultural Centre sits next door, while Jordan Lions Arena, Jordan Lions Park, seasonal pool, splash pad, playgrounds, skating, sports, camps, and community programming are close by. The Twenty Mile Creek trail system and Balls Falls offer year-round outdoor enjoyment, while Beamsville's skatepark, pump track, library, and recreation facilities are minutes away. Enjoy easy access to Jordan Village's boutique shops, restaurants, local markets, and Niagara wineries. Just minutes away, Restaurant Pearl Morissette-a two-MICHELIN-star dining destination-adds to the area's exceptional food and wine culture. With Inn On The Twenty, RPM Bakehouse, schools, recreation, trails, and the Niagara Benchlands at your doorstep and easy access to Niagara-on-the-Lake, St. Catharines, Hamilton, and the QEW, this is a unique Main Street address with the flexibility to become whatever your next chapter requires.