Introducing a newly listed property in Great Neck Estates, offering an extraordinary opportunity for those seeking a project with immense potential. This home, being sold 'as is,' requires significant work but is situated on a sprawling and highly sought-after piece of land. Nestled in an exceptional location near Old Mill Road, this property boasts the advantages of being part of a waterfront community. Residents can enjoy the abundant amenities, including a large park, indoor/outdoor tennis courts, a refreshing pool, a vibrant day camp, a delightful playground, and invigorating boating moorings. With the right vision and a touch of creativity, this property holds the promise of designing your dream home in a truly desirable neighborhood. Virtual Tour has video rendering of interior of home. The perfect canvas awaits for those ready to transform this diamond in the rough into a gem of their own making. BY APPOINTMENT ONLY! DO NOT WALK PROPERTY.