Refine Search
Sort by
$470,000
4 Beds 3 Baths 633910 MLS
Extremely rare 4 bed/ 3 bath Ranch home in desirable Hempsteade community!! Custom built columns give the open layout definition and a feeling of elegance. Formal living room and large family room w/ fireplace. Fresh kitchen with ample counter space, overhang for use as breakfast bar, white cabinetry, stainless steel appliances, and oversized walk-in pantry w/ plenty of shelving. Dining area w/ walkout access. Updated hardwood flooring in the kitchen/dining/ entryway areas. Laundry room conveniently located on main floor. Master bedroom features high ceilings & adjoining master bath w/ walk in- closet, double vanity, jetted tub, shower, and toilet closet. 2 more bedrooms on main level w/ updated full bath w/ built ins. Incredibly spacious finished basement for recreation w/ walkout, wet bar, media room, bedroom 4, and bonus room! New deck and a second deck space in front of the fire pit area. Private view of woods. 2 car garage.

10234 Hempsteade Drive, Union

$1,029,000
5 Beds 5 Baths 633829 MLS
Stunning custom all-brick home on a 1.1 acre private lakefront lot in the coveted Triple Crown community! This spacious 5 bed, 5 bath home features a gourmet kitchen, expansive back deck overlooking the lake, soaring 14' ceilings, a large primary suite with dressing room, finished walkout basement with wet bar, billiard and media room—perfect for entertaining or guests. Fish from your backyard in your private access lake as you enjoy this sprawling ranch with well-appointed living space, plus a 3-car garage and beautifully landscaped yard. Located on a quiet cul-de-sac, in one of Northern Kentucky's most desirable neighborhoods, with access to golf, pools, clubhouses, walking trails, and top-rated Boone County schools. A rare blend of luxury, space, and lifestyle—welcome home to Hyperion Ct!

1025 Hyperion Court, Union

$492,800
4 Beds 4 Baths 633822 MLS
Stunning 4 BDRM, 4 Bath, Drees-Built Ashton on Hard to Find, .28 Acre Level Homesite in Desirable French Quarter/Orleans Neighborhood! Award Winning Longbranch Elementary, Ballyshannon Middle, & Cooper High School District/3 FINISHED LEVELS w/APPROX 3,100 SQ FT in Total Living Space/Remarkable Fit & Finish w/Meticulous Attention to Detail/Impressive Entry w/Multiple Closets, Side Staircase, & Arched Niche w/Decorative Window/Expansive Great RM w/3 Oversized Windows & Open to Kitchen Area/State of the Art Granite Kitchen w/Upscale Appliances Including Double Oven, Gas Cooktop, Refrigerator, Built-In Microwave, & Dishwasher/Kitchen has Large Island with Counter Bar, Upgraded Staggered Cabinetry, Pendant & Recessed Lighting, Lots of Counter Space, Pantry, Adjoining Breakfast Area, & French Patio Door Walkout to Patio & Beautiful, Rear Lot/Inviting Dining RM/1ST FL Laundry RM/Fabulous Primary Suite w/Soaring Ceilings, Lots of Closet Space & Adjoining Luxurious Bath/2ND FL Gathering RM/Plushly FIN LL w/REC RM, 1/2 Bath, & 2 Storage RM's/New Carpeting/Freshly Painted/Upgraded Trim Package/Low Tax Rate/+ MUCH MORE! Outstanding Location Close to CVG Airport & Downtown Cincinnati

8663 Eden Court, Union

$649,800
4 Beds 4 Baths 633820 MLS
OPEN HOUSE CANCELED - HOME IS PENDING. Stunning 4 BDRM, 4 Bath MASTERPIECE w/3 Car Garage (2 Spaces, but SQ FT of a 3 Car Garage) on Perfectly Appointed Homesite in Desirable Ballyshannon! Incredible Outdoor Paradise Offering the Ultimate Lifestyle Including Spectacular, Inground Pool w/Concrete Surround, APPROX 400 SQ FT 2-Tiered Deck w/Steps to Rear Lot, 180 SQ FT Patio, Aluminum Fencing, & Evergreen Treeline/3 FIN LEVELS w/APPROX 4000 SQ FT in Award Winning Longbranch, Ballyshannon, & Cooper School District/Close to CVG Airport & Cincy/Remarkable Fit & Finish w/Meticulous Attention to Detail/State of the Art Upgrades/Soaring, 2 Story Great RM has Fireplace w/Reclaimed Wood Accents & Mantle/9 FT Ceilings on 1ST FL & in LL/Lots of HDWD Flooring/Fantastic High-End Finishes/Impressive Entry/1ST FL Study w/French Drs, Crown Molding, & New Custom Built-In's/Gourmet Granite KIT w/Massive Island, Gas Range, Staggered, White & Java Cabinetry, & ADJ Breakfast Area/1ST FL Hearth RM/Mudrm w/Cubbies/Luxurious Owner's Suite/2ND FL Laundry/Plushly FIN LL w/Walkout, Granite Wet Bar, REC RM, Full Bath, & 2 Storage RM's/New Carpeting/New, Upgraded HVAC/New H2O Heater & Back Door/ + MORE!

