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

451 Division Street
Marked Tree, AR 72365

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $380,000
Beds: 3
Baths: 3
Status: Active
SqFt: 3396
Agency: Century 21 Wright-Pace

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1986
Notes: Nestled amidst the serene beauty of a rural landscape, this unique home stands out with its striking hexagonal roofline, blending seamlessly into its natural surroundings. As you approach, the warmth of the cypress siding and rock exterior welcomes you, hinting at the rustic elegance within. Stepping through the double front doors, you're greeted by the inviting embrace of wood ceilings that stretch overhead, creating a cozy refinement. The wood and rock wall accents and stained concrete floors add elegance to the space. In the heart of the home lies a grand living space, anchored by a magnificent rock gas fireplace. This central gathering spot is perfect for cozy evenings with loved ones and the space is large enough for entertaining. The kitchen, a culinary haven, boasts modern amenities and ample space for both casual family meals and gourmet creations. The granite countertops enrich beauty along with the stainless appliances. Adjacent to it, the family dining room features a built-in buffet and wet bar, ideal for entertaining guests with ease. For more formal occasions, a separate dining room provides an elegant setting for unforgettable gatherings. Tucked away for privacy, the master suite is a haven of relaxation, complete with a cedar-lined walk-in closets and a sprawling master bath. Here, a freestanding soaker tub invites indulgent soaks, while an oversized tiled shower with double shower heads offers a luxurious bathing experience.The heated floors and heated towel rack provide the elegance this bath deserves. Also, the double vanity with exotic granite countertops provides plenty of storage. Throughout the home, the thoughtful inclusion of cedar-lined closets and security doors on every entrance. Outside, the sprawling grounds offer endless opportunities. The oversize patio offers a large firepit with plenty of space for entertaining. Also adjacent to the area is another large room that can be a office, shop, gameroom or mancave. In every corner and every detail, this rural retreat embodies a harmonious blend of natural beauty, refined craftsmanship, and modern comfort, a truly unique sanctuary for those who appreciate the finer things in life. Looking for all of this and rural living between Memphis and Jonesboro, look no further!
MlsNumber: 10113206


Listing Provided By: Century 21 Wright-Pace, original listing
Name: Century 21 Wright-Pace
Phone: (870) 933-0026
Office Name: Century 21 Portfolio
Office Phone: (870) 933-0026
Agent Name: Angie Smith
Disclaimer: Copyright © 2024 Northeast Arkansas 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