Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$2,400,000

  • For Sale
  • Active
  • Single Family
  • 5 Beds
  • 3 Full Baths
  • 2,640 Sq. Ft.
  • Updated 12 days ago
See This Home
Save This Home
See This Home
Save This Home
Hidden Lagoon is a one-of-a-kind tropical oasis tucked into a quiet St. Petersburg neighborhood, just minutes from world-class beaches, downtown dining, shopping, and entertainment. This exceptional five-bedroom, three-bath residence is thoughtfully designed to deliver both unforgettable family living and consistent short-term rental success. Step into a private, resort-style backyard anchored by one of the largest lagoon-style pools in Pinellas County, featuring optional seasonal heating, a soothing spa, and dramatic resort lighting for day-to-night enjoyment. The outdoor experience is further elevated by a tiki bar and BBQ pavilion with built-in gas grill and griddle, flat-screen TV, and Bluetooth sound system, creating an ideal setting for entertaining or relaxed poolside afternoons. Exterior amenities rival a true vacation destination and include a full sports court for pickleball and basketball, a custom mini-golf course, firepit lounge, bocce ball court, giant outdoor chess, a playground, and expansive patios with string lighting and multiple lounge areas, all intentionally designed to maximize guest enjoyment and rental appeal. Inside, the home features a gourmet chef's kitchen with quartz countertops and premium stainless steel appliances, open-concept living spaces filled with natural light and designer finishes, and a dedicated arcade game nook that keeps guests of all ages entertained year-round.

Full Property Details for 7701 40th Terrace N

General

  • Price: $2,400,000
  • Taxes: $15,849 (2024)
  • Status: Active
  • Type: Single Family
  • Source: MidFloridaRegionalMLS
  • MLS ID: TB8460610
  • Updated: 1/5/2026
  • Added to Site: 13 day(s) ago

Rental Information

  • Min. Lease: No Minimum

Interior

  • Number of Rooms: 8
  • Interior Features: Open Floorplan, Primary Bedroom Main Floor, Thermostat, Walk-In Closet(s), Window Treatments
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range, Range Hood, Refrigerator, Tankless Water Heater, Washer
  • Furnishings: Negotiable
  • Flooring: Luxury Vinyl

Rooms

Bathrooms

  • Total Bathrooms: 3
  • Full Bathrooms: 3

Bedrooms

  • Total Bedrooms: 5

Other Rooms

  • Laundry: Inside, Laundry Room

Additional Information

  • Pool: Yes
  • Private Pool: Yes
  • Pool Description: Heated, In Ground, Solar Heat
  • Spa: Yes
  • Spa Description: Above Ground, Heated

Exterior

  • Exterior Features: Basketball Court, Fire Pit, Outdoor Grill, Outdoor Kitchen, Playground, Private Yard

Location

  • Area: 33709 - St Pete/Kenneth City
  • County: Pinellas
  • Development Name: 33709 - St Pete/Kenneth City
  • Subdivision: SCHUETT SUB
  • Driving Directions: Directions: Heading North On 66 Th St N, Turn Left Onto 38 Th Ave N. Turn Right Onto 78 Th St N. Turn Right Onto 40 Th Terr N. Property Is Located At The End Of the street
  • Direction Faces: West

Community

  • Community Name: 33709 - St Pete/Kenneth City

Heating & Cooling

  • Cooling Type: Central Air
  • Heating Type: Electric, Heat Pump

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Utility Description: Cable Connected, Electricity Connected, Phone Available, Propane, Sewer Connected, Underground Utilities, Water Connected

Structural Information

  • Exterior Const.: Block, Vinyl Siding, Wood Frame
  • Roof: Metal
  • Windows: Window Treatments
  • Stories/Levels: One
  • Square Feet: 2,640
  • Sq. Ft. Source: Public Records
  • Year Built: 2018

Lot Features

  • Lot Size (Acres): 0.72
  • Lot Size (Sq. Ft.): 31,468
  • Lot Size: 31468
  • Lot Dimensions: 128 x 196
  • Street/Road Desc.: Asphalt

