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

1577 E. Main St
Piggott, AR 72454
Dana Gossett with DAN GOSSETT REAL ESTATE AND INS, original listing - (850) 501-2415

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $595,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 1012 Square Feet
Agency: DAN GOSSETT REAL ESTATE AND INS
Agency Phone: (850) 501-2415

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 17 acre(s)
Garage: Garage
Property Type: Residential-Farm
Year Built: 1917
Notes: Town & Country Farmhouse with17 ACRES m/l located within the city limits on prime highway frontage. Rose Dale Farm is located in Piggott , Arkansas which is ranked The Safest City in Arkansas! Built in 1917, this home is rich in local history and has entertained prominent guests such as Earnest Hemingway! Mr. Hemingway would quail hunt with the owners on the property and was known to have a few bourbons afterwards. He left his mark by leaving a few whiskey glass rings on some of the antique tables. These tables can still be found in this home today! Hemingway-Pfhieffer museum is located down the road, and has a barn where Hemingway wrote part of 'A Farewell to Arms'. It's a great local attraction and is a step back in time! Family and friends visiting from out of town will enjoy learning about local history and enjoy seeing how things were during another period of time. Life can be simple and beautiful when you live in a small town, with one stop light, and people are friendly and you know your neighbors by name! Peace and tranquility surround this property even though it sits inside the city limits. This lovely home is surrounded by 17 M/L irrigated pastoral acres. It has mature trees and beautiful landscaping and offers a picturesque view. There's a lovely front porch, which would be the perfect place for a couple of rocking chairs! Enjoying rocking your cares away sipping on some sweet tea ( the wine of the south)! This home has two bedrooms, one bath, and has 1012 sq ft. The ceilings have beautiful wood panels and add to the character and charm of this property. Character, charm, rich in local history, This Town & Country home has a lot to offer! There's also a special additional property available to purchase! Its a Hunter's Paradise with 99 aces M/L and is priced as a special package deal. Don't wait call today for more information on this amazing property!
MlsNumber: --
ListingId: 11430707


Listing Provided By: DAN GOSSETT REAL ESTATE AND INS, original listing
Phone: (870) 598-5555
Office Phone: (850) 501-2415
Agent Name: Dana Gossett
Disclaimer: Copyright © 2025 My State MLS. 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 = 118 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App