NOT LISTED FOR SALE

15628 Indian Queen Dr Odessa, FL 33556

Estimated Value: $678,347 - $749,000

4 Beds
2.5 Baths
2,452 Sq Ft
$287/Sq Ft Est. Value

Last Sold May 24, 2018

Last sale price $360,000 $147 Per Sq Ft

Est. 96% increase in value since last sale

Current estimated payment $4,681/month

87 Days on Market

Highlights

  • Oak Trees
  • Screened Pool
  • Property is near public transit
  • Hammond Elementary School Rated A-
  • Deck
  • Family Room with Fireplace

About This Home

As of May 2018

Living is easy in this impressive, generously spacious and beautiful, two story Traditional home, in the great upscale Farmington Village neighborhood near Lake Rogers, with a screened in private pool and patio that invites to comfort and relaxation. With 4 bedrooms, 2 and a half baths, generous living space and stylish finishes, you'll enjoy a perfect setting for relaxing and entertaining. Beautiful hardwood floors and plenty of natural night flow throughout the home. Other special highlights include a charming wood burning fireplace with rich exposed brick, recessed lighting and ceiling fans, a full size front loaded washer/dryer in large utility room with access to the 2-car garage and tons of storage space. Enjoy gatherings in the generously-sized family room graced by a wood burning fireplace and double French doors that lead out to the rear deck. The stylish kitchen will inspire your inner chef with its granite counters, granite center island and eat-in space. The upstairs master bedroom has its own private bath with shower stall and garden tub, plus a huge walk-in closet. You'll also love the convenience of being close to the Upper Tampa Bay Trail and near it all with banks, great shops, bars and restaurants minutes away. Only about 20 minutes’ drive to Tampa International Airport. No CDD and low HOA. MOVE IN READY – put it on your list to view today!

Last Agent to Sell the Property

Lotte Rogers, The Viking Team

RE/MAX ALLIANCE GROUP License #687742 Listed on: 01/29/2018

RE/MAX ALLIANCE GROUP

Co-Listed By

Pia Ellison, The Viking Team

RE/MAX ALLIANCE GROUP License #3300133

Last Buyer's Agent

Kristin Blankenship

License #3343359

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,276

Year Built

  • Built in 1987

Lot Details

  • 0.25 Acre Lot
  • Lot Dimensions are 88x124
  • Unincorporated Location
  • Northeast Facing Home
  • Child Gate Fence
  • Mature Landscaping
  • Oak Trees
  • Property is zoned PD

HOA Fees

  • $21 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Rear-Facing Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway
  • Open Parking

Home Design

  • Traditional Architecture
  • Bi-Level Home
  • Planned Development
  • Brick Exterior Construction
  • Slab Foundation
  • Shingle Roof
  • Block Exterior
  • Siding
  • Stucco

Interior Spaces

  • 2,452 Sq Ft Home
  • Ceiling Fan
  • Wood Burning Fireplace
  • Blinds
  • French Doors
  • Entrance Foyer
  • Family Room with Fireplace
  • Separate Formal Living Room
  • Formal Dining Room
  • Den
  • Inside Utility
  • Attic

Kitchen

  • Eat-In Kitchen
  • <<builtInOvenToken>>
  • Cooktop<<rangeHoodToken>>
  • Recirculated Exhaust Fan
  • <<microwave>>
  • Dishwasher
  • Stone Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Pool

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

Outdoor Features

  • Deck
  • Covered patio or porch
  • Rain Gutters

Location

  • Property is near public transit

Schools

  • Hammond Elementary School
  • Sergeant Smith Middle School
  • Sickles High School

Utilities

  • Central Heating and Cooling System
  • Electric Water Heater
  • High Speed Internet
  • Cable TV Available

Community Details

  • Association fees include ground maintenance, private road
  • Farmington Subdivision
  • The community has rules related to deed restrictions

Listing and Financial Details

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,276

Year Built

Built in 1987

Lot Details

0

HOA Fees

$21 per month

Parking

2

