$654,000

1042 Spectacular Bid Drive, Union, KY 41091

5 beds |
5 baths |
4,200 sqft

Single-Family Home
Built in 2003
0.36acre lot
3 car garage
$156/sqft
Listed 2 months ago

Property Description

$$$$$ LOOKING FOR EXTRA CASH FOR CHRISTMAS? VISIT OUR OPEN HOUSE THIS SUNDAY, NOVEMBER 9TH FROM 1-3pm FOR A CHANCE TO WIN! WE ARE GIVING AWAY 4-$100.00 VISA GIFT CARDS AND 3-$50.00 VISA GIFT CARDS! Immediate Occupancy! The perfect blend of luxury and comfort in this custom-built masterpiece, gracefully positioned on a cul-de-sac street with tranquil views of a scenic pond. Surrounded by lush landscaping and a backyard oasis, peaceful retreat in the heart of the prestigious Triple Crown Golf and Country Club community. Graced by a grand two-story foyer where natural light pours into an open-concept design that exudes warmth and sophistication. Boasting rich hardwood flooring, high ceilings, and elegant finishes throughout. 5 spacious bedrooms (5th Bedroom is located on first floor), five baths, study, and a finished walkout lower level. Every detail has been meticulously maintained, allowing you to move in and immediately enjoy the lifestyle this home affords. Just minutes to top-rated schools, shopping, dining, recreation, interstates, the airport, and downtown Cincinnati. Convenient to our new Union Promenade featuring retail, restaurants and our award winning Children's Hospital.

Listing Status:: Active
Listing Office:: Coldwell Banker Realty FM : 859-341-9000
Listing Agent:: Diana Pfaff : 859-640-1860
MLS ID:: 635600

General: Wet BarCeiling Fan(s)Recessed LightingMulti Panel DoorsHigh CeilingsRecess Ceiling(s)BookcasesBuilt-in FeaturesChandelierDouble VanityEntrance FoyerGranite CountersKitchen IslandOpen FloorplanPantrySoaking TubStorageTray Ceiling(s)Walk-In Closet(s)Pocket Door(s)
Appliances: Double OvenDishwasherMicrowaveRefrigeratorStainless Steel Appliance(s)Electric Cooktop
Laundry: Electric Dryer HookupMain LevelWasher HookupLaundry Room
Basement: FullFireplace(s)Walk-Out AccessFull Finished BathFinished
A/C: Central Air
Heating: Natural Gas
Fireplace: GasFireplaceFireplaces: 2

General: Fire PitPrivate Yard
Style: Traditional
Parking: AttachedDrivewayGarage Faces SideGarage Door OpenerGarage

Roofing: Shingle
Windows: Insulated WindowsWood FramesAluminum Clad Window(s)
General: BrickStoneVinyl SidingTwoConcrete Perimeter

Road/Access: City Street
HOA Amenities: Association FeesManagement475.0Annually
Originating MLS: Northern Kentucky Multiple Listing Service
School District: Boone Co Public
County: Boone

Zoning: 064.04-07-339.00
View: Trees/WoodsPondView

Utilities: Cable Available
Water: Public
Sewer: Public Sewer

Source: Northern Kentucky Multiple Listing Service

This listing courtesy of Diana Pfaff, Coldwell Banker Realty FM

Monthly Payment

$Est. Payment

Principal & Interest $
Property Taxes $
Home Insurance $
VA Funding Fee $

Ready to Start a VA Loan?

Get Started

NMLS #1907 ^†

Get Prequalified »

Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Schools Nearby

Shirley Mann Elementary School

10435 US Highway 42, Union, KY, 41091

Grades PK-5

1.11 miles away

Gray Middle School

10400 US 42, Union, KY, 41091

Grades 6-8

0.93 miles away

Larry A. Ryle High School

10379 US 42, Union, KY, 41091

Grades 9-12

0.87 miles away

Disclaimer: School and School District information courtesy of the National Center for Education Statistics (NCES). School boundaries may change. Proximity to listed schools does not guarantee enrollment eligibility. Contact the school district for more information and exact boundaries.