ML# :836156   Designer Modern Farmhouse ranch set on over 3.35 Acres with farm and scenic views. Renovated 2023. Open concept Living room, Dining room and Kitchen, Gorgeous kitchen with quartz countertops, Stainless Steel Appliances, built in wine cooler, new windows throughout, new interior doors, new exterior doors, new flooring, updated designer baths, new boiler, new well pump, new hot water heater. Spectacular 20x40 in ground saltwater pool with Cambridge pavers patio. Front porch overlooking farm views. Close to McCabe beach or quick drive for incredible sunsets. Access to Resident only Town Beaches, Boat Ramps and Parks with Town Permit. Farm animals permitted. Marina, airstrips and trails nearby.

ML# :3593554   Immediate occupancy available in The Rose at Great Neck. 40-New Luxury Condominiums on the North Shore of Long Island. This brand new mid-rise building is now over 30% sold. Offering an unparalleled residential experience and amenities including virtual doorman services, welcome lobby, resident lounge with YouTube TV, plus gym fitness center with treadmill, bike and free weights. Retreat to the rooftop common area and hang out at the perfect place to unwind with seating and enjoy the outdoors that include distant views towards New York City. Private indoor garage parking and outside private lot parking. The earliest residents have preferred choice of parking spaces. The allure of The Rose extends beyond its walls as residents enjoy instant access to the Village of Great Neck Estates Waterfront Park featuring Olympic sized swimming pool plus small pool, 7 tennis courts plus indoor tennis court in a bubble, marina and dock area, direct waterfront esplanade with views of Little Neck Bay, Douglas Manor and the Throgs Neck Bridge, shoreline access, baseball and soccer fields, playground, basketball, pickle ball, handball courts and snack bar. The Rose was creatively designed by famed architects Mojo Stumer with the very best of quality and modern sophistication. Exterior brick and metal panels accent the solid structure. Three floors high with a mix of 1 bedroom, 2 bedroom and 3 bedroom options in this new building. Unit 110 is an end unit, two bedrooms and two baths, approximately 1, 327 sqft, private laundry. Big windows in the condo bring in natural light. Sleek modern kitchens to spacious living areas and stunning bathrooms, every aspect of this building reflects a commitment to luxury and comfort. Various golf courses within close proximity and nearby to the famous Americana Manhasset shopping. Just 0.7 miles to the Great Neck LIRR train station that boasts a direct route to Penn Station and now Grand Central Station in Manhattan. Enjoy the suburban lifestyle at the pinnacle of luxury living in Great Neck with all its town amenities just 19 miles to midtown Manhattan and a short jaunt to international airports. Welcome home.

ML# :880556   Welcome to this beautifully designed 5-bedroom, 3-bath home in the highly sought-after Holliswood neighborhood of Queens. Sitting on aspacious, oversized 8, 500 sq. ft. lot, this 2, 510 sq. ft. residence offers the perfect blend of elegance, space, and modern convenience. Step intothe sun-drenched living room, where floor-to-ceiling glass windows provide breathtaking natural light and serene views. The chef’s kitchenboasts a large center island, ideal for gatherings and meal prep. The walkout basement offers endless possibilities—whether for additional livingspace, a home office, or recreation. A newly done driveway adds to the home’s curb appeal and practicality. A 12x12x10 ft shed coupled with theattached 2 car garage offers plenty of storage space. Oversized driveway can fit multiple cars as well. Nestled in a tranquil yet convenientlocation, this home provides easy access to major highways, public transportation, top-rated schools, parks, and shopping—offering the best ofsuburban living with city conveniences. A rare find in Holliswood—don’t miss this incredible opportunity!

