Julie Fronckowiak

License#: 100041

RARE opportunity in gated Greystone Legacy! Set on 5.67+/- private acres in one of the area’s premier golf communities, home to 2 PGA Championship courses, this pristine 5BR/4.5BA estate offers exceptional privacy & space. The main level features a luxurious primary suite with coffee bar, spa-like bath & 2 oversized walk-in closets, private office, banquet-sized dining room & huge laundry room. The chef’s kitchen boasts Bosch appliances, new Sub-Zero refrigerator, double ovens, warming drawer, large island & custom hidden walk-in pantry, opening to a vaulted keeping room. A serene walk-out patio with bar is perfect for entertaining. Upstairs has 4 spacious bedrooms—2 en suites + Jack & Jill—and large bonus/media room. Full unfinished basement stubbed for expansion. 2-car main-level + 2-car basement garages. Immaculately maintained!

Request Info / Schedule Showing

Julie Fronckowiak

General

  • Property Type: Single Family
  • Status: Coming Soon
  • MLS#: 21464471
  • List Price: $1,250,000
  • List Date: 09/09/2026
  • Year Built: 2007
  • County: Shelby
  • Area: N Shelby, Hoover
  • Subdivision: GREYSTONE
  • Beds: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Sq. Ft.: 4,754
  • Lot Description: Acreage, Cul-de-sac, Golf Community, Heavy Treed Lot, Interior Lot, Some Trees, Subdivision

Interior Features

  • Kitchen Features: Breakfast Bar, Eating Area, Island, Pantry
  • Rooms: Bedroom (ROOM), Dining Room (ROOM), Full Bath (ROOM), Great Room (ROOM), Half Bath (ROOM), Keeping Room (ROOM), Kitchen (ROOM), Laundry (ROOM), Master Bath (ROOM), Master Bedroom (ROOM), Office/Study (ROOM)
  • Bed/Bath Features: Double Shower, Jetted Tub, Separate Shower, Separate Vanities, Sitting Area in Master, Tub/Shower Combo, Walk-In Closets
  • Ceilings: Cathedral/Vaulted, 9 Feet +, Crown Molding, Smooth Ceilings, Trey Ceilings
  • Floors: Carpet, Hardwood, Tile Floor
  • Basement Style: Full Basement
  • Foundation: Basement
  • # of Fireplaces: 2
  • Fireplace Details: Gas Starter, Insert, Marble (FIREPL), Gas Logs
  • Fireplace Location: Den (FIREPL), Family Room (FIREPL), Great Room (FIREPL), Hearth/Keeping (FIREPL)
  • Fireplace Type: Gas (FIREPL)
  • Interior Features: Multiple Staircases, Recess Lighting, Safe Room/Storm Cellar, Wet Bar

Exterior Features

  • Exterior Features: Grill, Lighting System, Sprinkler System, Porch
  • Pool Description: In-Ground, Perimeter Fencing
  • Construction Type: 4 Sides Brick
  • Parking: Attached, Basement Parking, Driveway Parking, Lower Level, Parking (MLVL)

Size and Lot

  • Acres: 5.67
  • Upper Level Sqft: 1,931

Schools

  • Elementary: GREYSTONE
  • Middle: BERRY
  • High: SPAIN PARK

Utilities

  • Cooling: 3+ Systems (COOL), Central (COOL), Electric (COOL)
  • Water: Public Water
  • Sewer: Connected
  • Sewer/Septic: Connected
  • Energy Green Features: Ceiling Fans, Doub Paned Windows, Energy Star Windows, Generator, Programmable Thermostat, Ridge Vent
  • Heating: 3+ Systems (HEAT), Central (HEAT), Gas Heat
 

Estimated Monthly Mortgage Calculator

This calculator is provided for informational purposes only by Burrow Services, Inc. You should not make any decisions based simply on the information provided. Values indicated are estimates and may not be accurate and are only to be used as a guide. This calculator should not be relied upon in any way as the sole source of information. Please consult your financial, tax or legal advisers for an accurate assessment of your mortgage payments and any advice relating to your personal circumstances.

Similar Listings

Hoover Listings

468

Capstone Realty is powered by Burrow Services, Inc.