ML# :809306   248 St. Nicholas Avenue is a versatile 3-family home in the heart of Bushwick, featuring identical layouts with two units offering an extra bedroom above the main entry foyer. The property, in need of some TLC, includes a tenant-occupied second-floor unit (lease until March, $2, 800/month), a semi-finished basement with dual access points, and a backyard exclusive to the first-floor unit. Situated in an R6 zoning district with a maximum FAR of 2.43 (current FAR 1.83), the property may offer buildable opportunities—buyers should verify with their architect or contractor. Conveniently located near the M and L trains at Myrtle-Wyckoff and the B38, B54, and Q58 buses, this is an excellent investment or owner-occupant opportunity. Schedule a viewing today!

ML# :H6335411   Imagine an oasis where timeless elegance and modern comfort merge seamlessly across nearly 4 acres of lush landscapes. The Caldwell House Bed and Breakfast is a sanctuary of charm and sophistication, offering three unique residences with a total of 14 luxurious bedrooms, each with a private bath. This captivating property isn’t just a destination; it’s an invitation to experience tranquility and beauty in every corner.*The Main Building* spans approximately 4, 900 square feet, featuring 6 bedrooms, 8 bathrooms, a large kitchen, two inviting living areas, and a bright dining room perfect for gatherings.*The Carriage House* covers about 2, 400 square feet with 4 bedrooms and 4 bathrooms, meticulously renovated in 2013 to blend modern comfort with timeless charm.*The Connemara House* is a spacious 4, 000 square-foot residence with 4 bedrooms, 8 bathrooms, a kitchen, and two expansive living and dining areas, thoughtfully renovated in 2014 to preserve historic character with updated features.Adding to the possibilities, An *additional 1-acre with a residential home*, borders the B&B property. This 1, 936 square-foot home includes 3 bedrooms, a modern kitchen, a dining room, and a detached 2-car garage. (Both are being sold together and are listed separately)Surrounding the residences are sprawling, level green lawns with mature trees and beautifully landscaped gardens, offering a peaceful setting for both meditation and relaxation.This unique property offers endless opportunities. whether as a private retreat, an expanded business venture, or a new vision for an unforgettable guest experience.

ML# :3582241  

ML# :814063   Welcome to your dream home at the border of Sands Point! This five-bedroom, five-bath residence combines luxury with modern upgrades. Step inside to an open living space with natural hardwood floors in a rich Bola finish. The dining room features a hand-blown Murano crystal chandelier, complimenting elegant lighting in the entryway, stairwell, and primary suite. The kitchen is a chef’s dream, boasting sleek quartz countertops and brand-new Samsung appliances. The main floor offers two spacious bedrooms, perfect for guests or a home office. Upstairs, the primary suite serves as a private retreat with a spa-like bath, soaking tub, separate shower, and double vanity. Two additional oversized bedrooms, each with a private bathroom, provide comfort and privacy. New sliding doors lead to a beautifully designed two-level backyard, ideal for outdoor gatherings or just enjoying the sunset. The property includes a freshly paved asphalt driveway, a new garage door and Garage door opener, dawn-to-dusk exterior lighting. Additional features include new outdoor sprinklers, a fresh sidewalk, and stylish pavers that enhance curb appeal. The basement, equipped with an egress window, offers natural light and future expansion potential. With a brand-new roof, 6-inch glossy gutters, durable double-pained aluminum windows, and advanced HVAC systems, this home is both efficient and stunning. Don’t miss the chance to own this exceptional property. Schedule a viewing today to experience the perfect blend of elegance, comfort, and functionality!

ML# :808933   College Point Prime Location On Shopping Street, 1st Floor Features a Restaurant $3800/month Plus Pays Water Bill & 50% Of The Property Tax, Also 3% Rent Increase Every Year. 2nd Floor Is Two Bedroom apartment $1700/month, 3nd Floor Is A New Renovated Three Bedroom Apartment $1900/month. Low Property Tax, Separate Heating System(3 Zones) With 3 Gas Meters, 5 Electric Meters, Making It An Excellent Investment Opportunity. Building Size 23x48

ML# :3591659  

ML# :3591476  

ML# :3585536   Prime Location! Excellent Investment Opportunity in the Heart of Astoria. Situated in a highly sought-after area, the building is in excellent condition with recent upgrades, making it a promising choice for investors seeking steady income. Recently installed features included a new roof and solar electric system installed just three years ago, ensuring increased energy efficiency. Location is in the vibrant neighborhood of Astoria. Residents enjoy easy access to restaurants, shops, parks, and public transportation options. Updates: Solar Panel Roof-2021, Roof Redone-2021, Gas Boiler-2018 and 4 cameras provide security both in the front and back of the building., Building Size:30’ x 70’

ML# :3575398   Beautiful Young colonial with foyer, living room, dining room, den, brand new eat-in kitchen, and powder room on the main floor. The second floor has 3 bedrooms and 2 bathrooms. The third floor features 2 bedrooms and 1 bathroom. The basement includes a play area, guest bedroom, and bathroom. Gas heat, central air conditioning, and within walking distance to buses, school, and places of worship., Additional information: Appearance:excellent

ML# :3560516   Legal 3 family, brick, semi-detached house. 4 Bedrooms, 1 bathroom apartment over 3 Bedrooms, 1 Bathroom apartment over 2 Bedrooms, 2 bathrooms apartment. 1 car detached garage and private backyard. Separate boilers and hot water heaters for each apartment. House is centrally located, walking distance to public transportation, shopping, restaurants, pubs., Additional information: Appearance:Very good, Separate Hotwater Heater:Yes