Last Sold Price
4 beds3,512 sqft$277/sqft
1793 Frogtown Road, Union, KY 41091

Description

One of a kind Custom Designed & Built Home on over 4.5 acres in Ryle Dist! This house has so many upgrades and amenities: enter the covered porch thru the double wood doors into paradise! Large entry leads into Family Room w/11' high clgs, built ins & marble FP. Walk out & have your morning coffee on the peaceful covered back porch! Study w/custom built-ins & DR w/wainscotting. Kitchen is open w/ quartz countertops, SS appl, double gas oven & cooktop; huge island w/seating. First flr Master w/expansive...One of a kind Custom Designed & Built Home on over 4.5 acres in Ryle Dist! This house has so many upgrades and amenities: enter the covered porch thru the double wood doors into paradise! Large entry leads into Family Room w/11' high clgs, built ins & marble FP. Walk out & have your morning coffee on the peaceful covered back porch! Study w/custom built-ins & DR w/wainscotting. Kitchen is open w/ quartz countertops, SS appl, double gas oven & cooktop; huge island w/seating. First flr Master w/expansive Bath & WIC. Three more BR's upstairs, all with bathroom access & WIC's. Bonus Room great for playroom or sitting area! Unique moldings & finishes throughout. Adorable mud room w/bench, cubbies & WIC! Mechanics of home 2 years new, incl. cost saving Geothermal Heating and Cooling, Tankless water heater, Humidifier and pre-installed Radon Mitigation System. Two car attached garage & 2 car detached garage for all of your stuff. House is immaculate, move in ready! No HOA. Make it yours!
LISTING CLOSED: 09/26/2022 12:00 AM

  1. Listed by Jeffrey Forlenza • Brokerage DRE #237821 • Diversified Realty Services
    P: (859) 991-5572 C: (859) 991-5572 jeff@divrealtyservices.com

Property Details for 1793 Frogtown Road

Status
MLS #
607015
Days on Market
3
Taxes
-
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
2020
Lot Size
4.50 AC / 196,020 SF
Has View
Yes
Architectural Style
Traditional
View
Trees/Woods
Zoning Description
Residential

Location

Listing Courtesy of Diversified Realty Services

Sold By Diversified Realty Services

Add your commute

Building Information for 1793 Frogtown Road

Stories-Year Built2020Building Size-Lot Size4.50 AC / 196,020 SF

Payment Calculator

$5,041 per month

30 year fixed, 6.55% Interest

Principal and Interest

$4,941

Property Taxes

$100

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 1793 Frogtown Road

Summary
Location and General Information
  • Longitude: -84.670197
  • Latitude: 38.934871
  • Directions: US 42 to Frogtown Rd. or US 25 to Frogtown Rd.
  • MLSArea Major: K11 - Richwd/Un/Wal/Ver/SB
  • MLSArea Minor: K11 - Richwd/Un/Wal/Ver/SB
  • Year Built Known: Yes
  • SIC: UN - Union- Boone Cty
Taxes and HOA
  • Additional Parcels Description: 064.00-00-007.00
  • Association: No
  • Parcel Number: 064.00-00-008.00
  • Tax Rate: 11.25 buyer to verify
School Information
  • High School District: Boone Co Public
  • Elementary School: Shirley Mann School
  • Middle Or Junior School: Gray Middle School
  • High School: Ryle High
Parking
  • Parking Features: Attached, Driveway, Garage Faces Side, Oversized, Garage Door Opener, Garage
  • Attached Garage: Yes
  • Garage: Yes
  • Garage Spaces: 4.0
Property
Lot Information
  • Lot Size Units: Acres
  • Lot Size Square Feet: 100656.0
  • Lot Size Acres: 4.5
  • Lot Size Source: Realist
  • Lot Size Dimensions: Irregular
  • Lot Size Area: 4.5
Property and Assessments
  • New Construction: No
  • Year Built: 2020
  • Living Area: 3512.0
  • Living Area Units: Square Feet
  • Land Lease: Yes
  • Property Attached: No
  • Land Description: 1 to 4.9 Acres
Building Features
  • Levels: Two
  • Structure Type: House
  • Other Structures: Garage(s)
  • Foundation Details: Poured Concrete
  • Construction Materials: Brick
Farm Information
  • Other Equipment: Humidifier, Sump Pump
Utilities
  • Utilities: Cable Available, Water Available
  • Sewer: Septic Tank
  • Electric: 220 Volts
  • Water Source: Public
