NOT LISTED FOR SALE

17540 Queensland St Land O Lakes, FL 34638

Ballantrae Neighborhood

Estimated Value: $447,000 - $496,000

4 Beds
3 Baths
2,652 Sq Ft
$177/Sq Ft Est. Value

Last Sold August 14, 2018

Last sale price $263,000 $99 Per Sq Ft

Est. 79% increase in value since last sale

Current estimated payment $3,085/month

128 Days on Market

Highlights

  • Heated Spa
  • Open Floorplan
  • Contemporary Architecture
  • Sunlake High School Rated A-
  • Deck
  • Loft

About This Home

As of August 2018

Immaculate, beautifully remodeled home in Ballantrae! 4 bedroom, 3 full baths, plus a loft. Private 4th bedroom & bath on 1st floor perfect for guests. This home features granite countertops throughout, wood cabinets, 22" Tile on 1st floor, Premium Nuvelle laminate upstairs, Plantation Shutters, plenty of storage, surround sound and all appliances are included! Oversized utility room w/ wood look tile. Enjoy relaxing in your fenced backyard on your HUGE wood composite deck. Gazebo & Hot Tub are included! Plenty of curb appeal with stacked stone accents on exterior, tropical landscaping, & decorative Landscape Curbing. Community amenities include, clubhouse, park, playground, pool with splash pad, open field for soccer or football, basketball, tennis, and volleyball courts. Living in Ballantrae is a fast & easy commute to almost anywhere in the Bay Area with I-75 and The Suncoast Expressway nearby. Close to shopping, beaches, and much more! **CDD Fee is included in taxes** Basic cable included in low HOA fee of $370 a year

Last Agent to Sell the Property

Jodie Maddaloni

ADVANTAGE REAL ESTATE SERVICES License #659781 Listed on: 03/27/2018

Last Buyer's Agent

Joe Yasso

RE/MAX REALTEC GROUP INC License #582976

RE/MAX REALTEC GROUP INC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,167

Year Built

  • Built in 2005

Lot Details

  • 4,431 Sq Ft Lot
  • North Facing Home
  • Fenced
  • Mature Landscaping
  • Irrigation
  • Landscaped with Trees
  • Property is zoned MPUD

HOA Fees

  • $31 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Open Parking

Home Design

  • Contemporary Architecture
  • Bi-Level Home
  • Slab Foundation
  • Shingle Roof
  • Block Exterior
  • Stucco

Interior Spaces

  • 2,652 Sq Ft Home
  • Open Floorplan
  • Built-In Features
  • Ceiling Fan
  • Blinds
  • Family Room Off Kitchen
  • Formal Dining Room
  • Loft
  • Storage Room
  • Inside Utility
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Range
  • Microwave
  • Dishwasher
  • Stone Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Laminate
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 3 Full Bathrooms

Laundry

  • Dryer
  • Washer

Pool

  • Heated Spa
  • Above Ground Spa

Outdoor Features

  • Deck
  • Patio
  • Porch

Schools

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

Utilities

  • Central Heating and Cooling System
  • High Speed Internet

Listing and Financial Details

  • Down Payment Assistance Available
  • Homestead Exemption
  • Visit Down Payment Resource Website
  • Legal Lot and Block 33 / 2
  • Assessor Parcel Number 20-26-18-0040-00200-0330
  • $1,845 per year additional tax assessments

Community Details

Overview

  • Association fees include cable TV, community pool, recreational facilities
  • Ballantrae Villages 3A & 3B Subdivision
  • The community has rules related to deed restrictions

Recreation

  • Tennis Courts
  • Recreation Facilities
  • Community Playground
  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,167

Year Built

Built in 2005

Lot Details

0

HOA Fees

$31 per month

Parking

2

