$525,000

Estimated payment $3,322/month

Total Views 10,990
4 Beds
2.5 Baths
2,673 Sq Ft
$196 Price per Sq Ft

Highlights

  • Hot Property
  • Spa
  • Recreation Room
  • Longbranch Elementary School Rated A
  • Open Floorplan
  • Cathedral Ceiling

About This Home

Showstopper! This beautiful 4-bedroom, 2.5-bath home in the French Quarter at Orleans has been truly loved, thoughtfully upgraded and filled with designer touches throughout. Step inside to a formal dining room just off the entry, then into the welcoming family room where gorgeous built-ins surround the fireplace and create a space that immediately feels like home. The bright eat-in kitchen is made for gathering with a large center island, granite countertops, upgraded cabinetry, high-end pendant lighting and under-cabinet lighting. Just beyond, the sunroom may quickly become your favorite spot in the house, complete with a built-in bench perfect for reading, additional seating or simply enjoying your morning coffee. Upstairs offers even more room to spread out with a large loft, four additional bedrooms including a beautiful primary suite. The spacious ensuite features upgraded fixtures and hardware, an oversized shower and a huge walk-in closet. Three finished levels provide incredible flexibility, while the finished lower level offers additional living space plus tons of storage. And wait until you step outside! The covered, oversized concrete patio was designed for entertaining with a built-in stone fire pit and plenty of room for multiple seating areas. The flat, fenced backyard offers even more space to spread out, play and enjoy time outdoors. The location completes the package! Enjoy an established community with neighborhood pool access plus Orleans Park, featuring a fishing lake, paved walking trail, playground, basketball and tennis courts, sand volleyball, athletic field and more. Conveniently located near Longbranch Elementary and Cooper High School with easy access to Union Promenade and the growing US-42 corridor for shopping, dining, grocery, fitness and everything you need! This one has the style you want, the space you need, and all the little details that make a house feel like home.

Listing Agent

Missy Bricking

Keller Williams Realty Service License #204109 Listed on: 09/03/2026

Keller Williams Realty Service

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2018

Lot Details

  • 12,937 Sq Ft Lot
  • Lot Dimensions are 162 x 80
  • Split Rail Fence
  • Property is Fully Fenced
  • Level Lot
  • Private Yard
  • Land Lease

HOA Fees

  • $50 Monthly HOA Fees

Parking

  • Attached Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway
  • Off-Street Parking

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Shingle Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,673 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wired For Data
  • Built-In Features
  • Bookcases
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Pendant Lighting
  • Gas Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Family Room
  • Living Room
  • Breakfast Room
  • Formal Dining Room
  • Recreation Room
  • Bonus Room
  • Solarium
  • Storage
  • Neighborhood Views
  • Storage In Attic
  • Fire and Smoke Detector

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Gas Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Laminate

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Bathroom
  • Walk-In Closet
  • Double Vanity

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

  • Basement Fills Entire Space Under The House
  • Basement Storage

Outdoor Features

  • Spa
  • Covered Patio or Porch
  • Fire Pit

Schools

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

Utilities

  • Humidifier
  • Forced Air Heating and Cooling System
  • High Speed Internet

Community Details

Overview

  • Association fees include association fees
  • Vertex Association, Phone Number (859) 491-5711

Recreation

  • Tennis Courts
  • Community Playground
  • Community Pool
  • Trails

Home Details

Home Type

Single Family

Year Built

Built in 2018

Lot Details

0.3 Acres

HOA Fees

$50 per month

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.297
  • Year Built: 2018
  • Lot Size: 162 x 80
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Consumer
  • Directions: Longbranch Rd, L onto Barronne St, left onto Eden Ct
  • 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
  • Utilities Electric Company: Owen Electric
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone County
  • 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: None

