$1,500,000
SOLD AUG 19, 2025

Aquarius 1701 Gulf of Mexico Dr Unit 502 Longboat Key, FL 34228

2 Beds
2 Baths
1,551 Sq Ft
$2,314/mo HOA Fee

Recently Sold

$967 Per Sq Ft

16% Below List Price

81 Days on Market

Highlights

  • Beach Front
  • Water access To Gulf or Ocean
  • Heated Spa
  • Southside Elementary School Rated A
  • Fitness Center
  • Custom Home

About This Home

As of August 2025

Welcome to the Aquarius Club, a boutique coveted beachfront community on the serene southern end of Longboat Key, where just 58 residences enjoy an intimate, resort-style setting along the Gulf of Mexico. This 5th-floor, turnkey furnished direct Gulf-front condominium offers over 1,550+ SF of refined coastal living, with a desirable split floor plan featuring two bedrooms and two bathrooms. Flooded with natural light, the interiors exude casual sophistication with contemporary porcelain wood-look tile flooring, an updated kitchen, and beautifully renovated bathrooms. Floor-to-ceiling hurricane-impact windows in both bedrooms frame breathtaking views of the Gulf, while the spacious living and dining areas feature impact-rated sliders that open onto an extended balcony—perfect for morning coffee as the waves roll ashore or unwinding at sunset with a glass of wine in hand. The seamless indoor-outdoor flow invites the fresh sea breezes and soothing sounds of the surf into your everyday living experience. Aquarius Club offers a host of amenities, including tennis court, two pickleball courts, on-site management, a Gulf-front heated pool, and recently updated lobbies, hallways, a fitness center, community room, and conference space—all thoughtfully reimagined with coastal elegance. Adding to the allure, the world-class St. Regis Longboat Key Resort is located directly next door, and residents enjoy a complimentary social membership, providing access to exclusive dining, pool, state-of-the-art gym, and exceptional beachfront luxury. This is a rare opportunity to own a beachfront sanctuary that perfectly balances privacy, elegance, and the relaxed rhythms of island life.

Last Agent to Sell the Property

Ryan Ackerman

COLDWELL BANKER REALTY Brokerage Phone: 941-383-6411 License #0695084 Listed on: 04/28/2025

COLDWELL BANKER REALTY

Last Buyer's Agent

Ryan Ackerman

COLDWELL BANKER REALTY Brokerage Phone: 941-383-6411 License #0695084 Listed on: 04/28/2025

COLDWELL BANKER REALTY

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $11,031

Year Built

  • Built in 1975

Lot Details

  • Beach Front
  • Property fronts gulf or ocean
  • South Facing Home
  • Mature Landscaping
  • Landscaped with Trees

HOA Fees

  • $2,314 Monthly HOA Fees

Property Views

  • Beach
  • Full Gulf or Ocean

Home Design

  • Custom Home
  • Turnkey
  • Built-Up Roof
  • Concrete Roof
  • Block Exterior
  • Pile Dwellings
  • Stucco

Interior Spaces

  • 1,551 Sq Ft Home
  • Open Floorplan
  • Ceiling Fan
  • Shades
  • Blinds
  • Drapes & Rods
  • Sliding Doors
  • Living Room
  • Dining Room
  • Inside Utility

Kitchen

  • Range
  • Recirculated Exhaust Fan
  • Dishwasher
  • Stone Countertops
  • Disposal

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Primary Bedroom on Main
  • En-Suite Bathroom
  • Walk-In Closet
  • 2 Full Bathrooms
  • Single Vanity
  • Shower Only
  • Multiple Shower Heads

Laundry

  • Laundry Room
  • Dryer
  • Washer

Home Security

Parking

  • 1 Carport Space
  • Portico
  • Ground Level Parking
  • Open Parking
  • Deeded Parking
  • 1 Assigned Parking Space

Pool

  • Heated Spa
  • In Ground Spa
  • Heated Pool

