ML# :3538075   Professional Office Complex! TWO Buildings Approx 7000 sq feet in Total- Beautifully & FULLY Renovated. The Prestigious NAZTOR COMMONS by Route 105! Property FRONTS on NYS Route 25/Main Road and is immediately EAST of County Rte 105! The GATEWAY to both *NORTH and SOUTH* FORKS! Zoned RLC offering many Uses! Ideal Professional office or Satellite Office. Central Air, 7 Bathrooms, Gas Heat/Hot Water, Town Water and Private Septic on 2.52 Acres with Possible Room for Expansion! ! Abundance of customer & employee parking! Currently divided to suit current tenants. Multiple offices within each building. 9’ - 10’ Finished Ceilings. Fully built out as Standard Offices, Many Work stations, 7 Private Bathrooms, and lots of natural lighting here. Everything here is PRISTINE., Additional information: Office Pct.:100, Rental Income:Y, Building Size:7000

ML# :3582776   Sunny and Bright Detached 2 Family House in Little Neck. The House was Built in 2021. South Facing. Each Family Contains: 3 Bedrooms, 2 Full Baths, Living Room, Formal Dining Room. Eat-In-Kitchen. Fully Finished Basement with High Ceiling, Family Room, Play Room, Full Bath and Separate Entry. Central AC, One Car Garage, Nice Backyard Excellent Schools (Ps 94, Jhs 67 and Cardozo High School) Walking Distant to Little Neck LIRR, One Block to Northern Blvd. Close to Buses Q12 and N20. Close to Restaurants, Supermarket (J Mart & H Mart) and Shopping. A Must See., Additional information: Appearance:Mint, Separate Hotwater Heater:Yes

ML# :3563128   Are you in search of a home that offers the perfect blend of modern amenities, comfort, and timeless elegance? Look no further than this beautifully maintained Colonial Split in the desirable Laurel Hollow community. Set on an expansive 2.68-acre secluded lot, this stunning property is ideal for those who love entertaining, relaxing in nature, or enjoying the comforts of home year-round.As you step inside, you’ll immediately notice the bright and open layout, featuring hardwood floors throughout. The main level of this home provides plenty of space for entertaining, with a spacious formal Dining Room and a welcoming Living Room—both ideal for hosting guests or enjoying family time. The eat-in Kitchen is a chef’s dream, equipped with high-end Wolf appliances, including double wall ovens, and an oversized GE Monogram refrigerator. Quartz countertops and ample cabinet space make this kitchen not only functional but also a beautiful focal point of the home. The kitchen opens into the Family Room, which boasts cathedral ceilings, walls of windows and a wonderful woodburning fireplace, perfect for a seamless flow for gatherings, whether casual or formal. One of the standout features of this home is its well-designed split floorplan, offering a balance of privacy and shared spaces. The luxurious Primary Suite is situated on its own level, creating a serene retreat that’s perfect for unwinding after a long day. Throughout the home, there are three cozy wood-burning fireplaces—one in the Living Room, one in the Family Room, and another in the lower level. Whether you’re relaxing by the fire on a chilly winter evening or enjoying a quiet moment in the sunroom, there are plenty of spots to enjoy a warm and inviting atmosphere. The lower level offers a versatile guest suite, perfect for hosting long-term visitors or weekend guests. It features a private bedroom with an ensuite bath, as well as a second family room with its own fireplace. A summer kitchen and a half bath round out this space, which can be accessed through a separate entrance—ideal for maintaining privacy.The beauty of this property extends well beyond the walls of the home. Step outside to discover the expansive 2.68-acre lot that provides ample room for outdoor activities. The private in-ground gunite pool and large brick patio are perfect for everything from summer barbecues to peaceful evenings under the stars. Brick walkways lead you from the covered entry to the lower level, where the summer kitchen offers even more convenience for entertaining during the warmer months. Whether you’re lounging by the pool in the summer, watching the vibrant fall colors, or enjoying a cozy winter evening by the fire, this property provides a welcoming atmosphere for every season.With a whole-house generator and a three-car detached garage, this home is not only beautiful but functional as well. Located within Cold Spring Harbor School District #2, with access to Laurel Hollow Beach (membership dues required), this property offers a rare opportunity to live in one of the area’s most sought-after neighborhoods.If you’re looking for a home that offers luxury, comfort, and an exceptional lifestyle, this Colonial Split is truly one-of-a-kind. Don’t miss out on the chance to make it yours!

