• Listing status icon

    $1,695,000

  • Active | MLS#: T2843664
  • 6Beds
  • 7Baths
  • 8,398Sq Ft

18122 LONGWATER RUN DR TAMPA, FL 33647

Favorite
Share
Close
Info Visit Virtual Tour Search

Overview

Magnificent estate home in gated village of Heritage Oaks community of Hunter's Green! 8,398 sf, 6 bedrooms, 6 1/2 baths, Office, Game Room, Bonus Room, 4 Car Garage with courtyard driveway, heated pool and spa, and Summer Kitchen on .82 acre lot overlooking Hunter's Green Golf and Country Club. This home has all the finishes and upgrades one would expect in a luxury property! Please click on the virtual tour link to see many additional photos. Master and 2 bedrooms down, 3 bedrooms upstairs. 5 bedrooms offer ensuite baths. Bedroom 6, 14x14, being used as exercise room. Spacious Kitchen offers high end appliances, double copper sink, warming drawer, pot filler faucet, 6 burner gas stove, double ovens, island with vegetable sink. Butler's pantry with wine cooler and copper sink. The family room offers a vaulted wood ceiling, gas fireplace and wall of beautiful wood shelving. Formal Living Room offers a gas fireplace; large Formal Dining Room. Master bedroom is very spacious; Bath offers a claw foot soaking tub, separate vanities. Lanai boasts wood ceilings, two separate seating areas and views overlooking the golf course. Manicured gardens and fountains. Rich wood cabinetry; Gorgeous wrought iron stair railing; Wood floors; Wood inlay foyer floor; Plantation shutters; Extensive trim work; Tray ceilings; Custom closet shelving; and so much more! Hunter's Green is a 24 hr manned country club community with parks, tennis, sports courts. Near interstates, Moffitt, USF, hospitals, restaurants, shopping, more.

Listing provided courtesy of: Coldwell Banker Residential

General Features

  • Property Style Single Family Home
  • County Or Parish Hillsborough
  • Financing Available Cash, Conventional
  • HOA Fee 5248.00
  • Monthly HOA Amount 437.33
  • HOA Payment Schedule Annual
  • Housing For Older Persons N/A
  • MLS Area Major Tampa / Tampa Palms
  • Tax Year 2017
  • Taxes 28251
  • Township 27
  • Year Built 2006

Building Features

  • Architectural Style Traditional
  • Appliances Included Built In Oven, Dishwasher, Disposal, Dryer, Gas Appliances, Microwave, Oven - Double, Range, Range Hood, Refrigerator, Washer, Water Softener Owned, Wine/Bar Refrigerator
  • Additional Rooms Bonus Room, Breezeway, Den/Library/Office, Family Room, Game Room, Inside Utility
  • Air Conditioning Central
  • Community Features Fees Required, Gated Community, Golf Community, Park, Playground, Security, Tennis Courts
  • Property Description Two Story
  • Fireplace Description Family Room, Gas Fireplace, Living Room
  • Floor Covering Carpet, Ceramic Tile, Wood
  • Foundation Slab
  • Garage Carport 4 Car Garage
  • Garage Features Attached, Circular Drive, Detached, Oversized
  • Heatingand Fuel Central
  • Interior Features Attic, Blinds/Shades, Cathedral/Vaulted Ceiling, Ceiling Fan(S), Central Vacuum, Crown Molding, Inside Utility, Smoke Alarm(S), Solid Surface Counters, Solid Wood Cabinets, Tray Ceiling, Volume Ceilings, Walk In Closet
  • Interior Layout Breakfast Room Separate, Formal Dining Room Separate, Formal Living Room Separate, Master Bedroom Downstairs, Open Floor Plan, Split Bedroom
  • Kitchen Features Breakfast Bar, Island, Walk In Pantry
  • Maintenance Includes Not Applicable
  • Master Bath Features Dual Sinks, Tub with Separate Shower Stall
  • Pet Restrictions Refer to HOA guidelines for pet restrictions.
  • Pet Restrictions 1
  • Pool Private
  • Roof Tile
  • Sq Ft Heated 8,398
  • Sq Ft Total 11909

