Active$3,999,999
18562 COUNCIL CREST DRIVE
ODESSA, FL 33556
5 beds5 baths7,260 sqft
1 / 31
Active · Single Family
17924 SIMMS ROAD
ODESSA, FL 33556
Beds
2 beds
Baths
1 bath
Area
1,256 sqft
Single FamilyBuilt 1960326,264 sqft lot4-car garageElectricCentral AirFireplace$3583/sqft284 days on market
About this home
Rare 7.7-Acre Waterfront Opportunity on Lake Keystone! For the first time ever, this extraordinary 7.7-acre property on Lake Keystone—the most sought-after lake in Hillsborough County—is being offered to the public. With an impressive 300 feet of pristine lake frontage, this one-of-a-kind parcel offers endless possibilities for your private estate, family compound, or luxury retreat. Lake Keystone spans approximately 434 acres of crystal-clear, skiable water—ideal for boating, fishing, and lakeside living at its finest. The property provides a perfect balance of privacy, space, and natural beauty, all while remaining convenient to Tampa, Odessa, and surrounding communities. This is a once-in-a-generation opportunity to own one of the largest privately held tracts on Lake Keystone. Whether you envision building a custom lakefront residence, creating a multi-home estate, or simply investing in premier waterfront land, this property offers the rare combination of size, location, and lakefront lifestyle that cannot be replicated.
Facts & features
Interior
- Bedrooms
- 2
- Bathrooms
- 1
- Living area
- 1,256 sqft
- Heating
- Electric
- Cooling
- Central Air
- Flooring
- Carpet, Wood
- Fireplace
- Yes
- Features
- Ceiling Fans(s), Solid Wood Cabinets
- Appliances
- Electric Water Heater, Refrigerator
Exterior & lot
- Lot size
- 326,264 sqft (7.49 ac)
- Roof
- Shingle
- Construction
- Frame
- Exterior
- Storage
Parking
- Garage
- 4 spaces
Financial
- Annual tax
- $1,267 (2024)
- Price / sqft
- $3583/sqft
Utilities
- Water
- Well
- Sewer
- Septic Tank
- Utilities
- BB/HS Internet Available, Cable Available, Electricity Available, Sewer Available, Water Available, Water Connected
Property
- Property type
- Single Family
- Year built
- 1960
- Subdivision
- KEYSTONE LAKE VIEW PARK
- County
- Hillsborough
Assigned schools
- Elementary
- Hammond Elementary School
- Middle
- Sergeant Smith Middle-HB
- High
- Steinbrenner High School
Listing
- Status
- Active
- Days on market
- 263 days
- MLS #
- MFR774541312
- Source
- Stellar MLS
Listed by Joe Lewkowicz · COLDWELL BANKER REALTY
Listing data provided by Stellar MLS. Information deemed reliable but not guaranteed.
Estimate your monthly cost
PITI + HOAEstimated monthly payment$23,060/mo
- Principal & interest
- $22,754/mo
- Property tax
- $106/mo
- Home insurance
- $200/mo
Opens at 20% down over 30 years at 6.5%, the same assumptions as the answers below. Property tax is this listing's own 2024 bill. Insurance is left out until you enter a quote, because Florida premiums turn on roof age, elevation and carrier. Every field is editable.
Ask about this property
Answered from this listing’s own figures and the sales around it.
Price history
From the property’s MLS record.
| Date | Event | Price | Change |
|---|---|---|---|
| Jul 28, 2026 | Price reduced | $4,500,000 | −$1,900,000 |
| Nov 7, 2025 | Listed | $6,400,000 | — |
Neighbourhood
The schools below come from the MLS record for this home. Walking, transit and cycling figures for ODESSA, FL are not connected yet, so this page does not show them.
Elementary school
Hammond Elementary School
Assigned school from the MLS record
Middle school
Sergeant Smith Middle-HB
Assigned school from the MLS record
High school
Steinbrenner High School
Assigned school from the MLS record
Location
Similar homes nearby
Homes for sale in ODESSA within the same price band.