Listing Details

  • HOA Fee Includes: Maintenance Grounds, Private Road
  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Construction Materials: Block, Brick, Siding, Stucco
  • Fireplace: Yes
  • Living Area: 2452
  • Lot Size Acres: 0.25
  • New Construction: No
  • Year Built: 1987
  • Building Area Total: 3768
  • Lot Size Sq Ft: 10912
  • Directions to Property: Ehrlich Rd and Sheldon Rd/Gunn Hwy, North on Gunn Hwy, Left on Lake Grace Dr, Right on Indian Queen Dr
  • Status: Sold
  • Down Payment Resource URL: http://www.workforce-resource.com/eligibility/listing?metro_area=MFRMLS&listing_id=T2925966&show_results=true&skip_sso=true
  • Down Payment Resource URL 2: http://www.workforce-resource.com/eligibility/listing?metro_area=MFRMLS&listing_id=T2925966&cview=true&show_results=true&customer_portal=true
  • Homestead Y N: No
  • Total Acreage: 1/4 to less than 1/2
  • Home Warranty Y N: No
  • Planned Unit Development Y N: Yes
  • Ratio: Close Price\List Price: 0.94862
  • Price per Sq Ft: 146.82
  • Close to Original List Price Ratio: 0.91139
  • Ratio: Current Price\Building Area Total: 95.54
  • View: No
  • Co List Office Mls Id: 779309
  • Co List Office Phone: 813-259-0000
  • Ownership: Fee Simple
  • ResoBuildingAreaSource: PublicRecords
  • Tax Year: 2017
  • Special Features: VirtualTour

Interior Features

  • Fireplace Features: Family Room, Wood Burning
  • Living Area Units: Square Feet
  • Flooring: Ceramic Tile, Hardwood
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Interior Amenities: Attic, Ceiling Fans(s), Eating Space In Kitchen, Solid Wood Cabinets, Stone Counters, Walk-In Closet(s)
  • Appliances Included: Built-In Oven, Cooktop, Dishwasher, Disposal, Dryer, Electric Water Heater, Exhaust Fan, Microwave, Washer
  • Foundation Details: Slab
  • Total Bedrooms: 4
  • Levels: Two
  • Window Features: Blinds
  • Street Number Modifier: 15628
  • Room Count: 11
  • Additional Rooms: Attic, Den/Library/Office, Family Room, Formal Dining Room Separate, Formal Living Room Separate, Foyer, Inside Utility
  • ResoLivingAreaSource: PublicRecords

Exterior Features

  • Direction Faces: Northeast
  • Pool Features: Child Safety Fence, Gunite, In Ground, Screen Enclosure
  • Exterior Features: Fenced, French Doors, Rain Gutters
  • Roof: Shingle
  • Pool Private: Yes
  • Waterfront: No
  • Patio and Porch Features: Covered, Deck, Patio, Porch, Screened
  • Road Surface Type: Paved
  • Water View Y N: No
  • Water Access Y N: No
  • Water Extras Y N: No
  • Flood Zone Panel: 12057C0180H
  • Disclosures: HOA/PUD/Condo Disclosure

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2
  • Garage Yn: Yes
  • Parking Features: Driveway, Garage Door Opener, Garage Faces Rear, Garage Faces Side
  • Covered Parking Spaces: 2
  • Open Parking: Yes

Utilities

  • Utilities: BB/HS Internet Available, Cable Available, Cable Connected, Electricity Connected, Fiber Optics, Public, Street Lights
  • Cooling: Central Air
  • Heating: Central, Electric
  • Laundry Features: Inside
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Community Features: Deed Restrictions
  • Association Fee: 250
  • Association Fee Frequency: Annually
  • Association: Yes
  • Senior Community: No
  • Condo Land Included Y N: No
  • Association Fee Requirement: Required
  • Association Approval Required YN: No

Fee Information

  • Total Annual Fees: 250
  • Monthly HOA Fee: 20.83
  • Total Monthly Fees: 20.83

