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# :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.