ML# :3561589   Rare opportunity to own a detached and updated legal 3 family investment property on a double lot in Astoria’s desireable Upper Ditmars area. The house features 4 bedrooms, 3 baths, a private 3 car driveway, a sizeable backyard, a large attic, and 3 boilers and 3 hot water heaters. The first floor offers (2) one bedroom apartments with separate entrances along with an eat-in kitchen, living room, and a full bath in each. The second floor offers a very spacious two bedroom apartment with its own separate entrance, a large eat in-kitchen, breakfast area, an oversized living room and dining room fit for entertaining, and a full bath. A truly one of a kind residence. One block from Ditmars Blvd. where Q69 bus is on, direct access to Ditmars Station (N, W trains) and Queensboro Plaza (7, N, W). Close to major shopping and near LaGuardia airport. PS 151 Elementary School, IS 141 Middle School, William Cullen Bryant High School. Great investment opportunity. Financials are available upon request, Additional information: Appearance:Excellent, Separate Hotwater Heater:Yes

ML# :3574213   Welcome to your dream home in the heart of North Fork’s renowned wine country! This stunning new construction, completed in 2024, offers the perfect blend of modern luxury and timeless elegance. Nestled just steps away from the serene waterfront and a mere five-minute drive from the charming downtown of Greenport and its surrounding wineries, this custom-built masterpiece is an unparalleled find. Spanning 4, 122 square feet, this home boasts 5 spacious bedrooms and 4.5 beautifully appointed bathrooms. The moment you step inside, you’ll be captivated by the 22-foot vaulted ceilings that create an open, airy ambiance. The living area is anchored by a cozy gas fireplace, perfect for chilly evenings, while the gourmet kitchen is a chef’s delight. It features pristine quartz countertops, a center island with a dramatic waterfall edge, and top-of-the-line appliances. Entertain in style in the elegant dining room, complete with a bar and wine fridge-ideal for holiday gatherings or intimate dinners. The main floor also includes a convenient laundry room and a mudroom with direct access to the backyard porch. Exquisite details abound, from the glass panel railings and custom wood ceiling beams to the rich 7-inch oak wood plank floors that run throughout the home. The primary suite, located on the first floor, is a true retreat with sliding glass doors that open to the outdoor porch-perfect for unwinding with a glass of local wine as you watch the sunset. The suite also features spacious walk-in closets and a luxurious en-suite bathroom with a large soaking tub for ultimate relaxation. The second floor is equally impressive, offering four additional bedrooms, each with ample closet space, and two full bathrooms. Designed with entertainment in mind, the backyard is a private oasis, complete with an outdoor kitchen and a stunning in-ground pool. This home is a sanctuary where family and guests can gather, relax, and create lasting memories. Don’t miss this rare opportunity to own a piece of paradise in one of Long Island’s most sought-after locations., Additional information: Interior Features:Guest Quarters, Lr/Dr, Separate Hotwater Heater:1

ML# :817946   Development opportunity Vacant land for sale 148-11 & 148-07 15 ave block4865/4645- lot 31/33- zoning :R3aApproved plan for 2 x2fam

