ML# :3550261   180 Degree BREATHTAKING WATER VIEWS & SUNSETS. Imagine waking up to breathtaking panoramic views of the Long Island Sound -moments from the Sound View Beach. Or...lounging on your roof deck enjoying the sounds of the water and the incredible water views.... or even enjoying the fireworks display on the Fourth of July. This isn’t just a house, it’s a lifestyle. This ULTIMATE WATERSIDE home offers over 5800 SF of space, spread throughout multiple levels of luxurious sundrenched rooms, from a finished lower level to a 4th floor roof-top deck. The 5 EnSuite bedrooms with spacious closets provide a tranquil retreat after a day of enjoying the coastal lifestyle. Not to mention the wrap around decks where you can catch sunsets year-round. This luxurious PARADISE features many amenities including a SPARKLING POOL for refreshing dips on a hot summer day. And for those who love spending time on the water, in addition to the 3-car attached garage, there’s the 1.5 car detached garage, providing additional room for your boats complete with a huge storage area on top for your gear. This exceptional property boasts low taxes and a convenient rental permit, allowing you to explore income generating possibilities, or welcome loved ones for extended stays.

ML# :809084   Welcome to Luxury Living! This stunning 5-bedroom, 3.5-bathroom residence offers the epitome of modern living. Boasting over 4, 200 of living space, this recently renovated home features: Luxurious Master Suite: Indulge in the spacious master bedroom on the first floor, complete with a walk-in closet and a luxurious ensuite bathroom.Entertaining Spaces: Two inviting living rooms provide ample space for relaxation and gatherings. Gourmet Kitchen: The heart of the home, featuring a magnificent kitchen with a massive island, perfect for culinary adventures and entertaining guests. Outdoor Oasis: Enjoy the beautiful outdoors with an inviting pool, a relaxing outdoor bar area, and two balconies offering breathtaking views. Additional Features: Two fireplaces, 3 out of 5 bedrooms with ensuite bathrooms, a 2-car garage, and ample storage space complete this luxurious package.Don’t miss this opportunity to experience the ultimate in refined living!

ML# :3588518   THE ARTIST STUCCO COLONIAL, SITUATED IN THE HISTORIC DISTRICT OF DOUGLAS MANOR, IS WAITING FOR YOU TO VISIT. THIS METICULOUSLY MAINTAINED SIX BEDROOM, 3.5 BATH HOME CHECKS ALL YOUR BOXES. This home has many desired features, such as, 9 ft ceilings, open concept, hardwood floors, gas fpl, large eat-in-kitchen, Formal Dining Room, Large Living Room, Den and powder rm. plus walk in closet and central vac for your convenience. The 2nd floor boasts three bedrooms 2 baths plus sitting area with balcony with views of Manhattan Skyline. The third floor has three bedrooms and one bath with walk in closet, and views of Manhattan. Four zone heat, two Zone CAC, two car detached garage with hobby loft. Pocket doors, new sprinkler system, stained glass windows, Pella windows, cedar deck, alarm system, unfinished basement with mechanicals. This home is part of 595 homes surrounded by Little Neck Bay. The private dock shared by this community gives access to boating, kayaking and just enjoying the beautiful sunsets. Many conveniences are at your fingertips such as the LIRR, restaurants, express buses, schools and Douglaston Village. This can be a home for anyone’s lifestyle. Three full floors of living space gives everyone a private spot. There are a few chandeliers that are being replaced and the ring doorbell is going with the owner., Additional information: Appearance:GOOD, Separate Hotwater Heater:1

ML# :3583358   Hidden Meadow Stables is a stunning Long Island Equestrians Dream nestled on 2.55 private acres. This property consists of the Main home, a 4-stall barn, 2 Riding rings, 1.5 car garage and a guest cottage. The Main home is a 3 br 2.5 bth colonial w/an inviting new Trek front porch w/Aztec trim, Formal Living Room w/woodburning fireplace, Formal Dining Room an updated (2022) Eat in Kitchen w/Wolf Stove, Sub-Zero Fridge, Bosch Dishwasher, Marble Countertops w/under cabinet and counter lighting. There is a laundry room and a guest bathroom. The second floor: Primary suite w/updated (2021) bathroom w/radiant floor, lrg walk in shower, free standing bathtub and walk in closet. There are 2 additional bedrooms and a full bathroom. There is a full finished basement w/pool room & bar. The updated (2022) guest cottage consists of 1 bedroom, LR, 1.5 Baths, split ac/heat, w/d. The 4 Stall barn w/tack room and 9-ton hay loft has 2 riding rings consisting of 60’ covered round pen w/sprinkler system & lights. 190’x100’ arena w/sand footing blue stone base, stadium lighting, water and a 50-amp RV hook up w/water and electric. Updated electric and surveillance system. Water/electric is in every stall and there is an outside grass paddock for grazing. 1.5 car garage w/workshop, LED lighting, split ac/heat, pre-wired 220 amp for welder, 50-amp RV hook up and epoxy painted floor. The property is superbly maintained w/paved and newly lite driveways (2013/2018) the rear patio (2020) has poured concrete and Cambridge pavers, a full wet bar with sink, fridge, and a portico w/gas firepit, built in BBQ, lighting and a there is a gazebo. Freshly painted inside and out (2023). No expenses were spared within this unique property that you would be proud to call your own., Additional information: Appearance:Mint+, Separate Hotwater Heater:yes

