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

5904 Leone Pride Cir , Raleigh, NC 27603
$1,500,000
Est. Payment: $7,729.81/mo
4 Bed
5 Bath
3888 Sqft
Status: active | Days on site: 118
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

A 2026 Parade of Homes entry, located in the boutique luxury community of Carriage Farm offering a 1ST FLOOR PRIMARY SUITE AND GUEST SUITE! This stunning modern build with oversized black exterior windows that fill this open-concept home with tons of natural light. High end finishes and wide-plank hardwoods span throughout the main living! The gourmet kitchen features custom ''gray mist'' painted ceiling-height cabinets, ''calacatta laza'' quartz countertops, a huge social island and upgraded appliance suite, a single bowl sink with pass-through windows above, a hidden scullery with prep sink with opening window and walk-in pantry. A dedicated tasting room sits adjacent to the dining area, with herringbone laid hardwood floors and a beverage center, perfect for hosting intimate gathering. The private primary suite offers a tray ceiling, hardwoods and luxurious en-suite bath with a freestanding tub, tile to ceiling surround spa-style shower with zero entry and lighted niche between dual rain showers. All opening to a massive walk-in closet with laundry wall including pull-out shelving, ironing board and and two pull-out hampers. The family room features exposed ceiling beams, a tile surround gas log fireplace flanked with built-ins and oversized sliding glass doors leading to an expansive outdoor living area with phantom screens, an outdoor kitchen with gas grill and beverage fridge and outdoor fireplace for year-round entertaining! The upper level offers a large recreational room perfect for a home theater, a dedicated pocket office for a work space, and two secondary bedrooms with a central loft area and second laundry room for modern convenience. A huge bonus storage area over the garage offers tons of storage area or future expansion! Complete with a deep 3-car, side entry garage providing ample parking space and workshop area. Discover sophistication and everday functionality!

Highlights

Listed by Jim Allen , 919-645-2114 and Stefanie Bell , 919-274-5482 Coldwell Banker HPW , 919-876-8824. Triangle MLS, Inc. of North Carolina mls logo

Property Type

Residential

Lot/Acreage
0.9

HOA Fee

750 Semi-Annually

Year Built

2026

County

Wake

Neighborhood

Carriage Farm

Listing ID

10157776

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • Bedrooms:4
  • Bathrooms:5
  • Full Bathrooms:4
  • 1/2 Bathrooms:1
Appliances:Bar Fridge, Dishwasher, Double Oven, ENERGY STAR Qualified Appliances, Gas Cooktop, Microwave, Plumbed For Ice Maker, Self Cleaning Oven, Tankless Water Heater, Oven
Air Cond:Ceiling Fan(s),Central Air
Fireplaces:Family Room,Gas Log,Outside
Floor:Carpet,Hardwood,Tile
Above Ground Sq Ft:3888
Below Ground Sq Ft:0
Basement:Crawl Space
Other:Bar,Bathtub/Shower Combination,Beamed Ceilings,Breakfast Bar,Built-in Features,Pantry,Ceiling Fan(s),Crown Molding,Double Vanity,Eat-in Kitchen,Entrance Foyer,High Ceilings,In-Law Floorplan,Kitchen Island,Open Floorplan,Master Downstairs,Quartz Counters,Recessed Lighting,Second Primary Bedroom,Separate Shower,Smart Thermostat,Smooth Ceilings,Soaking Tub,Storage,Walk-In Closet(s),Walk-In Shower,Water Closet,Wet Bar,Wired for Data,Office
Other:Public

Exterior Features

Lot:Back Yard,Front Yard,Landscaped
Lot Dimensions:see plot plan
Roof:Shingle,Metal
Others:Gas Grill,In Parade of Homes,Outdoor Grill,Outdoor Kitchen,Rain Gutters,Covered,Front Porch,Patio,Rear Porch,Screened
Sewer:Septic Tank
Parking Features:Attached,Driveway,Garage,Garage Door Opener,Garage Faces Side,Inside Entrance

Open House

Upcoming Open Houses
Sunday 2:00 pm - 5:00 pm Aug 2
Saturday 2:00 pm - 5:00 pm Aug 8
Sunday 2:00 pm - 5:00 pm Aug 9
Saturday 2:00 pm - 5:00 pm Aug 15
Sunday 2:00 pm - 5:00 pm Aug 16
Saturday 2:00 pm - 5:00 pm Aug 22
Sunday 2:00 pm - 5:00 pm Aug 23
Saturday 2:00 pm - 5:00 pm Aug 29
Sunday 2:00 pm - 5:00 pm Aug 30
Principal Interest
$7,730
Taxes
$956
HOA
$750

Home Price

$1,500,000

Loan Details

30 yrs
6.683%

Down Payment

20%
$300,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:
$7,729.81

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $7,729.81 $956.25 $750.00 $9,436.06
Yearly $92,757.71 $11,475.00 $9,000.00 $113,232.71
Total $2,782,731.17 $344,250.00 $270,000.00 $3,396,981.17

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-02T05:25:12.000Z

© 2026 Triangle MLS, Inc. of North Carolina

MLS Logo - Triangle MLS, Inc. of North Carolina