5057 Loch Drive, Union

$628,500
4 Beds 3 Baths 633816 MLS
Welcome home to effortless elegance at The Huxley by Fischer Homes in the beautiful Du Monde at Orleans community! This stunning 4 bed, 2.5 bath floor plan boasts a gorgeous modern kitchen with pantry, maple cabinetry and quartz countertops opening up to the spacious and bright family room expanding to a two story morning room. Plenty of space to get work done in your separate study with double doors right off the entry way. The Primary Suite features a private bath with a stunning aesthetic, split vanity, soaking tub, shower and walk-in closet. With plenty of storage and room to create in the unfinished basement, you'll never need another storage unit again. This property truly represents the best of contemporary living in a highly desirable location. Don't miss your chance to call this exceptional residence your own! *Reverse Osmosis system and Radon System Included*

3020 Toulouse Drive, Union

$560,000
5 Beds 5 Baths 633808 MLS
Tucked on a quiet cul-de-sac in the desirable Hearthstone neighborhood, this spacious 5-bedroom home is move-in ready and packed with features you'll love. The main level offers a formal dining room with hardwood floors, a living room, a cozy family room with fireplace, and a private study...perfect for working from home. The gorgeous kitchen with granite countertops is the heart of the home. Upstairs you'll find brand new carpet, a huge primary suite, and three full bathrooms—yes, three! The finished lower level adds even more living space with a theater room, wet bar, and brand new carpet. Step outside to a covered back patio and fenced yard, ready for summer barbecues or lazy weekends. The 3-car garage provides plenty of storage, and the neighborhood? It's a winner...Hearthstone features a stunning pool, multiple play areas, and community charm that's hard to beat. This home truly has it all—space, style, and location. Don't wait!

2085 Blankenbecker Drive, Florence

$1,125,000
5 Beds 4 Baths 633768 MLS
This custom-built ranch estate offers expansive luxury, boasting over 6,000 square feet of living space with custom wood work through out. Custom hand built wood cabinets and the beautiful wood beamed ceilings that can be seen throughout the large open floor plan. Equipped with a 3 zone Geothermal cooling and heating system! This amazing home sits on a scenic 10.5-acre property. It includes a separate garage/storage building perfect for all your toys or an RV. This building is also fully equipped with a two-bedroom apartment with its own private entrance-and own septic system perfect for guests or rental income. Outdoor amenities include a beautiful inground saltwater pool, an outdoor fireplace, and a cozy firepit, ideal for entertaining year-round. Inside, the lower level features a wet bar and a theater room! The large decks and front porch have new composite decking! This home has everything you need!

1845 Stephenson Mill Road, Verona

$850,000
4 Beds 5 Baths 633512 MLS
Welcome to this extraordinary, fully updated luxury home featuring 4 spacious bedrooms and 4.5 baths, including a stunning first-floor primary suite with vaulted ceiling and serene ensuite. The remodeled kitchen is a chef's dream with a large island, breakfast bar, granite countertops, stainless appliances, and gas cooktop. Elegant tray ceilings, crown molding, and custom finishes elevate every room. The spectacular finished walkout lower level impresses with LVP flooring, a full kitchen, custom wet bar, fireplace, built-ins, and shiplap accents. Step outside to your private oasis: saltwater pool, lush landscaping, fire pit, garden and expansive patio. Whole-home generator, new roof, HVAC, HWH, sump pump, and home theatre system wired surround sound inside and out. Luxury living at its finest, every detail thoughtfully designed and beautifully maintained.

2619 Twin Hills Court, Union

