Opportunity knocks with this one-of-a-kind estate property set on 3.5 scenic acres overlooking the Conestoga River. This expansive Lancaster home offers a rare blend of space, flexibility, and peaceful waterfront living-ideal for multi-generational living, extended stays, or simply enjoying room to spread out. Flexible floor plan allows for up to 8 bedrooms and 7 full bathrooms (1 bedroom on the main level, 4 bedrooms on the second floor, and 3 additional rooms on the third floor that can be used as bedrooms/offices). The main level includes a private in-law suite complete with its own bedroom, full bath, and living room with fireplace-perfect for guests or extended family. At the heart of the home, the kitchen with breakfast area flows seamlessly into the family room with fireplace and provides direct access to the expansive rear deck overlooking the river, creating an ideal setup for both everyday living and entertaining. A formal dining room with hardwood floors and a separate living room complete the main level. Upstairs, the second floor features four bedrooms, each with its own en-suite bath, including a spacious primary suite with a large bonus room or private office. The third floor offers additional flexible living space, including three bedrooms/offices, a full bath, and a generous common area-perfect for a game room, lounge, or movie area. The partially finished walkout lower level features extra-high ceilings and provides even more space for recreation, storage, or future customization. Recent updates include fresh paint throughout and new carpeting, while large windows capture the home's stunning natural surroundings and river views. Step outside and enjoy the tranquility of the setting, with ample space to relax, entertain, and take in the beauty of the Conestoga River. A truly rare opportunity to own a property that combines size, setting, and exceptional flexibility in Lancaster County.