ML# :815950   Welcome to this brand-new luxury single-family home nestled in the heart of Fresh Meadows. This 4-bedroom, 3.5-bath residence showcases exceptional craftsmanship with soaring double-height ceilings, oversized windows, and modern finishes throughout. Equipped with a high-efficiency solar system generating 6.15kW, the home offers sustainable living and long-term energy savings.The main level features a sun-filled open living area, a sleek chef’s kitchen with custom cabinetry and a waterfall island, along with a guest bedroom and full bath—ideal for flexible living.The second floor offers three spacious bedrooms and two full bathrooms, including a stunning primary suite. A finished attic provides additional space for a home office, studio, or playroom. The full basement includes a laundry room, gas meter room, and a half bath. A detached garage and private driveway accommodate up to two vehicles.Located just minutes from St. John’s University, this home offers excellent access to transportation options, including the Q31, Q45 and Q74 bus lines, express buses to Manhattan, and nearby highways such as the Long Island Expressway and Grand Central Parkway. Enjoy a quiet residential setting with convenient access to nearby shops, parks, restaurants, and everyday amenities.

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# :937781   Welcome to an exceptional investment and lifestyle opportunity located directly across from iconic Astoria Park. This legally two-family home has been newly renovated from top to bottom, offering modern luxury, unmatched convenience, and extraordinary long-term potential. Property Highlights: 25x100 sq ft lot with R6B zoning — potential to expand up to approximately 5, 000 sq ft. Two-Family Configuration: Lower Duplex with 3 bedrooms, 2.5 bathrooms. Basement with large space and a separate entrance. Upper Unit with spacious 3-bedroom layout featuring park views. Completely Rebuilt Structure: New electrical, plumbing, windows, exterior walls, boiler and water heater. Separate electricity, water and gas meters for effortless rental management. Interior Excellence: Brand new open-plan kitchens with stylish finishes and premium LG appliances including dishwasher, microwave and wine cooler. In-unit washer/dryer for each residence. High-efficiency Mitsubishi split-system HVAC for year-round comfort. Smart Home Features: Nest thermostat, smart lighting, security cameras, and video doorbell. Comfortable ceiling heights, thoughtfully optimized floor plan and abundant storage throughout. Outdoor & Bonus Spaces including private, paved backyard ideal for entertaining or quiet relaxation. Oversized storage room offering valuable additional space. Top-floor unit includes a front-facing terrace with open views of Astoria Park’s greenery, tennis courts and running track. Unbeatable Location: Live in one of Queens’ most desirable neighborhoods, the house sits directly opposite Astoria Park, one of NYC’s premier waterfront green spaces, offering immediate access to jogging paths, athletic courts, playgrounds and the iconic pool. Convenient to the N/W subway at Astoria Blvd, Astoria Ferry, and major highways including GCP, BQE, RFK Bridge, Queensboro Bridge, and the Midtown Tunnel. Whether you’re an end-user seeking multi-generational living, an investor looking for strong rental income or a buyer planning a future expansion, this property delivers exceptional value and unmatched potential.

ML# :938491   This beautifully updated contemporary sits on a quiet cul-de-sac in the near NW Woods. On the main floor there is a lovely vaulted great room along with a large bedroom, half bath and laundry. Upstairs you will find the large primary suite with walk in closet and a second spacious bedroom with attached half bath. The finished lower level completes the interior of this wonderfully designed home providing a generously sized media room, bonus room, additional mixed use space and half bath. Surrounded by mature trees and beautifully landscaped the private backyard includes a newly updated heated pool.

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.