NOT LISTED FOR SALE

17804 Ayrshire Blvd Land O Lakes, FL 34638

Ballantrae Neighborhood

Estimated Value: $485,000 - $558,000

4 Beds
2.5 Baths
2,539 Sq Ft
$206/Sq Ft Est. Value

Last Sold July 29, 2022

Last sale price $550,000 $217 Per Sq Ft

Est. 4% decrease in value since last sale

Current estimated payment $3,702/month

12 Days on Market

Highlights

  • Screened Pool
  • Gated Community
  • Clubhouse
  • Sunlake High School Rated A-
  • View of Trees or Woods
  • Contemporary Architecture

About This Home

As of July 2022

A must see Pool Home on a gorgeous Conservation Lot in Ballantrae! This 4 bedroom beauty boasts over 2,500 sq. ft. with a loft upstairs and a huge master bedroom & bathroom. You'll notice the great curb appeal and a double door entry takes you into a spacious living room and formal dining room.Downstairs there's plenty of storage and lots of work space in the kitchen with 42" maple cabinets, a center island, a range hood, NEW FRIDGE & a NEW DISHWASHER along with a breakfast nook that opens to the family room. Sliders from the family room take you to your own outdoor oasis with a newer saltwater pool, and covered patio with beautiful travertine tile. There's also a half bath and the utility room downstairs. Upstairs the large master suite has 2 walk in closets, a large master bath with 2 vanities, a tub and a separate shower. There's 3 additional rooms and a LOFT upstairs that's the perfect play area/office/craft space. BRAND NEW ROOF IN 2022 AND THE INSIDE AC ALSO REPLACED IN 2022, original homeowners have lovingly maintained this home. Take advantage of the great community amenities including the pool, playground, park, and the tennis, basketball & volleyball courts. Easy Suncoast Parkway access from here and just minutes to shops & dining.

Last Agent to Sell the Property

Joseph Koebel

RE/MAX REALTEC GROUP INC License #616590 Listed on: 06/04/2022

RE/MAX REALTEC GROUP INC

Last Buyer's Agent

Ray Ingandela

KELLER WILLIAMS RLTY NEW TAMPA License #599210

KELLER WILLIAMS RLTY NEW TAMPA

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,517

Year Built

  • Built in 2006

Lot Details

  • 5,861 Sq Ft Lot
  • Near Conservation Area
  • East Facing Home
  • Wooded Lot
  • Landscaped with Trees
  • Property is zoned MPUD

HOA Fees

  • $57 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Driveway

Property Views

  • Woods
  • Pool

Home Design

  • Contemporary Architecture
  • Planned Development
  • Slab Foundation
  • Wood Frame Construction
  • Shingle Roof
  • Block Exterior
  • Stucco

Interior Spaces

  • 2,539 Sq Ft Home
  • 2-Story Property
  • High Ceiling
  • Ceiling Fan
  • Blinds
  • Sliding Doors
  • Family Room
  • Combination Dining and Living Room
  • Loft
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Range with Range Hood
  • Dishwasher

Flooring

  • Carpet
  • Laminate

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Upstairs
  • Walk-In Closet

Pool

  • Screened Pool
  • In Ground Pool
  • Gunite Pool
  • Saltwater Pool
  • Fence Around Pool

Schools

  • Bexley Elementary School
  • Charles S. Rushe Middle School
  • Sunlake High School

Additional Features

  • Covered Patio or Porch
  • Central Heating and Cooling System

Listing and Financial Details

  • Down Payment Assistance Available
  • Homestead Exemption
  • Visit Down Payment Resource Website
  • Legal Lot and Block 8 / 5
  • Assessor Parcel Number 18-26-20-0100-00500-00800
  • $1,845 per year additional tax assessments

Community Details

Overview

  • Association fees include community pool
  • Patricia Thibault Breezehome Association, Phone Number (813) 565-4663
  • Visit Association Website
  • Ballantrae Village 2B Subdivision
  • Rental Restrictions

Recreation

  • Tennis Courts
  • Community Basketball Court
  • Community Playground
  • Community Pool
  • Park

