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

166 Fry Pan Lane
Warrenton, NC 27589
James Hutson with Ninja Realty, original listing - (252) 915-2311

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $475,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 1783 Square Feet
Agency: Ninja Realty
Agency Phone: (252) 915-2311

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: HORSE PROPERTY on 11 ACRES with LOG CABIN RANCH - FULL EQUESTRIAN SETUP! ******** <br /> <br /> This is your chance to own a true EQUESTRIAN RETREAT in SOUTH WARREN COUNTY, just a short and easy commute to RALEIGH. Nestled on 11 ACRES of private, peaceful land, this property offers everything you need for horses, hobbies, and homestead living. Approximately 3 ACRES are CLEARED and FENCED with NO-CLIMB HORSE FENCING, and there's a well-designed 4-STALL HORSE STABLE with a TACK ROOM. Multiple OUTBUILDINGS and WORKSHOPS provide tons of space for equipment, tools, and storage. ******** <br /> <br /> At the heart of the property sits a CHARMING LOG CABIN RANCH HOME featuring 3 BEDROOMS, a PRIVATE HOME OFFICE, and an OPEN KITCHEN that FLOWS INTO THE LIVING ROOM. The layout includes TWO MASTER SUITES, each with its own PRIVATE BATHROOM, offering space and privacy for yourself and guests. ******** <br /> <br /> The home has received numerous updates in recent years, including a NEW ROOF (2020), NEW HVAC (2020), NEW WATER HEATER (2021), and SEPTIC PUMPED (2024). Additional improvements include NEW FLOORING in the kitchen, living room, PLUS tiled bathrooms and entry, FRESH INTERIOR & EXTERIOR PAINT, NEW VANITIES AND SINKS in the primary baths, and a NEW THERMOSTAT-CONTROLLED ROOF FAN for added efficiency. ******** <br /> <br /> Whether you're looking to start your dream farm, raise animals, or simply enjoy a private life in the country, this property delivers on all fronts. With its combination of SECLUSION, FUNCTIONALITY, and RUSTIC STYLE, this is a RARE FIND that's truly move-in ready. ******** <br /> <br /> SCHEDULE YOUR SHOWING TODAY and come experience the lifestyle this one-of-a-kind HORSE PROPERTY has to offer!
MlsNumber: --
ListingId: 10089373


Listing Provided By: Ninja Realty, original listing
Phone: (252) 915-2311
Office Phone: (252) 915-2311
Agent Name: James Hutson
Disclaimer: Copyright © 2025 Doorify MLS of North Carolina. 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 = 1977 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Jessica Council
Jessica Council
ASCIIWilkie Real Estate
Call Today!: (252) 578-9348

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App