ML# :816246   Spectacular One Of A Kind Home & Location For This Breathtaking Contractor’s Own 4659 Square Foot Post Modern Home With All High End, Top Of The Line Custom Details & Finishes On A Private Flag Lot Just Steps From The Pathway To A Private Long Island Sound Beach (Association Dues Are $400 Per Year) In The Beautiful Sought After Sunset Bluffs Community In Miller Place (Also A Perfect Second Home/Summer Getaway With It’s Private Location & Proximity To The Beach). All Top Of The Line, Exquisite Features & Upgrades, A Stylish & Sophisticated Home Designed For Both Indoor & Outdoor Living/Entertaining Offering An Elegant, Spacious Open Floorplan - Greeted By A Two Story Entrance Foyer With An Open Stairway, All Custom Woodwork/Trim & Large Circle Topped Window, Magnificent Great Room With 30’ Ceilings, Showcase Focal Point Two Story Fireplace With All Carved & Inlaid Marble, Circle Topped Windows, Hand Painted Faux Finished Walls, Hardwood Floors & Triple Andersen Doors To A Deck & Backyard, Breathtaking Sunroom With Glass Multipanel Walls & Ceilings, Double French Doors To A Deck Overlooking The Pool & Marble Tiled Floors. The Magnificent Chef’s Kitchen Offers Stunning Custom Cabinetry, Beautiful Custom Moldings, Details & Trim, Expansive Granite Countertops/Serving Areas, Italian Copper & Marble Farm Sink, Two Separate Barstool Areas, Five Star Stainless Steel Range With Six Burners, Grill & Two Separate Ovens (One Gas & One Electric), Cherry & Oak Hardwood Floors With Accent Mosaic Tile Inlays, And A Stunning Custom Bar With Arched Brick Walls, Beautiful Accents, Granite Counters & Sink. An Additional Game Room Offers Entertaining Space Between The Kitchen & Great Room, & A Sun Filled Two Story Dinette Area Offers Room For A Very Large Table, Two Sets Of Sliding Doors To The Back Deck, All Accent Andersen Windows Above & Venetian Plaster Accent Wall. Off Of The Entrance Foyer Is A Banquet Sized Formal Dining Room (Or 4th Bedroom) With Custom Moldings, Two Large Windows With Custom Draperies & Faux Painted Walls. A Stunning Powder Room Offers A Full Cut Stone Accent Wall & Custom Cherry Vanity, & A Comfortable Den/Family Room Offers Ample Room For Furniture, A Large Andersen Window For Natural Light, Faux Painted Walls, Venetian Plaster Accent Wall & All Custom Curtains/Draperies. A Large Main Floor Bedroom, Stunning Renovated Guest Bath With Vaulted Ceilings, Skylight, Slate & Beach Glass Tiled Floor, Blue Marble Topped Vanity & An Oversized Shower, & A Side Entry 2 1/2 Car Garage (With Steel Beams - No Columns - Perfect For Auto Enthusiasts) Completes the 1st Floor. The 2nd Floor Offers Glass French Doors To A Stunning Primary Bedroom - Offering Faux Finished Walls, A Door To A Juliet Deck With Beautiful Waterviews, Ample Room For Furniture & A Large Walk In Closet With Custom Built Ins/Closet System. The Magnificent Primary Bath Offers A Sunken Jacuzzi Tub With All New Glass/Mosaic Tile, Vaulted Ceilings, Skylight, Large Separate Shower & Custom Vanity, & Off Of The Primary Bedroom Is An Expansive Loft Overlooking The Dinette Area With Two Skylights & This Could Easily Be Converted Into An Additional Primary Bedroom Suite. The Lower Level Of The Home Offers A Fantastic Game Room/Pool Table Room, Lovely Full Bathroom, Amazing Media Room, Sitting/Living Room & An Entrance To The Backyard, And Top Of The Line Systems Including A Buderus Gas Propane Heating System, April Aire Humidifier, Multiple Upgraded Electric Panels, 3 Zone Heating, 3 Zone Central Air Conditioning & A 550 Gallon Propane Tank, The Exquisitely Landscaped Property Is Wrapped In Stunning Landscape, Tall Privacy/Shade Trees & Hedges, Estate Iron Fencing & Cut Stone Lighted Columns Wrap The Dazzling Country Club Entertainment Area Offering A Hidden Pond Natural Shaped Heated Saltwater In Ground Pool, Expansive Paver Patios/Pool Surround, Accent Stone Inlays/Trim, and Multilevel Decking. The Home & Location Are Truly One Of A Kind, Spectacular & A Must See!