$677,000
4 Beds 3 Baths 633475 MLS
COMPARE TO NEW! Remarkable, Ranch Home with APPROX 4000 SQ FT of Livable Space Including Finished Lower Level/4 BDRM, 3 Full Bath, 3 Car Garage Residence on an APPROX 1/2 Acre Premium Homesite in Red Stone Village! Perfectly Appointed at the End of a Beautiful Cul-De-Sac Street Backing Up to LASSING POINTE GOLF COURSE/Award Winning New Haven, Gray, & Ryle Schools/Low County Tax Rate/Covered Front Porch, Massive Rear Deck, & Hard to Find Private Setting/Open Airy Floorplan w/Lots of Natural Light/Elaborate Moldings/Soaring, 9 FT Ceilings Throughout/Hardwood Flooring/Desirable Design with Inviting GREAT RM Boasting Stone Fireplace & Wall of Windows/Spectacular, Gourmet KIT w/Granite Counters, Counter Bar, Gas Range, Stainless Steel Appliances, Staggered Cabinetry w/ Crown Molding, + Oversized Breakfast Area/1ST FL Laundry RM/Butler's Pantry/Amazing Primary Suite with Corner Windows & Adjoining Deluxe, Luxury Bath/Large Walk-In Closet with Closet Organizers/FINISHED LL w/Wet Bar in Pub Room, Recreation RM w/Walkout, True 4TH BEDROOM w/Closet & Egress Window, Adjacent Full Bath, + Tons of Storage/Oversized Windows/Silhouette Blinds//Lots of Recessed Lighting Throughout/ + MUCH MORE!

2563 Twin Hills Court, Union

$525,000
6 Beds 5 Baths 633433 MLS
Stunning 6-bedroom, 5-bath home located in the heart of Hebron, KY, offering three fully finished levels of exceptional living space. This home features an open-concept layout with a spacious living room, cozy fireplace, and a beautiful updated kitchen complete with a nice island for all your storage and hosting needs. Walk out from the breakfast nook to a large deck overlooking an immaculate backyard oasis with gorgeous landscaping and plenty of space for outdoor entertaining. The finished basement includes a recreational room, bonus room, and bath to easily make guests feel right at home. The luxurious primary suite boasts a spa-like private bath with a double vanity, separate shower, and tons of natural light with a massive walk-in closet. Additional highlights include first-floor laundry, a beautiful open foyer and so many options for entertainment/living rooms. Located in the desirable Thornewilde Neighborhood with easy access to I-71/75 and 2 community pools. Move-in ready with every feature you could want-this one has it all!

1413 Stoneyhollow Court, Hebron

$558,000
4 Beds 3 Baths 633401 MLS
Discover your dream home in the picturesque Red Stone Village! This stunning 4-bedroom, 3-bath residence offers nearly half an acre of beautifully landscaped space, with breathtaking views in every direction. Step inside to a dramatic 2-story foyer that flows past a formal living room or study and an elegant dining area, leading into the heart of the home—a spectacular great room with a soaring wall of windows that fills the space with natural light. The open-concept kitchen is ideal for entertaining, featuring a large center island, a spacious pantry, and quality finishes throughout. Upstairs, retreat to your expansive primary suite, complemented by three additional generously sized bedrooms. Additional highlights include a 3-car tandem side-entry garage, a full basement with a bath rough-in ready for your finishing touch, and ample room to grow. Located in the award-winning Ryle School District, this home truly has it all—style, space, and an unbeatable location. Don't miss your chance to call this exceptional property home—schedule your showing today!

2649 Twin Hills Court, Union

$715,000
4 Beds 4 Baths 633400 MLS
Step Into A Masterpiece*5,000 SF Of Luxurious Living Space Awaits*Featuring 3 Finished Levels, This Home Is Designed To Impress & Entertain* The Heart Of The Home Lies A Truly Unique Kitchen, Showcasing Reclaimed Brick From A Historic Church in NYC, Exuding Character & Warmth*For The Young At Heart, There's A Custom-Designed Mario Brothers Gaming Room, Perfect For Endless Fun & Competition* Designed By The Renowned Danielle Harris, This Home Is A True Showstopper*The Master Suite Rivals Any Ritz Carlton Experience, Featuring 2 Levels, An Exquisite Tray Ceiling, & An OnSuite To Die For*Venture To The Basement, Where You'll Be Transported To An Underground Speakeasy That's Perfect For Entertaining*Unwind In The Charming Brick Archway Gallery, Where You Can See The Columns Wrapped In Patina Copper From The Netherlands*Settle Into The Luxurious Family Sectional To Take In A Movie On The Big Screen, Or Drift Off To Sleep On The Inviting Recessed Lounge Bed*You Will Never Want To Leave This Space*Showcasing All-New Flooring And Fresh Professional Paint Throughout*100k in Upgrades*3 Car Garage*Stocked Private Lake*This Home Is Not Just A Place To Live,It's A Lifestyle*Pure Paradise*