ML# :816493   Discover your Dream Home in the Highly Sought-After Harbour Green Community! This Impressive 5 Bedroom, 3 Full Bath Residence Offers an Unparalleled Waterfront Lifestyle on a Deep Water Canal with 127’ of Bulkhead - Perfect for Boating Enthusiasts.This Lovely Home Boasts an Inviting Floor Plan, Ideal for Entertaining and Everyday Living. The Bright and Spacious Eat-in-Kitchen is the Heart of the Home Featuring a Separate Breakfast Nook that Offers the Perfect Spot to Enjoy your Morning Coffee while Taking in the Serene Views of the Water while the Evenings Offer Incredible Sunset Views. The Gourmet Kitchen Features Top of the Line S/S Appliances which includes a Viking Gas Oven, Thermador Wall Oven and Warming Drawer. The Kitchen Opens to the Formal Dining Room, Making it Perfect for Hosting Large Gatherings. The Living Room Features Custom Built-ins with a Gas Fireplace Perfect for Cold Winter Nights. The Large Den with Wet Bar and Gas Fireplace is Perfect for Entertaining. Adjacent to the Den is a Dedicated Home Office Space and Gym Which Can be Utilized as an Additional Bedroom Offering Flexibility and Functionality. Four Bedrooms are Located on the Second Floor which includes a Large Primary Bedroom with High Ceilings and Ensuite. The Finished Basement Offers Additional Living Space and Ample Storage. The Highlight of the Outdoor Space is the In-ground Pool, Hot Tub and Outdoor Kitchen and Covered Outdoor Seating Area Creating a Personal Oasis to Relax and Unwind.

ML# :808169   EXCELLENT INVESTMENT OPPORTUNITY - MIXED-USE IN ASTORIA - PRIME LOCATION - 5 Residential Units Plus Commercial Storefront - Highly Rentable Units in the heart of Astoria, in the Steinway-Ditmars Area - Located on STEINWAY STREET, just 1 block to DITMARS BOULEVARD - SETUP: 1st Floor Front – Commercial Space / 1st Floor Rear – 1-Bedroom Apartment / 2nd Floor – two 1-Bedroom Apartments / 3rd Floor – two 1-Bedroom Apartments / Basement – full, unfinished basement with access from both front and rear of building LOT SIZE: 20X100 / BUILDING: 20X73 / TAXES: $15, 009 / ZONING: R5D - LOCATIONLocated in the heart of Astoria, the Steinway/Ditmars area is local to everything, with a diverse selection of restaurants, shops, schools, parks, and several convenient transportation options just minutes away. TRANSPORTATION - 20-minute subway ride to Manhattan, 8-Minute walk to N/W trains, Steps to Q101, and Q69 bus lines. Easy access to all major highways, thoroughfares and bridges. LOT: 20x100 / BUILDING: 20x73 / TAXES: $15, 009 / ZONING: R5D

ML# :816343   Gorgeous and private haven on two acres with pool and pool house——just 40 minutes from midtown Manhattan! This 6100 sq ft home has been renovated and expanded to offer the perfect lifestyle. Located on level and beautifully landscaped property in a pretty neighborhood, the home is perfect for relaxation or entertaining. It has a large family room with fireplace, a formal dining room overlooking the beautiful yard and a charming living room with fireplace. The chef’s kitchen boasts Sub Zero refrigerator, Viking double range, Fisher & Paykel dishwasher, a wine cooler and a breakfast area with the serene view of the property. There are four large bedrooms and three and one-half baths. The primary suite is a private oasis, with balcony, sitting area, extensive closets and fireplace. The spa-like primary bath has a large soaking tub as well as an ample shower and double vanity. Plenty of bonus space for office and exercise or art studio. Enjoy lounging by your pool with a convenient pool house just steps away. Complete with stone patios, walks and lovely landscaping, this charming estate is the perfect choice!

ML# :815387   Stunning waterfront restaurant for sale, offering breathtaking views and a prime location. This property features a spacious dining area, modern kitchen, and two additional office spaces, perfect for extra income or operational needs. A rare opportunity to own a thriving business with endless potential!