$635,000
PENDING

10029 Barronne St Union, KY 41091

Florence Area

Estimated payment $3,789/month

Total Views 6,774
5 Beds
3.5 Baths
3,096 Sq Ft
$205 Price per Sq Ft

Highlights

  • In Ground Pool
  • Recreation Room
  • Cathedral Ceiling
  • Clubhouse
  • Traditional Architecture
  • Wood Flooring

About This Home

Rare opportunity in the French Quarter at Orleans, ideally situated at the end of a quiet cul-de-sac. This expansive home, with over 4,000 finished square feet, is defined by a true resort-style backyard featuring an Olympic-size, heated, inground pool-an exceptional amenity rarely found in Union. Inside, a dramatic two-story great room with a wall of windows fills the home with natural light. The kitchen offers granite countertops and abundant cabinetry. The spacious primary suite provides a private retreat. The finished lower level expands the lifestyle with a dedicated theater room, home gym, bedroom/office, and flexible recreation space. A standout combination of privacy, scale, and amenities in one of Union's desirable neighborhoods.

Listing Agent

Lena Keith

Pivot Realty Group License #270151 Listed on: 07/07/2026

Pivot Realty Group

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2007

Lot Details

  • 20,298 Sq Ft Lot
  • Cul-De-Sac
  • Wood Fence
  • Land Lease

HOA Fees

  • $18 Monthly HOA Fees

Parking

  • Garage
  • Side Facing Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding
  • Stone

Interior Spaces

  • 3,096 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Home Theater Equipment
  • Sound System
  • Cathedral Ceiling
  • 2 Fireplaces
  • Gas Fireplace
  • Insulated Windows
  • Family Room
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Home Office
  • Recreation Room
  • Storage Room
  • Utility Room
  • Home Gym

Kitchen

  • Double Oven
  • Electric Cooktop
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Carpet
  • Ceramic Tile
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Laundry Room
  • Laundry on main level
  • Laundry Chute

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Basement Storage

Outdoor Features

  • In Ground Pool
  • Covered Patio or Porch
  • Exterior Lighting

Schools

  • Longbranch Elementary School
  • Ballyshannon Middle School
  • Cooper High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Cable TV Available

Community Details

Overview

  • Association fees include association fees
  • Vertex Association, Phone Number (859) 491-5711
  • French Quater/Orleans Sub Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Playground
  • Community Pool

Home Details

Home Type

Single Family

Year Built

Built in 2007

Lot Details

0.47 Acres

HOA Fees

$18 per month

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.446
  • Year Built: 2007
  • Lot Size: Of Record
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Consumer
  • Subdivision Name: French Quater/orleans Sub
  • Directions: 42 to R on Old Union Rd, to R on Orleans Blvd through roundabout to L on Longbranch to R on Barronne
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • Contract Info:Auction YN: No
  • General Property Description:Basement YN2: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • Property Ownership:Property Ownership: Consumer
  • Land Description:Land Description: Less than .5 Acre
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: High Ceilings, Cathedral Ceiling(s), Sound System, Wet Bar
  • Basement: Full, Walk-Out Access, Full Finished Bath, Finished, Storage Space
  • Heating: Natural Gas
  • Levels: Two
  • Property Type: Residential
  • Appliances: Double Oven, Dishwasher, Microwave, Refrigerator, Electric Cooktop
  • Other Equipment: Home Theater
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Gas
  • Fireplaces: 2
  • Fireplace: Yes
  • Living Area: 3096.0
  • Window Features: Insulated Windows

Exterior Features

  • Fencing: Wood
  • Roof: Shingle
  • Lot Features: Cul-De-Sac
  • Pool Features: In Ground
  • Construction Type: Brick, Stone, Vinyl Siding
  • Exterior Features: Lighting
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Porch, Patio, Covered

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage Faces Side, Garage

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Main Level, Laundry Chute, Laundry Room
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available

Condo/Co-op/Association

  • Amenities: Pool, Clubhouse, Playground
  • Association Fee: 220.0
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • Association Information:Association Management Name 1: Vertex
  • Association Information:Association Management Phone 1: 859-491-5711
  • Association Information:Total Yearly Fees: 220.0