Outdoor Features

  • Water access To Gulf or Ocean
  • Balcony
  • Covered Patio or Porch
  • Exterior Lighting

Location

  • Flood Zone Lot

Schools

  • Southside Elementary School
  • Booker Middle School
  • Booker High School

Utilities

  • Central Heating and Cooling System
  • Vented Exhaust Fan
  • Electric Water Heater

Listing and Financial Details

Community Details

Overview

  • Association fees include common area taxes, pool, escrow reserves fund, maintenance structure, ground maintenance, management, pest control, recreational facilities, sewer, trash, water
  • Melanie Horton Association, Phone Number (941) 383-4223
  • Aquarius Club Community
  • Aquarius Club Subdivision
  • On-Site Maintenance
  • Association Owns Recreation Facilities
  • 6-Story Property

Recreation

  • Tennis Courts
  • Pickleball Courts
  • Recreation Facilities
  • Fitness Center
  • Community Pool
  • Community Spa

Pet Policy

  • No Pets Allowed

Additional Features

  • Elevator
  • Fire and Smoke Detector

Property Details

Home Type

Condominium

Est. Annual Taxes

$11,031

Year Built

Built in 1975

Lot Details

0

HOA Fees

$2,314 per month

Listing Details

  • HOA Fee Includes: Common Area Taxes, Pool, Escrow Reserves Fund, Maintenance Structure, Maintenance Grounds, Management, Pest Control, Recreational Facilities, Sewer, Trash, Water
  • Property Type: Residential
  • Property Sub Type: Condominium
  • Architectural Style: Custom, Other
  • Construction Materials: Block, Stucco
  • Fireplace: No
  • Living Area: 1551
  • Lot Size Acres: 4.15
  • New Construction: No
  • Year Built: 1975
  • Building Area Total: 1740
  • Lot Size Sq Ft: 180911
  • Directions to Property: Longboat Key, Gulf of Mexico Dr. to 1701 Aquarius Club on the beach side.
  • Status: Sold
  • Ownership: Condominium
  • Available for Lease YN: 1
  • Escrow State: FL
  • Floor Number: 5
  • List Office Head Office Key Nume: 1046393
  • Minimum Lease: 3 Months
  • RATIO Current Price By Calculate: 967.12
  • Total Acreage: 2 to less than 5
  • Unit Number YN: 0
  • Water Access YN: 1
  • Condo Fees Term: Quarterly
  • MFR_NumAssignedParkingSpaces: 1
  • MFR_InLawSuiteYN: 0
  • MFR_DockYN: 0
  • MFR_CommunityAssociationWaterFeatures: Gulf/Ocean Front,Water Access,Waterfront
  • Attribution Contact: 941-383-6411
  • Tax Year: 2024
  • Special Features: VirtualTour

Interior Features

  • Living Area Units: Square Feet
  • Flooring: Tile
  • Full Bathrooms: 2
  • Interior Amenities: Ceiling Fans(s), Open Floorplan, Primary Bedroom Main Floor, Stone Counters, Walk-In Closet(s), Window Treatments
  • Appliances Included: Dishwasher, Disposal, Dryer, Electric Water Heater, Exhaust Fan, Range, Refrigerator, Washer
  • Foundation Details: Stilt/On Piling
  • Total Bedrooms: 2
  • Levels: One
  • Spa Features: Heated, In Ground
  • Spa Yn: Yes
  • Stories: 6
  • Window Features: Blinds, Drapes, Shades
  • Street Number Modifier: 1701
  • Additional Rooms: Inside Utility
  • Living Area Meters: 144.09
  • Room Count: 5

