For sale

$1,125,000

Est. $9,149/mo —

•

1,433

sq ft

5790 Midnight Pass Rd #209, Sarasota, FL 34242

About this home

Welcome to highly sought-after "Building A" at the Gulf & Bay Club located on Siesta Key Beach! Where you'll be just steps to the No. 1 BEACH in the USA! As you enter the gated community, you will feel like you've landed in paradise as you make your way down the brick paved streets to the building closest to the beach. Offered TURN-KEY FURNISHED, this nicely updated 2-bedroom, 2-bathroom condo located on the second floor offers quick and easy access to the amenities and is just steps to private beach access! From the moment you enter you'll be drawn to the incredible views of the beach, gulf, pool, pond and beautiful grounds of the community! The kitchen features a large island, breakfast bar, granite countertops, new appliances and plenty of cabinetry for storage. The open floor plan is great for entertaining. Comfortably sleeps 6 people. Both bathrooms have been beautifully updated. New wood flooring follows throughout with tile in the kitchen. The unit offers an inside laundry room and an owner’s storage closet for your beach toys! Enjoy several upgrades including ceiling fans in each room, crown molding, custom trim woodwork and more! Amenities include 32 pristine acres, 800 feet of private beach on Siesta Key, a lush Tropical courtyard with a freshwater lake, 3 large heated pools, outdoor barbecuing areas, 6 tennis courts including 1 Har-Tru court, pickleball, basketball, shuffleboard, 2 clubhouses, media center, pool table and TV’s, fitness center and more! Schedule a showing today!

CondoProperty Type

1979Year Built

$785Price/Sq.Ft.

$1,647/moHOA Dues

1 spaceParking

Listed by Jamie Mullis • COLDWELL BANKER REALTY

Contact: 941-493-1000

Listing updated: Oct 20, 2026 at 01:06pm

Redfin checked: a minute ago

•Source:Stellar MLS as Distributed by MLS Grid #N6144235

Payment calculator

$9,149 per month

Principal and interest$6,063

Property taxes

HOA dues

Home insurance

Utilities

5 minutes to get started. No credit impact.

Affordability tools

See this home in person

Open houses

No upcoming open houses.

Nearby open houses (10)

OPEN TODAY, 12PM TO 3PM3D WALKTHROUGH
$1,195,000
2 beds2 baths1,505 sq ft
3235 Gulf OF Mexico Dr Unit A201, Longboat Key, FL 34228
$1,625 HOA • Community pool • Built 1975
OPEN TODAY, 1PM TO 4PM
$475,000
3 beds2 baths2,045 sq ft
281 Laurel Hollow Dr #62, Nokomis, FL 34275
0.24 acre lot • Garage • Pool
OPEN TODAY, 1PM TO 4PM
$469,000
3 beds2 baths1,277 sq ft
Sarasota, FL 34232
9,667 sq ft lot • Garage • Pool
OPEN TODAY, 1PM TO 4PM
$700,000
3 beds2 baths2,131 sq ft
905 Faulkwood Ct, Sarasota, FL 34232
8,957 sq ft lot • 2 garage spots • Pool
OPEN TODAY, 1PM TO 3PM
$775,000
3 beds3 baths2,610 sq ft
1408 Vermeer Dr, Nokomis, FL 34275
0.34 acre lot • 3 garage spots • Pool
OPEN TODAY, 1PM TO 4PM
$1,249,000
2 beds2 baths1,409 sq ft
1050 Longboat Club Rd #901, Longboat Key, FL 34228
$1,875 HOA • Community pool • Built 1974
REDFIN OPEN NOV 14, 10AM TO 12PM3D WALKTHROUGH
$699,000
3 beds2.5 baths2,033 sq ft
817 Oak Vista Dr, Sarasota, FL 34232
0.5 acre lot • 2 garage spots • Built 1999
REDFIN OPEN NOV 14, 11AM TO 2PM3D & VIDEO TOUR
$415,000
3 beds3 baths1,920 sq ft
209 Palm Ave, Nokomis, FL 34275
0.36 acre lot • 2 garage spots • Built 1963
OPEN NOV 14, 11AM TO 1PM
$315,000
3 beds2 baths1,430 sq ft
128 Revolution Way #128, Osprey, FL 34229
$475 HOA • Garage • Community pool
REDFIN OPEN NOV 14, 2PM TO 4PM3D WALKTHROUGH
$354,900
3 beds2 baths1,151 sq ft
5005 Bee Ridge Rd, Sarasota, FL 34233
9,000 sq ft lot • Garage • Built 1960

