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;

118 Herja Acre Ln
Palatka, FL 32177
Sheila Clark, PA with Watson Realty Corp (A1A), original listing - (904) 494-2575

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,800,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 3933 Square Feet
Agency: Watson Realty Corp (A1A)
Agency Phone: (904) 494-2575

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1963
Notes: The Winding Road That Leads To This Rare And Beautiful Property Sits The Stage For A Truly Special Experience. As You Enter The Property,You Are Greeted By A Mid-century Style Home With A Brick Front Entry Porch,With Charm And Character. The Landscape Is Easy To Care For,Adding To The Overall Appeal Of The Property. The Main Gathering Room Features Oversized Windows That Offer Breathtaking Views Of The Spring-fed Lake. The Formal Living Room And Family Room,Complete With A Wood Fireplace,Provide Cozy Spaces To Relax And Unwind. The Interior Of The Home Is Filled With Unique Features,Such As Oversized Bookshelves,Interior Windows That Bring In An Abundance Of Natural Light,And A Flowing Layout That Seamlessly Connects The Rooms. The Kitchen Is A Chef's Dream,With Beautiful Cabinets,Plenty Of Hidden Storage Spaces,And All Stainless Steel Appliances,Including A Double Oven. The Separate Washer And Dryer Area Is Spacious And Convenient For Everyday Use.,The Home Boasts Five Bedrooms And Three Full Bathrooms,Providing Ample Space For Family And Guests. The Owner's Suite Is A True Retreat,Offering Stunning Views Of The Spring-fed Lake And An En-suite Bathroom With A Walk-in,Door Less Shower And A Luxurious Claw Foot Tub With A Gas Flame. Hardwood Flooring,Tile,And Solid Surface Countertops Adds To The Elegance Home. While The Florida Room And Brick Patio Create Inviting Outdoor Spaces To Enjoy The Surroundings Serene. The Property Also Features A 4 Ft Plunge Pool With A Waterfall,Perfect For Relaxing In The Evening. There Is A Cottage Guest House On The Property That Is Rented Out On Airbnb,Providing Additional Income Potential. The Property Also Includes A Shed And Ample Parking For At Least 25 Cars,Making It Ideal For Hosting Parties,Meetings,Or Even Weddings. Overall,This Property Is A Rare Gem,Offering A Tranquil And Upscale Setting That Is Perfect For Those Seeking A Peaceful Retreat With Modern Amenities And Stunning Views. With Its Unique Features And Potential For Rental Income,This Home Is Truly One-of-a-kind. Next Door Is A Vacant Lot With 2.10 Acres With Dock And Well And Garage Is Included. Address Is 120
MlsNumber: --
ListingId: 240077


Listing Provided By: Watson Realty Corp (A1A), original listing
Phone: (904) 494-2575
Office Phone: (904) 494-2575
Agent Name: Sheila Clark, PA
Disclaimer: Copyright © 2024 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