ML# :3566946   Perfectly poised where South Gillette Avenue ends and The Great South Bay begins, this stunning home welcomes you. Recently undergoing a full renovation and expansion, taking full advantage of the sweeping views of the bay and Fire Island silhouettes. A fresh palette of soft grey exterior, surrounded by emerald green lawn makes this home a standout on one of Bayport’s most coveted streets. Enter the foyer and immediately be drawn to the southern water views. The grand living room is an open concept allowing you to conceptualize how YOU want to live. Perhaps a seating arrangement around the fireplace, a large dining area with room for all, and breakfast nook in the kitchen. The stunning kitchen boats Cafe appliances, farmhouse sink and large island with seating. This level includes a den/office with private bathroom, laundry room, powder room and access to the 2-car garage. The second level offers the most impressive primary suite. This room encompasses the entire south wing, with fireplace, vaulted ceiling, exquisite marble bath, walk in closet and a private covered balcony with panoramic water views from sunrise to sunset. Three additional en suite bedrooms, all with private bathrooms complete this level. This home beckons an elegant yet comfortable lifestyle. Beautifully designed and turn key, awaiting its new owners to create a lifetime of memories., Additional information: Appearance:Stunning, Green Features:Insulated Doors, Interior Features:Guest Quarters, Marble Bath, Separate Hotwater Heater:yes

ML# :3540372   ***SELLER FINANCING IS AVAILABLE Exceptional prime space located in the vibrant neighborhood of east Flatbush Brooklyn This spacious property occupies a 30x100 ft. Lot & boasts 7, 500 square feet of interior space spread out over 3 floors. It features expansive 13-foot ceiling heights-a perfect setup for various industrial pursuits. The zoning code is designated M1-1 and there are multiple uses, including industrial, manufacturing, commercial, and a community facility. The building contains 3 floors, all with separate entrances from the street. It can be used by one end user or rented out separately to maximize your investment and rental income. Main floor clear height 13’ Basement has separate entrance from the street and and can be used as storage or offices Main floor is is currently used for warehouse space 2nd floor has separate entrance from the street and was used as a social hall With its prime location in East Flatbush, you’ll be in close proximity to major transportation providing easy access for both employees and clients . Easily accessible to the b6, b8, b103, and b46 MTA bus line and the 2 & 5 train, Additional information: Rental Income:N, vac_perc:100

ML# :802352   Custom colonial, 9488 total sq ft, built by original owners. Grand entrance flows into the formal dining room, family room and living room each feature a gas fireplace. 2 bedrms on the main flr. Kitchen is equipped w/ stainless steel appliances, granite countertops, & lots of storage. The island features 5 burner stove with hood, and built in oven. Radiant tiles in entrance, kitchen and master bath. Upstairs, the spacious primary suite comes complete with walk in closets and a spa like ensuite bath, which features a beautiful skylight, soaking tub, his and hers vanities, and standing glass shower. 5 addl bedrooms through the 2nd floor, each with plenty of closet space and their own baths. The fully finished walkout basement features 10 ft ceilings, a fully equipped accessory kitchen, family room, recreation space, and full bath. The backyard is an oasis, with large deck for entertaining, inground pool surrounded by stone patio, and natural privacy fence. Home comes w/ a full generator.

ML# :3592444   New Construction on 1.2 Acres with Pool and Luxury Finishes! Discover Luxury Living With This Brand-New 4-Bedroom, 3.5-Bathroom Home, Perfectly Set On A Sprawling 1.2-Acre Flat Lot. Completely Renovated With No Expense Spared, This Home Offers An Open Canvas For Your Dream Lifestyle. Standout Features Include A Stunning Gunite In-Ground Pool, Gleaming Hardwood Floors, Beautiful Marble Countertops, And A Primary Suite Featuring A Luxurious Ensuite Bathroom And A Large Walk-In Closet. Additionally, This Home Is Certified And Comes With A 13-Month Home Warranty Through Home Warranty Of America, Offering Peace Of Mind For Your Investment. Don’t Miss This Unique Opportunity To Own A Truly Exceptional, Modern, Luxurious Home., Additional information: Appearance:Diamond, Interior Features:Lr/Dr

ML# :3548639   Excellent investment property in prime Elmhurst location. Three family plus store, mixed-used building, of brick construction in very close proximity to 7 Train, buses, shopping, schools, and all amenities. Close to the upcoming new development in Willets Point, Citifield, Roosevelt Ave, Flushing Meadows Corona Park and upcoming Soccer Stadium. All rented with good tenants: good condition and excellent income (income and expenses worksheet available on request). Building on 20x100 R6B lot . Great and secure investment. Tremendous rental upside., Additional information: Appearance:EXCELLENT

ML# :3522314   The Residences at Glen Harbor. NOW 90% SOLD. This new boutique resort style building is made up of 48 New luxury waterfront condos on Long Island’s North Shore. All condos have direct water views including the harbor and Long Island Sound. Designed for modern living, this brand new property is loaded with amenities including 24-hour concierge and doorman services, private garage parking, two fitness centers (cardio and weight room), clubhouse/lounge, coffee/card room. Exterior grounds feature a heated swimming pool, a beautiful pool pavilion that has a full kitchen, gas fireplaces and tv, fenced grass areas, BBQs and seating around firepits, all with sweeping waterfront sunset views. Pet friendly. This end unit third floor condo is 2 bedrooms and 2.5 baths, at 1, 906 square feet interior space plus 135 sqft covered terrace. Full laundry room and slop sink in unit. Two assigned parking spots in garage plus visitor parking too. Each condo overlooks the water, has high ceilings and great light. The layouts differ per unit, vary in size and price. Experience the North Shore lifestyle in this new resort style luxury condo building located adjacent to Glen Head, Roslyn Harbor, nearby beaches and Sea Cliff. North Shore School District. Glenwood Landing Elementary. Just 24 miles to Manhattan and a quick jaunt to local international airports., Additional information: Appearance:New, Interior Features:Guest Quarters