Property Features

  • Exterior Construction Block, Stucco, Wood Frame
  • Exterior Features Fenced, Gutters / Downspouts, Mature Landscaping, Outdoor Kitchen, Outdoor Lights, Patio/Porch/Deck Open, Sliding Doors, Trees/Landscaped
  • Location Golf Course Frontage, Golf Course View, In City Limits, Street Paved
  • Front Exposure South
  • Lot Dimensions 137x260
  • Lot Number 2
  • Lot Size Acres 0.82
  • Lot Size Sq Ft 35620
  • Total Acreage 1/2 Acre to 1 Acre
  • Utilities BB/HS Internet Avail, Cable Connected, City Water, Electric, Gas, Public Sewer, Public Utilities

Schools

Ask a Question

Price & Status History

Days on Market

  • This property has been listed on the market for 439 days
  • Average days-on-market for homes between $1,356,000 - $2,034,000 = 255 (in zip code 33647)

Location

The property map location is: Accurate, based on Google's address match.

Walk Score

Get the Walk Score Report

Home Valuation

Get the Home Value Report

Ask A Question

Community Demographics for Zip Code 33647 (TAMPA)

Housing Occupancy
  • Home Owners: 15,852 (56%)
  • Renters: 10,088 (36%)
  • Vacant: 2,465 (9%)
  • Total Housing Units: 28,405
Households
  • Average Household Size: 2.69
  • Housing Density (People per square mile): 2,060
Age Range (number of people)
  • Age 0-14: 15,247
  • Age 15-24: 9,820
  • Age 25-39: 12,751
  • Age 40-59: 18,117
  • Age 60-79: 11,789
  • Age 80+: 2,082
  • Total: 69,806

* All numbers in this section are 2016 projections provided by Geolytics Inc

School Information for 33647 (TAMPA)

Public Schools in Zip Code 33647 (TAMPA)

* This list of schools may not match the property above.

FREEDOM HIGH SCHOOL 17410 COMMERCE PARK BLVD TAMPA, FL 33647 Phone: 8135581185 9th-12th
Grade Size Distribution
  • 9th: 589
  • 10th: 541
  • 11th: 532
  • 12th: 462
School Population
  • Teachers: 123
  • Students per Teacher: 17.3
  • Students: 2124
  • Male/Female: 1049/964
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
WHARTON HIGH SCHOOL 20150 BRUCE B DOWNS BLVD TAMPA, FL 33647 Phone: 8136314710 9th-12th
Grade Size Distribution
  • 9th: 743
  • 10th: 641
  • 11th: 478
  • 12th: 491
School Population
  • Teachers: 139
  • Students per Teacher: 16.9
  • Students: 2353
  • Male/Female: 1131/1096
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
BARTELS MIDDLE SCHOOL 9020 IMPERIAL OAK BLVD TAMPA, FL 33647 Phone: 8139076801 6th-8th
Grade Size Distribution
  • 6th: 308
  • 7th: 307
  • 8th: 289
School Population
  • Teachers: 63
  • Students per Teacher: 14.3
  • Students: 904
  • Male/Female: 417/427
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
BENITO MIDDLE SCHOOL 10101 CROSS CREEK BLVD TAMPA, FL 33647 Phone: 8136314694 6th-8th
Grade Size Distribution
  • 6th: 345
  • 7th: 380
  • 8th: 437
School Population
  • Teachers: 76
  • Students per Teacher: 15.3
  • Students: 1162
  • Male/Female: 544/542
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
LIBERTY MIDDLE SCHOOL 17400 COMMERCE PARK BLVD TAMPA, FL 33647 Phone: 8135581180 6th-8th
Grade Size Distribution
  • 6th: 366
  • 7th: 403
  • 8th: 378
School Population
  • Teachers: 80
  • Students per Teacher: 14.3
  • Students: 1147
  • Male/Female: 540/545
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
CHILES ELEMENTARY SCHOOL 16541 WEST TAMPA PALMS BLVD TAMPA, FL 33647 Phone: 8135585422 K-5th
Grade Size Distribution
  • Knd: 107
  • 1st: 97
  • 2nd: 110
  • 3rd: 146
  • 4th: 133
  • 5th: 123
School Population
  • Teachers: 58
  • Students per Teacher: 12.3
  • Students: 716
  • Male/Female: 313/335
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
CLARK ELEMENTARY SCHOOL 19002 WOOD SAGE DR TAMPA, FL 33647 Phone: 8136314333 PreK-5th
Grade Size Distribution
  • PreK: 2
  • Knd: 120
  • 1st: 128
  • 2nd: 136
  • 3rd: 155
  • 4th: 136
  • 5th: 142