Fee Information

  • Association Fee Includes: Association Fees

Schools

  • Elementary School: Longbranch
  • Junior High Dist: Boone Co Public
  • High School: Cooper High School
  • Middle Or Junior School: Ballyshannon Middle School

Lot Info

  • Land Lease: Yes
  • Lot Size Sq Ft: 20298.0
  • Zoning Description: Residential

Map

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $3,450 $414,900 $50,000 $364,900
2024 $3,405 $414,900 $50,000 $364,900
2023 $3,193 $385,000 $44,000 $341,000
2022 $3,265 $385,000 $44,000 $341,000
2021 $4,195 $385,000 $44,000 $341,000
2020 $3,353 $385,000 $44,000 $341,000
2019 $3,382 $385,000 $44,000 $341,000
2018 $3,414 $385,000 $44,000 $341,000
2017 $3,363 $385,000 $44,000 $341,000
2015 $3,342 $385,000 $44,000 $341,000
2013 -- $385,000 $44,000 $341,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
07/19/2026 07/19/26 Pending -- -- --
07/07/2026 07/07/26 For Sale $635,000 -- $205 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Quit Claim Deed -- None Listed On Document
Quit Claim Deed -- Stewart Title Co
Interfamily Deed Transfer -- Stewart Title Co
Warranty Deed -- None Available
Deed $332,966 None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Open $50,000 Credit Line Revolving
Previous Owner $290,000 Future Advance Clause Open End Mortgage
Previous Owner $42,125 Credit Line Revolving
Previous Owner $230,000 VA
Previous Owner $230,000 New Conventional
Previous Owner $261,000 New Conventional
Previous Owner $66,350 Credit Line Revolving
Previous Owner $265,550 New Conventional
Source: Public Records

About the Listing Agent

Lena Keith

Pivot Realty Group

(859) 340-8864

Section Image

I’m Lena Keith, a former teacher turned full-time Realtor®—and I bring that same heart-first, service-driven approach into every part of the buying and selling process. After years in the classroom, I learned that people thrive when they feel supported, understood, and cared for. Real estate is no different.

My brand promise:
Care that guides. Clarity that empowers.

I’m here to make your next move feel informed, confident, and stress-light. When you work with me, you’re not

