ML# :898824   Absolutely Stunning Builder’s Own Huge Custom model! with WATER VIEW! The one you’ve been waiting for! Completely renovated Entertainer’s Delight! 5 bdrm 3 full bath, over 3300 sq ft Hi Ranch with designer touches throughout! Open Floor Plan, Huge Chef’s Eat-in Kitchen with 13’ Center Island, additional dining area and dry bar, Formal Dining Room with fireplace and water view! Living Room w/fireplace, Huge Primary Suite w/fireplace and 2 walk-in closets, 5 trey ceilings, 2 wood-burning fireplaces and 2 electric fireplaces, Crown moldings, Gorgeous Hardwood floors, Radiant heat in hall bath, Huge lower level with sitting room, Family room w/fireplace, dining area, 2 bedrooms and a full bath, sliders to paver patio and beautifully landscaped private backyard! Separate lower level Laundry room w/new slop sink and plenty of storage, 2 zone CAC, 3 zone heat, Gas heat and cooking, 200 amp electric, IGS, 2 car garage, Beautiful iron double front door, Near the Meca Pool Club and Merrick Golf course ! Won’t Last!!

ML# :897741   Welcome to 12 Griffen Ct, an extraordinary residence set within the prestigious North Harbor community of Miller Place, just minutes from the coveted sands of Cedar Beach. This grand colonial, offering over 4, 000 square feet of refined living space, has been masterfully updated with no expense spared. Featuring five generously scaled bedrooms with the option for a sixth or nursery, and three full bathrooms each brand new, meticulously curated, and finished with the finest materials this home embodies luxury at every turn. The heart of the home is its expansive chef’s kitchen, complete with a magnificent center island offering full storage and roll-out drawers, a walk-in pantry with custom glass door, lazy susans for seamless function, dual stainless-steel refrigerators and bespoke cabinetry designed with elegance and efficiency in mind. A dramatic great room with cathedral ceilings, a formal den with vaulted architecture, beautiful oak floors throughout and carefully selected new chandeliers and custom hi-hats create an atmosphere of sophistication throughout. Closets are abundant in every room, ensuring both form and functionality.Upstairs, the palatial primary suite boasts its own cathedral ceilings, a spa-like bathroom with a free-standing soaking tub, expansive walk-in shower, and a thoughtfully designed bonus space ideal for a nursery, couture dressing room, or grand closet. Every detail down to the custom fixtures and intricate finishes has been curated with intention.The fully finished lower level offers soaring ceilings, a private exterior entrance, dual upgraded electrical panels, new mechanical, and endless possibilities for recreation, extended living, or personalized design. Outdoors, nearly an acre of manicured grounds awaits, featuring a brand-new deck, fire pit, renovated shed, retractable awning, and a backyard offering boundless opportunity—including ample room for a swimming pool. Additional highlights include multi-zone central air, both propane and wood-burning fireplaces, in-ground sprinklers, an oversized two-car garage, and a meticulously landscaped, fully fenced property. A rare offering along the North Shore Do not miss the opportunity to make this yours in one of the most desirable communities on the Long Island Sound!

ML# :894485   Modern Living in Desirable Red Creek RidgeSet in the sought-after Red Creek Ridge neighborhood of Hampton Bays, this stylish modern home offers an open-concept layout ideal for today’s lifestyle. Featuring four spacious bedrooms and three full bathrooms, the main level showcases a bright and airy living room, dining area, and an updated kitchen designed for both function and entertaining.The fully finished lower level provides excellent versatility with a summer kitchen, expansive great room, additional bedroom, office, and full bathroom—perfect for guests or multigenerational living.Step outside to your private backyard oasis where a heated in-ground pool with an overflow hot tub is surrounded by elegant pavers and lush, natural landscaping—creating a serene setting for summer gatherings or peaceful relaxation.With proximity to bay beaches, nature preserves, and all the amenities of the Hamptons, this home delivers the best of year-round or seasonal living.

ML# :900209   Welcome to 99-03 207th St, a New construction Detached Single Family house situated in a 55x100 corner lot in Queens Village! This massive, bright, & Airy house features 1 Bedroom, 1 full Bathroom, a modern, open-concept living/Dining/Kitchen Combo on the 1st floor, 4 Bedrooms, 2 Full Bathrooms duplex with the attic on the 2nd fl, and a full, finished Basement with a separate entrance and a half Bath for a comfortable living. The exterior features an attached garage, a long Driveway, and a nice Yard. Just a block away from Francis Lewis Blvd, Close to Buses, Shops, Park, a short 10-minute bus ride to LIRR station, and more.

ML# :881611   Extra large 2 family with 4 units and a GIANT 5, 704 square foot lot parking lot for 22+ cars!The property has two 3 bedroom apartments PLUS two units that can be used for office or expanded living. Highly convenient location right off of the the highway PLUS the expansion of the metro north stations at Co-Op City will add valueSeparate utilities for ALL UNITSThe parking lot has already been fitted with a automatic gate and security cameras. The entire property has been immaculately upgraded and taken care of.

ML# :891362   THREE FAMILY , LAYOUT : BASEMENT == FULL AND PARTIALLY FINISHED WITH HIGH CEILING 1ST FLOOR == 2 BEDROOM APARTMENT 2ND FLOOR === 3 BEDROOM APARTMENT3RD FLOOR === 3 BEDROOM APARTMENT

ML# :884828   4 Family Investment Opportunity Located on desirable Van Cleef Street, this semi-detached, 3-story brick building is a must-see for investors and end-users alike. Set on a 20’ x 75’ lot, the property features four income-producing units: two 1BR/1BA duplexes on the first floor, and a spacious 2BR/2BA unit with a private balcony spanning the second and third floors. Enjoy a beautiful backyard! New roof. Close proximity to Queens Center Mall, Rego Park Shopping Complex, Flushing Meadows Park, the Hall of Science, and 108th St. buses—offering excellent convenience and tenant appeal. The building measures 20’ x 40’ and offers separated utilities and meters for each unit. Zoned R6B, this is a rare opportunity in a high-demand area. Don’t miss out on this exceptional investment in one of Queens’ most vibrant neighborhoods! Property occupied. Please do not disturb the tenants.

ML# :875321   Welcome to 119 Whittier Drive! This Brand New Construction is Ready for Your Personal Touches! This Home Features 3 Bedrooms, 2.5 Bathrooms with a Primary En-suite with a 2nd Floor Walk Out Covered Trex Deck to Soak up the Stunning Water Views! There is a Large Family Room With Tons of Natural Light and Large Windows Throughout. New Owner Still Has The Ability To Pick Paint Colors and Appliances. Dont Miss This Opporunity.**Kitchen Appliances Virtually Staged in Photos**

ML# :865626   This exceptional three-family home presents a prime investment opportunity, offering both comfortable living spaces and income potential. Each thoughtfully designed unit provides ample natural light, inviting interiors, and a well-balanced blend of privacy and functionality. The property features dedicated outdoor space, and convenient access to shopping, dining, public transportation, and major highways, making it highly desirable for renters. Additionally, its strategic location just a short distance from major roadways and a nearby A & C train station ensures easy commuting options, further enhancing its appeal. Whether you’re looking to expand your real estate portfolio or secure a multi-family property in a sought-after area, this home is an outstanding opportunity—schedule your private showing today!

ML# :835321   For Sale Is A Detached 2 Family HouseFULLY RENOVATED INSIDE AND OUTno expense has been spared3 Bed 1 Bath Over 3 Bed 1 BathFormal Living Dining Kitchen in each unit Massive Basement With High Ceilings and private entrance.