10608 Pegasus Court, Union

$695,000
4 Beds 4 Baths 633366 MLS
Drees Alden floorplan loaded with upgrades on a premium Traemore Overlook lot. Gourmet kitchen with quartz countertops, large island, double ovens, gas cooktop, built-in microwave, walk-in pantry. Main level office. Elegant posts and spindles on main staircase overlooking the impressive two-story great room with stone fireplace. Upgraded flooring on entire main level. Bright sunroom with a vaulted ceiling off of the breakfast room. Enjoy outdoor living from the covered patio and fenced backyard. Spacious oversized game room for entertainment. Private primary suite situated on its own level. Luxurious primary bathroom with double vanity, soaking tub, and tiled walk-in shower. Primary walk-in closet with custom closet system and convenient direct access to laundry room, with utility sink and upgraded cabinets. Three additional bedrooms and hallway bathroom are located on level 4. Bedroom 4 offers the added benefit of an en suite full bath. The 3-car garage is equipped with insulated garage doors, insulated walls, and ceilings, plus oversized driveway. Enjoy fantastic views of the community fountain pond and walking path/park directly across the street. When can you move in?

962 Traemore Place, Union

$430,000
5 Beds 4 Baths 633148 MLS
Wonderful NEW Price! Splish Splash! Just In Time for Summer Fun! If You Enjoy Quality - You'll Love this Rambling Full Brick 2 Story with a Vacationing Back Yard with a Gorgeous Inground Pool & Expansive Entertaining Areas! Formal Areas Plus Nice Gathering Room with Fireplace*Great Kitchen w. 4 Burner/Grill Gas Stove*Granite Tops*Stainless Appliances/Pantry*1st Level Laundry*Rich Hardwood Floors*4/5 Bedrooms on 2nd Level*(5th Bedroom Adjoins Owner's Suite so Great Nursery or Office)*Owner's Bath with Relaxing Jetted Tub*Step In Shower, Dual Vanities & Walk-In*Finished Lower Level Entertaining Room with Wet Bar & Fireplace*Lots of Storage Space! 2 Car Side Entry Garage*One Year Home Warranty Included - Tucked away in Desirable Eagles Landing Development - Yet Just Minutes to I-75/Shopping & Dining! Low Boone County Taxes!

9200 Kelly Louise Drive, Florence

$565,000
4 Beds 4 Baths 632994 MLS
PHENOMENAL 3,600+ TOTAL FINISHED LIVING SQ FT MASTERPIECE w/ 3 Finished Levels, 4-5 Bedrooms, 4 Baths, Study, 2 Car Side Entry Garage, Finished Lower Level, 180 SQ FT Screened-In Porch, + Highly Desirable INGROUND POOL. Superbly Situated on an Upscale PRIVATE Golf Course Homesite in The Links/LIFESTYLE at It's Finest Offering an Absolutely Beautiful Setting & Paradise for Entertaining/Incredible 2 Story Great RM w/Floor to Ceiling Fireplace & Wall of Oversized Windows/Formal DNR/Expansive, Fully Equipped Kitchen w/Granite Counters, Stainless Steel Appliances, Incredible Pantries w/Spice Racks & Organizers, + Nice Breakfast Area w/Single French Patio Door Walkout to Screened-In Porch, Spectacular Pool Area, & Sought Over Golf Course Frontage/Hard to Find 1ST FL Primary BDRM Suite w/Stunning Luxury Shower Panel w/Rainfall, Massage Jets, & Handheld Shower System, ONE OF A KIND-13x8 Walk-In Closet, + Balcony Overlooking Rear Lot & Pool/1ST Floor Laundry RM/All Generously Sized Rooms/Finished Lower Level w/Recreation RM, 2ND Fireplace, Full Bath, Hobby RM (Potential 5TH BDRM - no window) & Storage Area/Closet Organizers/6 Panel Solid Core Wood Doors/LOW COUNTY TAX RATE/+ MUCH MORE!

