2238 Emerald Avenue Lot 242, Castle Hayne, NC 28429 (MLS# 100552647)


$339,000
2238 Emerald Avenue Lot 242
Castle Hayne, NC 28429
MLS# 100552647
Status: Pending with Showings
3 beds  |  2 baths  |  1618 sqft


front 3
  1 / 43  
front 3 front 5 front 6 front 4 front 2 front 1 kitchen 1 kitchen 2 kitchen 3 wide angle 1 kitchen 4 kitchen 5 living 2 wide angle 1 bed 1 pic 1 bed 1 pic 2 bed 2 pic 1 living 1 bed 1 pic 3 laundry 1 utility alcove hall bath master bath 1 master bath 2 master bath 3 master bath 4 master bath 5 master bed 1 master bed 2 master bed 3 view 1 back 2 back 1 back 3 garage 1 sidbury station clubhouse 2 sidbury station clubhouse 3 sidbury station clubhouse 4 sidbury station clubhouse sidbury station fitness 1 sidbury station fitness 2 sidbury station playground 1 sidbury station pool

Property Description
SELLER 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!

Details
Maps
Property Interior Info
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
Contract Info
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
Current Price: $339,000
Location Information
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
Remarks and Showing
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.
Property Exterior Info
New Construction: No
Property Attached YN: No
Lot Acres: 0.16
Lot Dimensions: rectangular
Lot SqFt: 6970
Waterfront: No
Waterview: Yes
Location Type: Mainland
Horses Y/N: No
Legal & Taxes
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
Plat Page: 357
Lot #: 242
Special Assessments: none
Tax Year: 2025
Zoning: R-15
HOA: Yes
Cobra Zone: No
Federal Flood Ins Avlbl: No
School District: New Hanover
Elementary School: Castle Hayne
Middle School: Holly Shelter
High School: Laney
Garage & Parking
Attached Garage Spaces: 2
Detached Garage Spaces: 0
Total # Garage Spaces: 2
Total Carport Spaces: 0
Parking Features
Garage: 1
Off Street: 1
Paved: 1
HOA and Neigh Amenities
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
HOA
Association Fee 1/Year: 1260
Association Name: FirstService Residential
Association Phone: 7045272314
HOA 1 Mgmt. Company: FirstService Residential
HOA 1 Mgmt. Phone: 1800870010
Attic
Access Only: 1
Basement
None: 1
Frontage Type
Pond Front: 1
Handicap Accessible
None: 1
View Type
Pond: 1
Construction
Wood Frame: 1
Unit Type
3 Bedroom: 1
Style
Other: 1
Lot Water Features
None: 1
Exterior Features
None: 1
Current Service Providers
Electric Provider: Duke Progress Energy
Sewer Provider: Cape Fear Public Utility Authority
Water Provider: Cape Fear Public Utility Authority
Exterior Finish
Vinyl Siding: 1
Terms
Cash: 1
Conventional: 1
FHA: 1
VA Loan: 1
Fencing
None: 1
Foundation
Slab: 1
Flooring
Carpet: 1
Vinyl: 1
Green Bldg Certify
HERS Index Score: 1
Green Bldg Features
Prog Thermostats: 1
Patio and Porch Features
Patio: 1
Porch: 1
Pool Features
None: 1
Roof
Shingle: 1
Levels
One: 1
Entry Level Information
Entry Level: 1
Lot Features
Level: 1
Road Type/Frontage
Paved: 1
Private Road: 1
Trash Collection
Other: 1
Cooling
Central Air: 1
Heated SqFt
1600 - 1799: 1
Heating
Heat Pump: 1
Heating System Fuel Source
Electric: 1
Water Heater
Electric: 1
Utilities
Sewer Connected: 1
Water Connected: 1
Sewer
Municipal Sewer: 1
Water Source
Municipal Water: 1
Appliances/Equip
Built-In Microwave: 1
Dishwasher: 1
Electric Range: 1
Furnished
Unfurnished: 1
Interior Features
Entrance Foyer: 1
Master Downstairs: 1
Pantry: 1
Solid Surface: 1
Walk-in Shower: 1
Walk-In Closet(s): 1
Window Features
Thermal Windows: 1
Security Features
Smoke Detector(s): 1
Laundry Features
Laundry Room: 1
Dining Room Type
Combination: 1
Pets Allowed
Pets Allowed: Yes
Rooms
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
Legal Taxes
Year Built: 2023
Status Change Info
Under Contract Date: 2026-04-13
Property Features
Frontage Type: Pond Front
Handicap Accessible: None
View Type: Pond
Attic: Access Only
Basement: None
Construction: Wood Frame
Unit Type: 3 Bedroom
Style: Other
Exterior Features: None
Exterior Finish: Vinyl Siding
Fencing: None
Foundation: Slab
Green Bldg Certify: HERS Index Score
Green Bldg Features: Prog Thermostats
Parking Features: Garage; Garage; Off Street; Paved
Patio and Porch Features: Patio; Porch
Pool Features: None
Roof: Shingle
Levels: One
Trash Collection: Other
Lot Features: Level
Lot Water Features: None
Cooling: Central Air
Heating: Heat Pump
Heating System Fuel Source: Electric
Water Heater: Electric
Utilities: Sewer Connected; Water Connected
Sewer: Municipal Sewer
Water Source: Municipal Water
Flooring: Carpet; Vinyl
Furnished: Unfurnished
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
Heated SqFt: 1600 - 1799
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 Information
Room Name Length Width Level
Master Bedroom13.0014.80First
Bedroom 111.9010.70First
Bedroom 211.9010.70First
Living Room12.0016.00First
Dining Room12.0015.00First
Kitchen8.1012.10First

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.