$470,000 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. 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
$387,700 Just in time for the new school year in Ryle school district! You'll love this finished three-level home with 5 bedrooms, 3 1/2 baths, and a fenced-in back yard. Have no fear, you can move right in with fantastic stainless steel appliances & LVT flooring, both just 3 years old, along with a 2-year old HVAC, recent fencing and a NEW roof completed in 2024, and a 2019 water heater. The second floor laundry is convenient for the 3 bedrooms and large primary suite. The 5th bedroom in the finished lower level has a walk-in closet and a full bath located just off the recreation room, making this a fantastic layout for extra hang out space. This is one you won't want to miss. 5 Beds ⋅ 4 Baths ⋅ 633898 MLS Just in time for the new school year in Ryle school district! You'll love this finished three-level home with 5 bedrooms, 3 1/2 baths, and a fenced-in back yard. Have no fear, you can move right in with fantastic stainless steel appliances & LVT flooring, both just 3 years old, along with a 2-year old HVAC, recent fencing and a NEW roof completed in 2024, and a 2019 water heater. The second floor laundry is convenient for the 3 bedrooms and large primary suite. The 5th bedroom in the finished lower level has a walk-in closet and a full bath located just off the recreation room, making this a fantastic layout for extra hang out space. This is one you won't want to miss. 9070 Braxton Drive, Union
$504,000 Gorgeous well cared for home with many updates. This home features beautiful hand scraped hardwood floors on the first floor along with very pretty LVP floors on stairs and throughout the upstairs. Enjoy winters by the impressive stone fireplace in your two story great room. Lower level features more LVP flooring throughout with a walk out to your beautiful patio and fenced in backyard. Brand new trek deck also makes this backyard a big plus! Too many other features to mention, this home is a must see!!! 4 Beds ⋅ 4 Baths ⋅ 633865 MLS Gorgeous well cared for home with many updates. This home features beautiful hand scraped hardwood floors on the first floor along with very pretty LVP floors on stairs and throughout the upstairs. Enjoy winters by the impressive stone fireplace in your two story great room. Lower level features more LVP flooring throughout with a walk out to your beautiful patio and fenced in backyard. Brand new trek deck also makes this backyard a big plus! Too many other features to mention, this home is a must see!!! 9799 Melody Drive, Union
$1,029,000 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! 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 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 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 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! 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 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* 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
$564,235 Stylish new Grandin plan by Fischer Homes in beautiful Justify at Triple Crown featuring a gorgeous kitchen with stainless steel appliances, upgraded cabinetry with soft close hinges, gleaming granite counters, pantry, and walk-out breakfast room all open to the dramatic two-story family room. Casual living room just off the kitchen could function as a formal dining room. Private 1st floor study with double doors. Upstairs primary suite with an en suite that includes a double bowl vanity, walk-in shower, water closet and a huge walk-in closet. There are 3 additional secondary bedrooms and a centrally located hall bathroom. Full basement and a 2 bay garage. 4 Beds ⋅ 3 Baths ⋅ 633718 MLS Stylish new Grandin plan by Fischer Homes in beautiful Justify at Triple Crown featuring a gorgeous kitchen with stainless steel appliances, upgraded cabinetry with soft close hinges, gleaming granite counters, pantry, and walk-out breakfast room all open to the dramatic two-story family room. Casual living room just off the kitchen could function as a formal dining room. Private 1st floor study with double doors. Upstairs primary suite with an en suite that includes a double bowl vanity, walk-in shower, water closet and a huge walk-in closet. There are 3 additional secondary bedrooms and a centrally located hall bathroom. Full basement and a 2 bay garage. 628 Winstar Court, Union
$680,524 New Construction in the beautiful community of Ballyshannon, featuring the Wyatt Nantucket Retreat plan. This designer floorplan offers an open-concept kitchen with island, pantry, lots of cabinet space and quartz countertops. Family room with fireplace expands to light-filled morning room. Private study with French doors off of entry foyer. Upstairs owner's suite with attached private bath featuring dual vanity sinks, ceramic tile floors, walk-in shower, and oversized walk-in closet. Three additional bedrooms, hall bath, and second floor laundry room. Full finished basement with full bath and wet bar. Attached three car garage. 4 Beds ⋅ 4 Baths ⋅ 633558 MLS New Construction in the beautiful community of Ballyshannon, featuring the Wyatt Nantucket Retreat plan. This designer floorplan offers an open-concept kitchen with island, pantry, lots of cabinet space and quartz countertops. Family room with fireplace expands to light-filled morning room. Private study with French doors off of entry foyer. Upstairs owner's suite with attached private bath featuring dual vanity sinks, ceramic tile floors, walk-in shower, and oversized walk-in closet. Three additional bedrooms, hall bath, and second floor laundry room. Full finished basement with full bath and wet bar. Attached three car garage. 5004 Loch Drive, Union
$850,000 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. 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 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! 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
$447,500 Accepting Back Up Offers. Lg 5 bedrooms, 4 bath's layout. 1st floor bedroom with full bath for multi generational living, 3086 sq feet 1st two levels.with room to grow, basement has a full bath rough in, fenced yard with fruit trees, community pool and clubhouse, walking distance to entertainment, dining & shopping. Two staircases, desired open kitchen/2 story great room/dining room concept plan. 1st floor & 2nd floor family rooms, gas stove, newer kitchen appliances, 1st floor laundry room, updated shingles 2019, heating, cooling 2020 & hotwater heater, basement has a full bath rough in, All information is believed to be accurate but not guaranteed. 5 Beds ⋅ 4 Baths ⋅ 633443 MLS Accepting Back Up Offers. Lg 5 bedrooms, 4 bath's layout. 1st floor bedroom with full bath for multi generational living, 3086 sq feet 1st two levels.with room to grow, basement has a full bath rough in, fenced yard with fruit trees, community pool and clubhouse, walking distance to entertainment, dining & shopping. Two staircases, desired open kitchen/2 story great room/dining room concept plan. 1st floor & 2nd floor family rooms, gas stove, newer kitchen appliances, 1st floor laundry room, updated shingles 2019, heating, cooling 2020 & hotwater heater, basement has a full bath rough in, All information is believed to be accurate but not guaranteed. 2207 Bourbon Street, Union
$510,403 Trendy new Avery Cambridge Cottage plan by Fischer Homes in beautiful Justify at Triple Crown. This multi level home features a stunning island kitchen with stainless steel appliances, oak cabinetry with 42 inch uppers and soft close hinges, durable quartz counters, walk in pantry and walk-out breakfast room all open to the dramatic 2-story family room. Rec room on step-down level. Primary Suite, on private upper level, with an en suite that includes a double bowl vanity, soaking tub, separate shower and HUGE walk-in closet. There are 3 additional bedrooms and hall bathroom on top floor. Convenient upstairs laundry room. Full basement with full bath rough in. 2 bay garage. 4 Beds ⋅ 3 Baths ⋅ 633430 MLS Trendy new Avery Cambridge Cottage plan by Fischer Homes in beautiful Justify at Triple Crown. This multi level home features a stunning island kitchen with stainless steel appliances, oak cabinetry with 42 inch uppers and soft close hinges, durable quartz counters, walk in pantry and walk-out breakfast room all open to the dramatic 2-story family room. Rec room on step-down level. Primary Suite, on private upper level, with an en suite that includes a double bowl vanity, soaking tub, separate shower and HUGE walk-in closet. There are 3 additional bedrooms and hall bathroom on top floor. Convenient upstairs laundry room. Full basement with full bath rough in. 2 bay garage. 505 Coolmore Court, Union
$558,000 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! 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 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* 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
$629,000 Check out this amazing Clay floorplan by Fischer Homes in the heart of Triple Crown! Located on a quiet cul-de-sac, this 4-bedroom, 4.5-bath home has all the space you need—with an open, flexible layout that works great for both everyday living and entertaining. Finished, walk-out basement with a full bath*Hardwood Flooring through out*Granite countertops*Stainless Steel appliances *Fenced in yard*Synthetic maintenance free deck*Primary bathroom remodeled just last year*Two primary walk-in closets with custom closet system*4th bedroom has en suite bathroom*3-car garage*Front room could be used as a dining room or office. Just minutes from golf, dining, and shopping—this one's a must-see! 4 Beds ⋅ 5 Baths ⋅ 633371 MLS Check out this amazing Clay floorplan by Fischer Homes in the heart of Triple Crown! Located on a quiet cul-de-sac, this 4-bedroom, 4.5-bath home has all the space you need—with an open, flexible layout that works great for both everyday living and entertaining. Finished, walk-out basement with a full bath*Hardwood Flooring through out*Granite countertops*Stainless Steel appliances *Fenced in yard*Synthetic maintenance free deck*Primary bathroom remodeled just last year*Two primary walk-in closets with custom closet system*4th bedroom has en suite bathroom*3-car garage*Front room could be used as a dining room or office. Just minutes from golf, dining, and shopping—this one's a must-see! 1392 Ponder Court, Union
$695,000 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? 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
$431,735 New Construction by Fischer Homes in the beautiful Ballyshannon community with the Wilmington plan, featuring a stunning kitchen with pantry, lots of cabinet space and granite countertops. Walkout family room expands to open dining space. Private study with double doors. Primary Suite with private bath and walk-in closet. Additional secondary bedroom and hall bath. Upstairs features 3rd bedroom with full bath, and loft area. Two car garage. 3 Beds ⋅ 3 Baths ⋅ 633354 MLS New Construction by Fischer Homes in the beautiful Ballyshannon community with the Wilmington plan, featuring a stunning kitchen with pantry, lots of cabinet space and granite countertops. Walkout family room expands to open dining space. Private study with double doors. Primary Suite with private bath and walk-in closet. Additional secondary bedroom and hall bath. Upstairs features 3rd bedroom with full bath, and loft area. Two car garage. 2300 O'Clery Avenue, Union
$661,000 Stylish new Finley plan by Fischer Homes in beautiful Ballyshannon featuring a welcoming covered front porch. Once inside you'll find a private study with double door. Open concept with an island kitchen with built-in stainless steel appliances, upgraded maple cabinetry with 42 inch uppers and soft close hinges, durable quartz counters, walk-in pantry and walk-out breakfast room to the deck and all open to the dramatic 2 story family room with gas fireplace. 1st floor primary suite with tray ceiling and an ensuite with a double bowl vanity, walk-in shower and large walk-in closet with laundry room access for easy laundry days. Upstairs you'll find the 2 remaining bedrooms each with a walk-in closet, a centrally located full bathroom and loft. Full basement with full bath rough-in and a 2 bay side load garage. 3 Beds ⋅ 3 Baths ⋅ 633293 MLS Stylish new Finley plan by Fischer Homes in beautiful Ballyshannon featuring a welcoming covered front porch. Once inside you'll find a private study with double door. Open concept with an island kitchen with built-in stainless steel appliances, upgraded maple cabinetry with 42 inch uppers and soft close hinges, durable quartz counters, walk-in pantry and walk-out breakfast room to the deck and all open to the dramatic 2 story family room with gas fireplace. 1st floor primary suite with tray ceiling and an ensuite with a double bowl vanity, walk-in shower and large walk-in closet with laundry room access for easy laundry days. Upstairs you'll find the 2 remaining bedrooms each with a walk-in closet, a centrally located full bathroom and loft. Full basement with full bath rough-in and a 2 bay side load garage. 8501 Robert Grant Drive, Union
$690,000 A meticulously-maintained masterpiece, this Drees Naples offers comfort, convenience, and charm at every turn. Step-free living awaits on the main level with all the space and features you could need. A chef's kitchen complete with quartz, built in appliances, a gas cooktop, and plenty of cabinet space with soft-close slides and hinges. Additionally, you'll find a well appointed full bath, guest room and office. A comfortable dining space, generous living room with gorgeous stacked stone gas fireplace, a laundry space, and mudroom. The primary bedroom is fit for ultimate relaxation with its luxurious ensuite that rivals most spas and custom built in closets! Need more space? The finished LL is the perfect place to unwind featuring a fully custom bourbon inspired wet-bar/kitchenette complete with appliances, 9' ceilings, open living space, a full bathroom and 2 more generous bedrooms. Out back you'll find 2 covered patios, a huge, perfectly manicured lawn complete with irrigation, and massive 3-car garage with epoxy floors. Too many upgrades to mention, this is not be missed! 4 Beds ⋅ 3 Baths ⋅ 633192 MLS A meticulously-maintained masterpiece, this Drees Naples offers comfort, convenience, and charm at every turn. Step-free living awaits on the main level with all the space and features you could need. A chef's kitchen complete with quartz, built in appliances, a gas cooktop, and plenty of cabinet space with soft-close slides and hinges. Additionally, you'll find a well appointed full bath, guest room and office. A comfortable dining space, generous living room with gorgeous stacked stone gas fireplace, a laundry space, and mudroom. The primary bedroom is fit for ultimate relaxation with its luxurious ensuite that rivals most spas and custom built in closets! Need more space? The finished LL is the perfect place to unwind featuring a fully custom bourbon inspired wet-bar/kitchenette complete with appliances, 9' ceilings, open living space, a full bathroom and 2 more generous bedrooms. Out back you'll find 2 covered patios, a huge, perfectly manicured lawn complete with irrigation, and massive 3-car garage with epoxy floors. Too many upgrades to mention, this is not be missed! 1517 Bailey Court, Union
$707,000 Some photos have been virtually staged. New Construction by Fischer Homes in the beautiful Justify at Triple Crown community with the Greyson plan, featuring a stunning kitchen with pantry, lots of cabinet space and quartz countertops. Family room with fireplace expands to light-filled morning room, which has walk out access to the covered patio. Dining room off entryway. Upstairs features Primary suite with attached bath and walk in closet. Bedrooms 2 & 3 share bathroom and bedroom 4 has hall bathroom. Unfinished basement with full bath rough-in. Attached three car garage. 4 Beds ⋅ 4 Baths ⋅ 633181 MLS Some photos have been virtually staged. New Construction by Fischer Homes in the beautiful Justify at Triple Crown community with the Greyson plan, featuring a stunning kitchen with pantry, lots of cabinet space and quartz countertops. Family room with fireplace expands to light-filled morning room, which has walk out access to the covered patio. Dining room off entryway. Upstairs features Primary suite with attached bath and walk in closet. Bedrooms 2 & 3 share bathroom and bedroom 4 has hall bathroom. Unfinished basement with full bath rough-in. Attached three car garage. 1515 Authentic Court, Union
$455,000 Welcome home to the Drees Ashton model in Hawk's Landing ,Union Ky. This beautiful two story home boasts of a stunning front porch, 4 bedrooms, 3.5 baths, kitchen with granite countertops, stainless steel appliances, island, lots of cabinet space and a walkout to a large deck overlooking a spacious backyard. Primary bedroom with high ceilings, adjoined primary bathroom with double vanity, separate shower, walk in closet that can also be used as a dressing room. Remaining 3 bedrooms each offers walk-in-closets , wall to wall carpeting and a nearby loft. Entertain in the full finished basement with full bath and walk out to patio. This home is located in a cul-de-sac. Hurry dont let this one get away. All room sizes are approximate. Buyer to verify tax rates and schools. 4 Beds ⋅ 4 Baths ⋅ 633125 MLS Welcome home to the Drees Ashton model in Hawk's Landing ,Union Ky. This beautiful two story home boasts of a stunning front porch, 4 bedrooms, 3.5 baths, kitchen with granite countertops, stainless steel appliances, island, lots of cabinet space and a walkout to a large deck overlooking a spacious backyard. Primary bedroom with high ceilings, adjoined primary bathroom with double vanity, separate shower, walk in closet that can also be used as a dressing room. Remaining 3 bedrooms each offers walk-in-closets , wall to wall carpeting and a nearby loft. Entertain in the full finished basement with full bath and walk out to patio. This home is located in a cul-de-sac. Hurry dont let this one get away. All room sizes are approximate. Buyer to verify tax rates and schools. 540 Miles Court, Union
$650,000 PENDING WHEN SUBMITTED,Triple Crown Beauty! Lakeside home and view of #9 tee and fairway across the water! So pretty! Exceptionally well maintained home with tons of amenities! With a fireplace on first floor and a second one in lower level you'll have multiple places to entertain or just have some separate areas to peace out! Wide open kitchen area has walkout to covered and screened area of deck. Nice updates throughout, hardwood on first floor, newer HVAC and windows (with warranty to next owner!) Gorgeous first floor family room with soaring ceiling! Absolute must see! 4 Beds ⋅ 4 Baths ⋅ 633073 MLS PENDING WHEN SUBMITTED,Triple Crown Beauty! Lakeside home and view of #9 tee and fairway across the water! So pretty! Exceptionally well maintained home with tons of amenities! With a fireplace on first floor and a second one in lower level you'll have multiple places to entertain or just have some separate areas to peace out! Wide open kitchen area has walkout to covered and screened area of deck. Nice updates throughout, hardwood on first floor, newer HVAC and windows (with warranty to next owner!) Gorgeous first floor family room with soaring ceiling! Absolute must see! 1000 Dustwhirl Drive, Union
$437,731 New Construction by Fischer Homes in the beautiful Ballyshannon community with the Yosemite plan, featuring a stunning kitchen with lots of cabinet space and upgraded countertops. Family room expands to light-filled morning room. Study room off entry foyer. Primary Suite with private bath and walk-in closet. 3 additional bedrooms, convenient upstairs laundry, and hall bath. Full walkout unfinished basement with full bath rough-in. Two car garage. 3 Beds ⋅ 3 Baths ⋅ 633046 MLS New Construction by Fischer Homes in the beautiful Ballyshannon community with the Yosemite plan, featuring a stunning kitchen with lots of cabinet space and upgraded countertops. Family room expands to light-filled morning room. Study room off entry foyer. Primary Suite with private bath and walk-in closet. 3 additional bedrooms, convenient upstairs laundry, and hall bath. Full walkout unfinished basement with full bath rough-in. Two car garage. 4204 Rosslare Lane, Union
$550,000 It's your LUCKY DAY! Motivated Sellers offering fantastic INTEREST RATE BUY DOWN incentive! Call listing agent for details. NO STEP FULLY UPDATED MOVE IN READY ALL BRICK RANCH, 3.5acres! Awesome covered porches w/concrete patio & privacy fence. Home features 3bdr + 3 full ba w/finished walk-out basement, NEW LVP floors, fresh paint, natural wood accents, newer components, dimensional roof, wood fireplace, ('24)Updated kitchen-NEW EVERYTHING: leather granite, loads of countertop space, LVP, hickory cabinets, SS appliances, stone & metal wall accents, cathedral ceilings. Laundry on main floor. ('18)Added basement full bath w/walk-in shower, dual shower heads & handheld nozzles.('21)Updated owner's & hall bath. Owner's Suite: Vaulted ceiling, bath adjoins, large walk in closet with built-ins & towel warmer. Owner's bath features custom walk-in shower w/dual rain heads & handheld nozzles. 4 metal outbuildings: 56x70 Metal Barn/Shop w/15x40 lean-to & 4 garage bays & openers, 2 half baths, concrete floors, 150 amp electric, heat, water, 452 sqft FINISHED office/apartment space. 20x20 metal Carport. 20x30 Metal Outbuilding w/electric service & garage door. 30x30 metal barn 3 Beds ⋅ 5 Baths ⋅ 632975 MLS It's your LUCKY DAY! Motivated Sellers offering fantastic INTEREST RATE BUY DOWN incentive! Call listing agent for details. NO STEP FULLY UPDATED MOVE IN READY ALL BRICK RANCH, 3.5acres! Awesome covered porches w/concrete patio & privacy fence. Home features 3bdr + 3 full ba w/finished walk-out basement, NEW LVP floors, fresh paint, natural wood accents, newer components, dimensional roof, wood fireplace, ('24)Updated kitchen-NEW EVERYTHING: leather granite, loads of countertop space, LVP, hickory cabinets, SS appliances, stone & metal wall accents, cathedral ceilings. Laundry on main floor. ('18)Added basement full bath w/walk-in shower, dual shower heads & handheld nozzles.('21)Updated owner's & hall bath. Owner's Suite: Vaulted ceiling, bath adjoins, large walk in closet with built-ins & towel warmer. Owner's bath features custom walk-in shower w/dual rain heads & handheld nozzles. 4 metal outbuildings: 56x70 Metal Barn/Shop w/15x40 lean-to & 4 garage bays & openers, 2 half baths, concrete floors, 150 amp electric, heat, water, 452 sqft FINISHED office/apartment space. 20x20 metal Carport. 20x30 Metal Outbuilding w/electric service & garage door. 30x30 metal barn 2977 Hathaway Road, Union
$465,000 This stunning full-brick home is nestled in the desirable Heritage Trails neighborhood of Union, Kentucky. Boasting soaring ceilings and abundant natural light, the home features fresh paint throughout and brand-new flooring on the first floor. A spacious detached garage/workshop adds valuable versatility. Situated on a level, fully fenced lot of over half an acre, the outdoor space is ideal for both relaxation and entertaining. Inside, the home is thoughtfully designed with two dedicated office spaces—perfect for those working remotely. With four generously sized bedrooms and 2.5 bathrooms, this home offers both comfort and functionality. Conveniently located within the award-winning Ryle High School district, the property is just a 3-minute drive to the interstate and Publix Grocery Store, and within walking distance to Triple Crown Country Club. 4 Beds ⋅ 3 Baths ⋅ 632963 MLS This stunning full-brick home is nestled in the desirable Heritage Trails neighborhood of Union, Kentucky. Boasting soaring ceilings and abundant natural light, the home features fresh paint throughout and brand-new flooring on the first floor. A spacious detached garage/workshop adds valuable versatility. Situated on a level, fully fenced lot of over half an acre, the outdoor space is ideal for both relaxation and entertaining. Inside, the home is thoughtfully designed with two dedicated office spaces—perfect for those working remotely. With four generously sized bedrooms and 2.5 bathrooms, this home offers both comfort and functionality. Conveniently located within the award-winning Ryle High School district, the property is just a 3-minute drive to the interstate and Publix Grocery Store, and within walking distance to Triple Crown Country Club. 10836 Secretariat, Union
$400,000 Welcome to 1344 Wilshire Court, a beautifully maintained ranch in the fantastic Harmony subdivision. Built in 2016. 2260+ square feet, featuring 4 bed, 3 full baths & finished lower level. The open-concept main level is perfect for both entertaining or relaxing, while the finished walkout lower level provides additional living space ideal for a recreation room, guest suite, or home office. Enjoy the quiet street in a great location in Union, KY just minutes from schools, shopping, & dining. As part of the Harmony community, you'll also enjoy access to amenities including a clubhouse, community pool, playgrounds & scenic walking trails. 4 Beds ⋅ 3 Baths ⋅ 632929 MLS Welcome to 1344 Wilshire Court, a beautifully maintained ranch in the fantastic Harmony subdivision. Built in 2016. 2260+ square feet, featuring 4 bed, 3 full baths & finished lower level. The open-concept main level is perfect for both entertaining or relaxing, while the finished walkout lower level provides additional living space ideal for a recreation room, guest suite, or home office. Enjoy the quiet street in a great location in Union, KY just minutes from schools, shopping, & dining. As part of the Harmony community, you'll also enjoy access to amenities including a clubhouse, community pool, playgrounds & scenic walking trails. 1344 Wilshire Court, Union
$623,003 New Construction in the beautiful community of Justify at Triple Crown, featuring the Charles Modern Farmhouse plan. This designer floorplan offers an open-concept kitchen with spacious island, convenient pantry, abundant cabinet space and upgraded countertops. Family room expands to light-filled morning room. Living room off entryway. First floor owner's suite with attached private bath featuring dual vanity sinks, walk-in shower, garden tub and oversized walk-in closet. First floor laundry room. Upstaiirs features three additional bedrooms, and hall bath. Full unfinished basement with full bath rough in. Attached two car garage. 4 Beds ⋅ 3 Baths ⋅ 632905 MLS New Construction in the beautiful community of Justify at Triple Crown, featuring the Charles Modern Farmhouse plan. This designer floorplan offers an open-concept kitchen with spacious island, convenient pantry, abundant cabinet space and upgraded countertops. Family room expands to light-filled morning room. Living room off entryway. First floor owner's suite with attached private bath featuring dual vanity sinks, walk-in shower, garden tub and oversized walk-in closet. First floor laundry room. Upstaiirs features three additional bedrooms, and hall bath. Full unfinished basement with full bath rough in. Attached two car garage. 13073 Justify Drive, Union
$610,000 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! 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 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! 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