NOT LISTED FOR SALE

834 Bay Colt Ln Union, KY 41091

Estimated Value: $1,166,885 - $1,350,000

6 Beds
5.5 Baths
4,784 Sq Ft
$264/Sq Ft Est. Value

Last Sold December 19, 2023

Last sale price $1,065,000 $223 Per Sq Ft

Est. 18% increase in value since last sale

Current estimated payment $8,068/month

45 Days on Market

Highlights

  • On Golf Course
  • Spa
  • 0.49 Acre Lot
  • New Haven Elementary School Rated A
  • Eat-In Gourmet Kitchen
  • Open Floorplan

About This Home

As of December 2023

Wait until you see this breathtaking home overlooking the 7th hole in Triple Crown, on a private cul de sac street*6 bedrooms, 5 full and 1 half bathrooms*Oversized garage space including tandem spot holds up to 5 vehicles*Rear 6th garage for potential golf cart storage or lawn equipment*Completely remodeled eat in kitchen with custom cabinetry& upgraded appliances, walk in pantry, granite countertops, hammered copper sink*Open living room with gas fireplace and cathedral ceiling*First floor pub with phenomenal wet bar & stonework & walk out*Dreamy first floor primary bedroom suite-Heated marble flooring throughout bathroom and sizeable walk in closet that walks out to deck!*Fully finished, walk out lower level, complete with wet & dry bars, theater room, and fitness room*Large composite deck and patio ideal for entertaining features outdoor kitchen, stone fireplace &hot tub*Control 4 Sound System with custom lighting throughout home*Truly luxury living at its finest

Last Agent to Sell the Property

Jessica Powers

Huff Realty - Florence License #218872 Listed on: 08/23/2023

Huff Realty - Florence

Last Buyer's Agent

Trina Ellis

Coldwell Banker Realty FM License #193281

Coldwell Banker Realty FM

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,774

Year Built

  • Built in 1996

Lot Details

  • 0.49 Acre Lot
  • On Golf Course
  • Cul-De-Sac

HOA Fees

  • $38 Monthly HOA Fees

Parking

  • 6 Car Garage
  • Front Facing Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway
  • Off-Street Parking

Property Views

  • Golf Course
  • Woods

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding
  • Stone

Interior Spaces

  • 4,784 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Central Vacuum
  • Home Theater Equipment
  • Sound System
  • Built-In Features
  • Bookcases
  • Dry Bar
  • Woodwork
  • Crown Molding
  • Beamed Ceilings
  • Tray Ceiling
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Stone Fireplace
  • Gas Fireplace
  • Insulated Windows
  • Window Treatments
  • Bay Window
  • Picture Window
  • Sliding Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Family Room with Fireplace
  • Family Room with entrance to outdoor space
  • Living Room with Fireplace
  • Breakfast Room
  • Formal Dining Room
  • Home Office
  • Game Room Downstairs
  • Storage
  • Home Gym

Kitchen

  • Eat-In Gourmet Kitchen
  • Butlers Pantry
  • Gas Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Granite Bathroom Countertops
  • Dual Vanity Sinks in Primary Bathroom
  • Primary Bathroom includes a Walk-In Shower

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Finished Basement Bathroom
  • Stubbed For A Bathroom

Outdoor Features

  • Spa
  • Balcony
  • Deck
  • Covered patio or porch
  • Outdoor Kitchen
  • Exterior Lighting
  • Outdoor Grill

Schools

  • New Haven Elementary School
  • Gray Middle School
  • Ryle High School

Utilities

  • Forced Air Zoned Cooling and Heating System
  • Heating System Uses Natural Gas

Community Details

  • Towne Association, Phone Number (859) 291-5858

Listing and Financial Details

  • Assessor Parcel Number 064.10-07-007.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,774

Year Built

Built in 1996

Lot Details

0

HOA Fees

$38 per month

Parking

6

