SoldApr 23, 2026

Listed by George Duquette

Source: Stellar MLS #N6143045

406/5790 Midnight Pass Road, Siesta Key, FL, 34242

$1,120,000

2
2
1
1433 sq. ft.
267966 sq. ft.

Condo

3 days on the market

Sold: Apr 23, 2026

What's around 406/5790 Midnight Pass Road

About this property

Experience quintessential Siesta Key living at 5790 Midnight Pass Rd, Unit 406, a beautifully updated 2-bedroom, 2-bath residence with sweeping Gulf views and an unbeatable location just minutes from the sugar-white sands and the energy of Siesta Village. Inside, a thoughtfully designed layout offers a spacious living and dining area that flows to the Gulf-facing side of the home, where impact windows frame breathtaking water vistas and add peace of mind. The remodeled kitchen pairs modern finishes with everyday functionality, while both bedrooms have been tastefully refreshed for a clean, coastal feel - ideal for relaxed island living. Set within the renowned Gulf & Bay Club, residents enjoy a true resort lifestyle with three heated pools (including a lap pool), private beach access with beach chairs, shaded tiki huts, and grilling areas perfect for sunset dinners. The amenity lineup is exceptional: 8 tennis courts (including Har-Tru surfaces), pickleball, basketball, and shuffleboard, plus a fully equipped fitness center with cardio, free weights, and a yoga space. Unwind after the beach in the hot tub spa or one of six dry saunas. Two expansive clubhouses add to the community's lively social atmosphere with billiards, gathering rooms, and seasonal events, tournaments, and group outings. Beyond the gates, you'll love the convenience of the free island trolley and easy access to Siesta Key's boutiques, dining, live music, and nightlife. And when you're ready for a change of pace, Downtown Sarasota is just a short drive away - offering acclaimed arts, theatre, cultural attractions, and waterfront dining. Secure and gated, Gulf & Bay Club is one of the most desirable Gulf-front communities on Siesta Key, making Unit 406 a standout opportunity for full-time residents, seasonal owners, or investors seeking exceptional amenities in an iconic beachfront setting.

Looking for more information on 406/5790 Midnight Pass Road?

Explore comparables, sales history and growth for this property.
Learn more

Similar properties sold nearby

SoldJul 13, 2026
$585,000
307/1200 East Peppertree Lane
Siesta Key FL 34242
2
2
1
Condo
Listing courtesy of DOUGLAS ELLIMAN and COLDWELL BANKER REALTY
SoldJul 8, 2026
$400,000
301/101 Whispering Sands Drive
Siesta Key FL 34242
2
2
1
Condo
Listing courtesy of COLDWELL BANKER REALTY
SoldJul 8, 2026
$850,000
2A/35 Sandy Cove Road
Siesta Key FL 34242
2
2
1
Condo
Listing courtesy of MICHAEL SAUNDERS & COMPANY

Other properties sold by George Duquette

SoldJun 26, 2026
$575,000
10624 Corkwood Court
Venice FL 34293
3
2
2
Single-Family
Listing courtesy of ENGEL & VOELKERS VENICE DOWNTOWN
SoldJun 25, 2026
$370,000
17784 Stillness Court
Venice FL 34293
3
2
2
Villa
Listing courtesy of ENGEL & VOELKERS VENICE DOWNTOWN
SoldMay 27, 2026
$370,000
17787 Stillness Court
North Port FL 34293
3
2
2
Villa
Listing courtesy of MATTAMY REAL ESTATE SERVICES and ENGEL & VOELKERS VENICE DOWNTOWN

Browse properties sold in nearby areas

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under MLS GRID IDX Rules Updated September 16, 2024 7 U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to: dmca@ratemyagent.com

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

Email
© 2026 RateMyAgent