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

Terri Bias

Operator/Brokerage Owner | Terri Bias and Associates | PLACE

Agent profile image in message

1504 Consett Ct , Raleigh, NC 27613
$1,750,000
Est. Payment: $9,835.06/mo
4 Bed
6 Bath
6605 Sqft
1.04 Acres
Status: active | Days on site: 14
Get Pre-Qualified
77184 - 87721
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from Terri Bias, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.
Agent profile image
Terri Bias
Operator/Brokerage Owner

House 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.

Highlights

Listed by Jenny Hensley , Luxe Residential, LLC , Triangle MLS, Inc. of North Carolina mls logo

Property Type

Residential

Lot/Acreage
1.04

HOA Fee

141.66 Quarterly

Year Built

2005

County

Wake

Neighborhood

Stonemoor

Listing ID

10195602

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:6
  • ▪ Full Bathrooms:5
  • ▪ 1/2 Bathrooms:1
Appliances:Bar Fridge, Built-In Electric Oven, Built-In Refrigerator, Dishwasher, Disposal, Exhaust Fan, Free-Standing Gas Oven, Free-Standing Gas Range, Instant Hot Water, Range Hood, Self Cleaning Oven, Stainless Steel Appliance(s), Tankless Water Heater, Vented Exhaust Fan, Wall Oven, Warming Drawer, Water Softener, Water Softener Owned, Irrigation Equipment
Air Cond:Central Air
Fireplaces:Basement,Family Room,Fire Pit,Gas,Living Room,Outside,Wood Burning
Floor:Carpet,Ceramic Tile,Softwood,Tile,Wood
Above Ground Sq Ft:4428
Below Ground Sq Ft:2177
Basement:Bath/Stubbed,Exterior Entry,Finished,Full,Heated,Interior Entry,Storage Space
Other:
  • ▪ Additional:Bar, Bathtub/Shower Combination, Beamed Ceilings, Bookcases, Breakfast Bar, Built-in Features, Butler's Pantry, Cedar Closet(s), Ceiling Fan(s), Central Vacuum, Chandelier, Crown Molding, Double Vanity, Eat-in Kitchen, High Ceilings, High Speed Internet, Kitchen Island, Natural Woodwork, Pantry, Quartz Counters, Radon Mitigation, Recessed Lighting, Room Over Garage, Smooth Ceilings, Sound System, Storage, Tray Ceiling(s), Vaulted Ceiling(s), Walk-In Closet(s), Walk-In Shower, Whirlpool Tub
Water:Community Water

Exterior Features

Lot:Back Yard,Cul-De-Sac,Front Yard,Garden,Gentle Sloping,Hardwood Trees,Landscaped,Many Trees,Native Plants,Partially Cleared,Pie Shaped Lot,Sloped,Sprinklers In Front,Sprinklers In Rear,Wooded
Lot Dimensions:38.56 x 211.74 x 135.70 x 179.62 x 373.76
Zoning:R-40W
Roof:Architectural Shingle
Others:
  • ▪ Additional:Fenced Yard, Fire Pit, Garden, Lighting, Private Yard, Rain Gutters, Storage, Covered, Deck, Front Porch, Patio, Screened
Sewer:Septic Tank
Parking Features:Attached,Concrete,Driveway,Garage,Garage Door Opener,Garage Faces Side,Inside Entrance,Three Car Garage,Attached Garage
Principal Interest
$9,835
Taxes
$1,116
HOA
$142

Home Price

$1,750,000

Loan Details

30 yrs
7.548%

Down Payment

20%
$350,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:
$9,835.06

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $9,835.06 $1,115.63 $141.66 $11,092.34
Yearly $118,020.71 $13,387.50 $1,699.92 $133,108.13
Total $3,540,621.44 $401,625.00 $50,997.60 $3,993,244.04

Today's Rates

30 Year

7.55%

20 Year

7.5%

15 Year

6.75%

Never Miss a Property

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

Current Listings

Last 30 Days
N/A
Oct 2026

Average Price

All Price Ranges
N/A
Oct 2026

Average Days on Market

All Price Ranges
N/A
Oct 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-10-14T15:51:28.000Z

© 2026 Triangle MLS, Inc. of North Carolina

MLS Logo - Triangle MLS, Inc. of North Carolina