ML# :3539219   corner mixed use building in Fresh Meadows. built in 1976, well maintain, solid brick, Excellent investment properties with a good mix of residential and medical units. With 15 units: 12 of which are apartments (6 of One bedroom apartment and 6 of studios) and 3 medical offices, 4 parking spaces. this is a great investment opportunity. Close to school, bus shops and restaurants.

ML# :3592685  

ML# :H6333640   Looking for a one-of-a kind designer masterpiece? Look no further than this stunning estate. Step into this luxurious abode through a grand entrance adorned with marble tiles, floating staircase, formal dining room, butler’s bar and open concept. Designer kitchen complete with Wolf and Viking range and ovens, custom cabinetry, and built up waterfall marble countertops. The main floor living room boasts 22 foot ceilings, chevron wood flooring, a built in fireplace and exposed beams. Guest wing on main floor. The primary suite contains 2 walk-in closets and an ensuite bath with his and hers sinks, double head rain shower, and free standing tub. Full walkout basement is very spacious and doubles as 2nd guest quarters with an additional 3 beds and 3 baths plus family room with theater and home gym. Outside has a glass enclosed deck with new inground pool and patio. Home comes equipped with A/V security camera system, and smart house monitor. Over 8000 sq ft of finished usable space!

ML# :3586783   Welcome to an extraordinary waterfront home that masterfully blends contemporary design with unmatched resilience. Constructed on 42 pilings with steel-reinforced block concrete, this 5, 600-square-foot residence is built for exceptional strength, energy efficiency, and minimal maintenance. **Elevator Ready** Inside, you’ll find 5 spacious bedrooms, 3.5 luxurious baths, and three expansive decks-two front-facing and one rear, complete with a gas hookup. The open floor plan is beautifully appointed with hardwood floors, a gas-burning fireplace, and high-end appliances, including Hi-End countertops. For year-round comfort, the ground and lower levels are equipped with radiant heat. The expansive yard is a true retreat, with versatile cabana that can be enjoyed in any season. Perfectly located very close from to the LIRR and West End, this home is on the Open Bay scenic waterfront walking path and minutes away a platinum selection of restaurants, cafes, shops, and more. Experience modern luxury and resilience in this exceptional waterfront property. Show Your Success as You Sit on Your DECK and Watch the Sunset..Your Boat is Docked right outside your home...ALL NEW...SEE VITUAL TOUR...

ML# :3584675   Welcome To Swan View Estate, Nestled Within The Charming And Historic Strongs Neck Section Of Three Village. Swan View Embodies The Timeless Allure Of New England With Its Colonial Roots And Picturesque Coastal Surroundings. This Sprawling 10, 000 Sq. Ft. Victorian-Inspired Estate Sits Gracefully Along 120 Feet Of Waterfront On Conscience Bay. As You Enter Through The Gated Courtyard, You’re Greeted By A Radiant Heated Porte Cochere And A Mesmerizing 25-Foot Waterfall, Setting The Stage For The Elegance Within. Step Onto The Two-Tiered Porch Of Brazilian Hardwood, Where Panoramic Water Views Captivate From Every Angle. The Circular Entrance Foyer Welcomes Guests With A Sweeping Staircase And Clerestory Windows Bathing The Space In Natural Light. The Kitchen Embodies Sophistication With Handcrafted Cabinetry, Granite Countertops, And Top-Of-The-Line Appliances, While The Adjacent Great Room Boasts Floor-To-Ceiling Windows Framing Breathtaking Views Of The Bay, The Home Unfolds With Spacious Rooms Bathed In Natural Light, Adorned With Finely Crafted Millwork And Elegant Finishes. Ideal For Both Grand Entertaining And Intimate Gatherings, The Property Offers Superior Amenities Including A Screening Room With A 106 HDTV, A Club Room With Rich Mahogany Wood Paneling, A Home Theatre, A Gym, And A Great Room And More. French Doors Provide Entrance to the Master Suite, a Sumptuous Water View Retreat Opening with a Sitting Room That Includes an En Suite Bar with Refrigerator. A Large Octagonal Tower Holds the Master Bedroom Illuminated by Its Double Height Ceiling and Clerestory Windows. Walls of Windows and Three French Doors to the Balcony Add Panache, Along with the Fireplace and Hardwood Floors. The Bath Offers a Glass Enclosed Shower, a Commode, and His and Hers Sinks Surrounded by the Opulent Texture of Wood Built-Ins and Slate Flooring. A Vintage-Style Tub and Sconces Add Old World Details. Two Fully Outfitted Walk-In Closets Finish the Suite. There Are Three Additional Bedrooms, Each with Finely Decorated En Suite Baths and Superb Architectural Elements. Very Own Outdoor Sanctuary Features A Gourmet Outdoor Kitchen Overlooking A Magnificent Pool With Roman Ends. A Heated, Gunite Infinity Edge Pool With A Waterfall, An Al Fresco Outdoor Kitchen, Blue Stone Patio All Create The Perfect Setting For Leisurely Days Spent By The Water. With Its Seamless Blend Of Colonial Heritage And Modern Luxury, Swan View Offers An Unparalleled Opportunity And Lifestyle.