Listing Details

  • HOA Fee Includes: Cable TV, Community Pool, Recreational Facilities
  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Construction Materials: Block, Stucco
  • Fireplace: No
  • Living Area: 2652
  • Lot Size Acres: 0.1
  • New Construction: No
  • Year Built: 2005
  • Building Area Total: 3308
  • Lot Size Sq Ft: 4431
  • Directions to Property: From intersection of HWY 54 & 41 Head West on 54. Turn right at Ballantrae, Left Glenapp Dr, Right on Tarbolton Way, Left on Queensland house will be on left.
  • Status: Sold
  • Down Payment Resource URL: http://www.workforce-resource.com/eligibility/listing?metro_area=MFRMLS&listing_id=H2204872&show_results=true&skip_sso=true
  • Down Payment Resource URL 2: http://www.workforce-resource.com/eligibility/listing?metro_area=MFRMLS&listing_id=H2204872&cview=true&show_results=true&customer_portal=true
  • Homestead Y N: Yes
  • Total Acreage: 0 to less than 1/4
  • Unit Number Y N: No
  • Home Warranty Y N: No
  • Ratio: Close Price\List Price: 0.99245
  • Price per Sq Ft: 99.17
  • Close to Original List Price Ratio: 1.14348
  • Ratio: Current Price\Building Area Total: 79.5
  • View: No
  • Ownership: Fee Simple
  • ResoBuildingAreaSource: PublicRecords
  • Tax Year: 2017
  • Special Features: VirtualTour

Interior Features

  • Living Area Units: Square Feet
  • Flooring: Ceramic Tile, Laminate
  • Full Bathrooms: 3
  • Interior Amenities: Built in Features, Ceiling Fans(s), Eating Space In Kitchen, Kitchen/Family Room Combo, Open Floorplan, Solid Wood Cabinets, Stone Counters
  • Appliances Included: Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Washer
  • Foundation Details: Slab
  • Total Bedrooms: 4
  • Levels: Two
  • Spa Features: Above Ground, Heated
  • Spa Yn: Yes
  • Window Features: Blinds
  • Street Number Modifier: 17540
  • Room Count: 7
  • Additional Rooms: Formal Dining Room Separate, Inside Utility, Loft, Storage Rooms
  • ResoLivingAreaSource: PublicRecords

Exterior Features

  • Direction Faces: North
  • Exterior Features: Fenced, Irrigation System
  • Roof: Shingle
  • Pool Private: No
  • Waterfront: No
  • Patio and Porch Features: Deck, Patio, Porch
  • Road Surface Type: Paved
  • Water View Y N: No
  • Water Access Y N: No
  • Water Extras Y N: No
  • Flood Zone Panel: 12101C0384F

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Garage Yn: Yes
  • Parking Features: Garage Door Opener
  • Covered Parking Spaces: 2
  • Open Parking: Yes

Utilities

  • Utilities: BB/HS Internet Available, Street Lights
  • Cooling: Central Air
  • Heating: Central
  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Community Features: Deed Restrictions, Playground, Pool, Tennis Courts
  • Association Amenities: Playground, Recreation Facilities, Tennis Court(s)
  • Association Fee: 370
  • Association Fee Frequency: Annually
  • Association: Yes
  • Security: Smoke Detector(s)
  • Senior Community: No
  • Association Fee Requirement: Required
  • Association Approval Required YN: No

Fee Information

  • Total Annual Fees: 370
  • Monthly HOA Fee: 30.83
  • Total Monthly Fees: 30.83

Schools

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

Lot Info

  • Zoning: MPUD
  • Parcel Number: 20-26-18-0040-00200-0330
  • Additional Parcels: No
  • Lot Features: In County
  • Flood Zone Code: X
  • Flood Zone Date: 2014-09-26
  • Zoning Compatible Y N: Yes
  • ResoLotSizeUnits: SquareFeet

Rental Info

  • Pets Allowed: Yes
  • Minimum Lease: No Minimum
  • Pet Restrictions: Buyer to verify with HOA
  • Lease Restrictions Y N: No
  • Additional Lease Restrictions: Buyer to verify with HOA

Tax Info

  • Tax Annual Amount: 3167
  • Tax Block: 2
  • Tax Book Number: 50-049
  • Tax Lot: 33
  • Tax Other Annual Assessment Amount: 1845

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 27, 2018
Closed on
Aug 14, 2018
Sold by
Illingworth David
Bought by
Marazan Keri J
Seller's Agent
Jodie Maddaloni
ADVANTAGE REAL ESTATE SERVICES
Buyer's Agent
Joe Yasso
RE/MAX REALTEC GROUP INC
List Price
$275,000
Sold Price
$263,000
Premium/Discount to List
-$12,000
-4.36%
Current Estimated Value
$470,222

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$207,222
Avg. Annual Appreciation
8.56%

Purchase Details

