ML# :912330   **READY FOR IMMEDIATE OCCUPANCY!**One of Only 2 Top-Floor Homes Remaining – A Rare Waterfront Opportunity. Experience the epitome of luxury living at Unit 3C, a premier townhome-style condo at The Aristo, Astoria’s most coveted waterfront residence. Designed for both entertaining and relaxation, the expansive living space is enhanced by floor-to-ceiling sliding glass doors that seamlessly connect to your private balcony, where sweeping water and city views create a breathtaking backdrop.The chef’s kitchen is a true showpiece, featuring marble countertops and backsplash, custom cabinetry, and premium appliances including a Bertazzoni stove, Liebherr refrigerator, and dishwasher. Whether preparing a gourmet meal or hosting guests, this elegant space elevates every occasion.The serene primary bedroom offers a spacious closet, a spa-like en-suite bath with Porcelanosa tiles, and access to a private balcony for quiet mornings or evening relaxation. A generous second bedroom with ample closet space provides versatility for guests, a home office, or personal retreat.For the ultimate outdoor escape, ascend to your private 518 SF roof deck, a true urban sanctuary with panoramic city and waterfront views—perfect for sunset entertaining or peaceful solitude.Additional highlights include oak wood flooring, 8-foot doors, built-in Vessel Bluetooth speakers, Ring doorbell camera, Brinks security wiring, and washer/dryer hookup. Every detail balances modern convenience with timeless luxury.With on-site parking available (prewired for EV charging) and a beautifully designed common area, The Aristo combines sophistication with community. Its prime location provides effortless access to the N/W subway, while Astoria Park—with its expansive green spaces, pool, tennis courts, and waterfront trails—becomes your backyard retreat.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# :911602   Perched above Kingston yet just steps from the city’s vibrant heart, this Art Deco–inspired residence is a rare fusion of glamour and nature. Set on 8.5 private acres with sweeping mountain vistas and a tranquil pond, the home feels worlds away while remaining walkable to uptown Kingston. Recently reimagined and meticulously renovated, it rises three levels with a striking mix of architectural drama and modern comfort—perfect for those seeking a one-of-a-kind escape without sacrificing convenience.Inside, the surprises are endless. A soaring two-sided stone fireplace anchors the main living space, where elegant dark hardwood floors meet walls of glass that open onto a broad deck with dramatic mountain views. The chef’s kitchen is as functional as it is stylish, outfitted with state-of-the-art stainless steel appliances, a breakfast bar, and an adjacent vaulted dining room framed by Venetian windows. Two deluxe bedroom suites—each with spa-like ensuite baths—offer private retreats, while flexible bonus rooms can transform into a home office, creative studio, or playroom.The property itself is no less impressive. Mature trees frame wide-open lawns and mountain views, creating an atmosphere of serenity and grandeur. From your deck you’ll hear the breeze, spot the pond glimmering in the distance, and still know that Kingston’s Rondout waterfront, Midtown arts scene, and the historic Stockade District are minutes away. With Woodstock, New Paltz, Rhinebeck, Mohonk, and the Catskills all within half an hour, this home is more than a residence—it’s a gateway to the best of the Hudson Valley.

ML# :901803   Enjoy the most breathtaking water views in Stony Brook Village from this charming 1926 Colonial. Ideally located on .4 acres, this 4–5 bedroom home overlooks West Meadow Creek and the Long Island Sound, capturing spectacular westerly sunsets. A welcoming Dutch door opens to a home rich with architectural character. The spacious living room features a wood-burning stove framed by wood paneling, French doors, and sweeping water views. A cozy library with built-in shelving and cabinets offers the perfect setting for a home office. The formal dining room is accented by built-in corner cabinets and French doors leading to a wooden deck, ideal for outdoor entertaining.The kitchen boasts granite countertops, stainless steel appliances, and a gas range, while the family room’s wall of windows invites year-round enjoyment of the surrounding wildlife along West Meadow Creek. The efficient, state-of-the-art Navien gas heating system and central air conditioning provide modern comfort throughout the year.Situated in the heart of the Village, this exceptional property offers sidewalks to shops, restaurants, and Avalon Park—making it a rare opportunity to combine timeless architecture with an unbeatable waterfront setting.

ML# :881384   Don’t miss this incredible opportunity to own a semi-detached 2-Family home in prime location of Corona. The highly desirable area is perfect for investors or end-user looking for income generating potential. R5 zoning lot of 37x100, offers flexibility and potential for expansion or additional floor area ( please consult with your architect). This home has 3 floors, no basement. Featuring first and second floor are duplex apartments with 4 bedrooms and 2 full bath. 3rd floor has 3 bedrooms and 1 bath. Private driveway and huge backyard can park up to 6+ cars.

ML# :863105   Great location on busy area, 2 office with one store.

ML# :936885   Welcome to this rare 5-bedroom, 3.5-bath expanded split-level home located in the highly sought-after Syosset School District—one of the top-rated districts on Long Island. This spacious and beautifully updated residence offers the perfect blend of modern living, comfort, and convenience.Step inside to an open-concept main level featuring a recently upgraded kitchen seamlessly connected to the living and dining areas—perfect for entertaining. The home includes hardwood floors, recessed lighting (hi-hats), and a bright, modern layout throughout.Enjoy a cozy den with sliding doors that lead to an exceptional backyard oasis, complete with a large deck and mature privacy trees, ideal for gatherings or quiet relaxation. Additional highlights include a brand new roof, young boiler and hot water tank, and a finished basement offering extra living space or storage.A 2-car garage provides added convenience and functionality and natural gas is already available on the block for those who wish to convert. Located close to top-rated schools, shopping, major highways, and the LIRR, this home offers the best of suburban living with unbeatable accessibility.Don’t miss the opportunity to own this rare gem in Syosset!

