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

6826 Sw Georgia Street
Arcadia, FL 34269

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $989,000
Beds: 3
Baths: 4
Status: Active
SqFt: 1873
Agency: Coldwell Banker Schmidt Family Of Companies

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1958
Notes: WANNA GET AWAY...TO A RURAL BUT LAVISH SETTING THAT JUST WORDS MAY NOT BE ABLE TO EXPLAIN!!! A corner lot nestled QUIETLY into a beautifully landscaped farmland facing a natural historic park. A serene environment that compares to no other. The inside is filled from room to room with passion, dedication, and lots of love! The aesthetics that went into the interior designing of this country estate are simply breath taking to say the least. This property was completely upgraded with state of the art features from pillar to post. So much so that all of the upgrades can't possibly be listed here. The completed list for the serious buyer, has been added to the remarks in your MLS property listing for your personal review. Brand new appliances, cabinets, laminated wood floors throughout, new lighting fixtures and electrical throughout, hot water heater, hurricane impact windows, new a/c, expanded eat in kitchen, bathrooms, bedrooms . The roof has been replaced along with gutters, the facia including the carport and around the entire home. Hardee board siding was added as well. Comes with an attached 2 bedroom guest house with kitchenette, a/c and separate septic system...Unbelievable!! Above ground swimming pool with a heater, new deck and a hot tub includes salt water self cleaning system for all the relaxing you can imagine. Farm area boasts a small animal house extra fenced in area and 3 electric gates. This gorgeous country setting also, if you can believe it, dawns the luxury of new wood fencing around the entire home with a Quonset including a bathroom for tons of workshop space or for storage of any farm equipment, boats or RV's., 50A hookup already installed for the mobile home lovers!! Buyer must beware that, unless this property is personally seen... you will never be able to fully capture and experience the warmth, the charm or the value wrapped up in this Rural Masterpiece!!! These sellers have far, far exceeded the realm of capabilities that any pictures or words could give life to this dream home!! Call TODAY to schedule a walk through with the listing realtor. You won't believe it until you see it!!
MlsNumber: D6136152


Listing Provided By: Coldwell Banker Schmidt Family Of Companies, original listing
Name: Coldwell Banker Schmidt Family Of Companies
Office Name: Veterans
Office Phone: (941) 629-1245
Agent Name: Aubrey Jackson, Sr.
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt 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 = 337 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;
Real Estate Expert Photo for Linda Swanson
Linda Swanson
ASCIIKeller Williams Peace River
Call Today!: (732) 691-2791

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App