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

397 Se County Rd 18a
Starke, FL 32091
Marjorie Lindsey with Lighthouse Realty Associates, original listing - (904) 471-3400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $774,500
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2830 Square Feet
Agency: Lighthouse Realty Associates
Agency Phone: (904) 471-3400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1950
Notes: You Found It,Your Very Own Lake Front Home. A Gated Entry,Down A Flower Lines Drive Welcomes You To Crystal Lake,A Spring Feed Lake Stocked For Great Fishing,With No Public Access. This Property Has 84ft Of Sandy Beach Lake Frontage. The House Was Built In 1950,A Unique Property,Walls Of Brazilian Pecky Cedar,A Full Wall Of Cabinets Built With Reclaimed/Refurbished Barn Wood And Gainesville Sun Press Inserts. The Living Room Features A Wood Burning Fireplace And Fabulous Lake View Through The Wall Of Sliding Glass Doors. The Dining Room Will Welcome A Large Family With Plenty Of Seating. The Kitchen Has A Large Island And Lots Of Other Counter Spaces,It Has Windows To Enjoy The Lake Views And The Option Of Passing Food To Outdoor Dining. The Screened Veranda Is The Perfect Space To Enjoy The Relaxing Serine Moods Inspired By This Paradise. There Is A Spa Room With Access From The Veranda And Or 3rd Bedroom.,This Home Has Three Bedrooms,The Primary Suite Has An Attached Custom Closet/Dressing Room With Built Ins She Will Love,As Big As Most Guest Bedrooms. The Other Two Are Good-sized Guest Bedrooms With The Guest Bath Located Between Them. There Is A 16ft High Rv Parking Space With Electric And 2 More Slots For Your Water Toys,A Trailer Or Truck,Whatever You Need. Attached To It Is A 4-car Carport With Lighting. The Area In Front Of Home Is Asphalt,So There Is Plenty Of Guest Parking. This Is A Dream Come True! Seller Asking For As Is With Inspections Welcome. The Property Will Be Divided,And New Pin Number Will Be Assigned,Property Will Be Approximately 84x800. The Seller Has Done Some Improvements And Repairs,If You Have Seen It Before,It Is Worth Taking Another Look. If You Liked The Uniqueness,It May Work For You Now.
MlsNumber: --
ListingId: 252405


Listing Provided By: Lighthouse Realty Associates, original listing
Phone: (386) 931-7172
Office Phone: (904) 471-3400
Agent Name: Marjorie Lindsey
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.


Local Real Estate Expert

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 = 327 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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;
Real Estate Expert Photo for Dana Collins
Dana Collins
ASCIIFlorida Homes Realty and Mortgage
Call Today!: (904) 545-5759

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App