ML# :879151   Welcome to 1822 Stanhope Street in Ridgewood, NY, bordering Brooklyn! This impressive 4-family brick home offers an excellent investment opportunity. With approximately 2, 750 sq. ft. of living space and a 25x100 sq. ft. lot, the property boasts 4 spacious apartments, each with generous layouts. The first floor features a well-maintained 1-bedroom and 2-bedroom apartment, each with a cozy living room, dining area, eat-in kitchen, and full bathroom. The second floor includes two 2-bedroom apartments, each with living and dining rooms, eat-in kitchens, and full bathrooms — perfect for end users and/or buyers looking for rental income potential. The basement provides additional recreation space and storage. The property is equipped with 5 gas meters and 5 electric meters. This is a great investment for a first-time buyer as well as an experienced investor. Located near the Bushwick neighborhood and close to Williamsburg, with easy access to transportation (Buses B38, Q54, Q67, Q38, Q58, Q59, Subways L/M), schools, shopping, gyms, banks, and restaurants. Convenient access to the LIE, BQE, and Manhattan. Don’t miss out on this opportunity! Additional information: Appearance: Excellent.

ML# :851478   Townhouse 4J at Bayview Courtyard! Discover the pinnacle of elegant townhouse living in this unit, a four-bedroom triplex designed to offer the perfect balance of sophistication, comfort, and breathtaking waterfront views. Expansive Triplex Layout – Thoughtfully designed for seamless indoor-outdoor living Elevated Double-Height Ceilings in the living room – a statement of grandeur and space, privateentrance, front and back terraces and Private Rooftop Terrace – The ultimate retreat with stunning water views Exclusive Garden Patio – Your own oasis, perfect for morning coffee or entertaining under the stars. A Chef’s Dream Kitchen Custom-made kitchen cabinets with granite countertops and LED accent lighting Premium full-suite kitchen appliances Thoughtfully designed open-concept layout perfect for hosting. Indulgent Bathrooms Spa-inspired soaking bathtub Medicine cabinets with LED-lit mirrors Beautifully designed Kohler toilets with a custom-made vanity. Luxury Living at Every Turn European white oak flooring throughout Custom-made California Closets® in all bedrooms In-unit washer & dryer for everyday convenience. World-Class Amenities Await As a resident of Bayview Courtyard, you’ll enjoy access to: 50-foot indoor heated pool with lifeguard , 2, 000 sq. ft. state-of-the-art fitness center, Rooftop with breathtaking views of Manhattan & the ocean. Elegant outdoor zen terrace for meditation & relaxation. Residents’ lounge with coffee station, 24-hour Doorman & full-time resident manager. Prime Location – Brooklyn’s Hidden Gem Bayview Courtyard offers the best of tranquil waterfront living with easy access to Bensonhurst Park, vibrant dining, and top-tier transit options.

ML# :851485   Experience Luxury Living at Bayview Courtyard – Stunning Triplex Townhouse!. Welcome to Bayview Courtyard, where luxury meets elegance in this exquisite triplex townhouse-style condo. Designed for those who appreciate spacious living, high-end finishes, and breathtaking views, this 4-bedroom, 3-bathroom residence offers the perfect blend of comfort and sophistication. Enter Inside a Home That Redefines Luxury: Expansive open-concept layout seamlessly integrating living, dining, and kitchen spaces ?? Premium finishes & high-end fixtures throughout for a refined touch.Serene garden & water views providing a peaceful retreat. Beautiful private garden—perfect for entertaining or unwinding. Exclusive Building Features: 24-hour concierge & full-time resident manager, Three high-speed passenger elevators for easy access. Dedicated package room & Amazon Hub for secure deliveries. 215 valet parking spaces available for rent. Intercom system & secure entry for all residences. Storage & bicycle spaces available for sale or rent. World-Class Amenities at Bayview Courtyard: 2, 000 sq. ft. state-of-the-art fitness center, 50-ft indoor heated swimming pool with lifeguard. Residents’ lounge with coffee station. Indoor children’s play area. Landscaped outdoor space with grilling area & ample seating. Elegant outdoor zen terrace for yoga, meditation, or study. Outdoor dog run for your furry family member. Gorgeous rooftop with breathtaking views of Manhattan, Brooklyn & the ocean. Private event spaces available for reservation. Prime Location – Unparalleled Brooklyn Living Enjoy seamless access to fine dining, shopping, parks, and top-rated schools, all while living in a peaceful, amenity-rich community.

