A truly custom, unique, modern-farmhouse in a FABULOUS North Raleigh location! The lot has an incredilbe wooded/private feel, but you are really just minutes from 540. Sleek wire handrails lead to the gorgeous covered front porch with stained cedar brackets & ceiling. The main level is open concept with vaulted ceilings, executive study with custom barn doors, dining room with custom trim accent wall, stunning kitchen with a HUGE island, gas cook top, stainless hood, breakfast nook, & hidden pantry. Family room with stacked stone gas fireplace, & direct access to the 90 degree wrap around terrace, & screened porch with gas FP & stone surround. Custom built-ins in the mud room. 1st floor Primary Suite with zero entry shower, frame-less glass enclosure, 6ft soaking tub, & custom closet with shelves & drawers. Private Entrance Apartment/In-Law Suite with full kitchen, bedroom, bath, & laundry. Fully finished basement with a tech control room, laundry with 2 washers & dryers, folding space, a sink, & cabinets. Full bath with walk in shower, gym/office/flex room with walk-in closet – all bedrooms have generous walk in closets, too! Large family room in walk out basement with plenty of natural light. Perfect space for watching sports, playing games, shooting pool, or entertaining in the impressive bar area- complete with vintage brick accent wall, additional fridge, stainless steel sink, wine fridge, & kegerator. Guests can relax while sitting at the bar and watching one of 4 potential TV’s! Unique concrete room off the bar area would be perfect for a wine cellar! There are also 2 bedrooms, & a shared bathroom upstairs & separate from the In law suite/apartment. Outdoor spaces include over 800 sqft on the main level, including a screened porch & terrace with deck-tek (water sealed, water tight, waterproof) flooring & a 1240 sqft patio off the basement. Electric & Gas in place to add lighting, hot tub, & gas grill, & there is already a permit for a pool with shower! The whole house has upgraded electrical, there are 4 HVAC/heat units and 2 tankless water heaters with circulating pumps for instant hot water, and a constant pressure well pump that pumps a minimum of 30 gallons per minute.