Interior and Exterior Features
Interior Features
  • Bathrooms: 3
  • Appliances: Disposal, Double Oven, Dishwasher, Microwave, Refrigerator, Tankless Water Heater, Gas Oven, Stainless Steel Appliance(s), Gas Cooktop
  • Bathrooms Half: 1
  • Cooling: Central Air, Geothermal
  • Fireplaces Total: 1
  • Security Features: Smoke Detector(s), Security System
  • Fireplace: Yes
  • Window Features: Insulated Windows, Double Hung
  • Has Heating: Yes
  • Has Cooling: Yes
  • Basement: Walk-Out Access, Full Bath Rough In, Unfinished, Storage Space
  • Interior Features: Ceiling Fan(s), Recessed Lighting, Multi Panel Doors, High Ceilings, Crown Molding, Bookcases, Built-in Features, Chandelier, Double Vanity, Eat-in Kitchen, Entrance Foyer, Kitchen Island, Master Downstairs, Open Floorplan, Pantry, Stone Counters, Storage, Walk-In Closet(s), Pocket Door(s)
  • Rooms Total: 12
  • Laundry Features: Main Level, Laundry Room, Utility Sink
  • Heating: Forced Air, Geothermal
  • Fireplace Features: Marble, Gas
  • Laundry Room Features: Tile Flooring
  • Entry Features: Wood Flooring, Closet(s), Double Doors, Entrance Foyer
  • Kitchen Features: Eat-in Kitchen, Gourmet Kitchen, Kitchen Island, Planning Desk, Pantry, Recessed Lighting, See Remarks
  • Primary Bedroom Features: Wood Flooring, Bath Adjoins, Walk-In Closet(s), High Ceiling(s)
  • Office Features: Bookcases, French Doors
  • Dining Room Features: Wood Flooring, Chair Rail, Chandelier
  • Family Room Features: Wood Flooring, Bookcases, Fireplace(s), Walk-Out Access, French Doors, Ceiling Fan(s), Recessed Lighting
Exterior Features
  • Exterior Features: Private Yard
  • Patio And Porch Features: Porch, Covered
  • Door Features: French Doors
  • Roof: Metal, Shingle
Room Information
Room 1
  • Room Features: Wood Flooring, Closet(s), Entrance Foyer, Double Doors
  • Room Type: Entry
  • Room Length: 16.0
  • Room Level: First
  • Room Width: 8.0
  • Room Dimensions: 16 x 8
Room 2
  • Room Features: Wood Flooring, Chandelier, Chair Rail
  • Room Type: Dining Room
  • Room Length: 13.0
  • Room Level: First
  • Room Width: 12.0
  • Room Dimensions: 13 x 12
Room 3
  • Room Features: Planning Desk, Kitchen Island, Gourmet Kitchen, Eat-in Kitchen, Pantry, See Remarks, Recessed Lighting
  • Room Type: Kitchen
  • Room Length: 16.0
  • Room Level: First
  • Room Width: 13.0
  • Room Dimensions: 16 x 13
  • Room Description: Quartz Countertops, Tile Backsplash, Bosch Appl.
Room 4
  • Room Features: Hardwood Floors
  • Room Type: Breakfast Room
  • Room Length: 12.0
  • Room Level: First
  • Room Width: 13.0
  • Room Dimensions: 12 x 13
Room 5
  • Room Features: Walk-Out Access, Fireplace(s), Wood Flooring, French Doors, Bookcases, Ceiling Fan(s), Recessed Lighting
  • Room Type: Family Room
  • Room Length: 21.0
  • Room Level: First
  • Room Width: 17.0
  • Room Dimensions: 21 x 17
Room 6
  • Room Features: Wood Flooring, French Doors, Bookcases
  • Room Type: Office
  • Room Length: 13.0
  • Room Level: First
  • Room Width: 11.0
  • Room Dimensions: 13 x 11
Room 7
  • Room Features: Wood Flooring, Walk-In Closet(s), Bath Adjoins, High Ceilings
  • Room Type: Primary Bedroom
  • Room Length: 15.0
  • Room Level: First
  • Room Width: 14.0
  • Room Dimensions: 15 x 14
Room 8
  • Room Features: Utility Sink, Tile Flooring
  • Room Type: Laundry
  • Room Length: 11.0
  • Room Level: First
  • Room Width: 7.0
  • Room Dimensions: 11 x 7