ML# :883540   Huge Multifamily house in Brairwood prime location. Very close to F line subway from Hillside Ave. High Income potential for Investors even opportunity to live free for first time home buyers. ** Zoned R4A**. lots of potential. Private driveway with full finished garage. Full finished attick , full finished Basement, just like a WOW. do not miss this opportunity, call now.

ML# :806657   Introducing The Gables at Westhampton Beach, where classic Hamptons elegance meets modern luxury. These stunning two-story condominiums feature two bedrooms, two and a half baths, and a spacious 10-foot basement. Each unit is designed with wide plank white oak floors and 7’ solid doors, complemented by a cozy gas fireplace. The Atlantic unit offers a 1, 721 square foot open floor plan that seamlessly connects the kitchen to the great room with gas fireplace, and dining area. The high-end custom kitchen is a chef’s dream, equipped with natural wood cabinets, and top-of-the-line appliances from Sub Zero, and Wolf. The first floor also includes a half bath, den, and a covered patio for outdoor enjoyment. Upstairs, you’ll find a convenient laundry room and two spacious ensuite bedrooms. The primary suite is a retreat of its own, featuring an oversized bathroom with Porcelanosa natural wood floating double vanities, and an expansive walk-in closet. Residents at The Gables at Westhampton Beach can indulge in exceptional amenities designed for both relaxation and fitness. The clubhouse features a state-of-the-art gym equipped with Pelotons, free weights, and a private training room/yoga studio. For culinary enthusiasts, the clubhouse boasts a luxurious kitchen with Sub-Zero appliances and Porcelanosa finishes, alongside an indoor lounge with vaulted ceilings and an oversized gas fireplace. Head outside to enjoy a covered patio that overlooks the heated swimming pool with sun lounges, complete with an outdoor gas fireplace and seating area. The custom-built Wolf outdoor grilling station provides the perfect setting for entertaining. Experience the ultimate blend of sophistication and comfort at The Gables at Westhampton Beach. The complete terms are in an Offering Plan available from the Co-Sponsors. File No. CD24-0090.

ML# :892417   Great Investment Opportunity in the heart of Kew Gardens! A DIAMOND Multi- Family SEMI-ATTACHED Home just a few short blocks from Public Transportation Featuring Immaculate Condition Home! First Floor has One Bedroom Unit set up. Second Floor has Three Bedroom and Two Full Bathrooms, Third Floor has a Three Bedroom and Two Full Bathroom Units. A finished Basement in Diamond Condition! Each Unit has been renovated and is very Large! ALL Bedrooms suited with very large closets, Sun Filled with lots of Natural Light and Balconies/Terrace for Both Units. A Great Side Yard accessible from First Floor. One Car Garage in the Back with at least 6 parking spot ready!Note* This home is sold as Package Transaction along with 85-45 Abingdon Road, Kew Gardens, with is adjacent to this property.

ML# :892438   Amazing Investment Opportunity in the heart of Kew Gardens! A Tremendous Brick Home with Ground Floor One Bedroom unit. Second Floor has Three Bedrooms plus Two Bathrooms, and Third Floor has Three Bedrooms plus Two Bathrooms. A fully finished Basement, with lots of updates. Garage parking in front of the home. Gas Heat ! Tenant Pays for Gas and Electric. Excellent opportunity to own a beautiful colonial just a few minutes from Subway, Bus, and Express 10 Minute Ride to Manhattan! Please call to schedule a viewing , interior of the home is in Immaculate Condition! NOTE** This property is sold as a package transaction with the adjacent home Address 85-41 Abingdon Road.