6960 Glen Arbor Drive, Florence

$610,000
4 Beds 5 Baths 632879 MLS
Beautiful executive home boasts 4 large BR's, 3 full & 2 half baths. Located in prestigious Du Monde in Orleans South and Cooper school district. Beautiful wood floors throughout most of first and second floors, w/soft carpet where desired in Family Room & bsmnt Great Room. Walk through the lited front door into a large entry way w/detailed moldings, leading to Formal Living Room & Dining Room. Walk ahead to the grand 2 story Family Room with floor to ceiling fireplace. Gourmet kitchen has SS double ovens, stovetop, MW, island, and lots of beautiful upgraded maple cabinets with stone countertops & tiled backsplash--with a huge pantry! Office or flex room too! The laundry room has matching cabinets & 1 year new Front Load Washer and Dryer. Upstairs you'll find elegant Primary Suite w/sitting area & huge WIC, double vanities, shower & soaking tub. Each BR has WIC, and one BR has it's own private bath. There's a third level to enjoy--the Basement is a walkout w/a spacious open room & half bath, that can be expanded to full. AC is new in 2023. The back yard is an entertainer's dream, expansive deck and a fenced in yard. There's nothing more you need!

8665 Marais Drive, Union

$600,000
6 Beds 5 Baths 632727 MLS
A truly remarkable, 6 bedrm, 4 full bathrms and 1 half bath located in the French Quarter at Orleans North! Step inside to be greeted by a soaring 2 story entry offering hardwood floors. Spacious living room and formal dining room with an added touch of crown molding and chair rail. Hot water heater May 2025. ROOF 2023. Entertain in the expansive kitchen remodeled in 2020. Beautiful oversized butcher block island, MARBLE countertops, DOUBLE OVENS, 2 pantries, counter bar, wood cabinets, ceramic tile flooring and breakfast area. Walk out on the deck from the breakfast/kitchen area to enjoy that fresh cup of coffee every morning! Natural light pours in at ever turn with the abundance of windows you'll find throughout the 1st floor. 1ST FLOOR GUEST SUITE w/adjoining FULL bathrm and WIC. Gas fireplace in family room. Upstairs you will find 5 bedrms and 3 full bathrms. Find retreat in the master suite with sitting room, HUGE WIC and primary en suite offering double vanities, linen closet, ceramic tile flooring, soaking tub and shower with bench. Unfinished basement has over 2200 sq. ft. of usable space w/walk out and half bath rough in. Quick walk to the pool or park! Welcome home!

8394 Saint Louis Boulevard, Union

$505,000
3 Beds 4 Baths 632677 MLS
Open Friday 5-7! Simply Gorgeous! The Perfect Lifestyle~Low Maintenance Full Brick/Stone Wrap Patio Home! Drees Sarasota Plan*Easy 1st Flr Living w. 2nd Level Loft/Bedrm #3/Full Bath & Study or Hobby Rm*Finished Lower Level w Rec Rm, Full Bath, Tons of Storage & Rm for Possible 4th Bedrm/Workout Space/Media Rm or Workshop! Wonderful Open Floor Plan w. Cathedral Ceilings, Lots of Large Windows for Natural Lighting, Deluxe Kitchen w. Large Granite Island/Tiled Backsplash, Gas Cooktop*Stainless Appliances & Walk-In Pantry*Owner's Suite w. Adjoining Bath w. Dual Sink Vanity, Tiled Step In Shower*Spacious Walk-In Closet*2nd Bedrm & Full Bath on 1st Level*Formal Dining or ''Flex'' Rm*1st Flr Laundry w. Utility Sink/Cabinets*Easy Care Luxury Vinyl Plank Flooring*Designer Lighting & Finishes*Built In Sound System/Freshly Painted Thruout*Custom Blinds*Relaxing Covered Patio w. Extended Grilling Area*Mature Trees Added for Privacy*Small HOA Fee Covers Yard Maintenance & Snow Removal & Garbage*One of a Kind ''Harmony'' Community w. Elaborate Pools, Clubhouse, Walking Trails, Lakes & Private Park-All Just Minutes to Shopping/Dining & Entertainment! Could Work for Shared Living-A Home for Al

1513 Sweetsong Drive, Union