ML# :3578598   Prime Mixed-Use Brick 4 Family + Store in Williamsburg! Discover an exceptional investment opportunity at 213 Johnson Ave, situated in the heart of Williamsburg, Brooklyn. This meticulously maintained mixed-use building combines residential and commercial spaces, offering versatility and solid infrastructure for long-term value. Building Features (3 Floors): - 4 Residential Units configured as 1BR/1BA each (Front & Rear Apts) - Potential to convert to 2-bedroom units, providing flexibility for increased rental income or diverse leasing options. - Hardwood floors throughout each unit. - First Floor Commercial Space is currently utilized as a counseling office w/ Reception Area, Main Front Office & 5 Additional Private Offices - Commercial unit has access to the backyard and additional 1, 000 SF of storage in basement - Lower Level is used for pantry food storage. This versatile space offers potential for expansion or conversion based on your needs. - 6 gas meters and 6 electric meters - Electrical and Plumbing: completely updated in 2002. - Heating: two gas heating boilers installed in 2002. - Water Heaters: two units-one serving the apartments (replaced this year) and one serving the commercial space (replaced 4 years ago). - Surveillance System: equipped with 24/7 surveillance for added security and peace of mind - Roof is 6 years old and resurfaced earlier this year - Brick building with vinyl siding installed to protect building - The L, J, M, and G subway lines are just steps away, ensuring easy transportation Williamsburg is known for its lively ambiance, with numerous retail stores, restaurants, bars, cafes, and artisan shops. 213 Johnson Ave represents a rare investment opportunity with solid mechanical systems, a versatile layout, and an unbeatable location. Lot Size: 23.83 x 100 ft Bdg Size: 23.83 x 60 ft Zoning: R6 FAR: 1.89; Max FAR: 2.43 *Disclaimer: All Information provided is deemed reliable but is not guaranteed and should be independently verified.

ML# :3578593   Another beautiful new construction home by one of Long Island’s most coveted construction companies, Modern Age Home Builders! 2350 Shipyard Ln features a European style modern design home with the first and second floor totaling 4, 000 sq ft. with a detached oversized 2 car garage (with an electric car charger), all sitting on over 1.5 acres of land. The property offers the possibility to join the Summit Estates Homeowners Association which includes access to the private beach, picnic areas, and to-be-built tennis courts! The first floor consists of a large foyer that leads to an open and airy great room and kitchen which is perfect for entertaining guests and hosting gatherings. The great room has a linear gas fireplace, accented with a stunning, large format tile. The kitchen is finished with custom 2 stage cabinets, custom quartz countertops, and a top of the line 7-piece appliance package. There is also a living room, dining area, mudroom, half bath, and master ensuite. The second floor consists of a master ensuite, 3 secondary bedrooms, and 2 additional full bathrooms. Additionally, there is a study, laundry room (including a washer and dryer), as well as a loft which can easily be converted into an addition bedroom or anything else you desire! All closets are dressed with custom wood shelving and all bathrooms consist of custom cabinets, quartz countertops, and imported Italian tile. The master ensuite and loft each have their own balconies. The home also has a large, nearly 2, 000 sq ft, semi-finished lower level which is ready to use as is or you can truly make it your own. The basement will be delivered with insulated laminate floors throughout, as well as drape wall insulation and a fully finished bathroom! It has large egress windows that allow for natural light, perfect for finishing. There are two covered patios in the back along with a 20’ x 40’ inground swimming pool and just steps from the beach!

ML# :3577949   Experience elegance in this custom-built colonial home, completed in 2009. With 6, 600 sq ft of designer living space, this 5-bedroom residence boasts exceptional craftsmanship, intricate architectural details, and lavish millwork throughout. A grand two-story entrance welcomes you into a sophisticated living room and private library. The state-of-the-art kitchen, featuring high-end appliances, opens to a spacious family room, perfect for daily luxury living and great entertaining. The second floor features a luxurious primary suite with a spa-like bathroom and private balcony, alongside four additional guest suites that provide ample space. The lower level is an entertainment haven, complete with a home theater and an entertainment room. Located in the prestigious Little Neck area, this home offers convenience to LIRR train services and shopping centers. Zoned for top-rated schools including PS 94 and MS 67, with optional schooling at PS 221. This property also includes a secure two-car garage.

ML# :3573699   7 units modern property for sale in the heart of Ridgewood. Great income producer for owner user or investor. Prime location, close to stores, cafes and public transportation. Laundry room in the building. Excellent condition!

ML# :3571685   Brick 3 story 10, 000 sq ft w/52 parking spaces Elevator, Sprinkler and Fire Alarm System Built in 2020