Introducing this stunning, one-of-a-kind property overlooking the Susquehanna River. With a brand NEW exterior and new custom wrap around composite deck and porch, enjoy watching boats pass by, fireworks on the water, or just enjoy the serenity of this unique location at the Pequea boat ramp. This farmhouse style home is a GEM and a total home makeover! Sitting on one half acre, boasting over 3300 total square footage, 4 bedrooms, 2.5 bathrooms, detached garage/carriage house, walkout lower level, large driveway with plenty of parking, complete with total upgrades! Newly remodeled kitchen consists of granite countertops, farmhouse sink, new soft close cabinets, overhead lighting, breakfast area, and stainless steel appliances to stay with the home. Off the kitchen is a mudroom area with a newly remodeled powder room and new shiplap. Kitchen leads to open first floor with large dining area and living room complete with original hardwood flooring, newly insulated ceiling with exposed wood, and wood burning fireplace (new liner with electric fan in 2021). Large windows and tons of natural light with access out to brand new custom designed wrap-around composite deck and porch with new beams, porch railing, PVC ceiling, recess lighting (2022). Enclosed porch renovation in 2022 and complete renovation of exterior of home in 2021. New siding and paint. Second level complete with 3 bedrooms. Primary bedroom with custom barn door into full bathroom with double sink, quartz countertop, subway tile, and glass stall shower. Two additional bedrooms with ceiling fans throughout. Also on second level is new laundry room with tile flooring, utility sink, closet and tons of cabinet storage. Second floor hall bathroom consists of quartz countertop, double sink, and bathtub. Third floor has a loft area suitable for another bedroom, den, office, or additional family room area. Unfinished basement is perfect for storage of any kind with walkout access to the outside. In addition to the new wrap around deck and enclosed porch, there is new hardscape and landscaping, retaining wall, new outdoor dining patio area, and plenty of space for a playset and to enjoy the outdoors. So many more updates to list, including new recess lighting throughout, new double hung windows with new blinds, new septic system (2017), new gutters, new shed and carriage house roof, new metal roof, new hot water heater (2023) and water pump (2023). Heat pump and central air conditioning. With the most insane view of the Susquehanna plus the beauty of this home from the waters view, you must come see it for yourself! Fantastic for owner occupancy or a great investment opportunity.