ML# :911428   Detached large single dwelling home located in the heart of North Flushing! The total living area is 2, 247 square feet, with three stories above ground. There is a fully finished basement with a separate entrance, offering maximum living space with a flexible layout. The house was completely remodeled three years ago and features a beautiful backyard garden, a large paved deck, and is comfortable and clean! It has central cooling and split AC units. Conveniently located near the Long Island Rail Road and Northern Boulevard.

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# :868621   Welcome to Residence #5C at 39-16 Prince Street-a beautifully maintained 2-Bedroom, 2-Bathroom Condo located in the heart of vibrant Downtown Flushing. This sun-drenched corner unit offers a spacious layout with-bright Large windows, filling the home with natural light and showcasing open city views South and East explosion. As you see the floor plan there is huge beautiful balcony facing south, bring you private, relax space in downtown flushing.The modern kitchen features granite countertops, stainless steel appliances, and ample cabinet space, perfect for home chefs and entertainers alike. Both bedrooms are generously sized, with the primary suite boasting a private en-suite bathroom to ultimate comfort and privacy.Additional highlights include hardwood rollers throughout, in unit washer/dryer hookups, and central heating and cooling. The building is elevator-equipped with security guard and offers low common charges and a tax abatement, making this and excellent opportunity for both end-uses and investors.Conveniently located just steps from Main Street the 7 train, LIRR, supermarket, restaurants, doctor’s office hotels and much more! Do not miss your chance to own a prime condo in one of Queen’s dynamic neighborhoods!

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# :928443   brand new 2family with 3bedroom and 2fbth on each floor, finish basement with high ceiling can be shown anytime through Lb 347-528-5327

ML# :926252   Luxury meets majesty in the prime of Chestnut Ridge. Nested on an almost acre of well maintained lush property this contemporary colonial stands out with it’s many upgrades and high end finishes. Lovely front porch welcomes you into the grand 2 story entrance with detail and design, high ceilings, and sunlight streaming in from the skylights. The over sized dining room awaits ready to host and entertain. Luxurious built in wet bar with sink, dishwasher, mini kitchen and freezer. The kitchen with it’s wistfully white granite countertops and custom made cabinetry designed for optimal orderliness and convenience, is a haven for every homemaker. The kitchen island with it’s tasteful design and style complements this beautiful picture. Sliding doors lead to the large deck an oasis of privacy and shade . Lovely living room open to the kitchen with electric fireplace and exquisite moldings. Additional main level features: a study, full bathroom, and laundry area. On the upper level the majestic master suite has been thoughtfully designed and includes sitting area, grand huge master bath with hot tub and double vanity, and oversized bay windows inviting the sunlight. 3 additional bedrooms with full bathroom, each spacious, elegant, and sunny. The finished lower level has a family room additional bedroom and beautiful full bathroom. The house in all it’s grandeur is truly a cut above and will make every future homeowner proud.

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.