Agent profile image in chat bubble
Agent profile image in chat header

Dream Team United

| Dream Team United | Keller Williams Connected | PLACE

Agent profile image in message

5704 Wild Orchid Trl , Raleigh, NC 27613
$875,000
Est. Payment: $4,509.06/mo
4 Bed
4 Bath
3267 Sqft
Status: active | Days on site: 43
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275

By providing your number, you are expressly consenting, in writing, to receive telemarketing and other messages, including calls or texts at the number you provided above. This consent is not required to purchase any good or service. Message and data rates may apply. Text STOP to cancel.

This site is protected by reCAPTCHA and the GooglePrivacy Policy and Terms of Service apply.

House Description

Welcome home to this stately, traditional brick residence, nestled on a picturesque, wooded parcel that offers exceptional privacy and timeless appeal. Designed for today's lifestyle this home offers a 1st Floor Primary Bedroom, 3 additional Bedrooms, 3-1/2 Baths and a 2-Car Garage on a 1.349 Acre Lot. The Main Level floorplan incorporates flexibility with a distinguished 12 x 14 Home Office showcasing custom cabinetry and a bay window, as well as a separate Study that easily serves as a second Workspace, Library, or elegant Music Room. The sophisticated Dining Room has been thoughtfully renovated with beautifully-crafted Custom Cabinetry, providing stylish storage while featuring treasured collections—creating the perfect setting for memorable gatherings and holiday celebrations. The inviting Family Room features a soaring ceiling, a striking wall of windows that frames tranquil woodland views, and a fireplace that anchors the space with warmth and character. The 10 x 15 Kitchen featuring granite countertops, multiple ovens, and a gas range - is centrally located and open to the Family Room and Breakfast Room for daily convenience and gracious entertaining. Retreat to the First-Floor Primary Bedroom Suite, a sanctuary complete with an adjoining spa-inspired Primary Bath, and a Walk-in Closet. Also incorporated into the Main Level Living Area is a beautifully appointed Hallway connecting the Entrance Hall, Custom Built-In Cabinets, a Half Bath for Guests, the Kitchen, and access leading into the attached 2-Car Garage. On the Second Level of this home there is an additional Primary Bedroom #2 and adjoining Primary Bath 2 with a Walk-In Closet - sustaining the flexibility of multi-generational living or allocating this as private space for long-term Guests. Bedroom # 3 and Bedroom #4 have a spacious Full Bath easily accessible from the Hallway, and a 16 x 24 Bonus Room includes multi-purpose areas for working, playing and relaxing. Surrounded by mature trees and filled with timeless architectural details, this exceptional home blends classic elegance with modern functionality, in a peaceful natural setting. Welcome home to this stately, traditional brick residence, nestled on a picturesque, wooded parcel that offers exceptional privacy and timeless appeal. Designed for today's lifestyle this home offers a 1st Floor Primary Bedroom, 3 additional Bedrooms, 3-1/2 Baths and a 2-Car Garage on a 1.349 Acre Lot. The Main Level floorplan incorporates flexibility with a distinguished 12 x 14 Home Office showcasing custom cabinetry and a bay window, as well as a separate Study that easily serves as a second Workspace, Library, or elegant Music Room. The sophisticated Dining Room has been thoughtfully renovated with beautifully-crafted Custom Cabinetry, providing stylish storage while featuring treasured collections—creating the perfect setting for memorable gatherings and holiday celebrations. The inviting Family Room features a soaring ceiling, a striking wall of windows that frames tranquil woodland views, and a fireplace that anchors the space with warmth and character. The 10 x 15 Kitchen featuring granite countertops, multiple ovens, and a gas range - is centrally located and open to the Family Room and Breakfast Room for daily convenience and gracious entertaining. Retreat to the First-Floor Primary Bedroom Suite, a sanctuary complete with an adjoining spa-inspired Primary Bath, and a Walk-in Closet. Also incorporated into the Main Level Living Area is a beautifully appointed Hallway connecting the Entrance Hall, Custom Built-In Cabinets, a Half Bath for Guests, the Kitchen, and access leading into the attached 2-Car Garage. On the Second Level of this home there is an additional Primary Bedroom #2 and adjoining Primary Bath 2 with a Walk-In Closet - sustaining the flexibility of multi-generational living or allocating this as private space for long-term Guests. Bedroom # 3 and Bedroom #4 have a spacious Full Bath easily accessible from the Hallway, and a 16 x 24 Bonus Room includes multi-purpose areas for working, playing and relaxing. Surrounded by mature trees and filled with timeless architectural details, this exceptional home blends classic elegance with modern functionality, in a peaceful natural setting.

Highlights

Listed by Janet Rose , 919-810-3679 North Wake Realty , 919-810-3679. Triangle MLS, Inc. of North Carolina mls logo

Property Type

Residential

Lot/Acreage
1.35

HOA Fee

250 Annually

Year Built

1994

County

Wake

Neighborhood

Barton Creek Overlook

Listing ID

10175269

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:4
  • Bathrooms:4
  • Full Bathrooms:3
  • 1/2 Bathrooms:1
Appliances:Built-In Electric Oven, Dishwasher, Free-Standing Gas Range, Gas Range
Air Cond:Ceiling Fan(s),Central Air,Electric,Gas
Fireplaces:Gas Log,Great Room
Floor:Carpet,Hardwood,Tile,Wood
Above Ground Sq Ft:3267
Below Ground Sq Ft:0
Other:Bathtub/Shower Combination,Bookcases,Cathedral Ceiling(s),Ceiling Fan(s),Crown Molding,Double Vanity,Entrance Foyer,Granite Counters,High Ceilings,In-Law Floorplan,Open Floorplan,Master Downstairs,Recessed Lighting,Room Over Garage,Second Primary Bedroom,Smooth Ceilings,Stone Counters,Vaulted Ceiling(s),Walk-In Closet(s),Wet Bar,Office
Other:Public

Exterior Features

Lot:Back Yard,Front Yard,Hardwood Trees,Landscaped,Many Trees,Native Plants,Partially Cleared,Private,Sloped,Views,Wooded
Lot Dimensions:Survey to be Ordered by Buyer(s).
Zoning:R-40W
Roof:Metal,Other
Others:Patio,Terrace
Sewer:Public Sewer
Parking Features:Attached,Concrete,Driveway,Garage,Garage Door Opener,Garage Faces Side,Inside Entrance,Private
Principal Interest
$4,509
Taxes
$405
HOA
$250

Home Price

$875,000

Loan Details

30 yrs
6.683%

Down Payment

20%
$175,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$4,509.06

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $4,509.06 $404.72 $250.00 $5,163.77
Yearly $54,108.66 $4,856.59 $3,000.00 $61,965.25
Total $1,623,259.85 $145,697.70 $90,000.00 $1,858,957.55

Today's Rates

30 Year

6.68%

20 Year

6.55%

15 Year

6.13%

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Aug 2026

Average Price

All Price Ranges
N/A
Aug 2026

Average Days on Market

All Price Ranges
N/A
Aug 2026
Market insight data is pulled from the same city as the listing being viewed (Raleigh, NC).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Information Not Guaranteed.
Listings marked with an icon are provided courtesy of the Triangle MLS, Inc. of North Carolina, Internet Data Exchange Database.
©2026 Triangle MLS, Inc. of North Carolina. All rights reserved.

Data last updated: 2026-08-01T21:24:16.000Z

© 2026 Triangle MLS, Inc. of North Carolina

MLS Logo - Triangle MLS, Inc. of North Carolina