404 Frida Road, New Bern, NC 28560

$355,000
Property Type: Residential Bedrooms: 4 Baths: 3 Square Footage: 2,800 Lot Size (sq. ft.): 6,098 Status: Active
Current Price: $355,000 List Date: 5/01/2026 Last Modified: 6/12/2026

Overview

Description

The Wilmington floor plan offers 2,800 square feet of well-designed living space across two levels, combining comfort and style in an open-concept layout. The spacious kitchen is a standout feature, complete with white cabinetry, granite countertops, a subway tile backsplash, a large island with bar seating, and a roomy corner walk-in pantry--perfect for both everyday living and entertaining. The main-level owner's suite provides a private retreat, featuring a well-appointed bathroom with a 5-foot shower and an oversized walk-in closet conveniently connected to the bath. The inviting living room centers around a cozy corner fireplace, while the back patio extends your living space outdoors for relaxing or hosting guests. Additional features include a first-floor office, formal dining room, convenient main-level laundry, and a versatile loft upstairs. Throughout the home, you'll find quality craftsmanship, thoughtful design, and the added peace of mind of a builder's warranty. This com ...

Open Houses

  • Today, 12:00 pm - 2:00 pm

Listing Details MLS# 100570803

Contract Info

Sub-Type
Single Family Residence
Construction Type
Stick Built
Delayed Marketing?
No
Marketing Start Date
2026-05-01
Listing Price
355000
List Price/SqFt
126.79
Stipulation of Sale
Standard

Location Information

Street #
404
Street Name
Frida
Street Suffix
Road
County
Craven
State/Province
NC
Zip Code
28560
City Limits
Yes
Marketing City
New Bern
Subdivision
Tyler, Home on the Lake
Secondary Subdivision
N/A

Remarks and Showing

Directions to Property
From US 70 exit 411 head northwest toward NC 43 turn right onto NC 43 turn right onto Thomas Sugg Dr, turn left onto Louisa Mae Way.
Sign on Property
Yes

Property Exterior Info

New Construction
No
Lot Acres
0.14
Lot SqFt
6098
Lot Dimensions
irregular
Waterfront
No
Waterview
No
Horses Y/N
No
Location Type
Mainland

Property Interior Info

SqFt - Heated (Primary)
2800
Total SqFt - Heated (Primary + Separate)
2800
# Rooms
8
# Baths - Full
2
# Baths - Half
Yes
# Baths - Total
3
# Bedrooms
4
Master Bedroom Level
Non Primary Living Area
ud_i_10
2
Fireplace Y/N
Yes

Legal Taxes

Year Built
2020

More Information

Entry Level Information

Entry Level
Yes

Current Service Providers

Water Provider
City of New Bern

HOA

Association Fee 1/Year
450
Association Name
AAM
Association Phone
8003540257
HOA 1 Mgmt. Company
Montage Realty Group
HOA 1 Mgmt. Phone
470-545-4781

Rooms

Bedroom 2 Level
Second
Bedroom 3 Level
Second
Bedroom 4 Level
Second
Dining Room Level
Main
Family Room Level
Main
Kitchen Level
Main
Laundry Level
Main
Master Bedroom Level
Second
Bedroom 2
Yes
Bedroom 3
Yes
Bedroom 4
Yes
Dining Room
Yes
Family Room
Yes
Kitchen
Yes
Laundry
Yes
Master Bedroom
Yes

Building/Ext Features

ud_i_08
1

Legal & Taxes

Tax Assessed Value
338650
Total Real Estate Property Taxes
2827.06
Deed Book
3813
Deed Page
2124
Legal
LOT 829 TYLER HOME ON THE LAKE PH XII
Broker Owner
Yes
PID
8-223-3-829
Tax Identifier
8-223-3 -829
Plat Book
I
Plat Page
136 A & B
Lot #
829
Special Assessments
none Known
Tax Year
2025
Zoning
residential
HOA
Yes
Cobra Zone
No
Federal Flood Ins Avlbl
No
Elementary School
Oaks Road
Middle School
West Craven
High School
West Craven

Garage & Parking

