Off market since Oct 2026

Off market since Oct 2026 Home

Listed Jul 23, 2026

$1,050,000

554 West Rosiland Drive North

  • 4

    Beds

  • 5

    Baths

  • 5,066

    Sq ft

The story

  • Pool
  • Basement

Exceptional custom executive estate perfectly positioned on a private, professionally landscaped wooded homesite, offering timeless architecture, impeccable craftsmanship, and resort-style outdoor living. From the impressive two-story foyer with sweeping staircase to the extensive custom millwork, crown molding, hardwood flooring, plantation shutters, and elegant formal entertaining spaces, every detail reflects exceptional quality and thoughtful design. The spectacular two-story family room is flooded with natural light from soaring windows and is anchored by a dramatic floor-to-ceiling brick fireplace with custom built-in cabinetry. The beautifully appointed gourmet kitchen features custom cabinetry, granite countertops, a center island, premium appliances, abundant workspace, and a spacious breakfast area overlooking the backyard oasis. A richly appointed executive library with floor-to-ceiling custom built-ins provides an ideal work-from-home environment, while the luxurious primary suite offers a peaceful retreat complete with a sitting area, tray ceiling, spa-inspired bath, and an extraordinary custom walk-in dressing room. Designed for effortless entertaining, the finished English basement offers expansive recreation areas, a custom wet bar, game room, exercise space, and abundant daylight. A charming three-season sunroom seamlessly connects the interior to the spectacular outdoor living spaces. The resort-inspired backyard is truly exceptional, featuring a sparkling in-ground pool, expansive stamped concrete patios, mature trees, professional landscaping, and remarkable privacy-creating an outdoor setting that rivals a private country club. Meticulously maintained with significant recent improvements, including a new roof and gutters, updated HVAC systems, furnaces, water heaters, pool equipment, exterior painting, landscape lighting, washer and dryer, and more, providing complete peace of mind for years to come. A rare offering where timeless elegance, exceptional craftsmanship, modern mechanical updates, and outstanding indoor and outdoor living come together in one extraordinary residence. 2019 - New Sump Pump and New Battery Backup Pump 7 years old 2021 - New Roof and Gutters, 5 years old 2023 - New gas furnaces Downstairs and Main Levels 3 years old 2022 - New Hot Water Heaters X 2, 4 years old 2022 - Basement repainted, 4 years ago 2022 - New Carpet, Entire Basement, 4 years old 2023 - New Pool Filter, 3 years old 2023 - New Central Air Upstairs, 3 years old 2025 - Entire outside of House Painted, 18 months ago 2025 - New Landscape Lighting Front of House, 1 years old 2026 - New Landscape Lighting Back of House, 6 months old 2026 - New Pool Pump, new 2026 - New Pool Lights, new 2026 - Garage Painted (Inside), 3 months old 2026 - New Washer and Dryer, 1 year old 2026 - All Pavers Pressure Washed and Re-sanded, 6 months ago

Facts & features

Home type

Home

Year built

1994

Price per sq ft

$207

HOA

$350 / annually

Parking

3-car garage

Included features

  • Pool

    Yes

  • Fireplace

    2 fireplaces

  • Basement

    Yes

  • Cooling

    Central Air, Zoned

  • Heating

    Gas

  • Appliances

    Range, Microwave, Dishwasher, High End Refrigerator, Washer, Dryer, Disposal, Range Hood, Humidifier

  • Flooring

    Hardwood, Carpet

  • Roof

    Asphalt

  • Lot Information

    Cul-De-Sac, Landscaped, Wooded

  • Water Source

    Public

  • Sewer

    Public Sewer

Listing Broker

HomeSmart Connect LLC

Broker Name

HomeSmart Connect LLC

Agent

Debra Hallberg-Palmer