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

213 Columbine Crossing
Pollocksville, NC 28573
ROWLAND & THE HOME SALES TEAM with Keller Williams Realty, original listing - (252) 637-2010

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3500 Square Feet
Agency: Keller Williams Realty
Agency Phone: (252) 637-2010

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Tucked away in a peaceful cul-de-sac and surrounded by the beauty of hundreds of acres of woodlands, this beautiful home offers the best of both worlds—a location just minutes from historic downtown New Bern yet free from city taxes. This one-owner, custom-built brick home spans 3,500 square feet of refined living space on a sprawling 1.36-acre lot. Enter onto the charming rocking chair front porch and into a grand foyer that welcomes you with Brazilian cherry hardwood floors and an open view to the second floor. Entertain in style in the formal dining room, featuring vaulted ceilings and elegant chair rail molding, or gather in the stunning living room with an 18-foot vaulted ceiling, a cozy gas fireplace, and seamless flow into the kitchen. The kitchen is a chef's dream, boasting quartz countertops, a center island, stainless steel appliances, a gas cooktop, double ovens, tile flooring, a pantry, and a sunny breakfast nook. Retreat to the luxurious first-floor primary suite, adorned with a tray ceiling, crown molding, a spa-like en suite with dual vanities, a walk-in shower, and a spacious walk-in closet. A first-floor guest bedroom or office offers convenience, while upstairs, four additional rooms provide versatility for guests, an office, or hobbies. Outside, the screened back porch and expansive patio invite you to relax or entertain while taking in the peaceful, nature-backed surroundings. Perfectly positioned for easy commutes to MCAS Cherry Point and North Carolina's Crystal Coast beaches, this home offers a harmonious blend of elegance, comfort, and prime location. Contact us today for your private tour!
MlsNumber: --
ListingId: 100478676


Listing Provided By: Keller Williams Realty, original listing
Phone: (252) 631-6787
Office Phone: (252) 637-2010
Agent Name: ROWLAND & THE HOME SALES TEAM
Disclaimer: Copyright © 2024 Hive MLS / Neuse River Region Association 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