ML# :828750   KINGS POINT HOUSE - Renovated spacious waterfront offering in one of Great Neck’s premiere buildings with fabulous layout. This doorman coop features a split two bedroom two bathroom with direct breathtaking eastern views of Manhasset Bay from every room. This apartment features a gas barbecue grill on the terrace, individual thermostats, an extra large storage bin that transfers with the apartment, several walk In closets, complimentary guest parking, with indoor garage parking issued at closing. This turn key designer apartment boasts high end designer renovations with the finest quality custom materials, finishes, craftsmanship and upgrades.

ML# :891828   Wake up to sweeping ocean views from every room in this immaculate, turn key two-bedroom, two-bath condo located in the highly sought-after Ocean Grand building in Rockaway Park, Queens. This residence offers the perfect blend of luxury, comfort and oceanfront living.Inside, you’ll find a thoughtfully designed layout with an open-concept living and dining area that is warm, inviting and flows seamlessly into an open and airy modern kitchen complete with granite countertops, stainless steel appliances, and custom cabinetry. The spacious primary suite has beautiful direct ocean views and includes a walk-in closet and private en-suite bath. With pocket doors the second bedroom offers flexibility for guests, a home office, or additional living space since it opens up to the living room/dining room. Additional features include in-unit washer/dryer, three separate heat/AC units, hardwood floors, new stainless steel appliances and most importantly your own deeded parking space with an extra storage area. To finish things off, just step out onto your private 15 balcony and take in stunning unobstructed views of the Atlantic Ocean while watching the whale and dolphin pods swim by. Living oceanfront in The Rockaways is truly an amazing experience and one of the best places to live in NYC. The Ocean Grand offers a host of amenities including a doorman/concierge with package room, modern fitness center, computer room, relaxing common areas, a rooftop deck, two elevators, and a secure, well-maintained building with a great live in super. Outside, the surrounding area leaves you with unlimited options of things to do. From the obvious like enjoying the beach, swimming and surfing to over five miles of boardwalk with tons of parks, work out areas, skate parks, pickleball courts, a Par 3 golf course and more. Off the beach, Rockaway has really stepped up its food and entertainment game with several great restaurants within walking distance never mind up and down the rest of the peninsula. Let’s talk transportation. Locally, if your not walking or riding your bike there are free shuttles, buses and the A Train to take you up and down the peninsula. Now with accessibility to Brooklyn, the rest of Queens and Manhattan better than ever, you can be whisked off to the city via Express Bus, the A Train or the NYC Ferry that will get you to Wall St in 55 minutes. So don’t miss your chance to own a piece of The Rock - perfect as a primary home, weekend getaway, or investment opportunity you’ll love everything Rockaway has to offer.

ML# :889196   Modern Duplex Living with Private Roof Deck & PatioDiscover contemporary elegance and flexible living at The Aristo, Astoria’s premier waterfront development. Unit 1G is a thoughtfully designed 1-bedroom, 1-bathroom duplex offering 765 square feet of total interior space, plus a private 352-square-foot roof deck with its own storage closet—providing a rare blend of indoor comfort and generous outdoor living.The main level features an open-concept kitchen and living space. The kitchen is complete with sleek custom cabinetry, marble countertops and backsplash, and premium appliances including a Bertazzoni stove, Liebherr refrigerator, and a Bertazzoni dishwasher. Just off the kitchen, the bedroom offers comfort and privacy, while the spa-inspired full bathroom is adorned with Porcelanosa tiles, radiant heated floors, floating toilet, and an illuminated medicine cabinet—combining sophistication and practicality.The lower level offers a generous open space perfect for a home office, gym, or media room, with a washer/dryer hookup and a large closet for convenience. Whether you’re seeking separation of space or additional room to live and work, this level provides the flexibility to suit your lifestyle.Additional highlights include a Ring camera doorbell, engineered oakwood flooring, central AC & heating and wiring for a Brinks home security system. With on-site parking available for many residences and an elevated common area, The Aristo offers a sophisticated blend of convenience and community. Parking spaces will be prewired for electric car charging.The Aristo is ideally situated for those who value convenience, with easy access to public transportation options including the N and W subway lines, making commuting to Manhattan a breeze. Astoria Park, your backyard, offers a serene escape with its expansive green spaces, walking trails, and stunning views of the East River. The park also features a large swimming pool, tennis courts, playgrounds, and numerous athletic facilities, providing endless opportunities for recreation and relaxation.Photos are virtually staged.The complete offering terms are in an offering plan available from Sponsor. File No. CD24-0044.All measurements and dimensions are approximate and are subject to normal construction variances and tolerances and may vary from floor to floor. Sponsor reserves the right to make changes in accordance with the terms of the offering plan. All images are artist’s renderings for representational purposes only and are subject to variances. Though information is believed to be correct, it is presented subject to error, omissions, changes, and withdrawal without notice. Equal Housing Opportunity.

