$424,000
2 beds1,275 sq ft
Bay, harbor, inlet or soundShared waterfront site
251 174th St #218Sunny Isles Beach, FL 33160
Condo · MLS 11494323
Listing courtesy of Compass Florida, LLC · MyStateMLS
$419,000
Homes, condos and townhomes · MLS 11518899 · Listed 501 days ago (Jun 16, 2025)
Bay, harbor, inlet or sound · Shared waterfront site · Waterfront details
For sale: Listed and available according to the MyStateMLS feed.
Fantastic location at an unbeatable price in the heart of Sunny Isles Beach! This 2-bedroom, 2-bathroom condo features an open floor plan, split bedrooms, a balcony, and breathtaking views of the Intracoastal, ocean, and Sunny Isles skyline. HOA fees include gated parking, a heated pool, gym, cable, and internet. Walking distance to the beach, shops, restaurants, parks, playgrounds, and an 'A' rated K-8 school. Conveniently located near Aventura Mall, Bal Harbour Mall, and Gulfstream Park. 40/50-year certification complete. No rentals allowed during the first two years of ownership.
Description provided by the listing brokerage.
MLS-reported waterfront
The home is part of a condominium, cooperative or community whose shared site is reported as waterfront. Shoreline and docks are typically common or community property, not owned by the individual unit.
WaterfrontYN “Yes”: The listing is marked waterfront.WaterfrontFeatures “Bay”: Describes the water without a frontage value.PropertyTypeDetail “condo”: A unit on a shared (condominium-style) site.Classified from fields in the MyStateMLS listing data. It has not been independently verified, and it is not a survey, title examination or legal determination of shoreline or access rights. Rules version 2026-10-29.1. How we classify waterfront
Something wrong with this classification? Report a waterfront classification issue. Questions about frontage, docks or access are best answered by Compass Florida, LLC.
Facts are reported by the listing brokerage. Items not listed were not provided; that does not mean the property lacks them.
The pin is the listing's reported coordinates and may be approximate. It is not a parcel boundary or shoreline, and no flood, wetland or hazard conclusion should be drawn from it. See more listings in Sunny Isles Beach.
Changes observed by Waterfront Homes in MyStateMLS data since Oct 29, 2026. This is not a public-record sales history; MyStateMLS does not publish sold prices.
Estimated monthly payment
$2,594 per month
An estimate for comparison only, not a loan offer or approval. Actual rates, taxes, insurance, PMI and fees depend on your lender, credit, location and loan program.
Waterfront listings of the same property type and water type in Sunny Isles Beach, priced within 25% of this listing ($314,250 to $523,750), newest first. Each one passes the same waterfront rules. See all matches
$424,000
2 beds1,275 sq ft
Bay, harbor, inlet or soundShared waterfront site
Condo · MLS 11494323
Listing courtesy of Compass Florida, LLC · MyStateMLS
$429,000
2 beds1,275 sq ft
Bay, harbor, inlet or soundShared waterfront site
Condo · MLS 11456112
Listing courtesy of Compass Florida, LLC · MyStateMLS
Questions worth investigating for any waterfront property. They are not claims that this property has a problem or meets any condition.
Printable due-diligence checklist · Ownership budget planner · FEMA Flood Map Service Center (official flood maps; look up the address yourself)
Listing courtesy of Compass Florida, LLC. Listings provided by MyStateMLS.
Listing last updated by the brokerage Jun 18, 2025, 11:52 AM UTC. Waterfront Homes last received MyStateMLS data Oct 30, 2026, 7:53 PM UTC. Information is deemed reliable but not guaranteed; verify all details with the listing agent.