Rampart is Ready. This exceptional new build by Midtown Custom Homes in North Hills Estates blends timeless design with modern comfort. Offering 5,145 square feet, the home features 5 bedrooms, 5 full baths, and 2 half baths, a perfect balance of everyday function and refined entertaining. The kitchen is a true showpiece, featuring extensive custom cabinetry with gold accents, quartzite countertops and backsplash, and an oversized island illuminated by handcrafted alabaster and gold pendant lights from Corbett. Top-of-the-line appliances include a 36'' Sub-Zero refrigerator, 36'' Sub-Zero freezer, 48'' Wolf dual-fuel range, convection/steam oven, wall-mounted microwave, and dual dishwashers. A stunning scullery with oversized windows offers additional storage and prep space, and separate access to the dedicated grilling porch with built-in gas grill. The dining room is anchored by a bold statement chandelier set against moody Urbane Bronze walls and a custom accent wall paper on the ceiling. The dining room also has built-in cabinets for extra storage. There's a wet bar between the kitchen and living room with wine and beverage fridge, ice maker, and glass-and-metal framed display cabinetry- this space creates a natural hub for entertaining. The family room has a gas fireplace with quartzite surround and a custom mantel. The living room opens seamlessly through oversized sliders onto the covered back porch, complete with a brick fireplace, recessed infrared ceiling heaters, and built-in speakers. The professionally landscaped yard is enhanced by irrigation and architectural uplighting. The primary suite is a sanctuary, boasting cathedral ceilings, a custom accent wall with hidden storage and discreet access to the ensuite bath and closet, plus a private coffee bar with a mini fridge. The spa-style bath offers heated floors, a zero-entry shower with dual shower heads, and a freestanding tub within the glass enclosure. This space is crafted to deliver a true luxury experience. A first-floor guest suite can double as an executive study with private exterior access. Additional Features • Pre-wired surround sound in the rec room • Two-car garage with EV charger • Thoughtfully designed storage throughout Situated in North Hills Estates, one of Raleigh's most coveted neighborhoods, this home combines exceptional craftsmanship with unrivaled convenience. Just minutes from premier shopping, dining, fitness studios, green spaces, and entertainment, Rampart offers the ultimate in modern luxury living!
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
—
Baths
3.5
Stories
1.75
Lot width
—
Lot depth
—
Lot size
0.34 Acres
Year renovated
2025
Sq. Ft.
5,468
Year built
2025
Style
Single Family Residential
County
Wake County
APN
1706.14 24 9083 000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 10, 2026.
R-4
Residential-4 District
Subject to the density restriction of 4 units per acre, R-4 allows single-unit living in a detached house with a minimum lot size of 10,000 sq ft.; Decreased minimum lot sizes are permitted as part of a compact development.; Additional building types, smaller lot sizes and increased density as part of a conservation development are allowed in exchange for preserving common open space.
Permitted uses
Include but are not limited to:
Housing-Single unit
Housing-Multiple units
Infrastructure
Public service-Other
Recreation-Other
Park & open space
May 4, 2026 • Final
Residential plumbing water and/or sewer
Install a sewer tap on the existing main and install a PVC sewer clean out.
Plumbing
Aug 8, 2025 • Final
New single family dwelling/duplex/triplex/quadruplex/adu
Construct a new single-family home with a crawl space. The project includes a fireplace on the rear screened porch and in the family room.
New construction
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking Information
Attached Garage: Yes
Garage: Yes
Garage Spaces: 2
Open Parking: Yes
Open Parking Spaces: 4
Parking Features: Attached, Circular Driveway, Driveway, Garage, Garage Faces Side
Parking Total: 6
Interior
Bathroom Information
Bathrooms Full: 5
Bathrooms Half: 2
Bedroom Information
Bedrooms Total: 5
Interior Features
Appliances: Built-In Range, Dishwasher, Freezer, Gas Oven, Ice Maker, Microwave, Range, Refrigerator, Tankless Water Heater, Wine Refrigerator
Window Features: Display Window(s), Double Pane Windows, Insulated Windows
Laundry Features: Laundry Room, Main Level, Multiple Locations, Upper Level
Interior Features: Bar, Breakfast Bar, Built-in Features, Butler's Pantry, Cathedral Ceiling(s), Ceiling Fan(s), Chandelier, Crown Molding, Double Vanity, Eat-in Kitchen, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Downstairs, Recessed Lighting, Separate Shower, Smart Light(s), Smart Thermostat, Smooth Ceilings, Soaking Tub, Sound System, Storage, Vaulted Ceiling(s), Walk-In Closet(s), Walk-In Shower, Water Closet, Wet Bar, Wired for Sound
Fireplace: Yes
Fireplace Features: Family Room, Gas Log, Gas Starter, Kitchen, Living Room, Outside, Wood Burning
Fireplaces Total: 2
Door Features: Sliding Doors
Flooring: Ceramic Tile, Hardwood, Tile
Exterior
Building Information
Construction Materials: Brick, Fiber Cement, Low VOC Paint/Sealant/Varnish
Building Area Total: 5145.0
Builder Name: Midtown Custom Homes
Structure Type: Site Built
Exterior Features
Patio and Porch Features: Covered, Enclosed, Front Porch, Rear Porch, Screened
Foundation Details: Block, Brick/Mortar, Pillar/Post/Pier
Cooling Information: Ceiling Fan(s), Central Air, Dual, Zoned
Location
HOA Information
Association: No
School Information
Elementary School: Wake - Brooks
Middle Or Junior School: Wake - Carroll
High School: Wake - Sanderson
Location Information
County Or Parish: Wake
Directions: From 440, head North on Six Forks Rd, turn Left on NOrthbrook, Right on Yadkin, property is on the right past North Hills Club at corner of Rampart and Yadkin.
Latitude: 35.848767
Longitude: -78.652476
Postal Code: 27609
Road Responsibility: Public Maintained Road
Road Surface Type: Asphalt
Community Information
Community Features: Playground, Tennis Court(s)
Senior Community: No
Public facts
Beds: —
Baths: 3.5
Sq. Ft.: 5,468
Stories: 1.75
Lot Size: 0.34 acres
Style: Single Family Residential
Year Built: 2025
Year Renovated: 2025
County: Wake County
APN: 1706.14 24 9083 000
Home facts updated by county records on Aug 10, 2026
Other
hidden custom fields
Laundry Room, Main Level, Multiple Locations, Upper Level
Listing Date Information
Contract Status Change Date: 2025-12-16
Documents Change Timestamp: 2025-09-09T21:46:03Z
Photos Change Timestamp: 2025-09-16T15:17:43Z
Price Change Timestamp: 2025-02-14T02:21:34Z
Listing Price Information
Previous List Price: 2985000.0
Around this home
Schools
Brooks Elementary
Public PreK-5 • Assigned • 0.3mi
6/10
Carroll Middle
Public 6-8 • Assigned • 0.7mi
5/10
Sanderson High
Public 9-12 • Assigned • 0.9mi
6/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
6/10 Heat Factor
7 days above 105° expected this year, 17 days in 30 years
6/10 Wind Factor
60% chance of strong winds in next 30 years
3/10 Air Factor
2 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Raleigh, NC • 27609
Average low and high temperatures (°F)
48
29
54
35
70
46
77
55
79
60
90
69
91
73
82
68
80
63
71
52
65
45
53
35
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9 hours in
June and 5.1 hours in December, which is comparable to the
U.S. average for solar exposure.
9 hrs
5.1 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.72M – $3.29M
Reach more buyers when you sell with Redfin. Save up to $28,626 in fees.3 minutes to get started.