Title Page Background
DEBUG FN args: Array ( [0] => 1891 [1] => [2] => [3] => agent ) BEFORE: Site: 1891 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1891 Igate: njhud LocID: 1891 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1891 AND i.igate IN ('cihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1891 [1] => [2] => [3] => lender ) BEFORE: Site: 1891 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1891 Igate: njhud LocID: 1891 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1891 AND i.igate IN ('cihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1891 [1] => [2] => [3] => other ) BEFORE: Site: 1891 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1891 Igate: njhud LocID: 1891 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1891 AND i.igate IN ('cihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2176 Free Union Church Road
Pinetown, NC 27865
Spencer Lyndon with Our Town Properties Inc., original listing - (252) 243-7700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 3935 Square Feet
Agency: Our Town Properties Inc.
Agency Phone: (252) 243-7700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Escape to the perfect blend of luxury and country living in this stunning 5BR/5.5BA home situated on 4.25 acres just outside the city limits. Built in 2023, this exquisite property offers modern comfort with a serene rural backdrop.<br /> <br /> Step inside to discover spacious interiors featuring LVP flooring throughout, providing both style and durability. Each of the five bedrooms comes complete with its own private bath, ensuring ultimate convenience and privacy for family and guests. The 5th bedroom could also The master suite is a true retreat, showcasing a luxurious walk-in shower, a relaxing soaker tub, and a double vanity.<br /> <br /> The heart of the home is the open-concept kitchen and living area, designed for effortless entertaining. A dedicated home office provides a quiet, private space perfect for remote work or study, while the fifth bedroom offers flexibility as a potential bonus room or media room. Stainless steel appliances, sleek cabinetry, and a large island make meal prep a breeze. The living space extends outdoors through a luxury sliding glass door that opens to a covered back patio — perfect for morning coffee or evening gatherings while overlooking the expansive backyard.<br /> <br /> The picturesque front yard features a tranquil pond with a pier, ideal for relaxing, fishing, or letting the kids splash and play. Bring your dogs, horses, ATVs, and more — there's plenty of room to roam and explore.<br /> <br /> Enjoy the convenience of county water and the peace of country living, all within easy reach of city amenities. This property is a rare gem, offering the best of both worlds. Don't miss the chance to make it yours!
MlsNumber: --
ListingId: 100507710


Listing Provided By: Our Town Properties Inc., original listing
Phone: (252) 243-7700
Office Phone: (252) 243-7700
Agent Name: Spencer Lyndon
Disclaimer: Copyright © 2025 Hive MLS / Wilson 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