SavedSign in
For saleVirtual tour

$625,000

4 beds3,087 sq ft0.68 acres

10081 Barronne St.Union, KY 41091

Homes, condos and townhomes · MLS 12008899 · Listed 51 days ago (Sep 9, 2026)

16 mi straight line to Perfect North Slopes (alpine resort) · Ski access details

Report a problem

For sale: On the market and available to show.

About this property

Former Drees Model Home - Loaded with Upgrades! Welcome to this impressive Alden floorplan by Drees Homes, a former model home showcasing thoughtful upgrades and beautiful design throughout. Offering 4 bedrooms, 2.5 bathrooms and a 3-car garage, this home is ideally situated in the desirable French Quarter at Orleans. Step inside to an inviting open floorplan designed for both everyday living and entertaining. The fully equipped Kitchen features quartz countertops, a massive island with breakfast bar, spacious pantry and abundant workspace. The Kitchen flows seamlessly into the Breakfast Area, where you can step outside to the private deck with pergola-a perfect spot for outdoor dining or relaxing. The dramatic Living Room is a showstopper with soaring 18-foot ceilings, a wall of windows providing beautiful natural light and a cozy corner fireplace. Just a few steps down, you'll find a spacious Recreation Room, creating the perfect setting for movie nights, game days or entertaining family and friends. The Primary Suite truly feels like its own private wing, featuring an adjoining luxury bathroom and a massive walk-in closet with the added convenience of direct access to the Laundry Room. Upstairs, you'll find three additional spacious bedrooms and a full bathroom, providing plenty of room for family, guests or a home office. The unfinished walkout basement offers tremendous possibilities for future living space while currently providing excellent room for storage, a home gym, workshop or hobby area. Walk directly out to the backyard and imagine the possibilities! A 3-car garage provides plenty of room for vehicles, recreational equipment and additional storage. And the location makes it even better! Enjoy being within walking distance of the community pool, clubhouse, fishing pond and Orleans Park.

Description provided by the listing brokerage.

Ski access and nearby skiing

Why this listing is on Where2Ski: Measured distance to a ski area. It sits within 25 straight-line miles of an operating ski area's mapped entrance or base.

Nearby ski areas with straight-line distance
Ski areaTypeStraight-line distanceMeasured to
Perfect North SlopesIN · homes near itAlpine resort16 miBase areaBase area (mapped point)

Straight-line miles to each ski area's base or entrance, measured Oct 30, 2026, 5:56 PM UTC. Winter drives can take longer.

Ski access claims

The listing doesn't describe ski-in, ski-out, a short walk or a shuttle. The agent can tell you how owners get to the slopes.

Ski access is as described by the listing brokerage. Confirm trail access, easements and any pass or membership with Mike Parker of Huff Realty.

Features for skiers

  • Fireplace (mentioned in description)

How listings qualify · Report a wrong distance or ski-access claim

Facts

List price
$625,000
Status
For sale
Property type
House
Bedrooms
4
Full baths
2
Half baths
1
Interior area
3,087 sq ft
Lot size
0.68 acres
Year built
2018
Stories
2
Garage spaces
3
County
Boone County
HOA / association fee
$53 monthly
MLS number
12008899

Facts are provided by the listing brokerage.

Features

Interior

  • Walk-In Closet(s)
  • Entrance Foyer

Appliances

  • Stainless Steel Appliance(s)
  • Microwave
  • Refrigerator
  • Disposal
  • Dishwasher

Flooring

  • Tile

Basement

  • Walk-Out Access
  • Unfinished

Heating

  • Zoned
  • Forced Air
  • Natural Gas

Parking

  • Driveway

Construction

  • Vinyl Siding
  • Stone
  • Brick

Roof

  • Asphalt

Water

  • Public (Water Source)

Sewer

  • Other

Lot

  • Corner Lot

Virtual tours

Open virtual tour on www.tourfactory.com

Location

Pin placed from the listing's coordinates, which can be approximate. See more listings in Union.

Price and status history

    Changes seen in MyStateMLS data since Oct 29, 2026. Sold prices are not published.

    Estimate a monthly payment

    $125,000
    Illustrative. Replace with a quote from your lender.
    Estimate. Check the county assessor for the actual amount.
    Get a quote; rates vary widely by location.
    Manufactured homes on a leased lot.
    Applied only while the loan is over 80% of the price. Illustrative.

    Estimated monthly payment

    $3,918 per month

    Principal and interest$3,160
    Property tax$521
    Homeowners insurance$183
    HOA dues$53
    Loan amount$500,000
    Total interest over the term$637,722

    An estimate for comparison only. Actual rates, taxes, insurance, PMI and fees depend on your lender, credit, location and loan program.

    Similar listings near Perfect North Slopes

    The same type of property, priced $468,750 to $781,250 and a similar distance from Perfect North Slopes, newest first. See all matches

    Questions to ask before you buy

    Good questions for any home near the slopes.

    1. How is the property reached in winter, and who plows the road and driveway?A short straight-line distance can still mean a long or seasonal drive. Private roads, gates and mountain passes all shape winter access.
    2. Is there documented ski access from the property (trail, easement, lift), and does it transfer to a buyer?Rights to cross neighboring land or use a lift come from recorded easements and agreements, so a ski-in or ski-out description is where the question starts.
    3. Are there association, resort or club fees, and what do they cover?Some ski-area communities charge fees that cover only certain amenities, so ask what lift tickets, passes and services are included.
    4. Are there rules on renting the home short-term or long-term?Local ordinances, association covenants and deed restrictions all set rental rules, and they differ from place to place.
    5. What do heating, snow removal, winterization and utilities cost over a season?Ownership costs in snow country often run higher than the mortgage estimate suggests.
    6. For land: is there legal year-round access, and what utilities, septic and building rules apply?Seasonal roads and steep lots can limit what can be built and when it can be reached.

    Printable due-diligence checklist · Ski home ownership budget

    Guides and next steps

    Listing courtesy of Huff Realty. Listing agent: Mike Parker. Listings provided by MyStateMLS.

    Listing updated Oct 7, 2026, 7:15 PM UTC, MyStateMLS data received Oct 30, 2026, 5:01 PM UTC. Information deemed reliable but not guaranteed.