Financial Considerations

  • Tax Amount: $15,849.68
  • Tax Year: 2024

Disclosures and Reports

  • Ownership: Fee Simple
  • Special Conditions: None
  • Legal Description: SCHUETT SUB LOT 9 TOGETHER WITH THAT PART OF PINELLAS FARMS S 1/2 OF N 1/2 OF FARM 56 LYING E OF SCHUETT SUB
  • Flood Zone Info: X
  • APN: 63116791100000090
  • Property ID: 63116791100000090

Listed by Keller Williams Tampa Prop.

Quickly Find Out More

* Indicates a required field

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 Send Message, 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 an 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.

We Value Your Privacy

Listing agents

— 7701 40th Terrace N —

  • Keller Williams Tampa Prop.

  • Keller Williams Tampa Prop.

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 7701 40th Terrace N

School District:Pinellas County School District
NameGradesDistance
Seventy-Fourth St. Elementary School
3801 74th St N, St. Petersburg, FL 33709
PK-50.3 mi
Azalea Middle School
7855 22nd Ave N, St. Petersburg, FL 33710
6-81.1 mi
Dixie M. Hollins High School
4940 62nd Street North, Kenneth City, FL 33709
9-121.4 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 7701 40th Terrace N Get Price Alerts and Save Property

Date
Details
Price
Change
Source
1/05/2026
Listed
$2,400,000
89.13%
MLS
3/24/2025
Sold
$1,269,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 7701 40th Terrace N

Year
Property Taxes
Change
Tax Assessment
Change
2025
$16,787
6%
$791,045
5%
2024
$15,850
—
$752,425
1%
2023
$15,882
62%
$742,482
74%
2021
$9,829
-6%
$427,777
-14%
2022
$10,455
6%
$500,236
18%
2021
$9,829
14%
$424,880
18%
2019
$8,588
337%
$361,522
336%
2018
$1,965
11%
$82,855
10%
2017
$1,777
22%
$75,323
17%
2016
$1,460
2%
$64,515
5%
2015
$1,425
8%
$61,713
-2%
2014
$1,318
15%
$62,845
28%
2013
$1,145
—
$48,930
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 7701 40th Terrace N

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Keller Williams Tampa Prop.

Similar Properties near 7701 40th Terrace N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

11700 5th St E, Treasure Island, FL 33706 - Photo 1
$2,490,000
Open House

11700 5th St E  Treasure Island, FL 33706

  • Single Family
  • Active
  • Updated 8 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 4,082
    Sq. Ft.
Listed by Waterfront Realty Tampabay and Skyway Real Estate, Llc
1222 Brightwaters Blvd NE, Saint Petersburg, FL 33704 - Photo 1 Price Reduced
-$50,000 (-1.96%)
$2,500,000

1222 Brightwaters Blvd NE  Saint Petersburg, FL 33704

  • Single Family
  • Active
  • Updated 4 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 4,043
    Sq. Ft.
Listed by Smith & Associates Real Estate and Keller Williams St Pete Realty
11105 5th St E, Treasure Island, FL 33706 - Photo 1 Just Listed
$2,500,000

11105 5th St E  Treasure Island, FL 33706

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 4,599
    Sq. Ft.
Listed by Yellowfin Realty
7942 3rd Ave S, Saint Petersburg, FL 33707 - Photo 1
$2,495,000

7942 3rd Ave S  Saint Petersburg, FL 33707

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 3,432
    Sq. Ft.
Listed by Century 21 Jim White & Assoc

Just Listed near 7701 40th Terrace N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2654 Miriam St S, Gulfport, FL 33711 - Photo 1 Just Listed
$265,000

2654 Miriam St S  Gulfport, FL 33711

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 1
    Total Bath
  • 1,376
    Sq. Ft.
