Privately situated at the end of Flint Rock Drive, this versatile three-level home in the highly desirable Orchard Farm neighborhood offers exceptional space, privacy, and flexibility and is ideal for multi-generational living with its first level in-law suite. With direct entry from the attached two-car garage, the in-law suite features an open living/dining area with a gas fireplace, a full kitchen and French doors that open to the screened-in sunroom with access to a private deck. A en-suite bedroom, office, powder room and laundry area complete the in-law suite. Upstairs, the main home features a kitchen with center island open to the dining area and living room, also with a gas fireplace, and access to a deck overlooking the serene back yard and river beyond. A bedroom, full bath, laundry area complete this floor. Above the attached garage, a spacious bonus great room provides a flexible space. The top floor is dedicated to the primary suite and an additional bedroom, along with a third deck offering even more beautiful water views. The full basement offers plenty of room for storage. Mature landscaping, a patio area, and a well-kept lawn provide inviting outdoor spaces for pets, entertaining, and family gatherings. Enjoy deeded access to the association-owned waterfront, including a common neighborhood dock and boat launch-perfect for kayaking, paddleboarding, swimming, and enjoying the York River virtually right outside your door. Conveniently located near the York Golf & Tennis Club and just a short distance from area beaches, shopping, restaurants, and commuter routes this exceptional property combines flexible living spaces, water access, and a desirable York location.