ML# :884422   Nestled in the heart of Sag Harbor Village, 352 Main Street offers the rare opportunity to own a timeless 3-bedroom, 3-bath residence just moments from shops, restaurants, and the harbor. The home sits on a 0.17-acre lot and combines classic village charm with untapped potential.The light-filled interior features a cozy living area with fireplace, hardwood floors, and an open-concept layout ideal for entertaining. The eat-in kitchen leads to a spacious backyard with room for outdoor dining or a potential pool. While the home has solid bones, it presents a great opportunity for updates or renovation to match your vision and elevate its value.Located just blocks from the Sag Harbor Whaling Museum, John Jermain Library, and historic marinas, this property is a standout for buyers looking to invest in one of the most desirable and walkable villages in the Hamptons.

ML# :895768   A rare investment opportunity in the heart of Upper Manhattan , this fully detached four-family home sits on a wide, tree-lined street and offers 4, 370 sq ft of unused FAR, making it ideal for condominium development under R7-2 zoning. Located near a prestigious Columbia-affiliated university and a renowned hospital, the property is perfectly positioned to attract steady rental income from students and professionals alike. With the A, C, and 1 subway lines just steps away, Midtown Manhattan is only 25 minutes away. The neighboring property recently added two floors, maximizing its development potential , now it’s your turn to unlock the value of this underutilized gem. Selling it in its current condition.

ML# :938154   This two-family home features seven bedrooms and three full baths. The information provided is estimated to the best of our abilities at this time.

ML# :936856   Beechhurst rent generating modern 3-story brick three-family residential building. Spacious interior offers approximately 3, 762 sqft of combined living space with 3 residential units each with 3 bedrooms and 2 bathrooms. Plus a finished walk out basement. 2 attached garage and one additional parking space. Situated on 2, 359 sqft lot in R4 zoning. This northern Queens neighborhood offers both suburban charm and city convenience with stunning view of East River and the Throgs Neck Bridge from nearby waterfront parks. Fantastic international restaurants and shopping establishments. Easy commute via express buses to Manhattan plus Q-15/61 local buses for connection to #7 train and LIRR. Don’t miss this exceptional opportunity for home owners or investors portfolio.

ML# :936407   Beautifully maintained 3-family home! Each spacious apartment features 2 bedrooms, 1 bathroom, and a bonus room ideal for a home office, nursery, or guest room—an attractive feature for today’s renters. Residents will appreciate the timeless hardwood floors throughout, convenient shared laundry, and a clean, well-organized basement offering ample storage.The property also boasts a private backyard—perfect for relaxing, entertaining, or creating a charming outdoor space. Whether you’re an investor seeking strong rental potential or a buyer looking for a property with income-producing options, this home delivers outstanding value and charm.

ML# :931689   Expanded 6-Bedroom Splanch with Sunroom – Herricks School DistrictSpacious, modern, and designed for today’s lifestyle! This beautifully expanded 6-bedroom, 3.5-bath Splanch sits mid-block on an oversized 70 x 159 lot in the highly sought-after Herricks School District. Perfect for multi-generational living, it features a second master suite plus four additional bedrooms, providing flexible space for parents, children, or guests.The sunlit eat-in kitchen with granite countertops flows into a formal dining room, creating an elegant space for entertaining. A cozy family room with a wood-burning fireplace offers comfort and warmth, while the rear sunroom is ideal for morning coffee, reading, or casual gatherings. The cathedral-ceiling living room is filled with natural light and overlooks the park-like backyard.The finished basement adds versatility for a home office, gym, recreation, or study area—perfect for remote work or hobbies. Additional highlights include 200-amp electrical service, gas heating, central air conditioning, an oversized driveway, and a two-car garage.Combining style, space, and modern conveniences, this move-in ready home is perfectly suited for young families, multi-generational living, or anyone seeking room for work, play, and relaxation.

ML# :917434   Perched sixty feet above the Muddy Kill Creek in Stone Ridge, this newly built home, named ’’Fern Hollow’’, blends mid-century modern inspiration with one-of-a-kind details, offering both striking design and emotional warmth that sets it apart from standard new construction. The result is a modern treehouse, with dramatic views of the creek as it weaves through the lush wooded landscape. The builders took great care to infuse character into the home by incorporating reclaimed architectural pieces throughout. Vintage terrazzo floors, custom-designed door hardware, and an unforgettable walk-in closet—crafted from the cabinetry of a 1960s library—are just a few examples of the artistry. Every detail has been curated, creating a home that is elevated yet approachable. With a nod to Frank Lloyd Wright’s sense of surprise, the foyer’s understated character is bright and welcoming, giving way to the soaring main living space, where expansive glass walls frame the forest canopy and the creek below. A wood-burning fireplace provides warmth and a striking focal point, while two oversized doors extend the living area outward, opening directly to the decks and blurring the line between indoors and out. A hidden mechanized television drops down from above the fireplace, maintaining the clean lines of the room until it’s time to gather for a movie night. The kitchen is equally thought out in form and function, with soapstone counters, custom oak cabinetry, a coffee/dry bar, wine fridge, and a dramatic picture window in place of a backsplash, looking directly into the forest. A disguised door is integrated into the kitchen cabinetry, leading to a hidden first-floor suite—perfect for guests, in-laws, or a quiet office retreat. The sleek, moody mudroom just off the carport (with an EV charging station) leads to a powder room and laundry area with a chute, as well as a generous flex space suited to a gym, media room, or playroom. Upstairs, spalted maple floors run throughout. The spa-like primary suite is a tranquil, spacious retreat that opens to a hot tub ready private deck where you can unwind with the creek’s quiet rhythm as your backdrop. Completing the suite is a spa-like bathroom featuring a luxurious soaking tub and walk-in shower, along with a walk-in closet whose custom millwork nods to its origin as a mid-century library. Another guest room, a stylish full bathroom, and an open loft leading to a large deck round out the second floor, offering both comfort and flexibility for family or visitors. Additional features include polished concrete floors with radiant heat on the first level, mini-splits throughout for cooling and additional heating, and wiring in place for a whole-house generator. Set at the end of a private road, the property is secluded and peaceful, with frontage on both sides of the Muddy Kill Creek and mature trees that create a timeless natural sanctuary, yet it’s just minutes to the center of Stone Ridge and a short drive to Accord, High Falls, New Paltz, and the area’s farm stands, breweries, and dining destinations.

ML# :912675   Welcome to this stunning 2024-built Two-Family residence nestled in the highly sought-after Country Club area, known for its safety and suburban atmosphere. Featuring three above-ground floors plus a full finished basement with a separate entrance, a private garage, and energy-efficient solar panels. The home also boasts multiple balconies—both front and rear on the second floor, and front and rear on the third floor—perfect for enjoying fresh air and outdoor relaxation. One unit offers 2 bedrooms and 2 bathrooms, while the other unit boasts 6 bedrooms and 4 bathrooms—ideal for multi-generational living or rental income. Conveniently close to schools, shops, parks, restaurants, and public transportation, with easy access to major highways. Don’t miss this opportunity to own a home in such a prime location! Seller financing available for qualified buyers.

ML# :912424   _

ML# :907813   Legal 3 Dwelling Solid Brick Semi-Attachment House In The Heart Of Elmhurst. Excellent Condition, Built In 1989. Good Location Near Queens Center Mall, Supermarkets, Restaurants, And Major Highway. Convenient All. Subway Station E, M, R.