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

4620 Free Ferry Rd
Fort Smith, AR 72903

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,575,000
Beds: 4
Baths: 5
Status: Active
SqFt: 5627
Agency: Sagely & Edwards Realtors

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1946
Notes: Experience the pinnacle of luxury and private living within this stunning gated residence on Free Ferry, fully renovated by Carrington Creek Homes. From the impeccably landscaped grounds, designed by the award-winning DK Design, to the meticulously curated interior by the acclaimed Goddard Design Group, this property redefines elegance and is ready to welcome you home.<br /> <br /> Upon entering, you will be greeted by sophisticated surfaces adorned with marble, soapstone, leathered and polished quartzite, creating an atmosphere of refinement in every room. Home automation effortlessly manages lighting, drapery, and sound, adding convenience to your daily life; while the Marvin wood windows and doors, along with the security and surveillance systems, offer added peace of mind.<br /> <br /> The primary suite features a walk-in sauna for the utmost relaxation, and the property boasts a saltwater pool and basketball/pickleball court for recreational enjoyment, all within the confines of this two acre property. Enriched by four fireplaces, designer lighting, bespoke furnishings, hand-painted wallpaper, and luxurious textiles gracing every room, this dream home is available to the market fully furnished.<br /> <br /> Whether you're entertaining guests at the opulent bar on the main level or unwinding in the private library upstairs, you'll revel in the sophistication and warmth throughout this well appointed residence. Arrange your private showing today.
MlsNumber: 1068388


Listing Provided By: Sagely & Edwards Realtors, original listing
Name: Sagely & Edwards Realtors
Phone: (479) 782-8911
Office Name: Sagely & Edwards Realtors
Office Phone: (479) 782-8911
Agent Name: Carrington Team
Disclaimer: Copyright © 2024 Fort Smith 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