This home has it ALL—including upgrades galore and a WHOLE HOUSE GENERATOR! Located in the highly sought-after Tyler, Home on the Lake community, this beautifully maintained 4-bedroom, 2-bathroom home is packed with added value and thoughtful extras that make it truly move-in ready.Step inside to a spacious open-concept layout designed for both comfort and style. The modern kitchen is a chef's dream, featuring a gas range, upgraded stainless steel appliances, stone countertops, a large central island, and ample cabinetry—ideal for entertaining or everyday living. The bright and airy living and dining areas flow seamlessly, creating a warm, inviting space for family and guests alike. The luxurious primary suite offers a peaceful retreat with a double vanity, tiled walk-in shower, and a generously sized walk-in closet. Three additional bedrooms provide flexibility for guests, a home office, or a playroom. Enjoy the outdoors from your screened-in porch, extended patio, and fully fenced backyard—perfect for relaxing, gardening, or hosting weekend get-togethers. Additional upgrades and features include: Custom blinds throughout, Whole-home generator for peace of mind, Painted garage with added storage potential, Premium finishes throughout every room. The Tyler community offers resort-style amenities including a sparkling pool, walking trails, and a tranquil lake, all just minutes from the best of coastal North Carolina living. Bonus: This property qualifies for a $10,000 grant toward closing costs and loan fees for FHA and Conventional Loans through First Citizens for qualified buyers. This is a must-see home—don't miss your chance to own this upgraded gem. Schedule your private tour today!
Sold for $315,000 on 08/05/25
$315,000
400 Frida Road, New Bern, NC 28560
4beds
1,764sqft
Single Family Residence
Built in 2022
6,969.6 Square Feet Lot
$314,600 Zestimate®
$179/sqft
$2,171 Estimated rent
Home value
$314,600
$283,000 - $349,000
$2,171/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: August 06, 2025 at 04:26am
Listed by:
DONNETTE HANCOCK 252-649-9788,
NorthGroup,
MELISSA RANKIN 252-671-7196,
NorthGroup
Bought with:
Gentry Property Group, 329795
Keller Williams Realty
Jamie Schmidt Beitel, 329795
Keller Williams Realty
Source: Hive MLS,MLS#: 100504601
Originating MLS: Neuse River Region Association of Realtors
Originating MLS: Neuse River Region Association of RealtorsFacts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Level: First
- Dimensions: 12 x 15
Bedroom 2
- Level: First
- Dimensions: 10.4 x 11
Bedroom 3
- Level: First
- Dimensions: 10.4 x 11
Bedroom 4
- Level: First
- Dimensions: 11.1 x 11.8
Dining room
- Level: First
- Dimensions: 10.11 x 10.5
Family room
- Level: First
- Dimensions: 15.1 x 16.4
Kitchen
- Level: First
- Dimensions: 13.1 x 11.3
Heating
- Forced Air, Heat Pump, Zoned, Electric
Cooling
- Central Air
Appliances
- Included: Gas Cooktop, Built-In Microwave, Dishwasher
- Laundry: Dryer Hookup, Washer Hookup, Laundry Room
Features
- Master Downstairs, Vaulted Ceiling(s), Tray Ceiling(s), High Ceilings, Solid Surface, Kitchen Island, Ceiling Fan(s), Walk-in Shower, Blinds/Shades
- Flooring: Carpet, LVT/LVP
- Basement: None
- Attic: Pull Down Stairs
Interior area
- Total structure area: 1,764
- Total interior livable area: 1,764 sqft
Property
Parking
- Total spaces: 2
- Parking features: Concrete, On Site
Features
- Levels: One
- Stories: 1
- Patio & porch: Open, Patio, Porch, Screened
- Fencing: Back Yard,Full,Wood
Lot
- Size: 6,969 sqft
- Dimensions: 70 x 123 x 70 x 117
- Features: Open Lot, Corner Lot
Details
- Parcel number: 82233 827
- Zoning: Residential
- Special conditions: Standard
- Other equipment: Generator
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Brick, Vinyl Siding
- Foundation: Slab
- Roof: Architectural Shingle
Condition
- New construction: No
- Year built: 2022
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Sewer Available, Water Available
Community & neighborhood
Security
- Security features: Smoke Detector(s)
Location
- Region: New Bern
- Subdivision: Tyler, Home on the Lake
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $500 monthly
- Amenities included: Clubhouse, Maintenance Common Areas, Playground, Sidewalks, Street Lights
- Association name: AAM
- Association phone: 866-516-7424
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 8/5/2025 | Sold | $315,000$179/sqft |
Source:  Hive MLS #100504601 | ||
| 7/2/2025 | Contingent | $315,000$179/sqft |
Source: Hive MLS #100504601 | ||
| 5/28/2025 | Price change | $315,000-2.2%$179/sqft |
Source: Hive MLS #100504601 | ||
| 5/15/2025 | Price change | $322,000-2.1%$183/sqft |
Source: Hive MLS #100504601 | ||
| 5/1/2025 | Listed for sale | $329,000+10.2%$187/sqft |
Source: Hive MLS #100504601 | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $2,158 +412.9% | $249,830 +389.9% |
| 2023 | $421 | $51,000 +82.1% |
| 2022 | -- | $28,000 |
Find assessor info on the county website
Neighborhood: 28560
Nearby schools
GreatSchools rating
- 2/10Oaks Road AcademyGrades: PK-5Distance: 3 mi
- 4/10West Craven MiddleGrades: 6-8Distance: 3.7 mi
- 2/10West Craven HighGrades: 9-12Distance: 6 mi
Schools provided by the listing agent
- Elementary: Oaks Road
- Middle: West Craven
- High: West Craven
Source: Hive MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$314,600
2% more+ $6,292
With Zillow Showcase(estimated)
$320,892