Room 9
  • Room Features: Built-in Features, Closet(s), Ceramic Tile Flooring
  • Room Type: Other Room
  • Room Length: 7.5
  • Room Level: First
  • Room Width: 6.0
  • Room Dimensions: 7.5 x 6
  • Room Description: Mud Room w/ WIC; bench, cubbies
Room 10
  • Room Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins, Ceiling Fan(s)
  • Room Type: Bedroom 2
  • Room Length: 13.0
  • Room Level: Second
  • Room Width: 13.0
  • Room Dimensions: 13 x 13
Room 11
  • Room Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins, Ceiling Fan(s)
  • Room Type: Bedroom 3
  • Room Length: 13.0
  • Room Level: Second
  • Room Width: 13.0
  • Room Dimensions: 13 x 13
Room 12
  • Room Features: Carpet Flooring, Walk-In Closet(s), Bath Adjoins, Ceiling Fan(s)
  • Room Type: Bedroom 4
  • Room Length: 13.0
  • Room Level: Second
  • Room Width: 11.0
  • Room Dimensions: 13 x 11

Property History for 1793 Frogtown Road

DateEvent & SourcePriceAppreciation
Sep 26, 2022

Sold

Northern Kentucky Multiple Listing Service #607015

$972,000
Aug 16, 2022

Contract Signed

Northern Kentucky Multiple Listing Service #607015

Aug 13, 2022

Listed (Active)

Northern Kentucky Multiple Listing Service #607015

$979,000
DateEvent & SourcePrice
09/26/2022

Sold

Northern Kentucky Multiple Listing Service #607015

$972,000
08/16/2022

Contract Signed

Northern Kentucky Multiple Listing Service #607015

08/13/2022

Listed (Active)

Northern Kentucky Multiple Listing Service #607015

$979,000

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 1793 Frogtown Road

Taxable ValueLand$100,000Additions$7,500Total$107,500
Tax Record2025$1,201 ($100 / month)
Home Facts
Beds0StyleSingle Family ResidenceCountyBOONEAPN064.00-00-007.00

Schools near 1793 Frogtown Road

This home is within Boone County.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Public - PK to 5
Rating
School
Distance
Shirley Mann Elementary School
PublicPK to 5

Gray Middle School
Public6 to 8

Larry A. Ryle High School
Public9 to 12

Steeplechase Elementary School
PublicPK to 5

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 41091

$425,000 | 9738 Cherbourg Drive, Union, KY 41091
1/52
New

$425,000

4
Bedrooms
Unavailable
Square Feet
0.46
Acres
$729,900 | 632 Coaltown Court, Union, KY 41091
1/53
Listed By Coldwell Banker RealtyOpen: 8/16 01:00PM - 02:00PM

$729,900

4
Bedrooms
3,122
Square Feet
0.35
Acres
$639,900 | 10393 Brookhurst Lane North, Union, KY 41091
1/6
NewNew Construction

$639,900

4
Bedrooms
2,648
Square Feet
Unavailable
Acres
$829,000 | 10995 Arcaro Lane, Union, KY 41091
1/40
Open: 8/15 02:00PM - 04:00PM

$829,000

3
Bedrooms
Unavailable
Square Feet
0.88
Acres
$399,900 | 1232 Lancashire Drive, Union, KY 41091
1/35

$399,900

4
Bedrooms
Unavailable
Square Feet
0.22
Acres
$825,000 | 11109 War Admiral Drive, Union, KY 41091
1/42

$825,000

4
Bedrooms
2,800
Square Feet
0.53
Acres
$415,000 | 6821 Green Isle Lane, Union, KY 41091
1/28
Open: 8/15 11:30AM - 01:00PMNew Construction

$415,000

2
Bedrooms
1,227
Square Feet
0.19
Acres
$499,900 | 10082 Cedarwood Drive, Union, KY 41091
1/51
Listed By Coldwell Banker RealtyOpen: 8/16 01:00PM - 02:30PM

$499,900

4
Bedrooms
3,568
Square Feet
0.42
Acres
$659,900 | 1071 Dustwhirl Drive, Union, KY 41091
1/53

$659,900

4
Bedrooms
3,140
Square Feet
0.97
Acres

Nearby home values

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Diversified Realty Services

The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange Program of NKMLS. Real estate listings held by IDX Brokerage firms other than Compass and its related brokerages are marked with the Internet Data Exchange logo or the Internet Data Exchange thumbnail logo and detailed information about them includes the name of the listing Brokers. Listing information is deemed reliable, but not guaranteed. Copyright 2026 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.