Title Page Background
DEBUG FN args: Array ( [0] => 19 [1] => [2] => [3] => agent ) BEFORE: Site: 19 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 19 Igate: njhud LocID: 19 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 19 AND i.igate IN ('gahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 19 [1] => [2] => [3] => lender ) BEFORE: Site: 19 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 19 Igate: njhud LocID: 19 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 19 AND i.igate IN ('gahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 19 [1] => [2] => [3] => other ) BEFORE: Site: 19 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 19 Igate: njhud LocID: 19 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 19 AND i.igate IN ('gahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

938 5th Street
Florala, AL 36442
Christa V Merrifield with Merrifield & Pilcher Realty, original listing - (850) 892-9650

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 4016 Square Feet
Agency: Merrifield & Pilcher Realty
Agency Phone: (850) 892-9650

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1903
Notes: HISTORIC BEAUTY IN FLORALA JUST BLOCKS OFF LAKE JACKSON. HOME HAS BEEN UPGRADES AND IS REMARKABLE INSIDE WITH ALL THE HISTORIC CHARM REMAINING. HOME IS GRAND AND OF ENORMOUS SIZE INSIDEINCLUDING 2 DOWN STAIR LIVING ROOMS AS WELL AS AN UPSTAIRS LIVING ROOM. HOME HAS A LARGE OPEN KITCHENTHAT CONNECTS TO A FORMAL DINING AS WELL AS LIVING ROOM AND IS PERFECT FOR FAMILY ENJOYMENT. THE HOMEHAS TALL 12 FT CEILINGS AS WELL AS A GRAND STAIRCASE TO THE UPSTAIRS. ALL ORIGINAL FIREPLACES REMAININTACT TO INCLUDE ONE IN THE MASTER BATH - GREAT FOR RELAXING. PROPERTY ALSO INCLUDES A GREAT OUTSIDEAREA WITH A LARGE UPSTAIRS DECK, COVERED FRONT AND BACK PORCHES, STORAGE BUILDING AND GREAT SIZEBACKYARD. LOCATED JUST MINUTES TO SCHOOLS, PARKS, AND ALL THE THINGS QUITE FLORALA HAS TO OFFER.
MlsNumber: --
ListingId: 973154


Listing Provided By: Merrifield & Pilcher Realty, original listing
Phone: (850) 892-9650
Office Phone: (850) 892-9650
Agent Name: Christa V Merrifield
Disclaimer: Copyright © 2025 Emerald Coast Association 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