NOT LISTED FOR SALE

15701 Indian Queen Dr Odessa, FL 33556

Estimated Value: $650,703 - $738,000

4 Beds
2.5 Baths
2,600 Sq Ft
$266/Sq Ft Est. Value

Last Sold June 03, 2022

Last sale price $680,000 $262 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $4,294/month

3 Days on Market

Highlights

  • Screened Pool
  • Living Room with Fireplace
  • Outdoor Kitchen
  • Hammond Elementary School Rated A-
  • Traditional Architecture
  • Bonus Room

About This Home

As of June 2022

MULTIPLE OFFERS... OFFER DEADLINE, SUNDAY 5/1, 2PM... MOVE-IN-READY!! STUNNING 4 bedroom, 2.5 bathroom, 2-car garage, 2-story POOL home located in the desirable community of Farmington Village. Elegant 2,600 SqFt home is nestled on an almost 1/4 ACRE lush corner lot & overlooks picturesque trees. LOADED WITH UPGRADES, this home boasts all the bells & whistles! A COVERED ENTRY with a FRONT PATIO welcomes you into the foyer, and formal living room, and is across the way from the formal dining room. The fabulous GOURMET, EAT-IN kitchen showcases GRANITE countertops, UPGRADED STAINLESS STEEL appliances, elegant wood cabinets, DOUBLE OVENS, an ISLAND, and a BREAKFAST BAR! The kitchen seamlessly flows into the family room boasting a WOOD-BURNING FIREPLACE, and features DOUBLE POCKET DOORS, which lead to the office area, and are PERFECT for saving EXTRA space! The LARGE MASTER is simply blissful with CATHEDRAL CEILINGS! Recently overhauled and renovated LUXURIOUS ENSUITE MASTER BATHROOM! The additional bedrooms are bright, offer ample space, and are easily convertible. Back downstairs, you will see the laundry room that offers a utility sink, and leads to the garage. The half bathroom downstairs leads to the lanai area making for the perfect pool bath. PRIDE IN OWNERSHIP is clear within this home. OUTDOOR LIVING is appointed for fun year round with a FULLY-FENCED backyard that offers an ENORMOUS SCREENED-IN LANAI with a pool deck that has a kitchenette area with a sink area, and extra cabinetry. The lanai also offers a SPARKLING POOL & SPA (no pool heater). Truly an IDEAL place to entertain!! In addition, this home has NEWER INTERIOR PAINT! Small beautifully maintained community with a low HOA, and NO CDD fees, close to Gunn Hwy, which boasts entertaining, shopping, dining, services, and SO MUCH MORE! Come see this home NOW before it's gone! ***UPDATED/UPGRADED WITHIN THE LAST YEAR... New 30-Year 3-Dimensional Shingle Roof, Pool pump, Light Fixtures & Fans, Interior Paint, Dishwasher, Smart Thermostat, Alarm System, Pool Fence, and a completely gutted and renovated Ensuite Master Bathroom!

Last Agent to Sell the Property

Mike Grizzell

COMPASS FLORIDA LLC License #3221211 Listed on: 04/28/2022

COMPASS FLORIDA LLC

Last Buyer's Agent

Tom Leber

LPT REALTY, LLC License #3261509

LPT REALTY, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,551

Year Built

  • Built in 1988

Lot Details

  • 9,595 Sq Ft Lot
  • Lot Dimensions are 95x101
  • East Facing Home
  • Child Gate Fence
  • Mature Landscaping
  • Corner Lot
  • Oversized Lot
  • Landscaped with Trees
  • Property is zoned PD

HOA Fees

  • $22 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway
  • Secured Garage or Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 2,600 Sq Ft Home
  • 2-Story Property
  • Built-In Features
  • Crown Molding
  • Ceiling Fan
  • French Doors
  • Great Room
  • Family Room
  • Living Room with Fireplace
  • Breakfast Room
  • Formal Dining Room
  • Den
  • Bonus Room
  • Inside Utility
  • Laundry Room

Kitchen

  • Eat-In Kitchen
  • Built-In Oven
  • Cooktop with Range Hood
  • Recirculated Exhaust Fan
  • Microwave
  • Dishwasher
  • Stone Countertops
  • Disposal

Flooring

  • Parquet
  • Carpet
  • Laminate
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Split Bedroom Floorplan
  • Walk-In Closet

Home Security

  • Home Security System
  • Fire and Smoke Detector