School Population
  • Teachers: 64
  • Students per Teacher: 12.8
  • Students: 819
  • Male/Female: 413/335
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
HERITAGE ELEMENTARY SCHOOL 18201 EAST MEADOWS RD TAMPA, FL 33647 Phone: 8137404580 PreK-5th
Grade Size Distribution
  • PreK: 17
  • Knd: 75
  • 1st: 93
  • 2nd: 99
  • 3rd: 100
  • 4th: 89
  • 5th: 108
School Population
  • Teachers: 43
  • Students per Teacher: 13.5
  • Students: 581
  • Male/Female: 286/234
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
HUNTER'S GREEN ELEMENTARY SCHOOL 9202 HIGHLAND OAK DR TAMPA, FL 33647 Phone: 8139737394 PreK-5th
Grade Size Distribution
  • PreK: 25
  • Knd: 105
  • 1st: 137
  • 2nd: 166
  • 3rd: 143
  • 4th: 157
  • 5th: 159
School Population
  • Teachers: 67
  • Students per Teacher: 13.3
  • Students: 892
  • Male/Female: 432/414
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
PRIDE ELEMENTARY SCHOOL 10310 LION'S DEN DR TAMPA, FL 33647 Phone: 8135585400 PreK-5th
Grade Size Distribution
  • PreK: 2
  • Knd: 134
  • 1st: 147
  • 2nd: 178
  • 3rd: 157
  • 4th: 146
  • 5th: 170
School Population
  • Teachers: 72
  • Students per Teacher: 13.0
  • Students: 934
  • Male/Female: 447/425
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
TAMPA PALMS ELEMENTARY SCHOOL 6100 TAMPA PALMS BLVD TAMPA, FL 33647 Phone: 8139757390 PreK-5th
Grade Size Distribution
  • PreK: 26
  • Knd: 119
  • 1st: 127
  • 2nd: 122
  • 3rd: 128
  • 4th: 131
  • 5th: 135
School Population
  • Teachers: 63
  • Students per Teacher: 12.5
  • Students: 788
  • Male/Female: 385/346
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007
TURNER ELEMENTARY SCHOOL 9190 IMPERIAL OAK BLVD TAMPA, FL 33647 Phone: 8139079066 PreK-5th
Grade Size Distribution
  • PreK: 13
  • Knd: 135
  • 1st: 153
  • 2nd: 127
  • 3rd: 151
  • 4th: 139
  • 5th: 137
School Population
  • Teachers: 64
  • Students per Teacher: 13.4
  • Students: 855
  • Male/Female: 385/396
School District
  • HILLSBOROUGH
  • 901 EAST KENNEDY BLVD TAMPA, FL 33602
  • Phone: 8132724050
District Population
  • Schools: 313
  • Full-Time Teachers: 13986
  • Students per Teacher: 13.7
  • Staff: 25892
  • Students: 192007

Private Schools in Zip Code 33647 (TAMPA)

* This list of schools may not match the property above.

Family Of Christ Lutheran School 16190 Bruce B. Domas Blvd. Tampa, FL 33647 Phone: 8135589343 PreK-12th
Grade Size Distribution
  • PreK: 169
  • Knd: 36
  • 1st: 24
  • 2nd: 5
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 234
New Tampa Christian Academy 19911 Bruce B. Downs Blvd. Tampa, FL 33647 Phone: 8139732443 PreK-12th
Grade Size Distribution
  • PreK: 48
  • Knd: 12
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 60
ST. James UM Preschool & Kindergarten 16202 Bruce B. Downs Blvd. TAMPA, FL 33647 Phone: 8139711969 PreK-12th
Grade Size Distribution
  • PreK: 130
  • Knd: 14
School Population
  • Teachers: 0
  • Students per Teacher: N/A
  • Students: 144

* School data provided by US Department of Education


Listing information provided in part by the IDX Program of My Florida Regional MLS. All listing information is deemed reliable but not guaranteed and should be independently verified through personal inspection by appropriate professionals. Listings displayed on this website may be subject to prior sale or removal from sale; availability of any listing should always be independently verified. Data last updated on 12/16/2017 4:19 PM PST.

Listing information is provided for consumer personal, non-commercial use, solely to identify potential properties for potential purchase; all other use is strictly prohibited and may violate relevant federal and state law.



* Rates and payment information listed in the mortgage calculator are provided as for general reference only. Specific mortgage information should be verified with a qualified lending professional