Skip main navigation
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
    $316,100 Zestimate®
    $179/sqft
    $2,223 Estimated rent

    Owner options

    List your home for rent

    $2,223/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $2,223/mo

    Rent Zestimate®

    Refinance and save

    $2,301/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $2,301/mo

    Est. payment

    What's special

    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!

    Zillow last checked: 7 hours ago

    Listing updated: August 06, 2025 at 04:26am

    Listed by:

    DONNETTE HANCOCK 252-649-9788,

    NorthGroup,

    MELISSA RANKIN 252-671-7196

    Bought with:

    Gentry Property Group, 329795

    Keller Williams Realty

    Jamie Schmidt Beitel, 329795

    Source: Hive MLS,MLS#: 100504601MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 2
    • Full bathrooms: 2
    Primary bedroom
    • Level: First
    • Area: 180
    • Dimensions: 15.00 x 12.00
    Bedroom 2
    • Level: First
    • Area: 114.4
    • Dimensions: 11.00 x 10.40
    Bedroom 3
    • Level: First
    • Area: 114.4
    • Dimensions: 11.00 x 10.40
    Bedroom 4
    • Level: First
    • Area: 130.98
    • Dimensions: 11.80 x 11.10
    Dining room
    • Level: First
    • Area: 106.16
    • Dimensions: 10.50 x 10.11
    Family room
    • Level: First
    • Area: 247.64
    • Dimensions: 16.40 x 15.10
    Kitchen
    • Level: First
    • Area: 148.03
    • Dimensions: 11.30 x 13.10
    Heating
    • Electric, Forced Air, Heat Pump, Natural Gas, Zoned
    Cooling
    • Central Air
    Appliances
    • Included: Dishwasher
    Features
    • Master Downstairs, Vaulted Ceiling(s), Tray Ceiling(s), Solid Surface, Kitchen Island, Ceiling Fan(s), Walk-in Shower
    • Flooring: Luxury Vinyl, Carpet
    • Basement: None
    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: Full,Back Yard,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
    • Other equipment: Generator

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Brick, Vinyl Siding, Wood Frame
    • Foundation: Slab
    • Roof: Architectural Shingle
    Condition
    • New construction: No
    • Year built: 2022

    Utilities & green energy

    • Sewer: Municipal Sewer
    • Water: Public

    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 annually
    • Amenities included: Clubhouse, Maint - Comm Areas, Playground, Sidewalk, Street Lights
    • Association name: AAM
    • Association phone: 866-516-7424

    Other

    Other facts
    • Listing terms: Cash,Conventional,FHA,USDA Loan,VA Loan
    • Road surface type: Paved
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $316,100
    2% more+$6,322
    With Zillow Showcase(estimated)$322,422