Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 375 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 375 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 375 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1614 Hampton Court
Safety Harbor, FL 34695

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,349,000
Beds: 5
Baths: 4
Status: Pending
SqFt: 3591
Agency: Re/Max Response

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1989
Notes: Under contract-accepting backup offers. SELLER REQUESTS FINAL AND BEST OFFER BY NOON, SAT APRIL 27....Welcome to this one of kind spectacular custom designed luxury pool home in prestigious HUNTINGTON, a highly desired exclusive gated community located in the heart of Safety Harbor! Nestled on 1/2 acre lot size, the owner's pride of ownership is very evident not only because of the several hundred thousand dollars invested, but every special feature or remodel has been done first class with caring thought and love on every detail. For starters, the clay tile roof is known for its durability, strength, insulation, and fire resistance....The ECO-Turf Ornamental Peanut replaced the lawn 2009 resulting in savings of $4000/year for irrigation, pesticide, fungus and fertilizer and significant reduction in frequency of lawn mowing.....The Smart Home lighting and electrical technology system currently operates indoor and outdoor lighting, pool equipment, water leak detection alerts at all points of entry, open/close garage door status. It can be integrated to include security alarm systems, cameras, motion detectors of someone inside/outside home, HVAC control, virtually limitless operation with text alerts!.....Remodel of all 3.5 baths are stunning! The Lauzon Maple wood flooring was carefully selected to eliminate knots, imperfections and large color shade differences! The Subzero refrigerator/freezer, food warming drawer, reverse osmosis system (connected for drinking water at kitchen sink, refrigerator and ice maker) are part of the upgraded kitchen appliances! The 3 car side entry garage and front circular drives are both pavered allows for ample parking. Upgraded gas fireplace with burner/log set. Crown molding, wooden plantation shutters, R-38 attic insulation are among other great features! There is so much more, the home at night needs to be viewed as it is even more amazing for which a lighting specialist was hired to make this a perfect entertainment home! Fantastic location... within 20 minutes to Tampa and Clearwater/St Pete International Airports, 1/2 mile to protected bike trails allowing travel all the way across Tampa Bay to Tampa, close to water of Old Tampa Bay and easy access to Phillippe Park, a premier county Park in Pinellas County! Highly rated public schools along with Montessori and Espiritu Santo private schools all within 2 miles! Close to Mease Hospital, beaches, more than 35 eateries within a mile! Everything you need is here!
MlsNumber: U8239134


Listing Provided By: Re/Max Response, original listing
Name: Re/Max Response
Phone: (727) 443-6700
Office Name: RE/MAX REALTEC GROUP INC
Office Phone: (727) 789-5555
Agent Name: Rene Mailaender
Disclaimer: Copyright © 2024 Pinellas Suncoast Association of REALTORS ®, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 375 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Brian Cooper
Brian Cooper
ASCIIRealty Experts
Call Today!: (727) 351-2728

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App