Pool

  • Screened Pool
  • In Ground Pool
  • In Ground Spa
  • Gunite Pool
  • Fence Around Pool
  • Outdoor Shower
  • Outside Bathroom Access
  • Pool Tile
  • Pool Lighting

Outdoor Features

  • Enclosed Patio or Porch
  • Outdoor Kitchen
  • Exterior Lighting
  • Outdoor Storage

Schools

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

Utilities

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

Additional Features

  • Reclaimed Water Irrigation System
  • Property is near a golf course

Community Details

  • Association fees include common area taxes, escrow reserves fund, private road
  • Farmington Village HOA John Francis Association
  • Visit Association Website
  • Farmington Subdivision

Listing and Financial Details

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,551

Year Built

Built in 1988

Lot Details

0

HOA Fees

$22 per month

Parking

2

Listing Details

  • HOA Fee Includes: Common Area Taxes, Escrow Reserves Fund, Private Road
  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Construction Materials: Brick, Vinyl Siding
  • Fireplace: Yes
  • Living Area: 2600
  • Lot Size Acres: 0.22
  • New Construction: No
  • Year Built: 1988
  • Building Area Total: 3660
  • Lot Size Sq Ft: 9595
  • Directions to Property: From Gunn Hwy, Head West on Lake Grace Dr, Turn right on Indian Queen Dr
  • Status: Sold
  • Co List Office Mls Id: MFR781263
  • Co List Office Phone: 212-913-9058
  • Ownership: Fee Simple
  • ResoBuildingAreaSource: PublicRecords
  • Available for Lease YN: 1
  • Escrow City: Tampa
  • Escrow Postal Code: 33606
  • Escrow State: FL
  • Escrow Street Name: W Cleveland St
  • Escrow Street Number: 1560
  • List Office Head Office Key Nume: 169647934
  • Minimum Lease: No Minimum
  • RATIO Current Price By Calculate: 261.54
  • Total Acreage: 0 to less than 1/4
  • Unit Number YN: 0
  • Water Access YN: 0
  • Tax Year: 2021
  • Special Features: VirtualTour

Interior Features

  • Fireplace Features: Living Room
  • Living Area Units: Square Feet
  • Flooring: Carpet, Ceramic Tile, Laminate, Parquet
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Interior Amenities: Built-in Features, Ceiling Fans(s), Crown Molding, Eat-in Kitchen, Dormitorio Principal Arriba, Split Bedroom, Stone Counters, Walk-In Closet(s)
  • Appliances Included: Built-In Oven, Cooktop, Dishwasher, Disposal, Electric Water Heater, Exhaust Fan, Microwave, Range, Range Hood, Refrigerator
  • Foundation Details: Slab
  • Total Bedrooms: 4
  • Levels: Two
  • Spa Features: In Ground
  • Spa Yn: Yes
  • Stories: 2
  • Street Number Modifier: 15701
  • ResoLivingAreaSource: PublicRecords
  • Additional Rooms: Bonus Room,Breakfast Room Separate,Den/Library/Office,Family Room,Formal Dining Room Separate,Formal Living Room Separate,Great Room,Inside Utility
  • Living Area Meters: 241.55
  • Room Count: 9

Exterior Features

  • Direction Faces: East
  • Other Structures: Outdoor Kitchen, Storage
  • Pool Features: Child Safety Fence, Gunite, In Ground, Lighting, Outside Bath Access, Screen Enclosure, Tile
  • Exterior Features: Fence, French Doors, Irrigation System, Lighting, Outdoor Shower, Sidewalk
  • Roof: Shingle
  • Pool Private: Yes
  • Waterfront: No
  • Patio and Porch Features: Covered, Enclosed, Patio, Screened
  • Road Surface Type: Asphalt
  • Disclosures: HOA/PUD/Condo Disclosure, Seller Property Disclosure
  • Water Extras YN: 0
  • Water View YN: 0
  • Waterfront Feet Total: 0

Garage/Parking

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

Utilities

  • Utilities: BB/HS Internet Available, Cable Available, Cable Connected, Electricity Available, Electricity Connected, Fiber Optics, Sewer Available, Sprinkler Recycled, Street Lights, Underground Utilities
  • Cooling: Central Air
  • Heating: Central, Electric
  • Laundry Features: Inside, Laundry Room
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Association Fee: 260
  • Association Fee Frequency: Annually
  • Association Name: Farmington Village HOA - John Francis
  • Association: Yes
  • Security: Secured Garage / Parking, Security System, Smoke Detector(s)
  • Senior Community: No
  • Association Approval Required YN: 0
  • Pet Restrictions: Buyer to verify any and all pet restrictions with association.
  • Association Fee Requirement: Required
  • Association Email: kingfish0137@hmail.com
  • Association URL: www.farmington-village.com