Interested in buying?

Make a winning offer with the help of a local agent

Around this home

Schools

K - 12
Preschool & daycare

Phillippi Shores Elementary School

Public PreK-5 • Assigned • 1.9mi

9/10

Brookside Middle School

Public 6-8 • Assigned • 2.9mi

7/10

Sarasota High School

Public 9-12 • Assigned • 4.4mi

5/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Property details

Interior
Exterior
Finance

Kitchen

Bathroom

Bedroom

Living

Dining

Interior features
Ceiling fans
Crown molding
Open floor plan
Thermostat
Walk-in closet

Bedrooms
2 bedrooms

Bathrooms
2 full bathrooms

Kitchen
Eat-in kitchen
Solid surface counters
Dishwasher
Disposal
Microwave
Range
Refrigerator

Laundry & utility
Inside laundry room
Washer
Dryer
Electric water heater

Flooring
Laminate
Tile

Heating & cooling
Electric heating
Central air

Sale and tax history for 5790 Midnight Pass Rd #209

Sale History
Tax History

Date

Event

Price

Stellar MLS as Distributed by MLS Grid #N6144235

Oct 10, 2026

Relisted

—

Oct 7, 2026

Listing Removed

—

Aug 21, 2026

Relisted

—

Aug 7, 2026

Contingent

—

Jul 7, 2026

Relisted

—

Jun 8, 2026

Listing Removed

—

May 22, 2026

Price Changed

$1,125,000

$785/sq ft

May 8, 2026

Listed

$1,150,000

$803/sq ft

Stellar MLS as Distributed by MLS Grid #N6141203

Jan 31, 2026

Listing Removed

—

Stellar MLS as Distributed by MLS Grid #A4201434

Jan 31, 2018

Sold

$700,000

$488/sq ft

Jan 15, 2018

Pending

—

Dec 5, 2017

Price Changed

$750,000

$523/sq ft

Nov 10, 2017

Listed

$850,000

$593/sq ft

This is a beautiful 1,433-square-foot condominium in one of the best resorts on Siesta Key, Gulf & Bay Club. This two-bedroom, two-bath renovated residence is nicely appointed with plenty of room to live the island lifestyle. The well-planned kitchen has loads of storage space and an island, which is great for prepping and entertaining. The convenient inside utility room has a full-size washer and dryer and storage. Relax and enjoy views of the tropically landscaped grounds, lake, pool and amazing white sand beach and azure waters of the Gulf of Mexico. Gulf & Bay Club is a Gulf-front, guard-gated community that is perfectly situated on the No. 1 beach in the USA. Amenities include three heated pools, eight tennis courts, a fitness center with spa, an expansive clubhouse with library and computer room, racquetball and basketball courts, two freshwater lakes, shuffleboard and multiple barbecue areas with picnic tables. Take any one of four boardwalks to enjoy the famous sugar-white sand of Siesta Beach and the spectacular, blazing sunsets. This residence is conveniently located midway between the north and south bridges and close to Siesta Village. The cultural amenities of downtown Sarasota, shopping and fine dining are just 15 minutes by auto.

Property Description

High Rise

Public Records

Apr 30, 2007

Sold

$775,000

$541/sq ft

Public record

Public record
Zoning

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

—

Year renovated

2004

Finished Sq. Ft.

1,433

Unfinished Sq. Ft.

—

Total Sq. Ft.

1,433

Year built

1979

Style

Condo/Co-op

County

Sarasota County

APN

0105042018

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 15, 2026.

RMF-3

SKOD

Multi-Family District