Lena's Other Listings

  • 503 Rosary Dr, Erlanger, KY 41018

    $245,000 Pending

    • 3 Beds
    • 1 Bath
    • 1,188 Sq Ft
    • 503 Rosary Dr
    • Erlanger, KY

    Don't miss this beautifully updated 3-bedroom home in a convenient Erlanger location! From the stylish kitchen with quartz countertops to the fresh paint and remodeled shower, this home offers the updates buyers are looking for. The spacious basement provides endless possibilities for storage, a workshop, home gym, or future finished living space, while the attached 1-car garage adds everyday

    Lena Keith Pivot Realty Group

    Section Image
  • 3814 Church St, Covington, KY 41015

    $120,000

    • 2 Beds
    • 1 Bath
    • 1,040 Sq Ft
    • 3814 Church St
    • Covington, KY

    Investor Opportunity in Latonia! This two-story home offers great curb appeal, a welcoming front porch, driveway parking, and a detached garage features that add both functionality and appeal for a future rental or investment property. The layout and location provide an excellent opportunity for an investor looking to add value and build equity. Bring your vision and take advantage of the

    Lena Keith Pivot Realty Group

    Section Image
  • 1003 5th Ave, Dayton, KY 41074

    $200,000 $15K PRICE DROP

    • 3 Beds
    • 1.5 Baths
    • 1,696 Sq Ft
    • 1003 5th Ave
    • Dayton, KY

    Just minutes from downtown Cincinnati, this move-in-ready 3-bedroom, 1.5-bath home offers the space, character, and convenience today's buyers are looking for. Original woodwork, tall ceilings, spacious living areas, and abundant natural light highlight the home's historic charm, while the large kitchen and fully fenced backyard with a patio and fire pit make everyday living easy. Conveniently

    Lena Keith Pivot Realty Group

    Section Image
  • 120 S Main St, Glencoe, KY 41046

    $250,000

    • 4 Beds
    • 1 Bath
    • 1,445 Sq Ft
    • 120 S Main St
    • Glencoe, KY

    Wake up to peaceful views of the countryside and neighboring pond from this bright and spacious 4-bedroom home in the heart of Glencoe. Offering 1,445 square feet of light-filled spaces, the layout features three bedrooms on the main level plus a spacious loft and fourth bedroom upstairs, ideal for guests, a home office, or additional living space. The beautifully renovated bathroom adds modern

    Lena Keith Pivot Realty Group

    Section Image
  • 0 Whippoorwill Unit 645501, Perry Park, KY 40363

    $35,000

    • Land
    • 2 Acres
    • $17,500 per Acre
    • 0 Whippoorwill
    • Unit 645501
    • Perry Park, KY

    Discover the perfect setting for your dream home with this rare offering of approximately 2 acres comprised of four adjoining parcels on the Whippoorwill Loop in the desirable Perry Park Resort community. Surrounded by mature trees and abundant wildlife, this property offers the privacy and flexibility that's hard to find. Enjoy a true resort lifestyle with access to a 27-hole championship golf

    Lena Keith Pivot Realty Group

    Section Image
  • 671 Main St, Pleasureville, KY 40057

    $185,000 $4K PRICE DROP

    • 2 Beds
    • 1 Bath
    • 1,080 Sq Ft
    • 671 Main St
    • Pleasureville, KY

    Covered front porch, hardwood floors, detached garage with electric, and a generous .28-acre lot. This is the kind of property buyers are searching for. Located in the heart of Pleasureville, this well-maintained 2-bedroom, 1-bath home offers 1,080 square feet of inviting living space filled with charm and potential. Enjoy peaceful mornings on the front porch, plenty of outdoor space for

    Lena Keith Pivot Realty Group

    Section Image
  • 32 Barnwood Ct, Florence, KY 41042

    $325,000 Sold Apr 17, 2026

    • 3 Beds
    • 2.5 Baths
    • 2,554 Sq Ft
    • 32 Barnwood Ct
    • Florence, KY

    Two-story home in Farmview subdivision in the Florence/Union area offering flexible living space and functional updates. Main level includes HUGE family room, nice kitchen, and two enclosed rooms (formerly open den and dining areas) with added walls and doors, creating private office or flex spaces. Vaulted ceilings in the family room and primary bedroom add volume and natural light. Partially

    Lena Keith Pivot Realty Group

  • 1057 Hamilton Rd, Park Hills, KY 41011

    $355,000 Sold Feb 02, 2026

    • 3 Beds
    • 2 Baths
    • 2,030 Sq Ft
    • 1057 Hamilton Rd
    • Park Hills, KY

    Gorgeous 1924 home in the heart of Park Hills! This charming property offers 3 bedrooms and 2 baths, blending classic character with modern comfort. Enjoy city views from the expansive front porch and relax in the cozy, courtyard-style backyard. The location is unbeatable, just minutes from downtown Cincinnati with easy highway access. Currently used as a multifamily with a tenant in the upstairs

    Lena Keith Pivot Realty Group

  • 4504 Church St, Taylor Mill, KY 41015

    $195,000 Sold Mar 10, 2026

    • 3 Beds
    • 1 Bath
    • 1,125 Sq Ft
    • 4504 Church St
    • Taylor Mill, KY

    Charming 1.5-story home offering 3 bedrooms and 1 full bath, located on a quiet, cute street in Taylor Mill. Property backs directly to the Bill Cappel Sports Complex, providing a unique no-rear-neighbor setting and easy access to green space and recreation. Features include a newer roof, functional layout, and great overall value at an attractive price point. Ideal for owner-occupants or

    Lena Keith Pivot Realty Group

Source: Northern Kentucky Multiple Listing Service

MLS Number: 644393

Northern Kentucky Multiple Listing Service

APN: 051.01-06-424.00

Your Personal Tour Guide

Ask me questions while you tour the home.