Attached Garage Spaces
2
Detached Garage Spaces
0
Total # Garage Spaces
2
Total Carport Spaces
0

Parking Features

Off Street
Yes
Paved
Yes

HOA and Neigh Amenities

Community Pool
Yes
Trail(s)
Yes
Water
Yes

Attic

Access Only
Yes
Stairs - Pull Down
Yes

Basement

None
Yes

Frontage Type

See Remarks
Yes

Handicap Accessible

None
Yes

View Type

None
Yes

Construction

Concrete
Yes
Wood Frame
Yes

Unit Type

4 Bedroom Or More
Yes

Exterior Features

None
Yes

Exterior Finish

Vinyl Siding
Yes

Terms

Cash
Yes
Conventional
Yes
FHA
Yes
USDA Loan
Yes
VA Loan
Yes

Fencing

None
Yes

Foundation

Slab
Yes

Flooring

Carpet
Yes
Vinyl
Yes

Patio and Porch Features

Patio
Yes

Security Features

Security System
Yes
Smoke Detector(s)
Yes

Pool Features

None
Yes

Roof

Architectural Shingle
Yes

Levels

Two
Yes

Road Type/Frontage

Paved
Yes

Trash Collection

City Pick-UP
Yes

Cooling

Central Air
Yes
Zoned
Yes

Heated SqFt

2800 - 2999
Yes

Heating

Zoned
Yes

Heating System Fuel Source

Natural Gas
Yes

Water Heater

Electric
Yes

Utilities

Sewer Available
Yes
Water Available
Yes

Sewer

Municipal Sewer
Yes

Water Source

Municipal Water
Yes

Appliances/Equip

Built-In Microwave
Yes
Dishwasher
Yes
Electric Oven
Yes

Fireplace Features

None
Yes

Interior Features

Ceiling Fan(s)
Yes
Gas Log
Yes
High Ceilings
Yes
Pantry
Yes
Walk-in Shower
Yes
Walk-In Closet(s)
Yes
Whirlpool
Yes

Window Features

Thermal Windows
Yes

Laundry Features

Laundry Room
Yes

Dining Room Type

Formal
Yes

Home Warr/Termite

Home Warranty/Seller
Yes
Home Warranty Company
Builder's Warranty
Home Warranty Amount
0

Property Features

Frontage Type: See Remarks Handicap Accessible: None View Type: None Attic: Access Only; Stairs - Pull Down Basement: None Construction: Concrete; Wood Frame Unit Type: 4 Bedroom Or More Exterior Features: None Exterior Finish: Vinyl Siding Fencing: None Foundation: Slab Parking Features: Off Street; Paved Patio and Porch Features: Patio Pool Features: None Roof: Architectural Shingle Levels: Two Trash Collection: City Pick-UP Cooling: Central Air; Zoned Heating: Zoned Heating System Fuel Source: Natural Gas Water Heater: Electric Utilities: Sewer Available; Water Available Sewer: Municipal Sewer Water Source: Municipal Water Fireplace Features: None Flooring: Carpet; Vinyl Interior Features: Ceiling Fan(s); Gas Log; High Ceilings; Pantry; Walk-in Shower; Walk-In Closet(s); Whirlpool Window Features: Thermal Windows Security Features: Security System; Smoke Detector(s) Laundry Features: Laundry Room Heated SqFt: 2800 - 2999 Dining Room Type: Formal HOA and Neigh Amenities: Community Pool; Trail(s); Water Rooms: Bedroom 2; Bedroom 3; Bedroom 4; Dining Room; Family Room; Kitchen; Laundry; Master Bedroom Terms: Cash; Conventional; FHA; USDA Loan; VA Loan

Room Information

Room Name Length Width Level Remarks
Family Room 18.00 17.00 Main
Dining Room 12.00 10.00 Main
Kitchen Main Breakfast area, Island, Pantry
Laundry Main
Master Bedroom 18.00 17.00 Second
Bedroom 2 12.00 14.00 Second
Bedroom 3 13.00 12.00 Second
Bedroom 4 13.00 12.00 Second
IDX
Listing Office: CENTURY 21 ZAYTOUN RAINES
Last Updated: June - 12 - 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.