ML# :H6331031   This immaculate 2-bedroom ranch is perfectly situated on 13.72 sprawling acres, offering a tranquil escape with all the comforts of modern living. Ideal for horse enthusiasts, this property features two spacious horse paddocks with sheds and a barn. Perfectly situated just outside of town, enjoy the best of both worlds—privacy and convenience. A stream running thru the property offers a picturesque feature that enhances the natural beauty of the land. With an open flr plan enjoy a seamless flow between the living spaces. Master suite, second bedroom all on one flr living, whole house generator, huge basement w/radiant heat, this versatile area is perfect for a family room, movie theater, storage or your personal touch. Central air, hardwood flrs, central vacuum! Property receives income from a land lease for battery storage. Amenities:Stall Shower, ParkingFeatures:2 Car Attached,

ML# :888098   Harbors at Haverstraw! All about the views ! Experience luxury living right on the water! Perfectly positioned where the Hudson River meets the lagoon, this stunning four-level townhome renovated in 2019 boasts one of the most desirable locations in the community. A private patio offers the perfect setting for al fresco dining with river views while the expansive rooftop deck showcases serene water views—ideal for relaxing or entertaining. Renovated in 2019, the interior features a designer kitchen with premium finishes and high-end appliances, crafted for both everyday comfort and elegant hosting. The spacious living room boasts soaring 9-foot ceilings, a cozy fireplace perfect for relaxing evenings, and a charming Juliette balcony that invites in natural light and fresh air with river views from every level. The primary suite is a true retreat, complete with a spa-like bathroom (2019) featuring a whirlpool tub, steam shower, and modern finishes. Residents enjoy access to exceptional amenities, including a resort-style pool, spa, fitness center, concierge services, clubhouse, basketball court, playground, and beautifully landscaped grounds and Pet friendly. Enjoy scenic waterfront paths and convenient access to NY Waterway ferry to Ossining and beyond...Welcome Home!

ML# :859435   Lakefront living begins here—where your days rise with shimmering water and end in the embrace of nature’s hush. With your own private dock, you can launch a kayak at sunrise, cast a line at dusk, or simply sit with your thoughts while the light dances on the water. Every season brings something new: summer swims, autumn reflections, winter stillness, and the promise of spring. Whether you’re looking for a weekend escape or a forever kind of calm, this property offers a rare and restorative connection to the lake that soothes the soul and sparks the imagination. Originally reconstructed using materials from the 1939 World’s Fair Swedish Pavilion, the main residence is a three-bedroom, two-bathroom ranch-style cabin set on protected watershed land, with breathtaking lake views from nearly every room. Crafted almost entirely of wood and framed by towering pines, the home features Jefferson and Andersen windows that flood the interior with natural light.At the heart of the home is an open-concept chef’s kitchen, designed for both form and function. Quartz countertops, stainless steel appliances, and custom cabinetry provide a sleek and modern touch, while the seamless flow into the dining and living areas makes it ideal for entertaining or cozy nights at home.The expansive living room centers around a rustic flagstone fireplace—perfect for fireside conversations, family gatherings, or moments of peaceful solitude. Step outside to a covered porch overlooking the calm, reflective lake—once a flowing river, now a tranquil body of water lined with ancient trees. Whether you’re sipping coffee on the lakeside deck, launching a kayak from the private dock, or casting a line into still waters, outdoor living becomes a cherished rhythm of life. Rowboat and two kayaks are included.One of the most exciting features of this offering is the second, buildable 2.51-acre parcel—perfect for adding a guest home, creative studio, or future investment property. Down by the water’s edge sits a charming grandfathered loft cabin, full of potential and ready for renovation, offering even more ways to enjoy this one-of-a-kind lakeside retreat.Scattered across the grounds, you’ll find three useful outbuildings: a utility shed, a wood shed, and a larger structure that could be reimagined as a workshop, bunkhouse, or additional guest space. A deep freshwater well and underground propane tank support modern convenience while maintaining the rustic charm of off-the-grid living. The home is offered fully furnished and move-in ready, currently operating as a successful income-generating Airbnb, making it a turnkey opportunity for both lifestyle and investment.Whether it’s sunrise paddles, evening fires, or stargazing from the porch, this home invites you to slow down and savor each moment. The low-maintenance grounds let nature take center stage, and the surrounding protected land ensures lasting peace and privacy. Lake rights are deeded and fully documented with unrestricted personal use. While commercial operations such as taverns or restaurants aren’t permitted, this property is ideal as a private retreat, legacy compound, or creative escape.