Schools

  • Elementary School: Hammond Elementary School
  • High School: Sickles-HB
  • Middle Or Junior School: Sergeant Smith Middle-HB

Lot Info

  • Zoning: PD
  • Parcel Number: U-35-27-17-02X-000003-00016.0
  • Additional Parcels: No
  • Lot Features: In County, Near Public Transit, Sidewalk, Unincorporated
  • Lot Dimensions: 88x124
  • Flood Zone Code: X
  • Flood Zone Date: 2008-08-28
  • Zoning Compatible Y N: Yes
  • ResoLotSizeUnits: SquareFeet

Rental Info

  • Furnished: Unfurnished
  • Pets Allowed: Yes
  • Minimum Lease: No Minimum
  • Lease Restrictions Y N: No

Tax Info

  • Tax Annual Amount: 6276
  • Tax Block: 3
  • Tax Book Number: 60-32
  • Tax Lot: 16

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 29, 2018
Closed on
May 24, 2018
Sold by
423 Ventires Llc
Bought by
Ali Syed S and Syed Shama
Seller's Agent
Lotte Rogers, The Viking Team
RE/MAX ALLIANCE GROUP
Buyer's Agent
Kristin Blankenship
List Price
$395,000
Sold Price
$360,000
Premium/Discount to List
-$35,000
-8.86%
Current Estimated Value
$704,587

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$344,587
Avg. Annual Appreciation
9.38%
Original Mortgage
$270,000
Outstanding Balance
$235,439
Interest Rate
4.4%
Mortgage Type
New Conventional
Estimated Equity
$448,760

Purchase Details

Closed on
Jun 14, 2016
Sold by
Glasscock John
Bought by
423 Ventures Llc

Purchase Details

Closed on
Apr 20, 2015
Sold by
Triplett Robert D and Triplett Karen L
Bought by
Glasscock John

Purchase Details

Closed on
Jun 24, 1997
Sold by
Rosario Angel M and Rosario Yolanda
Bought by
Triplett Robert D and Triplett Karen L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$118,000
Interest Rate
7.97%
Mortgage Type
New Conventional
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
Ali Syed S $360,000 Veritas Title Inc
423 Ventures Llc -- Veritas Title Inc
Glasscock John $335,000 Veritas Title Inc
Triplett Robert D $153,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ali Syed S $270,000
Previous Owner Triplett Robert D $150,000
Previous Owner Triplett Robert D $162,700
Previous Owner Triplett Robert D $118,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/24/2018 05/24/18 Sold $360,000 -5.1% $147 / Sq Ft
04/27/2018 04/27/18 Pending -- -- --
02/28/2018 02/28/18 Price Changed $379,500 -3.9% $155 / Sq Ft
01/29/2018 01/29/18 For Sale $395,000 -- $161 / 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 $9,087 $522,143 $105,737 $416,406
2023 $8,479 $507,309 $100,172 $407,137
2022 $7,674 $453,188 $89,042 $364,146
2021 $6,826 $353,685 $72,347 $281,338
2020 $6,433 $332,767 $69,564 $263,203
2019 $6,508 $324,735 $69,564 $255,171
2018 $6,445 $318,025 $0 $0
2017 $6,276 $305,665 $0 $0
2016 $6,058 $289,859 $0 $0
2015 $3,087 $265,150 $0 $0
2014 $3,062 $171,048 $0 $0
2013 -- $168,520 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • K

    Buyer's Agent in 2018

    Kristin Blankenship

    Section Image
See All Agents

Map

Source: Stellar MLS

MLS Number: T2925966

Stellar MLS

APN: U-35-27-17-02X-000003-00016.0

Florida Hillsborough County Odessa 33556

15628 Indian Queen Dr, Odessa, FL

This home is located at 15628 Indian Queen Dr, Odessa, FL 33556 since 29 January 2018 and is currently estimated at $704,587, approximately $287 per square foot. This property was built in 1987. 15628 Indian Queen Dr is a home located in Hillsborough County with nearby schools including Hammond Elementary School, Sgt. Paul R. Smith Middle School, and Sickles 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