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;

173 Azalea Lane
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: $599,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2609 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: 2023
Notes: Nestled on a corner lot with water views, among the 634-acre master-planned community, this brand new home crafted by custom builder, Mike Jones, is one not to miss. This home is located in the prestigious Cutter Creek Golf Course community. This course was created by renowned Bob Moore of JMP Golf Design Group. The expansive front porch invites you to step through the double entry doors, where meticulous attention to detail is immediately evident. The entryway features a rich, recessed tongue and groove ceiling, leading to the main living space adorned with stunning wood beams and a vaulted ceiling. The exquisite trim design adds just the right touch of rustic warmth. This open floor plan is perfect for entertaining and offers a lot of natural light. The living room is centered around a fireplace with its combination of brick and shiplap surround, extending to the full height of the room. The kitchen boasts custom cabinetry, granite countertops, herringbone tile backsplash, a gas cooktop, & a deep farmhouse sink. The high-end appliances, center island, and dedicated pantry maximize both functionality and beauty. The master bedroom and 2 additional bedrooms are located on the first floor. The master bedroom offers a tongue and groove trey ceiling and beautiful views from the windows. The master bath is stunning with a double sink vanity, soaking tub, tiled walk-in shower, and a large walk-in closet. The fourth bedroom is located upstairs and features an attached full bathroom, creating a private suite on the second level of the home. Covered back porch gives you privacy and a place to unwind with views of one of the many lakes in this communtiy. Enjoy the clubhouse grill, pool/pool house, and golfing in this booming community. Additional amenities in the plans! Only 25 minutes to Greenville for shopping and restaurants.
MlsNumber: --
ListingId: 100459148


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 NCRMLS/ 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