ML# :834118   Welcome to this stunning 7-acre Gentleman’s Farm, offering beauty, privacy, and tranquility. The 3, 200 sq ft home features 4 bedrooms, a formal dining room with a stone fireplace, and a spacious living room with another fireplace and access to a large deck. Enjoy central air, elegant hardwood floors, tray ceilings, and a bright eat-in alcove off the kitchen, with the potential for a Mother-Daughter suite.The property includes a spacious detached garage suitable for an RV or boat, with an impressive workshop above. There’s also a climate-controlled kennel and a 3-stall barn with a tack room and hay loft, surrounded by fenced paddocks. The expansive grounds are perfect for recreational use, with a pond for ice skating in winter. This property is a perfect blend of luxury and functionality for those seeking a serene lifestyle!

ML# :815406   Welcome to this stunning, fully renovated, expanded Cape Cod-style home, where modern updates meet timeless charm. This spacious and light-filled property is perfect for those seeking a beautiful home in an unbeatable location. The home features five generously sized bedrooms, including two oversized bedrooms with ensuite bathrooms, offering comfort and privacy for all. Large windows throughout the home fill every room with natural light, creating a warm and inviting atmosphere. The neutral-toned kitchen is thoughtfully designed with quartz countertops, brand-new stainless-steel appliances, and a workstation sink, combining practicality and elegance in every detail. Each of the three updated bathrooms boasts sleek, modern finishes, blending style with functionality. Located just steps from Freeport’s renowned Nautical Mile, this home offers access to vibrant waterfront dining, shopping, and boating opportunities. It’s also conveniently close to schools and beautiful parks, including Cow Meadow Park, with playgrounds, nature trails, scenic waterfront views, and Milburn Creek Park, perfect for picnics, fishing, and relaxation. This exceptional home is a rare find, combining space, style, and location. Don’t miss your chance to experience everything this property has to offer!

ML# :843244   Boat Lover’s Dream with Over $40K in Home ImprovementsWelcome to 647 Lincoln Street—a picturesque 3-bedroom, 2.5-bath home nestled in the heart of Baldwin Harbor, where timeless charm meets modern coastal living. Situated on a quiet dead-end street, this inviting home offers breathtaking water views, a private boat slip that fits a 22 ft. boat, and a spacious deck perfect for entertaining.Inside, the sun-drenched layout is filled with warmth and character, highlighted by unique windows and thoughtful finishes throughout. The kitchen features stainless steel appliances and a central island ideal for cooking and gathering. The serene primary en-suite boasts a Juliet balcony overlooking the harbor—perfect for morning coffee or unwinding at sunset.This home also includes over $40, 000 in recent upgrades, including new solar panels, an HVAC system, water heater (with a transferable 9-year warranty), dishwasher, washing machine, and dryer—providing modern efficiency and peace of mind.Located just minutes from marinas, parks, the LIRR, and local shops, this home blends tranquility and convenience. Whether you’re boating, entertaining, or simply soaking in the view, 647 Lincoln Street offers a waterfront lifestyle you’ll love to come home to.

ML# :833313   Welcome to luxury living at The Towers at Waters Edge in Bayside, NY! Nestled in the prestigious Versailles building, the central gem of this elegant three-building community, residence 6D stands out as one of the largest and most sought-after layouts available. Boasting approximately 1, 500 sq. ft., this stunning home features a designer chefs kitchen with high end appliances, 3 spacious bedrooms, 2 fully renovated bathrooms, and two private balconies offering serene views. Every inch of the unit showcases custom high-end renovations, designed with both style and functionality in mind. Experience a resort-like lifestyle with access to exclusive amenities, including a private pool club, state-of-the-art gym, steam rooms, sauna, and tennis courts. From the moment you arrive, you’re welcomed by a professional doorman and attentive concierge, ensuring seamless living with package handling, guest hospitality, and more.There is also an active social calendar that the development hosts from themed parties and holiday events. Don’t miss this rare opportunity to own a sophisticated sanctuary in one of Bayside’s most coveted developments!