The RMF Districts permit multifamily residential densities, which may take the form of a variety of housing types, including single-family detached, lot line, traditional, patio, villa, atrium, duplex, townhouse, multiplex, or apartment units. These districts are used in areas having convenient access to both collector and arterial streets, and nearby civic and commercial uses, as well as employment opportunities; The RMF Districts are generally used to implement the Comprehensive Plan within those areas shown as Medium Density Residential, High Density Residential, Office Multifamily Residential Areas and Corridors, and Town and Village Centers on the Future Land Use Map, on the Barrier Islands where the application of the district would not increase the density of development or hamper hurricane evacuation planning and disaster mitigation efforts, and Developments of Regional Impact. The RMF Districts, while not a primary implementing district, may also be allowed in Regional, Community, Village I, Village II, and Neighborhood Commercial Centers. Appropriate densities within the Medium Density and High Density Residential areas shall be guided by the density ranges as outlined in Future Land Use Policy 1.1.1, Objective 2.3, and Policy 2.3.1 of the Comprehensive Plan. These densities shall also be determined, in part, by the land use designations and developed residential areas surrounding the parcel.

Zone overlays

Siesta Key Overlay District

Permitted uses

Include but are not limited to:

Community / recreation center
Day care facility
Housing-Group
Housing-Single unit
Housing-Multiple units
Housing-Senior
Housing-Student
Infrastructure
Wastewater treatment
Park & open space

Climate risks

9/10 Flood Factor

Estimated 80%+ chance of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

10/10 Heat Factor

7 days above 107° expected this year, 29 days in 30 years

10/10 Wind Factor

99% chance of strong winds in next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 1 days in 30 years

Provided by First Street

Historical weather

Sarasota, FL • 34242

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

98/ 100

Exceptional sunlight

Sunscore

This home ranks in the top 16% for direct sun exposure in Sarasota. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.

8.8 hrs

6.6 hrs

JuneDecember

Provided by Shadowmap

Redfin Estimate for 5790 Midnight Pass Rd #209

$1,046,057

$79K under list price of $1.13M

Nearby comparable homes

The Redfin Estimate uses 6 recent nearby sales, priced between $965K to $1.3M.

SOLD SEP 30, 2026
$965,000 Last sold price
2 beds2 baths1,361 sq ft
5760 Midnight Pass Rd Unit 209D, Siesta Key, FL 34242
$76/sq ft
2 years newer
SOLD MAY 6, 2026
$1,113,000 Last sold price
2 beds2 baths1,285 sq ft
5830 Midnight Pass Rd #705, Sarasota, FL 34242
$81/sq ft
3 years older
SOLD OCT 2, 2026
$1,125,000 Last sold price
2 beds2 baths1,449 sq ft
5740 Midnight Pass Rd Unit 104F, Siesta Key, FL 34242
$9/sq ft
7 years newer
SOLD JUL 14, 2026
$1,300,000 Last sold price
2 beds2 baths1,334 sq ft
5920 Midnight Pass Rd #704, Sarasota, FL 34242
$190/sq ft
8 years older
SOLD AUG 24, 2026
$1,070,000 Last sold price
2 beds2 baths1,335 sq ft
5790 Midnight Pass Rd #506, Sarasota, FL 34242
$16/sq ft
SOLD JAN 30, 2026
$1,300,000 Last sold price
2 beds2 baths1,471 sq ft
5750 Midnight Pass Rd Unit 508 E, Siesta Key, FL 34242
$99/sq ft
5 years newer

Rental earnings

Est. $2,426 per month, based on comparable rentals

Tour for free, no strings attached

Takes about 5 minutes & won’t affect your credit

Ask a question

(407) 863-9765

Early Access listings

EARLY ACCESSCOLDWELL BANKER REALTY COMING SOON

$470,000

4 beds3 baths1,700 sq ft

2935 Sunset Vista Blvd, Kissimmee, FL 34747

EARLY ACCESSCOLDWELL BANKER REALTY COMING SOON

$699,900

4 beds3 baths2,744 sq ft

11902 Granite Woods Loop, Venice, FL 34292

EARLY ACCESSCOLDWELL BANKER REALTY COMING SOON

$264,000

3 beds2 baths1,540 sq ft

128 Miller Dr, Winter Haven, FL 33884

EARLY ACCESSCOLDWELL BANKER REALTY COMING SOON

$159,000

2 beds2 baths960 sq ft

165 Hickory Gate Dr, Palm Harbor, FL 34684

EARLY ACCESSCOLDWELL BANKER COMING SOON

$549,000

3 beds2 baths1,781 sq ft

36431 Fairview Heights Rd, Zephyrhills, FL 33541

EARLY ACCESSCOLDWELL BANKER REALTY COMING SOON

$2,250,000

