1504 Consett Ct, Raleigh, NC 27613

$1,825,000
4
BD
6
BA
6,605
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

Seller Representative Luxe Residential, LLC

List Price
$1,825,000
Status
ACTIVE
Days on Market
0
MLS#
10195602
Subtype
Residential
Style
Traditional
Year Built
2005
Bedrooms
4
Bathrooms
6
Full Baths
5
Half Baths
1
Living Area
6,605
Lot Size
45,302
Acres
1.04
Subdivision
Stonemoor

Property Description

Renovated luxury home on a 1.04-acre cul-de-sac lot in Stonemoor, Raleigh, with 4 bedrooms, 5.5 baths, a main-level primary suite, and a 3-car side-load garage. The fully renovated kitchen features new cabinetry with glass display fronts, quartz counters, a new tile backsplash, gold hardware and faucet, a 7-burner Viking gas range with Viking hood, Sub-Zero refrigerator, warming drawer, and two pantries. The renovated primary bath offers a dual vanity with glass storage tower, frameless shower with bench and double niche, and a two-person jetted soaking tub. Major systems are updated with HVAC in 2023 and 2026, roof and gas water heater in 2020, and septic pumped in 2025. Mahogany front doors open to a two-story foyer with wood beams and a new chandelier, and cypress hardwood floors run throughout the main level. Formal spaces include a study with stained coffered ceilings and glass French doors, a dining room with crystal chandelier, and a two-story living room with a wall of windows, stacked stone gas fireplace, and serving bar. The family room adds wood ceiling beams, built-ins, and a second stacked stone gas fireplace, and the breakfast nook with coffee bar opens to the screened porch. The primary suite includes tray ceilings, a bay window sitting area, and a custom walk-in closet. All 3 bedrooms on the second floor have their own bathrooms and large closets. The lower level offers two flex rooms, a full bath, a bonus room with stacked stone gas fireplace, a custom wet bar with dishwasher and ice maker, and a wine room. Two additional rooms work well as a home gym, office, or hobby room. Outdoors, enjoy a screened porch, grilling deck, and stone patio with a wood-burning fireplace, plus landscape lighting and a fenced yard. Epoxy floors in the garage and lower-level storage, and an oversized driveway with parking pad. 3 interior gas fireplaces, 1 exterior wood burning fireplace. Community pool, tennis courts, playground, pavilion, and walking trails.

Additional Information

Interior Features
Bar, Breakfast Area, Beamed Ceilings, Bookcases, Cedar Closets, Ceiling Fans, Chandelier, Crown Molding, Central Vacuum, Double Vanity, Eat-In Kitchen, High Ceilings, High Speed Internet, Kitchen Island, Natural Woodwork, Pantry, Recessed Lighting, Speakers, Storage, Tray Ceiling(s), Vaulted/Cathedral Ceilings, Walk-In Closet(s), Butler Pantry, Whirlpool Tub, Bathtub/Shower Combination, Walk-In Shower, Quartz/Quartzite Counters, Radon Mitigation System, Garage Apartment, Smooth Ceilings
Exterior Features
Fire Pit, Garden, Lighting, Private Yard, Rain Gutters, Storage, Fenced Yard
Taxes
$8,018
HOA Fee
$425
Property Description
Traditional
Zoning
R-40W
Flooring
Carpet, Tile, Softwood, Tile, Wood
Appliances
Bar Fridge, Electric Oven, Built in Refrigerator, Disposal, Dishwasher, Exhaust Fan, Gas Oven, Gas Range, Instant Hot Water, Range Hood, Self Cleaning Oven, Stainless Steel Appliance(s), Water Heater, Vented Exhaust Fan, Warming Drawer, Water Softener Owned, Water Softener Owned, Wall Oven
Heating
Fireplace, Heat Pump, Natural Gas
Air Conditioning
Central Air
Stories
2
Levels
Two
Roof
Architectural
Foundation
Brick/Mortar
Parking Features
Attached, Paved, Driveway, Garage Faces Side, Garage, Garage Door Opener, Inside Entrance
Garage Spaces
3
Elementary School
Wake - Baileywick Road Elementary
Middle School
Wake - West Millbrook Middle
High School
Wake - Millbrook High

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Listings provided courtesy of Triangle MLS, Inc. of NC, Internet Data Exchange Database. Information deemed reliable but not guaranteed. © 2026 Triangle MLS, Inc. of North Carolina. Data last updated .