Listing Details

  • Cooling: Zoned, Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.49
  • Year Built: 1996
  • Lot Size: Of record
  • Directions: S I-71, Exit 175 towards Richwood, R on Richwood Rd, R onto Triple Crown Blvd, L onto Rosebriar, L onto Bay Colt
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: New Haven Elementary
  • Location Tax Legal Info:Middle or Junior School: Gray Middle School
  • Location Tax Legal Info:High School: Ryle High
  • Location Tax Legal Info:Subdivision2: Triple Crown Country Club
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: Of record
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Room Type:Office5: Yes
  • Sewer:Public Sewer: Yes
  • Utilities Electric Company: Owen
  • Utilities Gas Company: Duke
  • Water Company: Boone County Water
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.49
  • General Property Description:Living Area: 4784.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Laundry Features:Main Level: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Architecture:Traditional: Yes
  • Levels:Two: Yes
  • Location Tax Legal Info:Tax ID: 064.10-07-007.00
  • Appliances Refrigerators: Yes
  • Room Type:Living Room4: Yes
  • General Property Description:Fireplaces Total: 1
  • Appliances Dryer: Yes
  • Washers: Yes
  • View:TreesWoods: Yes
  • Room Type:Study: Yes
  • Percent Basement Finished: Yes
  • Room Type:Game Room: Yes
  • Room Type:Game Room Level: Basement
  • Other Equipment:Home Theater: Yes
  • Laundry Room Features:Tile Flooring15: Yes
  • Room Type:Exercise Room: Yes
  • Room Type:Exercise Room Level: Basement
  • Office Features:Hardwood Floors16: Yes
  • Study Room Features:Carpet Flooring13: Yes
  • Cooling:Zoned: Yes
  • View:Golf Course2: Yes
  • Office Features:Bookcases8: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Barn Door(s), Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Storage, Sound System, Open Floorplan, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Dry Bar, Crown Molding, Chandelier, Bookcases, Built-in Features, Beamed Ceilings, Butler's Pantry, Cathedral Ceiling(s), Ceiling Fan(s), Central Vacuum, High Ceilings, Multi Panel Doors, Natural Woodwork, Recess Ceiling(s), Recessed Lighting, Vaulted Ceiling(s)
  • Basement: Finished, Bath/Stubbed
  • Heating: Natural Gas, Forced Air
  • Levels: Two
  • Property Type: Residential
  • Appliances: Gas Range, Gas Oven, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer, Wine/Beverage Cooler
  • Other Equipment: Home Theater
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Fireplace Features: Stone, Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 4784.0
  • Window Features: Bay Window(s), Insulated Window(s), Picture Window(s), Slider Window(s)
  • Appliances Dishwasher: Yes
  • Interior Features:Built-in Features2: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Entrance Foyer2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:High Ceilings: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Storage2: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Interior Features:Wet Bar4: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Appliances:Gas Range: Yes
  • Kitchen Features Pantry: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Living Room Features:Walk-Out Access: Yes
  • Dining Room Features:Hardwood Floors4: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:Natural Woodwork: Yes
  • Basement:Fireplace(s)7: Yes
  • Interior Features:Crown Molding: Yes
  • Living Room Features:Wood Flooring2: Yes
  • Dining Room Features:Wood Flooring3: Yes
  • Family Room Features:Fireplace(s)4: Yes
  • Family Room Features:Walk-Out Access4: Yes
  • Kitchen Features:Wood Flooring4: Yes
  • Basement:Full Finished Bath: Yes
  • Kitchen Features:Eat-in Kitchen: Yes
  • Fireplace Features:Gas: Yes
  • Family Room Features:Window Treatments4: Yes
  • Living Room Features:Fireplace(s): Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Vaulted Ceiling(s): Yes
  • Living Room Features:Ceiling Fan(s)6: Yes
  • Living Room Features:High Ceiling(s)4: Yes
  • Dining Room Features:Chandelier: Yes
  • Kitchen Features:Hardwood Floors10: Yes
  • Primary Bath Features:Granite Countertops2: Yes
  • Primary Bedroom Features:Hardwood Floors18: Yes
  • Interior Features:Recessed Lighting: Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Bookcases4: Yes
  • Interior Features:Central Vacuum: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Appliances:Gas Oven: Yes
  • Fireplace Features:Stone4: Yes
  • Interior Features:Butler_squote_s Pantry: Yes
  • Interior Features:Recess Ceiling(s): Yes
  • Family Room Features:Recessed Lighting6: Yes
  • Family Room Features:Wet Bar2: Yes
  • Kitchen Features:Butler_squote_s Pantry2: Yes
  • Basement:Built-in Features3: Yes
  • Interior Features:Beamed Ceilings: Yes
  • Primary Bath Features:Tile Flooring4: Yes
  • Living Room Features:Built-in Features7: Yes
  • Interior Features:Tray Ceiling(s): Yes
  • Primary Bedroom Features:Tray Ceiling(s)2: Yes
  • Appliances:WineBeverage Cooler: Yes
  • Interior Features:Sound System: Yes
  • Interior Features:Barn Door(s): Yes
  • Interior Features:Dry Bar4: Yes
  • Living Room Features:Bookcases7: Yes
  • Basement:Dry Bar5: Yes
  • Primary Bedroom Features:See Remarks16: Yes

Exterior Features

  • View: Golf Course, Trees/Woods
  • Roof: Shingle
  • Lot Features: Cul-De-Sac, On Golf Course
  • View: Yes
  • Construction Type: Brick, Stone, Vinyl Siding
  • Exterior Features: Outdoor Kitchen, Balcony, Hot Tub, Lighting, Outdoor Grill
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Deck, Patio
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Insulated Window(s): Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Construction Materials:Stone2: Yes
  • Office Features:French Doors5: Yes
  • Window Features:Picture Window(s): Yes
  • Lot Features:Cul-De-Sac: Yes
  • Window Features:Bay Window(s): Yes
  • Exterior Features:Lighting: Yes
  • Exterior Features:Outdoor Grill: Yes
  • Window Features:Slider Window(s): Yes
  • Exterior Features:Balcony: Yes
  • Exterior Features:Hot Tub: Yes
  • Lot Features:On Golf Course: Yes
  • Exterior Features:Outdoor Kitchen: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage, Garage Door Opener, Garage Faces Front, Garage Faces Side, Off Street, Oversized
  • General Property Description:Garage Spaces: 6.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Garage Faces Front: Yes
  • Parking Features:Off Street2: Yes
  • Parking Features:Oversized: Yes
  • Parking Features:Garage Faces Side: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Laundry Room, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association Fee: 450.0
  • Association Fee Frequency: Annually
  • Association: Yes
  • ResoAssociationFeeFrequency: Annually