Additional Features

  • Clubhouse
  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,517

Year Built

Built in 2006

Lot Details

0

HOA Fees

$57 per month

Parking

2

Listing Details

  • HOA Fee Includes: Community Pool
  • Property Type: Residential
  • Property Condition: Completed
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Construction Materials: Block, Stucco, Wood Frame
  • Fireplace: No
  • Living Area: 2539
  • Lot Size Acres: 0.13
  • New Construction: No
  • Year Built: 2006
  • Building Area Total: 3279
  • Lot Size Sq Ft: 5861
  • Directions to Property: From SR 54 head north on Ballantrae Blvd. then east on Ayrshire to the property on the right hand side.
  • Status: Sold
  • Down Payment Resource URL: https://www.workforce-resource.com/dpr/listing/MFRMLS/U8164422?w=Agent&skip_sso=true
  • Down Payment Resource URL 2: https://www.workforce-resource.com/dpr/listing/MFRMLS/U8164422?w=Customer
  • Homestead Y N: Yes
  • Total Acreage: 0 to less than 1/4
  • Unit Number Y N: No
  • Home Warranty Y N: No
  • Planned Unit Development Y N: Yes
  • Ratio: Close Price\List Price: 0.97431
  • Price per Sq Ft: 216.62
  • Close to Original List Price Ratio: 0.95156
  • Ratio: Current Price\Building Area Total: 167.73
  • View: Yes
  • Ownership: Fee Simple
  • Tax Year: 2021
  • Special Features: None

Interior Features

  • Living Area Units: Square Feet
  • Flooring: Carpet, Laminate
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Interior Amenities: Ceiling Fans(s), Eating Space In Kitchen, High Ceiling(s), Living Room/Dining Room Combo, Master Bedroom Upstairs, Walk-In Closet(s)
  • Appliances Included: Dishwasher, Range, Range Hood, Refrigerator
  • Foundation Details: Slab
  • Total Bedrooms: 4
  • Levels: Two
  • Spa Yn: No
  • Stories: 2
  • Window Features: Blinds
  • Street Number Modifier: 17804
  • Room Count: 10
  • Additional Rooms: Family Room, Loft

Exterior Features

  • Direction Faces: East
  • Pool Features: Gunite, In Ground, Salt Water, Screen Enclosure
  • Exterior Features: Sidewalk, Sliding Doors
  • Roof: Shingle
  • Pool Private: Yes
  • View: Pool, Trees/Woods
  • Waterfront: No
  • Patio and Porch Features: Covered, Rear Porch, Screened
  • Road Surface Type: Paved
  • Water View Y N: No
  • Water Access Y N: No
  • Water Extras Y N: No
  • Disclosures: HOA/PUD/Condo Disclosure, Other, Seller Property Disclosure

Garage/Parking

  • Attached Garage: Yes
  • Carport Y N: No
  • Garage Spaces: 2
  • Garage Yn: Yes
  • Parking Features: Covered, Driveway
  • Covered Parking Spaces: 2
  • Open Parking: No

Utilities

  • Utilities: Public
  • Cooling: Central Air
  • Heating: Central, Electric
  • Laundry Features: Laundry Room
  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Community Features: Park, Playground, Pool, Tennis Courts
  • Association Amenities: Basketball Court, Clubhouse, Park, Playground, Tennis Court(s)
  • Association Fee: 170
  • Association Fee Frequency: Quarterly
  • Association Name: Patricia Thibault - BreezeHome
  • Phone: 813-565-4663
  • Association: Yes
  • Security: Gated Community
  • Senior Community: No
  • Association Website: ballantraecdd.org
  • Association Email: ballantraepasco@breezehome.com
  • Association Fee Requirement: Required
  • Association Approval Required YN: No

Fee Information

  • Total Annual Fees: 680
  • Monthly HOA Fee: 56.67
  • Total Monthly Fees: 56.67

Schools

  • Elementary School: Bexley Elementary School
  • High School: Sunlake High School-PO
  • Middle Or Junior School: Charles S. Rushe Middle-PO

