Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Advisor Realty
Property view
Listing view 2
Listing view 3

2829 Frankel Boulevard, 
Merrick, NY 11566

$2,399,999


8

Beds


6

Baths


6,818

Sq Ft


Single Family

Active

Listed by

Natan Amos

Resource Realty Group

Last updated:

January 10, 2026, 12:27 PM

MLS#

947687

Source:

OneKey MLS

About This Home

2829 Frankel Boulevard

A one of a kind masterpiece of unique architecture. Waterfront home, where luxury meets comfort and breathtaking views! The home boasts a magnificent indoor pool that is designed for both relaxation and recreation. The pool is adorned with sparkling tiles and offers a serene oasis right within the comfort of your home. The oversized kitchen in this home is a culinary haven. It is meticulously designed with ample space for meal preparation and entertaining. The countertops, crafted from beautiful granite, provide a luxurious touch and plenty of room for cooking and serving. State-of-the-art appliances. Convenience is paramount in this home, which is why it includes not just one, but two well-equipped laundry rooms. These rooms are equipped with high-quality washers and dryers, allowing for efficient and organized laundry care. To accommodate your vehicles and provide secure parking, this home features a spacious two-car garage. This garage offers ample space for your cars, along with extra storage room for tools, equipment, or recreational gear. In this home, you'll find a spacious cedar closet. This closet is custom-built with high-quality cedar wood, which not only exudes a pleasant aroma Enhancing both warmth and ambiance, this home features two gas working fireplaces. These fireplaces are designed to create a cozy atmosphere and serve as focal points in both the formal living room and the office. This home includes formal living and dining rooms that exude elegance and sophistication. The formal living room is tastefully decorated with beautiful hardwood floors, creating a warm and inviting space for relaxation and socializing. The formal dining room, adjacent to the living room, offers a refined setting for hosting formal dinners and special occasions, complemented by the stunning waterfront views. The office in this home is a dedicated space for work or study. Throughout this home, you'll find a seamless blend of hardwood and granite floors. The hardwood floors exude timeless elegance and add warmth to the living spaces, while the granite floors in the kitchen and bathrooms provide a luxurious touch. Indulge in ultimate relaxation and rejuvenation with the steam shower this home provides. This luxurious feature allows you to unwind and melt away the stress of the day. The walk-in closet in this home is designed to accommodate your storage needs while providing a touch of luxury. This spacious closet offers ample room for organizing and displaying your wardrobe, shoes, and accessories. With custom-built ins. Too much to list this property is a must see!!

Home Facts

Single Family

6 Baths

8 Bedrooms

Built in 1991

Price Summary

2,399,999

$352 per Sq. Ft.

MLS #:

947687

Last Updated:

January 10, 2026, 12:27 PM

Added:

16 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

8

Bathrooms

Total Bathrooms:

6

Full Bathrooms:

5

Interior

Living Area:

6,818 Sq. Ft.


Structure

Structure

Architectural Style:

Colonial

Building Area:

8,400 Sq. Ft.

Year Built:

1991


Lot

Lot Size (Sq. Ft):

16,200


Finances & Disclosures

Finances

Price:

$2,399,999

Price per Sq. Ft:

$352 per Sq. Ft.

Source:OneKey MLS
Copyright 2026 OneKey MLS. All rights reserved. Listings courtesy of OneKey MLS as distributed by MLS GRID . OneKey MLS provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. OneKey MLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of OneKey MLS.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.