If you need assistance, please call 919-740-0379

  • DESCRIPTION

    Entertainers DREAM HOUSE - Basement Estate Home on 1 Acre Cul-de-Sac Lot Backed to Hardwoods, Old World Charm w/ Modern Updates, Chef's Kit w/ Granite, Island, S-S Appl, Exposed Rustic Beams, Custom Moldings, Hardwoods, Soaring Ceilings, 3 FPs, Hearth and Family Rms, Office, Main Lvl MBR w/ Spa-Like Bath, Oversized Upper BRs w/ Priv BAs, Large Finished Bsmt w/ Bar and Wine Rm, Additional Flex/Guest Rooms, Screened Porch, Deck, Patio, OUTDOOR FIREPLACE, Fenced Yard, New Carpet, Fresh Paint, and MORE.

    KEY DETAILS
    • Price:
    • $1,275,000
    • Bedrooms:
    • 4
    • Full Baths:
    • 5
    • Half Baths:
    • 1
    • Square Footage:
    • 6,557
    • Acreage:
    • 1.04
    • Year Built:
    • 2005
    • MLS #:
    • 2231801
    • Street Address:
    • 1504 Consett Court
    • City:
    • Raleigh
    • State:
    • NC
    • Postal Code:
    • 27613
    • County:
    • Wake
    • Area:
    • North Raleigh
    • Subarea
    • North Raleigh/B
    • Subdivision:
    • Stonemoor
    • Listing Status:
    • For Sale - Active

    Building

    • Basement Description:
    • Daylight, Finished Bsmt, Full, Heated, Inside Entrance, Outside Entrance
    • Deck Dimensions:
    • 10x10
    • Exterior Features:
    • Community Rec Avail., Covered Porch, Deck, Fenced Yard, Gutters, Irrigation System, Patio, Screen Porch, Tennis Court/Priv. Com, Neighborhood Playground, Landscape Lighting
    • Fireplace:
    • Gas Logs, In Basement, In Family Room, In Living Room, Wood Burning, Natural Gas, Exterior Fireplace
    • Flooring:
    • Carpet, Hardwood, Tile Floor
    • Foundation:
    • Basement
    • Has Basement:
    • Yes
    • Interior Features:
    • 10ft+ Ceiling, 9 Ft Ceiling, Bookshelves, Cable Tv Available, Cathedral Ceiling, Ceiling Fan, Central Vac Finished, Coffered Ceiling, Distributed Audio, Granite Counter Tops, Pantry, Security System Finished, Smoke Alarm, Walk In Closet, Wet Bar, Smooth Ceilings, Vaulted Ceilings, Kitchen Island
    • Number Of Fireplaces:
    • 3
    • Porch Size:
    • 6x20
    • Siding:
    • Partial Brick, Stone Ext
    • Stories:
    • 2 Story, 2.5 Story
    • Style:
    • Transitional
    • Total Building Square Footage:
    • 6557
    • Type Of Roof:
    • Shingle
    • Year Built:
    • 2005

    Land

    • Lot Description:
    • Cul-De-Sac, Hardwood Trees, Landscaped
    • Lot Number:
    • 7
    • Lot Square Footage:
    • 45302.4

    Listing

    • Days On Market:
    • 99

    Money

    • Association Fee:
    • 125
    • Association Fees Payment Frequency:
    • Monthly
    • Hoa Fee Includes:
    • Clubhouse, Ho Association, Maint Com. Area, Pool, Tennis
    • Hoa Y/N:
    • Yes
    • Price Per Square Foot:
    • 194.45

    Rooms

    • Attic Description:
    • Floored, Pull Down, Unfinished Att, Walk In
    • Bathroom Description:
    • Bath/Shower, Bath/Tub, Tub/ Sep Shower, Whirlpool
    • Bedroom #2 Dimensions:
    • 16.8x16.9
    • Bedroom #3 Dimensions:
    • 13.6x14
    • Bedroom #4 Dimensions:
    • 13x14.2
    • Dining Room:
    • Breakfast Room, Separate Dining Room
    • Dining Room Dimensions:
    • 14x15
    • Dining Room Level:
    • Main
    • Family Room Dimensions:
    • 16x19.2
    • Family Room Level:
    • Main
    • Is Master On Main?:
    • Yes
    • Kitchen Dimensions:
    • 15x18.5
    • Kitchen Level:
    • Main
    • Laundry Room Level:
    • 1st Floor, Utility Room Wd
    • Master Bedroom Dimensions:
    • 15x20.4
    • Master Bedroom Location:
    • Main
    • Office Dimensions:
    • 13x15.3
    • Other Rooms:
    • 1st Floor Master Bedroom, Entry Foyer, Family Room, Fitness Room, Office, Walk In Pantry, Rec Room, Utility Room
    • Total Rooms:
    • 16
    • Utility Room Dimensions:
    • 6.2x11.7

    Structures

    • Garage Capacity:
    • 3
    • Garage Dimensions:
    • 24x33
    • Parking Description:
    • Attached, Dw/Concrete, Entry/Side, Garage
    • Pool Description:
    • Swim Pool/Priv. Com

    Systems

    • Appliances:
    • Dishwasher, Double Oven, Gas Range, Ice Maker Connection, Microwave, Range Hood, Refrigerator, Wall Oven
    • Cooling System:
    • Central Air
    • Existing Water:
    • Community Water, Septic Tank
    • Heating:
    • Forced Air
    • Heating Fuel:
    • Electric Fuel, Natural Gas
    • Water Heater:
    • Gas

    Source

    • Listing Provided By Keller Williams Preferred Realty

      “Copyright 2017 Triangle MLS, Inc. of North Carolina. All rights reserved.”


      TMLS
    School data provided by
    GreatSchools
    REQUEST SHOWING
    SCHOOL RATINGS
    6

    BAILEYWICK ROAD ELEMENTARY
    Elementary School
    Public

    4

    EAST MILLBROOK MIDDLE
    Middle School
    Public

    8

    LEESVILLE ROAD HIGH
    High School
    Public

    NOTES

    No notes have been added for this home.

    CONTACT AN AGENT

    SCORECARD

    0
    PROS
    0
    CONS
    Condition
    Location
    Nearby
    Schools
    Taxes
  • Add Note
  • Add to Notebook
  • Share
  • ;