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

19264 Nw Cr 287
Clarksville, FL 32430

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,900
Beds: 3
Baths: 2
Status: Active
SqFt: 1000
Agency: Danny Ryals Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 47 acre(s)
Property Type: Residential
Year Built: --
Notes: Here is the old farmhouse with almost 47 acres that may be just what you are looking for! This 3BR/2BA 1000sf solid home was built in 1949 with heart pine lumber and survived the Cat 5 Hurricane Michael storm in 2018! The home has been updated and still retains the country look and feel. Home has a screened front porch and another big screened porch and utility room on the back of the house. This porch is like an outside den without the bugs. The land has been cleaned up and there are pasture areas, pines, hardwoods and a small pond on the property. There are several small outbuildings and a current survey. The owners have done a lot of work on the home and land and it is on a paved road about 35-40 minutes from Panama City and 10 minutes from Clarksville. The Carr Pre K - 8th grade school and Clarksville, which has a gas station and 2 convenience stores, is about 10 minutes away. There are several beautiful homesites on this property in case you have other family members wanting to live here or if you want to build a bigger home. Measurements: Front Porch: 21'6x8' Living room: 13'4x11'10 Bedroom 1: 11'2x11'5 Bedroom 1 closet: 8'x2' Bedroom 2: 11'2x11'5 Bedroom 2 closet: 2'6x3'6 Kitchen: 16'3x11'11 Bathroom: 5'x6'4 Hallway/storage: 5'8x6'5 Bedroom 3 (primary): 18'6x9'8 Bedroom 3 bathroom: 9'7x5' Back porch: 21'8x19'9
MlsNumber: 11264968


Listing Provided By: Danny Ryals Real Estate, original listing
Name: Danny Ryals Real Estate
Phone: (850) 674-5478
Office Name: DANNY RYALS REAL ESTATE
Office Phone: (850) 674-5478
Agent Name: Danny Ryals
Disclaimer: Copyright © 2024 My State MLS. 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