Nestled on just over 5 picturesque acres along a tranquil York River inlet, this exceptional 5-bedroom, 5.5-bath property offers a rare blend of privacy and versatility. Whether you're seeking a full-time residence, an income-producing bed-and-breakfast, working farm, or an ideal setting for a home-based business, this unique estate delivers endless possibilities. The property features 3 separate living spaces, including a custom-built main residence with more than 4,000 sq ft of living space, a 1,220 sq ft lower-level apartment, and a 648 sq ft accessory dwelling above the heated detached 3-car garage. Inside the main home, a two-story foyer welcomes you with gleaming hardwood floors, abundant natural light, and timeless craftsmanship. The thoughtfully designed 1st floor includes 2 spacious primary suites, a convenient powder room, formal dining room, a stunning chef's kitchen with premium stainless-steel appliances, natural cherry cabinetry, as well as a generous living room, sun-filled office, and inviting 3-season sunroom. An expansive rear deck extends the width of the home, providing the perfect spot to relax and enjoy peaceful water views. Upstairs, 2 large guest bedrooms are positioned on opposite ends of an open catwalk, sharing a well-appointed full bath for family and guests alike. The lower level adds flexibility with a private apartment currently generating rental income, additional laundry facilities, an indoor lap pool, a utility room, and ample storage. Multiple outbuildings provide abundant space for farm animals, equipment, workshop needs, or additional storage. With both commercial and residential zoning, this remarkable property presents an outstanding opportunity for entrepreneurs, investors, or anyone seeking a truly unique lifestyle property. Located just minutes from York's beaches, restaurants, shopping, this waterfront estate offers great versatility top homeowners or investors. Property is being sold 'AS IS'.