Lot Info

  • Zoning: MPUD
  • Parcel Number: 18-26-20-0100-00500-00800
  • Additional Parcels: No
  • Lot Features: Conservation Area, Sidewalk
  • Flood Zone Code: x

Rental Info

  • Pets Allowed: Yes
  • Minimum Lease: 1-2 Years
  • Approval Process: Patricia Thibault - Breeze Home 813-565-4663
  • Lease Restrictions Y N: Yes
  • Additional Lease Restrictions: All leasing restrictions to be verified by buyer. Patricia Thibault - Breeze Home 813-565-4663

Tax Info

  • Tax Annual Amount: 4517.06
  • Tax Block: 5
  • Tax Book Number: 57-034
  • Tax Lot: 8
  • Tax Other Annual Assessment Amount: 1845

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 4, 2022
Closed on
Jul 28, 2022
Sold by
Kearley and Donna
Bought by
Berger Michael Andrew and Berger Kerri
Seller's Agent
Joseph Koebel
RE/MAX REALTEC GROUP INC
Buyer's Agent
Ray Ingandela
KELLER WILLIAMS RLTY NEW TAMPA
List Price
$578,000
Sold Price
$550,000
Premium/Discount to List
-$28,000
-4.84%
Current Estimated Value
$529,598

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$20,402
Avg. Annual Appreciation
-1.40%
Original Mortgage
$405,000
Outstanding Balance
$390,568
Interest Rate
5.81%
Mortgage Type
New Conventional
Estimated Equity
$136,260

Purchase Details

Closed on
Sep 15, 2006
Sold by
M I Homes Of Tampa Llc
Bought by
Kearley Gregory and Kearley Donna

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$342,300
Interest Rate
6.52%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Berger Michael Andrew $550,000 Republic Land & Title
Kearley Gregory $360,337 M-I Title Agency Ltd Lc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Berger Michael Andrew $405,000
Previous Owner Kearley Donna $50,000
Previous Owner Kearley Gregory $342,300
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/29/2022 07/29/22 Sold $550,000 -2.6% $217 / Sq Ft
06/16/2022 06/16/22 Pending -- -- --
06/16/2022 06/16/22 Price Changed $564,500 -2.3% $222 / Sq Ft
06/04/2022 06/04/22 For Sale $578,000 -- $228 / Sq Ft
Source: Stellar MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $8,948 $448,030 -- --
2023 $8,696 $434,986 $56,760 $378,226
2022 $8,136 $389,043 $47,355 $341,688
2021 $4,517 $197,220 $23,574 $173,646
2020 $3,849 $155,460 $23,574 $131,886
2019 $3,808 $151,970 $0 $0
2018 $3,766 $149,140 $0 $0
2017 $3,755 $149,140 $0 $0
2016 $3,691 $143,068 $0 $0
2015 $3,716 $142,073 $0 $0
2014 $3,665 $157,032 $22,749 $134,283
Source: Public Records

Agents Affiliated with this Home

  • Joseph Koebel

    Seller's Agent in 2022

    Joseph Koebel

    RE/MAX

    (727) 410-1455

    1 in this area

    160 Total Sales

    Section Image

  • R

    Buyer's Agent in 2022

    Ray Ingandela

    KELLER WILLIAMS RLTY NEW TAMPA

    (813) 994-4422

    1 in this area

    16 Total Sales

    Section Image
See All Agents

Map

Source: Stellar MLS

MLS Number: U8164422

Stellar MLS

APN: 20-26-18-0100-00500-0080

Florida Pasco County Land O Lakes 34638 Ballantrae

17804 Ayrshire Blvd, Land O Lakes, FL

This home is located at 17804 Ayrshire Blvd, Land O Lakes, FL 34638 since 04 June 2022 and is currently estimated at $522,296, approximately $205 per square foot. This property was built in 2006. 17804 Ayrshire Blvd is a home located in Pasco County with nearby schools including Bexley Elementary School, Charles S. Rushe Middle School, and Sunlake High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Stellar MLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.



Listing Information presented by local MLS brokerage: Ten-X - (888)-952-6393

Nearby Homes