Fee Information

  • Total Annual Fees: 260.00
  • Total Monthly Fees: 21.67
  • Monthly HOA Amount: 21.67

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-000001-00007.0
  • Additional Parcels: No
  • Lot Features: Corner Lot, Near Golf Course, Oversized Lot, Sidewalk
  • Lot Dimensions: 95x101
  • Flood Zone Code: X
  • Homestead YN: 1
  • Lot Size Square Meters: 891

Green Features

  • Green Verification Count: 0

Rental Info

  • Pets Allowed: Yes
  • Lease Restrictions YN: 0
  • Additional Lease Restrictions: Buyer responsible for verifying any and all lease restrictions.

Tax Info

  • Tax Annual Amount: 5551
  • Tax Block: 1
  • Tax Book Number: 60-32
  • Tax Lot: 7

Multi Family

  • Approval Process: Buyer responsible for verifying any and all lease restrictions.

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 28, 2022
Closed on
Jun 3, 2022
Sold by
Christmann and Melissa
Bought by
Warren Malia and Warren Nathan A
Seller's Agent
Mike Grizzell
COMPASS FLORIDA LLC
Buyer's Agent
Tom Leber
LPT REALTY, LLC
List Price
$599,900
Sold Price
$680,000
Premium/Discount to List
$80,100
13.35%
Current Estimated Value
$692,426

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$12,426
Avg. Annual Appreciation
0.55%
Original Mortgage
$544,000
Outstanding Balance
$516,799
Interest Rate
5.09%
Mortgage Type
New Conventional
Estimated Equity
$175,627

Purchase Details

Listed on
Mar 17, 2021
Closed on
Apr 27, 2021
Sold by
Rosbrough Joseph A and Rosbrough Kelly G
Bought by
Christmann Daniel and Christmann Melissa
Seller's Agent
Andrew Duncan
LPT REALTY LLC
Buyer's Agent
Mike Grizzell
COMPASS FLORIDA LLC
List Price
$445,000
Sold Price
$453,000
Premium/Discount to List
$8,000
1.8%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
44.67%
Original Mortgage
$430,350
Interest Rate
3%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 30, 2014
Sold by
Stackhouse Donald E and Stackhouse Margaret A
Bought by
Rosbrough Joseph A and Rosbrough Kelly G

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$351,220
Interest Rate
4.4%
Mortgage Type
VA
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
Warren Malia $680,000 Old Tampa Bay Title
Christmann Daniel $453,000 Strategic Title
Rosbrough Joseph A $340,000 Brokers Title Of Tampa Llc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Warren Malia $544,000
Previous Owner Christmann Daniel $430,350
Previous Owner Rosbrough Joseph A $347,755
Previous Owner Rosbrough Joseph A $351,220
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/03/2022 06/03/22 Sold $680,000 +13.4% $262 / Sq Ft
05/02/2022 05/02/22 Pending -- -- --
04/28/2022 04/28/22 For Sale $599,900 +32.4% $231 / Sq Ft
04/27/2021 04/27/21 Sold $453,000 +1.8% $174 / Sq Ft
03/22/2021 03/22/21 Pending -- -- --
03/17/2021 03/17/21 For Sale $445,000 0.0% $171 / Sq Ft
03/06/2018 03/06/18 Rented $2,400 0.0% --
02/19/2018 02/19/18 Under Contract -- -- --
01/26/2018 01/26/18 Price Changed $2,400 -4.0% $1 / Sq Ft
01/18/2018 01/18/18 Price Changed $2,500 -5.7% $1 / Sq Ft
01/11/2018 01/11/18 For Rent $2,650 -- --
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 $6,993 $408,160 -- --
2023 $6,765 $396,272 $89,809 $306,463
2022 $6,320 $373,987 $79,830 $294,157
2021 $5,782 $295,403 $64,862 $230,541
2020 $5,493 $282,275 $62,368 $219,907
2019 $5,150 $263,702 $62,368 $201,334
2018 $4,952 $250,635 $0 $0
2017 $3,772 $243,553 $0 $0
2016 $3,732 $221,674 $0 $0
2015 $3,774 $212,907 $0 $0
2014 $2,859 $208,462 $0 $0
2013 -- $170,510 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Stellar MLS

MLS Number: T3369180

Stellar MLS

APN: U-35-27-17-02X-000001-00007.0