Interior Features

  • Interior Amenities: Ceiling Fan(s), Recessed Lighting, Attic Storage, Multi Panel Doors, High Ceilings, Cathedral Ceiling(s), Vaulted Ceiling(s), Wired for Data, Bookcases, Breakfast Bar, Built-in Features, Chandelier, Double Vanity, Eat-in Kitchen, Entrance Foyer, Granite Counters, High Speed Internet, Kitchen Island, Open Floorplan, Storage, Walk-In Closet(s)
  • Basement: Full, Finished, Storage Space
  • Heating: Forced Air
  • Levels: Two
  • Property Type: Residential
  • Appliances: Disposal, Dishwasher, Microwave, Gas Range, Stainless Steel Appliance(s)
  • Other Equipment: Humidifier
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Door Features: French Doors
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 2673.0
  • Window Features: Insulated Windows, Vinyl Frames

Exterior Features

  • View: Neighborhood
  • Fencing: Full, Split Rail, Fenced
  • Roof: Shingle
  • Lot Features: Level
  • View: Yes
  • Construction Type: Brick, Shingle Siding
  • Exterior Features: Hot Tub, Fire Pit, Private Yard
  • Foundation Details: Poured Concrete, Concrete Perimeter
  • Patio And Porch Features: Porch, Patio, Covered

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway, Off Street, Garage Faces Front, Garage Door Opener, Garage

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Main Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Amenities: Pool, Tennis Court(s), Playground, Trail(s)
  • Association Fee: 595.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: 595.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: 12937.0
  • Zoning Description: Residential

Matterport 3D Tour

Floorplans

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,417 $362,300 $60,000 $302,300
2024 $3,348 $362,300 $60,000 $302,300
2023 $3,145 $333,500 $51,000 $282,500
2022 $3,161 $333,500 $51,000 $282,500
2021 $4,064 $333,500 $51,000 $282,500
2020 $3,234 $333,500 $51,000 $282,500
2019 $3,263 $333,500 $51,000 $282,500
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
09/03/2026 09/03/26 For Sale $525,000 -- $196 / 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
Warranty Deed $333,460 Terry Monnie Title
Warranty Deed $51,000 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 $206,000 New Conventional
Closed $203,000 New Conventional
Source: Public Records

About the Listing Agent

Missy Bricking

Keller Williams Realty Service

(859) 295-5924

Section Image

Life changes fast — and when it does, where you live often changes too. Whether you're buying, selling, building, investing, or starting a new chapter, you deserve more than just a Realtor®. You deserve a trusted advisor who will guide you with clarity, confidence, and a proven strategy.

For more than 24 years, Missy has helped clients across Kentucky and Ohio navigate life’s biggest transitions with expert counsel, strong advocacy, and results-driven service. Recognized as a top

