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 = 414 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 414 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 414 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

126 Flicker
Saint George, GA 31562
Debra Johanson with Keller Williams GA Communities, original listing - (833) 833-1145

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $379,900
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1200 Square Feet
Agency: Keller Williams GA Communities
Agency Phone: (833) 833-1145

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Exquisite Deep Water Living on the St Marys River. With 155 feet of River Frontage, this Custom Home is a Nature Lovers Paradise. Nestled in the heart of St. George on the Florida/Georgia border, this one of a kind, Custom Built Home is perfect for entertaining and peaceful living. The Craftsmanship includes handsome tongue and groove Pine Walls and Ceilings throughout the home; with exposed and smartly stained Ceiling Rafters offering a rich contrast in the open concept Living Room and kitchen area. The kitchen has Stainless Steel Appliances, Butcher Block Countertops, Ample Cabinetry and Floating Shelves for storage and creative design. The Owner's Suite and additional Bedroom/Flex Space is beautifully designed with White Washed Wood Walls and lovely Barn Doors. Venture outside to find that all under the same roof is an Attached Pavilion with impressive Exposed Rafters. This area is built for entertainment with enough room for lounging, dining, and much more. There is also a very large tool/storage room. Additional features include 2/50 Amp Campsite Hook Ups, Septic System large enough to accommodate 4 bedrooms, Water Softener, Circle Driveway... you need to see this property to understand all that it has to offer. Location is also key! While you will enjoy the privacy of this property, there is easy access to MacClenny for nearby shopping and dining. And it's just a short drive to the bustling City of Jacksonville or the beautiful Golden Isles of Georgia. *Schedule your showing today. Seller requires preapproval or proof of funds.
MlsNumber: --
ListingId: 10485992


Listing Provided By: Keller Williams GA Communities, original listing
Phone: (833) 833-1145
Office Phone: (833) 833-1145
Agent Name: Debra Johanson
Disclaimer: Copyright © 2025 Georgia Multiple Listing Service. 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