Listed on
Jul 7, 2013
Closed on
Dec 27, 2013
Sold by
Aldahondo Christopher K and Aldahondo Angelique
Bought by
Illingworth David
Seller's Agent
Souzan Mawajdeh
CENTURY 21 CIRCLE
Buyer's Agent
Charles Haselton
LPT REALTY, LLC
List Price
$129,900
Sold Price
$100,000
Premium/Discount to List
-$29,900
-23.02%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
23.23%

Purchase Details

Closed on
Nov 30, 2005
Sold by
Kb Home Tampa Llc
Bought by
Aldahondo Christopher K and Aldahondo Angelique

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$251,486
Interest Rate
6.23%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Apr 8, 2005
Sold by
M/I Homes Of Tampa Llc
Bought by
K B Home Tampa Llc
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
Marazan Keri J $263,000 Bay City Title Partners
Illingworth David $100,000 All American Title Affiliate
Aldahondo Christopher K $279,429 First American Title Ins Co
K B Home Tampa Llc $456,149 M-I Title Agency Ltd Lc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Aldahondo Christopher K $290,000
Previous Owner Aldahondo Christopher K $251,486
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/14/2018 08/14/18 Sold $263,000 -0.8% $99 / Sq Ft
08/01/2018 08/01/18 Pending -- -- --
07/17/2018 07/17/18 Price Changed $265,000 -3.6% $100 / Sq Ft
07/06/2018 07/06/18 For Sale $275,000 +4.6% $104 / Sq Ft
05/16/2018 05/16/18 Off Market $263,000 -- --
04/24/2018 04/24/18 Pending -- -- --
04/22/2018 04/22/18 For Sale $230,000 0.0% $87 / Sq Ft
03/31/2018 03/31/18 Pending -- -- --
03/26/2018 03/26/18 For Sale $230,000 +130.0% $87 / Sq Ft
06/16/2014 06/16/14 Off Market $100,000 -- --
12/27/2013 12/27/13 Sold $100,000 -8.3% $38 / Sq Ft
09/09/2013 09/09/13 Pending -- -- --
08/01/2013 08/01/13 Price Changed $109,000 -9.1% $41 / Sq Ft
07/22/2013 07/22/13 Price Changed $119,900 -7.7% $45 / Sq Ft
07/07/2013 07/07/13 For Sale $129,900 -- $49 / 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 $5,953 $271,260 -- --
2023 $5,800 $263,360 $0 $0
2022 $5,397 $255,690 $0 $0
2021 $5,330 $248,250 $19,275 $228,975
2020 $5,275 $244,822 $19,275 $225,547
2019 $5,949 $244,175 $19,275 $224,900
2018 $3,178 $112,801 $0 $0
2017 $3,167 $112,801 $0 $0
2016 $3,107 $108,209 $0 $0
2015 $3,124 $107,457 $0 $0
2014 $3,087 $106,604 $13,492 $93,112
Source: Public Records

Agents Affiliated with this Home

  • Jodie Maddaloni

    Seller's Agent in 2018

    Jodie Maddaloni

    ADVANTAGE REAL ESTATE SERVICES

    (813) 382-2692

    1 in this area

    18 Total Sales

    Jodie Maddaloni
    Section Image
  • Joe Yasso

    Buyer's Agent in 2018

    Joe Yasso

    RE/MAX

    (727) 647-1891

    58 Total Sales

    Joe Yasso
    Section Image
  • Souzan Mawajdeh

    Seller's Agent in 2013

    Souzan Mawajdeh

    CENTURY 21 CIRCLE

    (813) 416-8319

    28 Total Sales

    Souzan Mawajdeh
    Section Image
  • Charles Haselton

    Buyer's Agent in 2013

    Charles Haselton

    LPT REALTY, LLC

    (813) 679-7530

    51 Total Sales

    Charles Haselton
    Section Image
See All Agents

Map

Source: Stellar MLS

MLS Number: H2204872

Stellar MLS

APN: 20-26-18-0040-00200-0330

Florida Pasco County Land O Lakes 34638 Ballantrae

17540 Queensland St, Land O Lakes, FL

This home is located at 17540 Queensland St, Land O Lakes, FL 34638 since 27 March 2018 and is currently estimated at $470,222, approximately $177 per square foot. This property was built in 2005. 17540 Queensland St 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