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

115 Easement
Welaka, FL 32193
Delilla Harts with Florida Homes Realty & Mortgage, original listing - (904) 342-8127

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $359,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1056 Square Feet
Agency: Florida Homes Realty & Mortgage
Agency Phone: (904) 342-8127

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Mobile Home
Year Built: 2007
Notes: Welcome Home To This Boating,Fishing And Relaxing Paradise Located In Welaka Fl Known As The Bass Capitol Of The World. Sit On The Back Porch Of This Meticulously Maintained Home And Plan Your Fishing/River Boat Trip From Your Canal. This Special Property Includes A New Dock With Boat Lift And Deck On The Canal Located Just A Few 100’ From The St Johns River. Situated On A Large Lot Which Could Be Separated Again Into 2 Buildable Lots Or Kept As It Is,For 100’ Of Canal Frontage With More Privacy. The Yard Is Blessed With Towering Oaks Draped In Spanish Moss Giving You A Nostalgic Feel Of Old Florida But Close To All Modern Conveniences. Inside You Will Find A Large Sunny Great Room Spilling Onto The Oversized Porch And Offering Room For Gatherings With The Entire Family And Your Friends. Newer Carport,Roof (2020) And Workshop With Electricity And A/C Add Comfort And Convenience So All You Must Do Is Relax In Your New Home. New Paint Throughout. Home Located In Flood Zone X.,No Flood Insurance Required. Several Resorts In The Area Offer World-class Restaurants,Boat Docks,And Entertainment. Bass Pro Shop Is Planning A Resort Community In The Near Proximity. Centrally Located Less Than An Hour To Historic St Augustine,1-1/2 Hours To Orlando And 1 Hour To Gainesville You Can Have The Best Of All Worlds. Come See For Yourself. You Will Not Be Disappointed.
MlsNumber: --
ListingId: 246080


Listing Provided By: Florida Homes Realty & Mortgage, original listing
Phone: (904) 377-6157
Office Phone: (904) 342-8127
Agent Name: Delilla Harts
Disclaimer: Copyright © 2025 St. Augustine & St. John's County 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