Skip main navigation
Off market
  • $652,600

    17857 Ayrshire Blvd, Land O Lakes, FL 34638

    5beds
    3,406sqft
    Single Family Residence
    Built in 2007
    6,033 Square Feet Lot
    $652,600 Zestimate®
    $192/sqft
    $3,807 Estimated rent

    Home value

    $652,600

    $620,000 - $685,000

    $3,807/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,807/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

    $3,807/mo

    Rent Zestimate®

    Refinance and save

    $4,536/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

    $4,536/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Highly sought-after 5-bedroom, 4-bathroom pool home in family-friendly Ballantrae community. Off the entry are formal dining and living spaces, with access to the kitchen which has updated stainless steel appliances (2015), and space for a kitchen table. Off the kitchen is a casual family room and small hallway leading to both a bedroom and full bathroom, perfect for guests. You can exit the family room or bathroom onto the outdoor patio, a tropical oasis complete with saltwater pool and heat pump, and outdoor kitchen space with grill and kegerator. The space is well-maintained and ideal for entertaining guests, with a view of the conservation. The remaining 4 bedrooms and 3 bathrooms are located upstairs, along with a bonus room/loft space. Ballantrae community amenities include clubhouse; pool; tennis, volleyball and basketball courts; and playground. Minutes from the Suncoast Parkway and area amenities such as shopping, restaurants and beaches, plus close to top-rated schools.

    This property is not currently displayed as for sale or rent on Zillow. This may be different from what's on other websites or public sources.

    Originating MLS: Tampa

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 4
    Heating
    • Forced air
    Cooling
    • Central
    Features
    • Ceiling Fans(s), Window Treatments
    • Flooring: Other, Carpet
    Interior area
    • Total interior livable area: 3,406 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Attached
    Features
    • Levels: Two
    • Patio & porch: Deck, Patio, Porch, Screened, Covered, Front Porch, Rear Porch, Enclosed
    • Exterior features: Other, Stucco
    • Pool features: Child Safety Fence, Gunite, Heated, In Ground, Salt Water, Screen Enclosure, Self Cleaning, Lighting, Tile
    Lot
    • Size: 6,033 Square Feet
    • Features: Sidewalk
    Details
    • Parcel number: 2926180100003000230
    • Zoning: MPUD

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Traditional
    • Property subtype: Single Family Residence
    Materials
    • Concrete Block
    • Roof: Asphalt
    Condition
    • Year built: 2007

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Electricity Connected, Phone Available, Cable Available, Street Lights, Underground Utilities, Cable Connected, Electricity Available, Water Connected

    Community & HOA

    Community
    • Subdivision: BALLANTRAE VILLAGE 2B
    HOA
    • Has HOA: Yes
    • Amenities included: Cable, Clubhouse, Pool, Basketball Court
    • Services included: Community Pool, Cable TV, Internet
    • HOA fee: $56 monthly
    Location
    • Region: Land O Lakes

    Financial & listing details

    • Price per square foot: $192/sqft
    • Tax assessed value: $565,286
    • Annual tax amount: $9,154
    • Listing terms: Cash, Conventional, FHA, VA Loan
    • Ownership: Fee Simple

    Price history

    DateEventPrice
    7/12/2024Listing removed$489,900-6.7%$144/sqft
    Source: Stellar MLS #T3300314 Report a problem
    6/3/2021Sold$525,000+7.2%$154/sqft
    Source: Public Record Report a problem
    4/10/2021Pending sale$489,900$144/sqft
    Source: Stellar MLS #T3300314 Report a problem
    4/9/2021Listed for sale$489,900+40.4%$144/sqft
    Source: Stellar MLS #T3300314 Report a problem
    7/21/2015Sold$349,000$102/sqft
    Source: Agent Provided Report a problem
    7/6/2015Listed for sale$349,000$102/sqft
    Source: PEOPLE'S CHOICE REALTY SVC LLC #T2752485 Report a problem
    7/6/2015Pending sale$349,000$102/sqft
    Source: PEOPLE'S CHOICE REALTY SVC LLC #T2752485 Report a problem
    7/2/2015Listed for sale$349,000$102/sqft
    Source: PEOPLE'S CHOICE REALTY SVC LLC #T2752485 Report a problem
    6/6/2015Pending sale$349,000$102/sqft
    Source: PEOPLE'S CHOICE REALTY SVC LLC #T2752485 Report a problem
    4/18/2015Listed for sale$349,000+2.5%$102/sqft
    Source: PEOPLE'S CHOICE REALTY SVC LLC #T2752485 Report a problem
    12/3/2007Sold$340,416$100/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2024$9,154 +2.9%$460,160
    2023$8,895 +8.6%$460,160 +3%
    2022$8,191 +28.8%$446,760 +42.9%
    2021$6,358 +1.1%$312,690 +1.4%
    2020$6,289 +1.1%$308,380 +2.3%
    2019$6,219 $301,450 +1.9%
    2018$6,219 +1.3%$295,832 +0%
    2017$6,141 +0.2%$295,825 +4.2%
    2016$6,126 +23.7%$283,787 +32.4%
    2015$4,952 +1.7%$214,346 -8.5%
    2014$4,870 $234,141 +9%
    2013-- $214,786 +4.3%
    2012-- $206,000 -4.7%
    2011-- $216,116 +7.9%
    2010-- $200,289 -19.9%
    2009-- $250,002 -21%
    2008-- $316,475 +493.5%
    2007-- $53,320 +671.4%
    2006-- $6,912
    Find assessor info on the county website

    Neighborhood: Ballantrae

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Bexley Elementary School
    • Middle: Charles S. Rushe Middle-PO
    • High: Sunlake High School-PO

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    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
    $652,600
    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
    $652,600