Welcome to this exquisite estate in the sought-after North Hills of Fairhope. Custom built by Ben Stewart and Gold Fortified, just over 5,200 sq ft home is the perfect blend of elegance and function. Inside, you’re welcomed by soaring cathedral ceilings and wide plank hardwood floors throughout. Intricate moldings and detailed finishes elevate the space throughout. The custom chef’s kitchen features hand-painted cabinetry, quartz countertops, Wolf 48” gas range, SubZero side-by-side refrigerator and steam wall oven. A separate scullery features an additional wall oven, prep sink, dishwasher, full refrigerator and beverage cooler. The main-level primary suite includes two walk-in closets (one with safe room) and a luxurious bath with double vanities, lighted mirrors, huge shower, and dual private water closets. A spacious guest suite with private bath also offers direct access to the enclosed pool house. Additional main-floor highlights include a private office with double glass doors, soaring tongue and groove ceilings, wet bar and beverage cooler. Laundry with mud sink and plenty of additional storage. True three car garage with epoxy floors and large additional storage. Upstairs are two large bedrooms sharing an adjoined bath with separate vanities, plus a large storage room with lift to the garage. Step outside to your private backyard retreat. The all season, glassed room features cathedral tongue-and-groove ceilings, a wood-burning fireplace, and full kitchen. Gunite pool with spa, sun shelf, and multiple water features—all surrounded by lush landscaping, full fencing, and exceptional privacy. A whole-home generator completes this luxury package. Too many features to list! Please see feature sheet for details. Call today to experience this truly one-of-a-kind home! Buyer to verify all information during due diligence.
Active
$2,685,000
312 Powderhorn Ridge Rd, Fairhope, AL 36532
4beds
5,268sqft
Est.:
Residential
Built in 2022
0.49 Acres Lot
$-- Zestimate®
$510/sqft
$104/mo HOA
What's special
Three car garageWet barMultiple water featuresGunite pool with spaEnclosed pool houseDetailed finishesQuartz countertops
- 103 days
- on Zillow |
- 817 |
- 42 |
Zillow last checked: 7 hours ago
Listing updated: July 16, 2025 at 02:59pm
Listed by:
Georgia Sumlin PHONE:251-533-8855,
Coldwell Banker Reehl Prop Fairhope
Source: Baldwin Realtors,MLS#: 378122

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
- Main level bedrooms: 2
Rooms
- Room types: Family Room, Office/Study, Sun Room
Primary bedroom
- Features: 1st Floor Primary, Multiple Walk in Closets
- Level: Main
- Area: 255.39
- Dimensions: 14.11 x 18.1
Bedroom 2
- Level: Main
- Area: 253.11
- Dimensions: 14.3 x 17.7
Bedroom 3
- Level: Second
- Area: 259.93
- Dimensions: 18.7 x 13.9
Bedroom 4
- Level: Second
- Area: 243.82
- Dimensions: 14.6 x 16.7
Primary bathroom
- Features: Double Vanity, Shower Only, Private Water Closet
Dining room
- Features: Breakfast Area-Kitchen, Separate Dining Room
Family room
- Level: Main
- Area: 369.6
- Dimensions: 22 x 16.8
Kitchen
- Level: Main
- Area: 253.44
- Dimensions: 14.4 x 17.6
Heating
- Central, Other
Cooling
- Electric, Other, Ceiling Fan(s), HVAC (SEER 16+)
Appliances
- Included: Dishwasher, Disposal, Ice Maker, Refrigerator w/Ice Maker, Wine Cooler, Cooktop, Tankless Water Heater
- Laundry: Main Level, Inside
Features
- Breakfast Bar, Eat-in Kitchen, Entrance Foyer, Ceiling Fan(s), En-Suite, High Ceilings, High Speed Internet, Split Bedroom Plan, Storage, Vaulted Ceiling(s), Wet Bar
- Flooring: Tile, Wood
- Windows: Window Treatments, Double Pane Windows
- Has basement: No
- Number of fireplaces: 2
- Fireplace features: Electric, Family Room, Wood Burning, Gas
Interior area
- Total structure area: 5,268
- Total interior livable area: 5,268 sqft
Property
Parking
- Total spaces: 3
- Parking features: Attached, Garage, Garage Door Opener
- Has attached garage: Yes
- Covered spaces: 3
Features
- Levels: Two
- Patio & porch: Covered, Patio, Rear Porch, Front Porch
- Exterior features: Irrigation Sprinkler, Outdoor Kitchen, Storage, Termite Contract, Gas Grill
- Fencing: Fenced,Fenced Storage
- Has view: Yes
- View description: Western View
- Waterfront features: No Waterfront
Lot
- Size: 0.49 Acres
- Dimensions: 110 x 195.2
- Features: Less than 1 acre, Level, Few Trees, Subdivided
Details
- Additional structures: Storage
- Parcel number: 4602030000004.137
- Zoning description: Single Family Residence,Within Corp Limits
Construction
Type & style
- Home type: SingleFamily
- Architectural style: French Provincial
- Property subtype: Residential
Materials
- Brick, Concrete, Stone, Block, Fortified-Gold
- Foundation: Slab
- Roof: Composition
Condition
- Resale
- New construction: No
- Year built: 2022
Utilities & green energy
- Electric: Generator
- Gas: Gas-Natural
- Water: Well
- Utilities for property: Natural Gas Connected, Underground Utilities, Fairhope Utilities, Riviera Utilities
Community & HOA
Community
- Features: BBQ Area
- Security: Carbon Monoxide Detector(s), Security Lights, Security System
- Subdivision: North Hills at Fairhope
HOA
- Has HOA: Yes
- Services included: Maintenance Grounds
- HOA fee: $1,250 annually
Location
- Region: Fairhope
Financial & listing details
- Price per square foot: $510/sqft
- Tax assessed value: $936,600
- Annual tax amount: $6,133
- Price range: $2.7M - $2.7M
- Date on market: 4/25/2025
- Ownership: Whole/Full
- Loading
- Loading