2238 Emerald Avenue Lot 242, Castle Hayne, NC 28429 (MLS# 100552647)
2238 Emerald Avenue Lot 242
Castle Hayne, NC 28429
MLS# 100552647
Status:
Pending with Showings3 beds | 2 baths | 1618 sqft
Property DescriptionSELLER IS EXTREMELY MOTIVATED! Great deal in 28429 - three bedroom two bath - generous open living on one level with a pond view out back and a two car garage. This is the Aria floorplan home and only two years old. Sidbury Station is a still growing community offering an amazing recreation, exercise and pool complex for your enjoyment. Located right up the road from the Cape Fear Community College North Campus and just around the corner from Northchase shopping, this home is also right at the intersection of Interstate 40 and 140 for easy access to 17. Come take a look at your next home!
ud_i_10: 1
Total SqFt - Heated (Primary + Separate): 1618
# Rooms: 6
# Baths - Full: 2
# Baths - Half: 0
# Baths - Total: 2
Master Bedroom Level: Primary Living Area
Fireplace Y/N: No
SqFt - Heated (Primary): 1618
# Bedrooms: 3
Delayed Marketing?: No
Sub-Type: Single Family Residence
Construction Type: Stick Built
List Price/SqFt: 209.52
Stipulation of Sale: Standard
Status: Pending with Showings
Marketing Start Date: 2026-02-03
Listing Price: 339000
Unit #: Lot 242
City Limits: No
Marketing City: Castle Hayne
Street #: 2238
Street Name: Emerald
Street Suffix: Avenue
County: New Hanover
State/Province: NC
Zip Code: 28429
Subdivision: Sidbury Station
Geo Lat: 34.330901
Geo Lon: -77.847427
Sign on Property: Yes
Directions to Property: North on N Colle Rd. to Parmele Rd. Right on Parmele, right on Blue Clay, then left onto Sidbury Rd.
New Construction: No
Property Attached YN: No
Lot Acres: 0.16
Lot Dimensions: rectangular
Lot SqFt: 6970
Waterfront: No
Waterview: Yes
Location Type: Mainland
Tax Assessed Value: 322900
Total City Real Estate Property Tax: 0
Total Real Estate Property Taxes: 1222.18
Deed Book: 71
Deed Page: 357
Legal: LOT 242 PH 1A SIDBURY STATION
Broker Owner: No
PID: R01900-002-175-000
Tax Identifier: R01900-002-175-000
Plat Book: 71
Special Assessments: none
Tax Year: 2025
Cobra Zone: No
Federal Flood Ins Avlbl: No
School District: New Hanover
Elementary School: Castle Hayne
Middle School: Holly Shelter
High School: Laney
Attached Garage Spaces: 2
Detached Garage Spaces: 0
Total # Garage Spaces: 2
Total Carport Spaces: 0
Barbecue: 1
Basketball Court: 1
Clubhouse: 1
Community Pool: 1
Fitness Center: 1
Game Room: 1
Maint - Comm Areas: 1
Maint - Grounds: 1
Maint - Roads: 1
Management: 1
Master Insure: 1
Meeting Room: 1
Pickleball: 1
Playground: 1
Street Lights: 1
Tennis Court(s): 1
Trash: 1
Club Membership: None Selected
Association Fee 1/Year: 1260
Association Name: FirstService Residential
Association Phone: 7045272314
HOA 1 Mgmt. Company: FirstService Residential
HOA 1 Mgmt. Phone: 1800870010
Electric Provider: Duke Progress Energy
Sewer Provider: Cape Fear Public Utility Authority
Water Provider: Cape Fear Public Utility Authority
Sewer Connected: 1
Water Connected: 1
Built-In Microwave: 1
Dishwasher: 1
Entrance Foyer: 1
Master Downstairs: 1
Pantry: 1
Solid Surface: 1
Walk-in Shower: 1
Walk-In Closet(s): 1
Bedroom 1: 1
Bedroom 1 Level: First
Bedroom 2: 1
Bedroom 2 Level: First
Dining Room: 1
Dining Room Level: First
Kitchen: 1
Kitchen Level: First
Living Room: 1
Living Room Level: First
Master Bedroom: 1
Master Bedroom Level: First
Under Contract Date: 2026-04-13
Frontage Type: Pond Front
Handicap Accessible: None
Exterior Finish: Vinyl Siding
Green Bldg Certify: HERS Index Score
Green Bldg Features: Prog Thermostats
Parking Features: Garage; Garage; Off Street; Paved
Patio and Porch Features: Patio; Porch
Heating System Fuel Source: Electric
Utilities: Sewer Connected; Water Connected
Water Source: Municipal Water
Interior Features: Entrance Foyer; Master Downstairs; Pantry; Solid Surface; Walk-in Shower; Walk-In Closet(s)
Window Features: Thermal Windows
Security Features: Smoke Detector(s)
Laundry Features: Laundry Room
Dining Room Type: Combination
HOA and Neigh Amenities: Barbecue; Basketball Court; Clubhouse; Community Pool; Fitness Center; Game Room; Maint - Comm Areas; Maint - Grounds; Maint - Roads; Management; Master Insure; Meeting Room; Pickleball; Playground; Street Lights; Tennis Court(s); Trash
Rooms: Bedroom 1; Bedroom 2; Dining Room; Kitchen; Living Room; Master Bedroom
Terms: Cash; Conventional; FHA; VA Loan
| Room Name | Length | Width | Level |
| Master Bedroom | 13.00 | 14.80 | First |
| Bedroom 1 | 11.90 | 10.70 | First |
| Bedroom 2 | 11.90 | 10.70 | First |
| Living Room | 12.00 | 16.00 | First |
| Dining Room | 12.00 | 15.00 | First |
| Kitchen | 8.10 | 12.10 | First |
IDX
Listing Office: Sea River Realty
Last Updated: April - 13 - 2026
Copyright 2024 NCRMLS. All rights reserved. North Carolina Regional Multiple Listing Service, (NCRMLS), provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. NCRMLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of NCRMLS.