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

138 Pine Tree Point
Snow Hill, NC 28580
Felecia Langley with Legacy Premier Real Estate, LLC, original listing - (252) 751-9995

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $719,900
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 2880 Square Feet
Agency: Legacy Premier Real Estate, LLC
Agency Phone: (252) 751-9995

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Welcome to this exquisite new home built by the prestigious Dennis Fitzgerald, situated on the 4th hole of the world-renowned Cutter Creek Golf Course. Loaded with luxurious features and designed with modern living in mind, this home offers both elegance and functionality. Step into the foyer and be greeted by gorgeous beaded cove moldings and 8' solid core doors. The spacious greatroom has a lot of natural light and a gas fireplace for those cozy winter nights. The greatroom seamlessly connects to a spacious, light-filled kitchen featuring abundant cabinetry for storage and generous counter space for meal prep. The kitchen boasts an 10-foot island, custom cabinetry, quartz countertops, a farmhouse sink, a walk-in pantry, top-of-the-line 36'' Z-line gas range with a custom hood, a convenient microwave drawer, and a large walk-in pantry. A large dining room with a vaulted tongue and groove ceiling, and windows all all sides makes this dining area the perfect spot for breathtaking views of the gold course. The first-floor guest bedroom is perfect as a mother-in-law suite with it's own private full bathroom. Also, on the first floor is a mudroom and half bathroom. The master suite it conveniently located on the second floor to private ultimate privacy. The master bath has his/her vanities, a large tiled shower with dual shower heads, and an expansive walk-in closet with custom built-ins. Bedroom 3 has it's own full bathroom. The 4th bedroom has a private access door to the 4th full bathroom. The 5th bedroom is exceptionally large and could be used as a recreation room. This room has picturesque views of the golf course. Each additiional full bathroom located upstairs features a custom vanity and beautifully tiled tub surrounds, adding a unique touch to every space. This home has a 3rd story and is unfinished. Relax and unwind on the covered back porch, where you can enjoy the serene breezes and stunning golf course views. A 2-car garage and a golf cart garage complete this home. This exceptional home offers luxury living in a peaceful location.<br /> Only 8 minutes to Food Lion in Snow Hill/30 minutes to Sam's Club in Greenville/18 minutes from restaurants in downtown Kinston.
MlsNumber: --
ListingId: 100476068


Listing Provided By: Legacy Premier Real Estate, LLC, original listing
Phone: (252) 347-4056
Office Phone: (252) 751-9995
Agent Name: Felecia Langley
Disclaimer: Copyright © 2024 Hive MLS / Coastal Plains 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