Exterior Features

  • Direction Faces: South
  • Pool Features: Heated
  • Exterior Features: Balcony, Lighting, Sliding Doors, Tennis Court(s)
  • Roof: Built-Up, Concrete
  • Pool Private: No
  • View: Water
  • Waterfront: Yes
  • Patio and Porch Features: Covered, Patio, Porch, Side Porch
  • Road Surface Type: Asphalt, Paved
  • Water Access: Beach,Gulf/Ocean
  • Water Extras YN: 0
  • Water View: Beach,Gulf/Ocean - Full
  • Water View YN: 1
  • Waterfront Feet Total: 0
  • Flood Zone Date: 2024-03-27
  • Flood Zone Panel: 12115C0126G

Garage/Parking

  • Carport Spaces: 1
  • Carport Y N: Yes
  • Garage Yn: No
  • Parking Features: Assigned, Covered, Deeded, Ground Level, Guest, Open, Portico

Utilities

  • Utilities: Public
  • Cooling: Central Air
  • Heating: Central, Electric
  • Laundry Features: Inside, Laundry Room
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Community Features: Association Recreation - Owned, Buyer Approval Required, Fitness Center, Pool, Tennis Court(s)
  • Association Amenities: Elevator(s), Fitness Center, Maintenance, Pickleball Court(s), Pool, Recreation Facilities, Spa/Hot Tub, Tennis Court(s)
  • Association Name: Melanie Horton
  • Phone: 941-383-4223
  • Association: No
  • Security: Smoke Detector(s)
  • Senior Community: No
  • Association 2 YN: 0
  • Association Approval Required YN: 1
  • Building Name Number: AQUARIUS CLUB
  • Condo Fees: 6943
  • Condo Land Included YN: 1
  • Montly Maint Amt Addition To HOA: 0
  • Association Email: aquariusclublbk@gmail.com
  • Monthly Condo Fee Amount: 2314

Fee Information

  • Total Annual Fees: 27772.00
  • Total Monthly Fees: 2314.33

Schools

  • Elementary School: Southside Elementary
  • High School: Booker High
  • Middle Or Junior School: Booker Middle

Lot Info

  • Zoning: R6MX
  • Parcel Number: 0009043041
  • Additional Parcels: No
  • Lot Features: FloodZone
  • Flood Zone Code: AE
  • Homestead YN: 0
  • Lot Size Square Meters: 16807

Green Features

  • Green Verification Count: 0

Rental Info

  • Furnished: Turnkey
  • Pets Allowed: No
  • Lease Restrictions YN: 1
  • Additional Lease Restrictions: Application / Lease approval required. Tenants no pets.

Tax Info

  • Tax Annual Amount: 11031
  • Tax Book Number: 8-29
  • Tax Lot: 1701

Multi Family

  • Waterfront Features: Beach Front, Gulf/Ocean
  • Approval Process: Application & fee, Background check & interview.

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 28, 2025
Closed on
Aug 18, 2025
Sold by
Cerullo Kim J and Kim J Cerullo Revocable Trust
Bought by
Govic Mario and Govic Ann Marie
Seller's Agent
Ryan Ackerman
COLDWELL BANKER REALTY
Buyer's Agent
Ryan Ackerman
COLDWELL BANKER REALTY
List Price
$1,795,000
Sold Price
$1,500,000
Premium/Discount to List
-$295,000
-16.43%
Views
18

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
140.01%
Original Mortgage
$1,300,000
Outstanding Balance
$1,300,000
Interest Rate
6.67%
Mortgage Type
Seller Take Back
Estimated Equity
$239,920

Purchase Details

Closed on
Apr 29, 2021
Sold by
Geist Robert W and Robert Geist Md Revocable Trus
Bought by
Geist Robert W and Robert W Geist Revocable Trust

Purchase Details

Closed on
Dec 20, 2004
Sold by
Geist Robert W
Bought by
Geist Md Robert W
Source: Public Records

