Skip main navigation
Off market
  • $2,237,500

    590 Bayshore Dr, Terra Ceia, FL 34250

    5beds
    4,349sqft
    Single Family Residence
    Built in 1923
    4.03 Acres Lot
    $2,237,500 Zestimate®
    $514/sqft
    $6,846 Estimated rent

    Owner options

    List your home for rent

    $6,846/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $6,846/mo

    Rent Zestimate®

    Refinance and save

    $14,460/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $14,460/mo

    Est. payment

    What's special

    Step back into Old Florida with this exquisite and unique 4-acre estate on Terra Ceia Island. Built in 1923, the magnificent 3 bedroom/3.5 bath home is teeming with history and charm but updated with modern luxuries and boasts gorgeous water views from most rooms as well as the front wrap porch & balconies. The detached carriage house with 2 car garage & pool bath has a 2nd floor guest suite with living room, kitchen, 2 bedrooms/1 bath. Upon entering the main house, new blends seamlessly with vintage. You'll appreciate the architectural details, original wood floors and built-ins combined with new fixtures and finishes. The impressive chef's kitchen with custom cabinetry and quartz counters features a Wolf range, Sub-Zero refrigerator & freezer, bar fridge, ice machine, huge center island and large laundry/pantry. All bedrooms are en suite and located on the 2nd floor. Both master and 2nd bedroom open to balconies to enjoy the bay breezes as does the 3rd floor media/bonus room. The expansive grounds are filled with a variety of fruit trees including citrus, mango and lychee. Recent additions of pool/spa, basketball court and 350' composite dock w/10,000 lb lift add to the elements of fun this home provides. With direct access to Terra Ceia Bay, Tampa Bay & the Gulf of Mexico and a location convenient to St Pete (aprox. 20 min.), Sarasota/Bradenton and our Gulf beaches, this can be your personal piece of paradise!

    Originating MLS: Sarasota - Manatee

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 6
    • Full bathrooms: 5
    • 1/2 bathrooms: 1
    Heating
    • Heat pump
    Cooling
    • Central
    Appliances
    • Laundry: Inside, Laundry Room, In Garage
    Features
    • Ceiling Fans(s), Eating Space In Kitchen, Walk-In Closet(s), Crown Molding, Solid Wood Cabinets, Solid Surface Counters, Built in Features, Window Treatments, Attic Fan
    • Flooring: Tile, Carpet, Hardwood, Laminate
    • Windows: Blinds, Shades, Window Treatments, Drapes, Rods, Shutters
    • Has fireplace: Yes
    • Fireplace features: Living Room, Gas
    Interior area
    • Structure area source: Public Records
    • Total interior livable area: 4,349 sqft

    Property

    Parking
    • Total spaces: 4
    • Parking features: Covered, Garage, Carport
    Features
    • Levels: Three Or More
    • Patio & porch: Patio, Screened, Covered, Front Porch, Rear Porch, Enclosed, Wrap Around
    • Exterior features: Stone, Wood, Cement / Concrete
    • Pool features: Auto Cleaner, Gunite, Heated, In Ground, Salt Water
    • Has spa: Yes
    • Spa features: Heated, In Ground
    • Waterfront features: Bay/Harbor
    • Body of water: TERRA CEIA BAY
    Lot
    • Size: 4.03 Acres
    • Features: In County, Oversized Lot, Street Paved, FloodZone
    • Residential vegetation: Fruit Trees, Mature Landscaping, Trees/Landscaped, Oak Trees
    Details
    • Additional structures: Guest House, Storage, Kennel/Dog Run
    • Parcel number: 2202400053
    • Zoning: RSF1

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Frame
    • Roof: Composition
    Condition
    • Completed
    • Year built: 1923

    Utilities & green energy

    • Sewer: Septic Tank
    • Water: Public
    • Utilities for property: Electricity Connected, Sprinkler Well, BB/HS Internet Available, Cable Connected, Propane

    Community & neighborhood

    Security
    • Security features: Closed Circuit Camera(s)
    Location
    • Region: Terra Ceia
    • Subdivision: TERRA CEIA

    Other

    Other facts
    • Additional Parcels YN: 0
    • Additional Rooms: Attic, Den/Library/Office, Formal Dining Room Separate, Media Room
    • Appliances: Dishwasher, Disposal, Electric Water Heater, Range, Refrigerator, Microwave, Washer, Wine Refrigerator, Dryer, Ice Maker
    • Association Approval Required YN: 0
    • Available For Lease YN: 1
    • Cooling: Central Air
    • Country: US
    • Building Area Source: Public Records
    • Disclosures: Seller Property Disclosure, Lead Paint
    • Exist Lse Tenant YN: 0
    • Flooring: Carpet, Ceramic Tile, Wood, Laminate
    • Direction Faces: South
    • Garage YN: 1
    • DPRYN: 0
    • Heating: Electric, Heat Pump
    • Exterior Features: French Doors, Irrigation System, Fenced, Rain Gutters, Balcony, Storage, Dog Run
    • Homestead YN: 1
    • Fireplace Features: Living Room, Gas
    • Interior Features: Ceiling Fans(s), Eating Space In Kitchen, Walk-In Closet(s), Crown Molding, Solid Wood Cabinets, Solid Surface Counters, Built in Features, Window Treatments, Attic Fan
    • Fireplace YN: 1
    • Foundation Details: Crawlspace
    • Furnished: Unfurnished
    • Lease Restrictions YN: 0
    • Listing Service: Full Service
    • Listing Terms: Cash, Conventional
    • Lot Features: In County, Oversized Lot, Street Paved, FloodZone
    • Major Change Type: Pending
    • Minimum Lease: No Minimum
    • Mls Status: Pending
    • New Construction YN: 0
    • Ownership: Fee Simple
    • Parking Features: Garage Door Opener, Driveway, Oversized, Covered, Bath In Garage, Circular Driveway
    • Patio And Porch Features: Patio, Screened, Covered, Front Porch, Rear Porch, Enclosed, Wrap Around
    • Pets Allowed: Yes
    • Utilities: Electricity Connected, Sprinkler Well, BB/HS Internet Available, Cable Connected, Propane
    • Previous Status: Active
    • Property Sub Type: Single Family Residence
    • Property Type: Residential
    • Vegetation: Fruit Trees, Mature Landscaping, Trees/Landscaped, Oak Trees
    • Roof: Shingle
    • Syndicate To: Homes.com, HomeSnap, Realtor.com, State27Homes.com, Zillow/Trulia
    • Tax Year: 2018
    • Water Source: Public
    • Window Features: Blinds, Shades, Window Treatments, Drapes, Rods, Shutters
    • Construction Materials: Wood Frame, Wood Siding
    • Laundry Features: Inside, Laundry Room, In Garage
    • Attached Garage YN: 0
    • Pool Features: Auto Cleaner, Gunite, Heated, In Ground, Salt Water
    • Pool Private YN: 1
    • Levels: Three Or More
    • Property Condition: Completed
    • Flood Zone Code: VE
    • View: Water
    • Water View YN: 1
    • Sewer: Septic Tank
    • List Agent AOR: Sarasota - Manatee
    • List AOR: Sarasota - Manatee
    • Room Count: 12
    • Other Structures: Guest House, Storage, Kennel/Dog Run
    • Total Acreage: Two + to Five Acres
    • Spa Features: Heated, In Ground
    • Water Access YN: 1
    • Water Extras YN: 1
    • Waterfront YN: 1
    • Water Access: Bay/Harbor
    • Water View: Bay/Harbor - Full
    • Stories Total: 3
    • County Or Parish: Manatee
    • Zoning: RSF1
    • Public Survey Section: 35
    • Public Survey Range: 17
    • Flood Zone Date: 2014-03-17
    • Water Extras: Dock - Composite, Bridges - No Fixed Bridges, Dock w/Electric, Dock w/Water Supply
    • Security Features: Closed Circuit Camera(s)
    • Waterfront Features: Bay/Harbor
    • Flood Zone Panel: 12081C0154E
    • Garage Dimensions: 29x25
    • MLS Area Major: 34250 - Terra Ceia/Terra Ceia Island
    • Year Built: 1923
    • Water Body Name: TERRA CEIA BAY
    • Subdivision Name: TERRA CEIA
    • Living Area: 4349.00
    • Building Area Total: 7561.00
    • Water Frontage Feet Bay Harbor: 567
    • Waterfront Feet Total: 567
    • Pet Restrictions: County ordinances and leash laws apply.
    • Tax Annual Amount: 8272.00
    • Listing terms: Cash, Conventional
    • Ownership: Fee Simple
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,237,500