ML# :910363   This charming colonial-style home in a quiet neighborhood is ready for its next chapter—and it won’t stay on the market long! Inside, you’ll find gleaming mahogany wood floors, spacious rooms with plenty of storage, a finished basement perfect for family gatherings or extra living space, and a porch for organizing plus the convenience of a private garage. Just steps from two bus lines (Q16/Q15) to Flushing, close to the LIRR, and only 30 minutes to Manhattan, it’s the ideal blend of comfort, character, and accessibility for today’s busy families. Schedule your showing today before it’s gone!

ML# :909766   Absolutely unique and gorgeous 1, 458 sq ft duplex condo located in the heart of Bayside. 3rd floor unit with rare high ceilings. Living room with ceiling fan, updated kitchen/dining room with stainless steel appliances and granite countertops, huge master bedroom and updated large bathroom are on the 1st level. Updated built in washer and dryer. 2nd level is a duplex to the third floor that features two bedrooms, updated large bathroom and a bonus room/den that can be used as an office or storage. The 2nd level features skylights that brings in natural sunlight to make it a stunningly bright home. This condo is located just one block away from Bell Blvd and Northern Blvd. Bayside LIRR is just 2 blocks away ! Great location with easy access to shopping and transportation.

ML# :889306   Welcome to The Farrington** A Brand New Luxury Hotel-Condominium Building with 100 Luxury Residences. Designed by World-Renowned Interior Designer Andres Escobar, Unit 10K is a modern residence featuring: - 2 Beds/2 Baths 863sqft - Balcony 90 sqft - Floor-to-Ceiling Windows - Oak Wood Flooring - Radiant Heated Bathroom Floors - Gourmet Chef Kitchen with High-End Appliances Enjoy the benefit of 421-A Tax Abatement & Immediate Occupancy. **Amazing Amenities:** - Recreation Room - Rooftop Lounge with 360-Degree Panoramic Views of Manhattan & Queens - Beautifully Landscaped Roof Terraces with Outdoor Furniture and BBQ Areas - State-of-the-Art Fitness Center - Indoor Swimming Pool - Indoor Recreation Room - 24-Hour Concierge - Video Intercom - 186 Parking Spaces - 15 Electric Car Supercharger Stations Conveniently located near #7 Train, LIRR, and Multiple Bus Lines. Easily accessible to Shops, Popular Restaurants, and Cultural Centers.

ML# :875431   Welcome home to this stunning High-Ranch single-family house, complete with a fully permitted accessory apartment! Nestled on a massive, serene 0.46-acre flat lot in a peaceful community, this property offers exceptional space, value, and the ultimate in indoor-outdoor living – perfect for raising kids and entertaining.First Floor (Renovated 2017): Completely renovated in 2017, this level features two bedrooms, one full bathroom, a formal living room, and a bright dining area that flows into an open kitchen (featuring stainless steel appliances and a dishwasher). Second Floor: Enjoy 3 spacious bedrooms, 1 full bathroom, a formal dining room, and a generous living room flooded with light. The open kitchen here features a high ceiling and a skylight, wood cabinets. Plus, dining room sliding doors lead to a wood deck – your prime spot for BBQs and sunset views! Key Feature: Includes a fully legal accessory apartment with proper permits, offering excellent potential or flexible space for family, guests, or a home office.Outdoor Oasis - This is Long Island living at its finest. The sprawling, flat, fenced backyard is HUGE (almost half an acre!), offering endless possibilities: play, garden, expand, or relax. Enjoy parties, family time, or quiet nights under the stars.Prime Location - Unbeatable convenience. Close to all major highways (for an easy commute or city escape), tons of shopping, restaurants, and the LIRR for a stress-free ride into the city.Top-Rated Schools: Situated within the award-winning Half Hollow Hills School District, a major draw for families.Tax Advantage: Seriously low taxes for what you get! Only $13, 569.17.Discover the perfect blend: modern updates, a versatile living space (including a legal 2-bedroom apartment), a huge private yard, fantastic decks for entertaining, top schools, and an unbeatable location. This isn’t just a house, it’s the Long Island lifestyle you’ve been looking for. Don’t miss out!