4 beds4 baths2,854 sq ft

6111 Tarawood Dr, Orlando, FL 32819

Nearby similar homes

$45,000

4 beds3 baths2,460 sq ft

915 Seaside Dr Unit 405, WEEKS 22-23, Sarasota, FL 34242

Listed 76 days

$299,000

1 bed1 bath797 sq ft

5641 Midnight Pass Rd #902, Sarasota, FL 34242

Community boat docks • Public beach access • Listed 90 days

$229,000

2 beds2 baths1,164 sq ft

1647 Southwood St #1647, Sarasota, FL 34231

Updated kitchen • Plantation shutters • Tropical landscaping

$1,090,000

2 beds2 baths1,217 sq ft

1313 Dockside Pl #120, Sarasota, FL 34242

45 boat slip • New boat lift • Waterfront townhouse

OPEN TODAY, 1:30PM TO 3:30PMVIDEO TOUR

$645,000

3 beds3 baths2,172 sq ft

1703 Starling Dr #1703, Sarasota, FL 34231

Screened lanai • 2.66 acre lot • 2 garage spots

OPEN TODAY, 1PM TO 4PM3D & VIDEO TOUR

$3,995,000

4 beds3 baths2,385 sq ft

1035 Seaside Dr #502, Sarasota, FL 34242

Gulf view residence • Expansive terraces • Solid wood cabinetry

New listings for sale in 34242

NEW 24 HRS AGO

$1,200,000

5 beds4 baths2,961 sq ft

618 Avenida DE Mayo, Siesta Key, FL 34242

6,566 sq ft lot • Built 1948

$1,100,000

3 beds2 baths1,582 sq ft

310 Avenida Milano, Sarasota, FL 34242

Canal front lot • Private estate • Major renovation

3D WALKTHROUGH

$2,195,000

3 beds3.5 baths2,856 sq ft

3941 Hamilton Club Cir #9, Sarasota, FL 34242

Private boating • Private elevator • Impact rated windows

$598,000

2 beds2 baths1,303 sq ft

8767 Midnight Pass Rd Unit 205F, Sarasota, FL 34242

Boat docks • Kayak launches • Fitness center

3D WALKTHROUGH

$325,000

Studio1 bath420 sq ft

6006 Midnight Pass Rd #48, Sarasota, FL 34242

Community pool view • Stainless steel sink • Two swimming pools

$5,199,000

8 beds9 baths4,681 sq ft

316 Beach Rd, Sarasota, FL 34242

Deeded beach access • Panoramic gulf views • Private elevator

$560,000

1 bed1 bath728 sq ft

5830 Midnight Pass Rd #61, Sarasota, FL 34242

Redesigned kitchen • New appliances • $1,231 HOA

$2,495,000

4 beds2.5 baths2,513 sq ft

3458 Anglin Dr, Sarasota, FL 34242

Double lot • 0.33 acre lot • Garage

$3,900,000

5 beds5 baths3,824 sq ft

67 Avenida Messina Unit B, Sarasota, FL 34242

Gated enclave • Sunlit kitchen • Separate balcony

Details provided by Stellar MLS as Distributed by MLS Grid and may not match the public record. Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Siesta Beach homes for sale
The Landings homes for sale
Sarasota Beach homes for sale
Siesta homes for sale
Whispering Sands Condominiums homes for sale

Houses for rent in Siesta Key	Agents near me	Fort Lauderdale, FL homes for sale	Siesta Key Housing Market
Houses for sale near me	Orlando, FL homes for sale	Sarasota, FL homes for sale
Land for sale near me	Tampa, FL homes for sale	Boca Raton, FL homes for sale
Open Houses near me	Miami, FL homes for sale	Siesta Key Property Records
Condos for sale near me	Jacksonville, FL homes for sale	FL New Listings

Bradenton homes for sale
Venice homes for sale
Sarasota homes for sale

About this home

Payment calculator

Affordability tools

See this home in person

Nearby open houses (10)

Interested in buying?

Around this home

Schools

Lifestyle

Property details

Sale and tax history for 5790 Midnight Pass Rd #209

Public record

Climate risks

Historical weather

Sun exposure

Redfin Estimate for 5790 Midnight Pass Rd #209

Early Access listings

Nearby similar homes

New listings for sale in 34242

More real estate resources