Listed by Adam Swiecicki (305) 240-4379
2938 Beach Blvd S, Gulfport, FL 33707 - Photo 1 Just Listed
$925,000

2938 Beach Blvd S  Gulfport, FL 33707

  • Multi-Family
  • Active
  • Updated 2 days ago
  • 4
    Units
  • 0.13
    Acres
Listed by Kevin Gallagher (727) 365-2221
715 53rd St S, Gulfport, FL 33707 - Photo 1 Just Listed
$594,900

715 53rd St S  Gulfport, FL 33707

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,628
    Sq. Ft.
Listed by Mihara & Associates Inc.
3020 Clinton St S, Gulfport, FL 33707 - Photo 1 Just Listed
$250,000

3020 Clinton St S  Gulfport, FL 33707

  • Lots/Land
  • Active
  • Updated 5 days ago
  • 0.09
    Acres
Listed by Axen Realty, Llc

Price Reduced near 7701 40th Terrace N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

5925 Shore Blvd S, Gulfport, FL 33707 - Photo 1 Price Reduced
-$15,100 (-7.02%)
$199,900

5925 Shore Blvd S  #505  Gulfport, FL 33707

  • Condo
  • Active
  • Updated 6 days ago
  • 1
    Bed
  • 1
    Total Bath
  • 1,060
    Sq. Ft.
Listed by Gabriela Raimander (727) 422-1743
6238 13th Ave S, Gulfport, FL 33707 - Photo 1 Price Reduced
-$100 (-0.03%)
$398,900

6238 13th Ave S  Gulfport, FL 33707

  • Single Family
  • Active
  • Updated 23 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,337
    Sq. Ft.
Listed by Jay Alan Real Estate
5950 Pelican Bay Plaza S, Gulfport, FL 33707 - Photo 1 Price Reduced
-$15,000 (-3.13%)
$465,000

5950 Pelican Bay Plaza S  #705  Gulfport, FL 33707

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,476
    Sq. Ft.
Listed by Caldwell Realty
2801 Tifton St S, Gulfport, FL 33711 - Photo 1 Price Reduced
-$25,000 (-4.35%)
$550,000

2801 Tifton St S  Gulfport, FL 33711

  • Single Family
  • Active
  • Updated 4 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 1,731
    Sq. Ft.
Listed by Forever Florida Real Estate

Recent Sales near 7701 40th Terrace N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

5275 95th St N, Saint Petersburg, FL 33708 - Photo 1 Sold
$2,500,000

5275 95th St N  Saint Petersburg, FL 33708

  • Industrial
  • Closed
Listed by Rigler Realty Company
Sold by Rigler Realty Company
840 123rd Ave, Treasure Island, FL 33706 - Photo 1 Sold
$2,300,000

840 123rd Ave  Treasure Island, FL 33706

  • Lots/Land
  • Closed
  • 0.37
    Acres
Listed by Engel & Volkers Madeira Beach
Sold by Five Star Real Estate Of Florida Llc
750 123rd Ave, Treasure Island, FL 33706 - Photo 1 Sold
$2,075,000

750 123rd Ave  Treasure Island, FL 33706

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,619
    Sq. Ft.
Listed by Exp Realty Llc
Sold by Charles Rutenberg Realty Inc
440 Capri Blvd, Treasure Island, FL 33706 - Photo 1 Sold
$2,400,000

440 Capri Blvd  Treasure Island, FL 33706

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 3,274
    Sq. Ft.
Listed by Smith & Associates Real Estate
Sold by Beachwise Real Estate

7701 40th Terrace N, Saint Petersburg, FL 33709 (MLS# TB8460610) is a Single Family property with 5 bedrooms and 3 full bathrooms. 7701 40th Terrace N is currently listed for $2,400,000 and was received on January 05, 2026. Want to learn more about 7701 40th Terrace N? Do you have questions about finding other Single Family real estate for sale in Saint Petersburg? You can browse all Saint Petersburg real estate or contact a Coldwell Banker agent to request more information.

Tour this property