ML# :932988   Welcome to 111 Farrington Ave! A beautiful 3 bedroom, 3 bathroom, single family home located in the desirable Hudson River neighborhood of Philipse Manor in Sleepy Hollow, New York. The tastefully updated home features high-end renovations throughout the entire 2, 360 square feet. Upon entering this beautiful home you will take note of the restored white oak hardwood flooring that runs throughout the entire first and second level of the property. To the left of the entranceway is a large living room with wood-burning fireplace featuring beautiful oversized windows that flood the South-facing home with natural light. Located just opposite the living room is a stunning modern kitchen that features quartz countertops, European style acrylic cabinets, Bespoke glass appliances and large-format tile flooring. The eat-in kitchen is spacious with counter stool seating making it a perfect spot for morning breakfast or coffee. An added bonus space just off the kitchen is a lovely covered balcony perfect for grilling or just relaxing outside in the peaceful tranquility of Philipse Manor. Located conveniently beside the kitchen through a charming pocketdoor is a spacious formal dining room perfect for hosting meals. A couple of steps up from the main living area you will find the bedroom level with 3 spacious bedrooms and 2 full bathrooms. The primary bedroom features 2 closets (one of which is a large walk-in closet) and ensuite bathroom with a floating vanity, standing shower, and tasteful finishes. Inside the walk-in closet there are pull-down stairs that lead to a full-sized attic, perfect for all of your storage needs. Down the hall you will find 2 more spacious bedrooms and an entire hallway of closets. Each bedroom easily fits a queen bed and has its own spacious closet. At the end of the hall is a renovated bathroom with deep soaking tub, shower, and detailed tile work. Located on the lower level, you will find some of the best features this property has to offer. This incredible space is defined by high ceilings over 9’, custom built cabinetry, and recessed lighting. There is large bonus room with ensuite bathroom that would be perfect as an home office, exercise space, or however you can imagine. The lower level features sliding glass doors that lead to a covered patio and spacious backyard, perfect for alfresco dining. There is a large mechanical room off the lower level that features a workshop and laundry space with additional storage closets and direct access to the attached 2-car garage. While this home is truly something incredible, we invite you to explore the surrounding neighborhood of Philipse Manor. This home is just a short stroll to the Philipse Manor train station (just a 42 minute express commute to Grand Central Station), the Old Croton Aqueduct Trail (a 41-mile trailway popular with runners), the newly built Hudson Riverwalk, Rockefeller State Park Preserve, and Main Street Tarrytown for all your shopping and dining needs. We invite you to join the Philipse Manor Beach and Boat Club exclusive for residents of Philipse Manor. This community is truly something special, between the proximity to Midtown Manhattan and the peaceful tranquility of the Hudson River. Reach out to Brian Ippoliti today, this one won’t last long!

ML# :932062   Welcome to this fully detached, beautifully renovated one-family home, where timeless charm meets modern luxury. Gut-renovated from the ground up just 3 years ago, this residence offers a new roof, new plumbing and electrical systems, new central A/C unit and a water tank—providing comfort and peace of mind for years to come. Inside, you’ll find a custom-built kitchen with premium finishes, 2.5 tastefully designed bathrooms on each floor, and elegant details throughout, including new parquet floors, doors, and fixtures. Fireplace and window mosaics on all floors add charm and exclusivity to this home, while the full finished basement and attic provide versatile space for relaxation, storage, or recreation. Outdoors, enjoy a beautifully maintained front and backyard, perfect for entertaining or quiet evenings at home. A private driveway on 30X100 lot with room for up to 4 cars and a detached garage offer both convenience and value. Ideally situated in an excellent location, this home is close to everything you need—shopping, schools, transportation, and more. Move-in ready and meticulously cared for, this property is a rare opportunity to own a truly turnkey residence that blends comfort, style, and convenience

ML# :931838   Stunningly Fully Renovated / Rebuilt Two Family Home, Where Modern Elegance Meets Todays Functionality. Each Unit Boast Three Spacious Bedrooms & Two Full Baths, Including A Master Suite With A Private Bath. The Open Concept Layout Is Enhanced By Modern Finishes And Hardwood Flooring Creating A Warm And Inviting Atmosphere. The Kitchens Are Equipped With Stainless Steel Appliances. A Fully Finished Basement With A Full Bath, Laundry Hook- Up & An Outside Entrance. Enjoy The Convenience Of A Wide Private Driveway Making For Ample Parking. This Home Is Located Close To All Conveniences. Would Not Last !

ML# :913454   Quiet Ditmars block—brick two-family with parking & yard!Looking for a home on a quiet block in the Ditmars section of Astoria? Look no further. This semi-detached, original brick two-family is set back behind a front garden and flooded with light and cross-breezes. Interiors feature high ceilings and hardwood floors. The rear yard is made for entertaining and includes additional off-street parking. A full, finished basement with high ceilings adds flexible bonus space. Delivered fully vacant.Just a short stroll to the Ditmars Blvd N/W, with expanded bike lanes along 20th Ave for easy neighborhood access. On a full 25 × 100 lot, this property works beautifully as an investment, an owner-occupied multi-family, or—subject to approvals—a conversion to a large single-family townhouse. Solid brick construction currently refaced with vinyl siding.