Association/Amenities

  • Association Information:Association YN: Yes
  • Association Information:Association Management Name 1: Towne
  • Association Information:Association Management Phone 1: 859-291-5858
  • Association Information:Total Yearly Fees: 450.0
  • Association Information:Association Fee: 450.0
  • Association Information:Association Fee Frequency: Annually

Schools

  • Elementary School: New Haven Elementary
  • Junior High Dist: Boone Co Public
  • High School: Ryle High
  • Middle Or Junior School: Gray Middle School

Lot Info

  • Lot Size Sq Ft: 21344.4
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 23, 2023
Closed on
Dec 19, 2023
Sold by
Laurino Carl and Laurino Jerilyn
Bought by
Schrage Thomas A
Seller's Agent
Jessica Powers
Huff Realty - Florence
Buyer's Agent
Trina Ellis
Coldwell Banker Realty FM
List Price
$1,200,000
Sold Price
$1,065,000
Premium/Discount to List
-$135,000
-11.25%
Views
106
Current Estimated Value
$1,261,721

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$196,721
Avg. Annual Appreciation
8.89%
Original Mortgage
$690,000
Outstanding Balance
$681,973
Interest Rate
7.5%
Mortgage Type
New Conventional
Estimated Equity
$528,209

Purchase Details

Closed on
Jul 1, 2019
Sold by
Watson Marc A and Watson Lori A
Bought by
Laurino Carl and Laurino Jerilyn

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$364,000
Interest Rate
4.2%
Mortgage Type
New Conventional

Purchase Details

Closed on
Mar 13, 2007
Sold by
Sirva Relocation Credit Llc
Bought by
Watson Marc A and Watson Lori A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
6.22%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 9, 2007
Sold by
Houser Michael D and Houser Carrie A
Bought by
Sirva Relocation Credit Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
6.22%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 3, 2005
Sold by
Prudetial Residentil Services Lp
Bought by
Houser Michael D and Houser Carrie A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$57,500
Interest Rate
5.74%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
May 6, 2005
Sold by
Ried Robert J and Ried Susan R
Bought by
Prudential Residential Services Lp

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$57,500
Interest Rate
5.74%
Mortgage Type
Credit Line Revolving
Source: Public Records

Similar Home in Union, KY

  • 749 Man o War Blvd, Union, KY 41091

    $969,741

    • 6 Beds
    • 5 Baths
    • 4,502 Sq Ft
    • 749 Man o War Blvd
    • Union, KY

    The Brennan by Drees Homes is full of charm and curb appeal. Enjoy the luxurious main level primary suite and bath. The free-standing tub and oversized shower make every day a spa day. Work from home? The spacious home office is conveniently located off the foyer. An open design of the family room and gourmet kitchen are highlighted by a vaulted ceiling with wood beams and a working pantry

    John Heisler Drees/Zaring Realty

    Section Image

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Purchase History

Date Buyer Sale Price Title Company
Schrage Thomas A $1,065,000 360 American Title Services
Laurino Carl $970,000 Northwest Ttl Fam Of Compani
Watson Marc A $610,000 Vintage Title Agency Inc
Sirva Relocation Credit Llc $610,000 Vintage Title Agency Inc
Houser Michael D $575,000 None Available
Prudential Residential Services Lp $575,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Schrage Thomas A $352,350
Open Schrage Thomas A $690,000
Previous Owner Watson Marc A $364,000
Previous Owner Watson Lori A $328,700
Previous Owner Watson Marc A $133,230
Previous Owner Watson Marc A $387,000
Previous Owner Watson Marc A $417,000
Previous Owner Houser Michael D $57,500
Previous Owner Prudential Residential Services Lp $460,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/19/2023 12/19/23 Sold $1,065,000 -11.3% $223 / Sq Ft
10/08/2023 10/08/23 Pending -- -- --
08/23/2023 08/23/23 For Sale $1,200,000 -- $251 / Sq Ft
Source: Northern Kentucky Multiple Listing Service

Tax History Compared to Growth

Source: Public Records

Tax History

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
2024 $11,774 $1,065,000 $100,000 $965,000
2023 $11,039 $970,000 $100,000 $870,000
2022 $10,890 $970,000 $100,000 $870,000
2021 $10,988 $970,000 $75,000 $895,000
2020 $11,105 $970,000 $75,000 $895,000
2019 $8,418 $726,720 $75,000 $651,720
2018 $8,367 $726,720 $75,000 $651,720
2017 $8,292 $726,720 $75,000 $651,720
2015 $8,190 $726,720 $75,000 $651,720
2013 -- $726,720 $75,000 $651,720
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 616423

Northern Kentucky Multiple Listing Service

APN: 064.10-07-007.00