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 = 343 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 = 343 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 = 343 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;

1447 Deer Run Road
Havana, FL 32333
Michael Eaton with Dalton Wade, Inc, original listing - (727) 888-4175

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,900
Beds: 4
Baths: Full: 3
Status: Pending
SqFt: 1872 Square Feet
Agency: Dalton Wade, Inc
Agency Phone: (727) 888-4175

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: If you are searching for a private oasis with unlimited possibilities, this may be the one! Drive thru your private gate, down a private meadow with fruit trees to the secluded craftsman style home. The first thing you will notice is the huge covered front porch with swing. Don't forget to feed the fish in your koi pond. Open the front door to reveal a huge open concept living area complete with a wood burning stove for those chilly nights. The Kitchen features updated stainless steel appliances and PLENTY of counter space for those chefs in the family. Your HUGE master suite on the first floor features two spacious closets, a snazzy shower and a clawfoot tub next to the window. A full guest bath and guest room is also on the first level for those in the family that can't easily navigate stairs. Before going up the stairs, we should talk about the covered screened back porch that runs the entire width of the home. Keep the kiddos upstairs! you deserve an adult space. 2 nicely sized bedrooms and a full bath and more attic space than one could wish. You are on 14.53 acres, it's quiet. Enjoy the solitude, check out the stars, plant a garden, start a farm, you now have multiple outbuildings to finally realize your hobbies. You have an outdoor shower, trails for the horses and or motorized toys. Go check out your stream! YOU NEED TO SEE THIS ONE! Seller is offering a GENEROUS paint and flooring allowance. ** All room dimensions are approximate, Buyer to verify if important.**
MlsNumber: --
ListingId: 361271


Listing Provided By: Dalton Wade, Inc, original listing
Phone: (727) 888-4175
Office Phone: (727) 888-4175
Agent Name: Michael Eaton
Disclaimer: Copyright © 2024 Tallahassee Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App