ML# :874067   Two Dwelling house in the convenient location of College Point. Close to shopping. Bus stop right at the block.

ML# :868052   Location, Location, Location! Located in the Heart of Flushing. One Block to Main Street. 24 Hour Doorman. Convenient Shops, Restaurants, Supermarkets and Transportation. All Information, Including But Not Limited To: Taxes, Lot Size, Etc. Are Not Guaranteed And Must Be Independently Verified. Board Approval is needed.

ML# :864092   Discover the perfect blend of comfort and investment potential with this lovingly maintained semi-detached 2-family brick home in the heart of Middle Village, Queens. With a 3-bedroom apartment over 1-bedroom apartment, this home is perfect for buyers to live in or for generating rental income effortlessly. Both apartments feature a spacious living room, dining room, a full bathroom, and kitchen, and each apartment is adorned with ample storage space and drenched in natural light with many windows throughout. The basement is fully finished with excellent ceiling height with plenty of windows, a full modern bath, and additional storage space. This home also features your very own private yard with new paving stones, offering you and your loved ones a peaceful oasis away from the everyday hustle and bustle of Queens living. Additional features include a new gas hot water heater and gas boiler, as well as a party driveway for easy parking. Conveniently located near The Shops at Atlas Park, Metropolitan Avenue for ample shopping and restaurant options, as well as easy access to public transportation, including the Q29, Q47, and Q54 local bus lines. Excellent opportunity for a 1031 exchange. Vacant on title.

ML# :823896   Beautiful Legal 3 family Brick House .Very Well Maintained , All Utilities are separately, Great Location ! Short Walk to 2, 5 Subways, House Could be Well Incomes Producer! Paying Very Low Property due to Tax Abetment! Great Opportunity For New Owner!

ML# :862092   Introducing Eastone Plaza, Flushing’s newest luxury condominium. Ideally located in a prime, central neighborhood, Eastone Plaza offers unmatched convenience with easy access to shopping, dining, top-rated schools, parks, and public transportation. Completed in 2025 to the highest standards, this striking mid-rise development features 175 contemporary residences, thoughtfully designed to suit modern lifestyles, with layouts ranging from studios to spacious three-bedroom homes. Each residence is outfitted with premium finishes, including engineered wood flooring, floor-to-ceiling double-glazed soundproof windows, multi-zone heating and cooling, and a Latch keyless entry system with intercom. The kitchens showcase a full suite of BOSCH appliances—including an in-unit washer and dryer, dishwasher, and 3-speed range hood—alongside custom cabinetry, quartz countertops and backsplash, and Grohe fixtures. Bathrooms are elegantly appointed with LED-lit medicine cabinets, premium Grohe fixtures, TOTO smart toilets, walk-in showers, and bathtubs in select units. Many homes also feature private balconies or terraces. Residents enjoy a robust array of amenities, including a fully equipped fitness center, a stylish lounge with a coffee station, an indoor children’s playroom, a beautifully landscaped second-floor terrace with BBQ grills and ample seating, and a private outdoor dog run. Additional conveniences include a full-service concierge available seven days a week, three high-speed elevators, a dedicated package room with Amazon Hub, and an intercom system in every unit. The building also offers 154 parking spaces, as well as private storage and bicycle storage, all available for sale. Now is the perfect time to make Eastone Plaza your new home. Discover the unmatched comfort, style, and convenience of Flushing’s premier new condominium.