Missy's Other Listings

  • 2166 Serenity Ct Unit 200A, Union, KY 41091

    $225,000 Pending

    • 2 Beds
    • 2 Baths
    • 1,476 Sq Ft
    • 2166 Serenity Ct
    • Unit 200A
    • Union, KY

    Welcome home to Harmony in Union! This beautifully maintained first-floor condo offers the perfect blend of comfort, style, and easy living with 2 bedrooms, a versatile den/office, and 2 full baths--all with convenient, no-step access.Step inside to find upgraded hardwood-style laminate flooring, fresh paint, stylish decorative lighting, stainless steel appliances, huge pantry, and custom

    Missy Bricking Keller Williams Realty Service

    Section Image
  • 7812 E Bend Rd, Burlington, KY 41005

    $2,500,000

    • 4 Beds
    • 2 Baths
    • 4,100 Sq Ft
    • 7812 E Bend Rd
    • Burlington, KY

    A rare legacy offering in Burlington (4 miles to RT 18) where history, land, and opportunity align in a way that's increasingly hard to replicate.Set across 20 breathtaking acres, this extraordinary estate is more than a property, it's a living piece of Boone County history. The iconic farmhouse, recognized in film productions and a national ice cream commercial, carries a presence that

    Missy Bricking Keller Williams Realty Service

    Section Image
  • 9827 Codyview Dr, Independence, KY 41051

    $297,500 $3K PRICE DROP

    • 3 Beds
    • 2.5 Baths
    • 9827 Codyview Dr
    • Independence, KY

    Welcome home to this newer 3-bedroom, 2.5-bath Celestial Builders bi-level offering a great combination of space, function and convenience in Independence! Step inside to an open, bright layout highlighted by cathedral ceilings, upgraded cabinetry and plenty of room to gather. The private primary suite features its own full bath, while two additional bedrooms provide flexibility for family,

    Missy Bricking Keller Williams Realty Service

    Section Image
  • 293 Walton Nicholson Rd, Walton, KY 41094

    $430,000 $20K PRICE DROP

    • 5 Beds
    • 3 Baths
    • 1,998 Sq Ft
    • 293 Walton Nicholson Rd
    • Walton, KY

    BACK ON THE MARKET AT NO FAULT OF THE SELLERS! - Have you ever dreamed of having nearly an acre of your own land where you can garden, entertain, and enjoy the privacy you've always wanted and still have the amenities of a neighborhood, like a community pool? Well, you don't have to choose. This multi generational home gives you the best of both worlds.The main residence features 4

    Missy Bricking Keller Williams Realty Service

    Section Image
  • 1972 Tanners Cove Rd, Hebron, KY 41048

    $215,000 $5K PRICE DROP

    • 2 Beds
    • 2 Baths
    • 1,203 Sq Ft
    • 1972 Tanners Cove Rd
    • Hebron, KY

    Welcome home to this beautifully maintained condo tucked away in the quiet and secluded Tanners Cove community in Hebron! From the inviting covered front patio to the spacious interior, this home offers true NO-STEP, low-maintenance living. This open-concept home features 2 bedrooms, 2 full bathrooms, and a formal dining room (or potential office/hobby space) with soaring ceilings throughout. The

    Missy Bricking Keller Williams Realty Service

    Section Image
  • 720 Broomtail Ln, Hebron, KY 41048

    $719,000 $16K PRICE DROP

    • 4 Beds
    • 3.5 Baths
    • 720 Broomtail Ln
    • Hebron, KY

    **MOTIVATED Seller** Step into refined luxury in this stunning executive residence, meticulously renovated across three finished levels. The gourmet kitchen dazzles with a massive island, sleek custom cabinetry, and top of the line stainless steel appliances - ideal for culinary creations or casual gatherings. Check out that stunning new staircase! Four spacious bedrooms (possible 5th on the main

    Missy Bricking Keller Williams Realty Service

    Section Image
  • 1419 Industrial Rd, Cold Spring, KY 41076

    $27,500 $3K PRICE DROP

    • Land
    • 0.46 Acre
    • $59,783 per Acre
    • 1419 Industrial Rd
    • Cold Spring, KY

    Turn your DREAM into a reality! A great builder + Your vision + Your future HOME! 1/2 Acre homesite in Cold Spring! Great location! Close to Cincinnati and the river!

    Missy Bricking Keller Williams Realty Service

    Section Image
  • 124 Belmont Ct, Williamstown, KY 41097

    $298,858 New Construction

    • 3 Beds
    • 2 Baths
    • 124 Belmont Ct
    • Williamstown, KY

    FREE refrigerator just in time for Thanksgiving! Locally built and thoughtfully crafted by EARP Builders! COMPLETE and MOVE-IN-READY! This BRAND NEW low-maintenance, no-step living ranch delivers quality you can feel. The Abby floorplan features 3 bedrooms, 2 full baths, a bright open great room, and 9-foot ceilings. This home blends comfort and function in all the right ways. Enjoy a welcoming

    Missy Bricking Keller Williams Realty Service

    Section Image
  • 126 Belmont Ct, Williamstown, KY 41097

    $318,328 New Construction

    • 3 Beds
    • 2 Baths
    • 126 Belmont Ct
    • Williamstown, KY

    FREE refrigerator just in time for Thanksgiving! Locally built and thoughtfully crafted by EARP Builders, welcome to the Apollo II floorplan, COMPLETE and MOVE-IN-READY! This BRAND NEW low-maintenance, no-step living, our largest ranch floorplan, delivers quality you can feel. Featuring 3 bedrooms, 2 full baths, a bright & spacious open great room, and 9-foot ceilings. Kitchen offers ample

    Missy Bricking Keller Williams Realty Service

    Section Image

Source: Northern Kentucky Multiple Listing Service

MLS Number: 646292

Northern Kentucky Multiple Listing Service

APN: 051.01-06-550.00

Your Personal Tour Guide

Ask me questions while you tour the home.