


Listing Courtesy of: NORTHERN KENTUCKY / Coldwell Banker Realty / Diana Pfaff  
1042 Spectacular Bid Drive Union, KY 41091
      Active        (35 Days)  
  
$654,000            (USD)    
  
      MLS #:
      
      
635600
      635600
        Lot Size
        
        
0.36 acres
      0.36 acres
        Type
        
        
Single-Family Home
      Single-Family Home
        Year Built
        
        
2003
      2003
        Style
        
        
Traditional
      Traditional
        Views
        
        
True
      True
        County
        
        
Boone County
    
  Boone County
Listed By
Diana Pfaff, Coldwell Banker Realty
  Source
NORTHERN KENTUCKY
Last checked Oct 31 2025 at 6:31 AM GMT+0000
            NORTHERN KENTUCKY
Last checked Oct 31 2025 at 6:31 AM GMT+0000
        Bathroom Details
        
        
      - Full Bathrooms: 4
- Half Bathroom: 1
        Interior Features
                  
      - Dishwasher
- Microwave
- Refrigerator
- Stainless Steel Appliance(s)
- Electric Cooktop
- Double Oven
        Lot Information
                  
      - Level
- Sloped
- Wooded
        Property Features
        
        
      - Fireplace: Gas
- Foundation: Poured Concrete
        Heating and Cooling
                  
        - Natural Gas
- Central Air
          Basement Information
          
          
      - Full
- Finished
- Walk-Out Access
- Storage Space
- Full Finished Bath
- Fireplace(s)
        Homeowners Association Information
        
        
  - Dues: $475/ANNUALLY
            Utility Information
            
            
    - Sewer: Public Sewer
            School Information
            
            
      - Elementary School: Shirley Mann School
- Middle School: Gray Middle School
- High School: Ryle High
        Parking
        
        
      - Driveway
- Garage
- Garage Door Opener
- Attached
- Garage Faces Side
        Living Area
        
        
  - 4,200 sqft
  Location
  
  
  
Disclaimer: Copyright 2025 Northern Kentucky MLS. All rights reserved. This information is deemed reliable, but not guaranteed. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated 10/30/25 23:31
    
 
           
           
      
Description