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

5058 Pullman Ave
Harrisville, WV 26362
Cory Farley with Whitetail Properties Real Estate LLC, original listing - (920) 369-6869

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: --
Agency: Whitetail Properties Real Estate LLC
Agency Phone: (920) 369-6869

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 44 acre(s)
Garage: Garage
Property Type: Residential-Single Family Attached
Year Built: 2015
Notes: Escape to the tranquility of this pristine 44.56-acre farm nestled in the heart of Ritchie County, West Virginia. Beyond the stone gated entrance, a picturesque scene unfolds as you traverse down the concrete drive, leading to the masterfully crafted stone home that serves as the centerpiece of this idyllic property. Step into the grandeur of the main living room, adorned with an exquisite Austrian Swarovski chandelier, real hickory hardwood floors, and a double-sided gas fireplace that seamlessly divides the space and kitchen. The culinary enthusiast will delight in the kitchen's elegance, boasting beautiful quartz countertops, stainless steel appliances, a double oven, gas cooktop, and walnut cabinets. Adjacent to the kitchen, an elegant dining room, illuminated by a tray-lit ceiling, offers ample space for gatherings with loved ones. Extend your living space outdoors onto the covered balcony overlooking the rolling pasture land-a perfect setting for outside dining, equipped with a gas port for grilling and ceiling fans for comfort. Retreat to the spacious and cozy primary bedroom, complete with a tray-lit ceiling and two walk-in closets featuring walnut shelving. The ensuite primary bath beckons with its luxurious amenities, including a heated tub strategically positioned to provide breathtaking views of the horse barn and pasture, a spacious glass door shower, double sinks, quartz countertops, and walnut cabinets. Descend into the lower level, where another living room or bonus room awaits, featuring a fridge, quartz bar, and radiant floor heating-a perfect space for relaxation and entertainment. Stay active in the workout room, complete with built-in walnut shelving for storage and a built-in desk for added convenience. Never worry about losing power in the house or having to fuel the whole house generator, as it is piped directly into the free gas that is available on the property. The two-stall garage offers heated flooring, ensuring comfort year-round. Outdoors, the horse barn stands as a testament to equine luxury, with four 16x12 stalls boasting stunning European stall fronts and heated Nelson waterers. Additional features include a heated wash bay, spacious tack room with one cedar wall with six mounted saddle racks, additional saddle pad racks, and adjacent bridle hooks, gas heat, sink, cabinetry, and a bathroom. A heavily insulated 40x60 steel building provides ample space for storing farming equipment and supplies. The property also boasts approximately 15.5 acres of lush pasture ground and hay fields, enclosed by high-tensile and ribbon fencing, along with a small pond and a trail installed for many horseback rides. Ample deer and turkey are spread throughout the property, offering lots of great hunting opportunities. Or take advantage of day ride opportunities off the farm locally at Wayne National Forest, North Bend State Park or the Rails to Trails with convenient trailer parking right in Ellenboro. With its captivating ridge-top views, this property offers a rare opportunity to embrace the beauty and tranquility of rural living in style.
MlsNumber: --
ListingId: 11342179


Listing Provided By: Whitetail Properties Real Estate LLC, original listing
Phone: (304) 679-6148
Office Phone: (920) 369-6869
Agent Name: Cory Farley
Disclaimer: Copyright © 2024 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 = 3009 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