Similar Homes in Longboat Key, FL

  • 601 Longboat Club Rd Unit 504S, Longboat Key, FL 34228

    $1,590,000

    • 2 Beds
    • 2 Baths
    • 1,560 Sq Ft
    • 601 Longboat Club Rd
    • Unit 504S
    • Longboat Key, FL

    Welcome to Unit 504S — a rare corner residence perched above the sand and sea on the highly sought-after south end of Longboat Key. With uninterrupted views of both the Gulf of Mexico and the Links on Longboat Golf Course, this spacious 2-bedroom, 2.5-bath condominium offers a rare opportunity to design your dream coastal retreat.Spanning over 1,560 square feet, the split-bedroom

    Irma Scherer COMPASS FLORIDA LLC

    Section Image
  • 1701 Gulf of Mexico Dr Unit 404, Longboat Key, FL 34228

    $1,550,000

    • 2 Beds
    • 2 Baths
    • 1,551 Sq Ft
    • 1701 Gulf of Mexico Dr
    • Unit 404
    • Longboat Key, FL

    AQUARIUS CLUB – This exquisitely renovated fourth floor residence is situated within an exclusive beachfront boutique community on Longboat Key, located directly adjacent to the new Five Diamond St. Regis Resort. Modern design blends seamlessly with coastal elegance in the two-bedroom, two-bathroom retreat. The meticulously updated interior offers 1,551 Sq. ft of open living space, with privacy

    Doug Parks MICHAEL SAUNDERS & COMPANY

    Section Image
  • 1445 Gulf of Mexico Dr Unit 304, Longboat Key, FL 34228

    $1,500,000

    • 3 Beds
    • 3 Baths
    • 1,859 Sq Ft
    • 1445 Gulf of Mexico Dr
    • Unit 304
    • Longboat Key, FL

    Timeless sophistication meets resort-style elegance in this fully renovated 3-bedroom residence at the coveted Players Club on Longboat Key. Ideally situated on the sought-after south end of the island, this home places you moments from the prestigious St. Regis Hotel, the Longboat Key Club, Publix, and the upscale dining, boutique shopping, and cultural attractions of St. Armands Circle and

    Mairead Smialek COLDWELL BANKER REALTY

    Section Image
  • 1445 Gulf of Mexico Dr Unit 404, Longboat Key, FL 34228

    $1,349,000

    • 3 Beds
    • 2 Baths
    • 1,679 Sq Ft
    • 1445 Gulf of Mexico Dr
    • Unit 404
    • Longboat Key, FL

    Gulf-Front Elegance at The Players Club. Welcome to the epitome of coastal luxury living at The Players Club, where the pristine shores of Longboat Key meet world-class resort-style amenities. This beautifully renovated 3-bedroom, 2-bath split-plan residence is being offered turn-key furnished - ready for you to move in and immediately embrace the Gulf-front lifestyle. From the moment you step

    Kathy Callahan MICHAEL SAUNDERS & COMPANY

    Section Image
  • 1445 Gulf of Mexico Dr Unit 203, Longboat Key, FL 34228

    $1,250,000

    • 2 Beds
    • 2.5 Baths
    • 1,721 Sq Ft
    • 1445 Gulf of Mexico Dr
    • Unit 203
    • Longboat Key, FL

    Under contract-accepting backup offers. Welcome to your perfect Gulf-front getaway at The Players Club on Longboat Key. This beautifully renovated second-floor condominium offers stunning views of the Gulf of Mexico and is just steps from the pristine beach. From the moment you enter, your eyes are drawn through the spacious great room to the expansive balcony, where you can relax for hours in

    Mairead Smialek COLDWELL BANKER REALTY

    Section Image
  • 1932 Harbourside Dr Unit 244, Longboat Key, FL 34228

    $1,200,000

    • 2 Beds
    • 2 Baths
    • 1,192 Sq Ft
    • 1932 Harbourside Dr
    • Unit 244
    • Longboat Key, FL

    Welcome to this breathtaking, fully remodeled, turnkey furnished contemporary residence in Fairway Bay—nestled on picturesque Longboat Key. From the moment you enter, you're greeted by a thoughtfully redesigned open floor plan, elevated ceilings, solid core doors, and impeccable high-end finishes. IT IS TRULY ONE OF A KIND! This condominium is truly one-of-a-kind! Exceptional Kitchen features

    Jan Jordan BETTER HOMES AND GARDENS REAL ESTATE ATCHLEY PROPE

    Section Image
  • 2105 Gulf of Mexico Dr Unit 3303, Longboat Key, FL 34228

    $1,650,000

    • 2 Beds
    • 2 Baths
    • 1,463 Sq Ft
    • 2105 Gulf of Mexico Dr
    • Unit 3303
    • Longboat Key, FL

    Welcome to your dream oasis. Just completed fully updated, turnkey furnished unit, directly on the Gulf, at Sunset Beach. This stunning retreat boasts spectacular renovations, featuring a custom kitchen with solid wood cabinets, a light commercial-grade hood fan and elegant quartz countertops throughout. The kitchen has a GE Monogram induction stove with a convection oven, a GE Monogram

    Dennis Girard PREMIER SOTHEBY'S INTERNATIONAL REALTY

    Section Image
  • 1211 Gulf of Mexico Dr Unit 309, Longboat Key, FL 34228

    $1,819,000

    • 2 Beds
    • 2 Baths
    • 1,827 Sq Ft
    • 1211 Gulf of Mexico Dr
    • Unit 309
    • Longboat Key, FL

    Surround yourself with captivating views and timeless design in this coastal retreat thoughtfully renovated by Brista Homes. While offering partial views, this residence is the closest unit on the market to full beachfront—just one tier away—making it a rare opportunity to enjoy a front-row coastal lifestyle. Inside, every detail has been thoughtfully curated to inspire both beauty and function.

    Gina Ursini BRISTA REALTY LLC

    Section Image
  • 1211 Gulf of Mexico Dr Unit 702, Longboat Key, FL 34228

    $1,500,000

    • 3 Beds
    • 3 Baths
    • 2,100 Sq Ft
    • 1211 Gulf of Mexico Dr
    • Unit 702
    • Longboat Key, FL

    Enjoy breathtaking 270-degree views from the gulf to the bay in this exceptionally furnished 2,100-square-foot residence. The deluxe primary suite boasts dual walk-in closets and a beautifully renovated en-suite bath. The guest suite features a queen-sized Murphy bed, en-suite bath and walk-in closet, while the den, thoughtfully designed as a third en-suite guest room, includes a queen Murphy

    Jo Rutstein PREMIER SOTHEBY'S INTERNATIONAL REALTY

    Section Image

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Warranty Deed $1,500,000 None Listed On Document
Interfamily Deed Transfer -- Accommodation
Warranty Deed -- Accommodation
Interfamily Deed Transfer -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $1,300,000 Seller Take Back
Previous Owner $277,000 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/19/2025 08/19/25 Sold $1,500,000 -11.5% $967 / Sq Ft
07/18/2025 07/18/25 Pending -- -- --
05/16/2025 05/16/25 Price Changed $1,695,000 -5.6% $1,093 / Sq Ft
04/28/2025 04/28/25 For Sale $1,795,000 -- $1,157 / Sq Ft
Source: Stellar MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $10,501 $794,123 -- --
2023 $10,501 $835,400 $0 $835,400
2022 $9,042 $656,300 $0 $656,300
2021 $5,733 $394,700 $0 $394,700
2020 $5,769 $387,100 $0 $387,100
2019 $7,175 $494,300 $0 $494,300
2018 $6,742 $474,100 $0 $474,100
2017 $6,070 $407,700 $0 $407,700
2016 $7,022 $473,300 $0 $473,300
2015 $6,724 $450,600 $0 $450,600
2014 $6,722 $339,500 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Stellar MLS

MLS Number: A4650323

Stellar MLS

APN: 0009-04-3041