$317,835 - $400,000
RENTED JUN 23, 2025
4 Beds
2 Baths
1,412 Sq Ft
$253 Price per Sq Ft

Highlights

  • Gourmet Kitchen
  • View of Trees or Woods
  • Cape Cod Architecture
  • Highlands Middle School Rated A
  • 0.7 Acre Lot
  • Deck

About This Home

As of June 2025

Beautiful 4 Bedroom ~ 2 Full Bath Cape Cod Home w/2 Car Garage nestled on CUL-DE-SAC w/lovely private wooded lot in back yard. Large addition over top of garage creates both a carpeted family room & a dining room w/HDWD floors with walkout onto beautiful deck overlooking a private park like wooded lot! Gourmet Kitchen w/new gas stove for those who love to cook. Full basement flows into oversized 2 car garage w/walkout to back yard. This is not your typical cape cod and you have lots of living space to use! Of course you're in the Ft. Thomas School District, one of the top school districts in NKY!

Last Agent to Rent the Property

Frank Schmitt

Huff Realty - CC License #204011 Listed on: 06/06/2025

Huff Realty - CC

Last Renter's Agent

Henry Pogue

Pogue & Associates License #176646

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,192

Year Built

  • Built in 1956

Lot Details

  • 0.7 Acre Lot
  • Lot Dimensions are 38x134x201x100x256
  • Cul-De-Sac
  • Level Lot
  • Partially Wooded Lot
  • Private Yard

Parking

  • 2 Car Attached Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking

Property Views

  • Woods
  • Neighborhood

Home Design

  • Cape Cod Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof

Interior Spaces

  • 1,412 Sq Ft Home
  • 1.5-Story Property
  • Ceiling Fan
  • Recessed Lighting
  • Chandelier
  • Fireplace
  • Vinyl Clad Windows
  • Insulated Windows
  • Sliding Doors
  • Family Room
  • Living Room
  • Formal Dining Room
  • Basement Fills Entire Space Under The House
  • Fire and Smoke Detector

Kitchen

  • Gourmet Kitchen
  • Gas Range
  • Dishwasher
  • Solid Surface Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 2 Full Bathrooms

Laundry

  • Laundry on lower level
  • Dryer
  • Washer

Outdoor Features

  • Deck
  • Shed
  • Porch

Schools

  • Moyer Elementary School
  • Highlands Middle School
  • Highlands High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • 220 Volts
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Tenant pays for electricity, cable TV, gas, heat, internet/wifi, sewer, water
  • No Smoking Allowed
  • 12 Month Lease Term
  • Assessor Parcel Number 999-99-16-589.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,192

Year Built

Built in 1956

Lot Details

0

Parking

2

Rental Info

  • Lease Term: 12 Months

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.7
  • Year Built: 1956
  • Lot Size: 38x134x201x100x256
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Ownership: Consumer
  • Directions: Grand Avenue to Summit Lane. Take Summit to Holiday Lane. Turn Right. Go to Aqua Vista Ct. Turn Right.
  • Architectural Style: Cape Cod
  • New Construction: No
  • Property Attached Yn: No
  • Structure Type: House
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: No
  • Location Tax Legal Info:Elementary School: Moyer Elementary
  • Location Tax Legal Info:Middle or Junior School: Highlands Middle School
  • Location Tax Legal Info:High School: Highlands High
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: No
  • General Property Description:Lot Size Dimensions: 38x134x201x100x256
  • General Property Description:Approx SqFt2: 1412.0
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities Electric Company: Duke
  • Utilities Gas Company: Duke
  • Water Company: NKY
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: Yes
  • General Property Description:Lot Size Acres: 0.695
  • General Property Description:Living Area: 1412.0
  • General Property Description:Lot Size Square Feet: 30274.0
  • Structure Type:House: Yes
  • Security Features:Smoke Detector(s): Yes
  • Location Tax Legal Info:Tax ID: 999-99-16-589.00
  • Appliances Refrigerators: Yes
  • Laundry Features:Electric Dryer Hookup: Yes
  • Laundry Features:Washer Hookup: Yes
  • Other Structures:Shed(s): Yes
  • Appliances Dryer: Yes
  • Washers: Yes
  • View:TreesWoods: Yes
  • Laundry Features:Lower Level: Yes
  • Vegetation:Partially Wooded: Yes
  • Architecture:Cape Cod: Yes
  • Levels:One and One Half: Yes
  • Contract Info:Lease Term: 12 Months
  • Contract Info:Smoking Permitted YN: No
  • Utilities:Separate Air Condition: No
  • Utilities:Separate Furnace: No
  • Utilities:Separate Gas Electric: No
  • Pets Allowed:Pets Allowed2: No
  • Room Details:Bedroom on Level 1: Yes
  • Contract Info:Furnished: Unfurnished
  • Electric 220 Volts2: Yes
  • Electric:Circuit Breakers: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Chandelier, Ceiling Fan(s), Recessed Lighting
  • Basement: Full
  • Heating: Natural Gas, Forced Air
  • Levels: One and One Half
  • Property Type: Residential Lease
  • Tenant Pays: Electricity, Cable TV, Gas, Heat, Internet/Wifi, Sewer, Water
  • Furnished: Unfurnished
  • Appliances: Gas Range, Dishwasher, Disposal, Dryer, Refrigerator, Washer
  • Full Bathrooms: 2
  • Total Bedrooms: 4
  • Door Features: Sliding Doors
  • Fireplace: No
  • Living Area: 1412.0
  • Window Features: Insulated Windows, Vinyl Frames
  • Full Basement: Yes
  • Appliances Dishwasher: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Appliances:Gas Range: Yes
  • Interior Features:Chandelier2: Yes
  • Interior Features:Recessed Lighting: Yes

Exterior Features

  • View: Neighborhood, Trees/Woods
  • Roof: Shingle
  • Lot Features: Cul-De-Sac, Level, Sloped Down
  • View: Yes
  • Construction Type: Brick
  • Exterior Features: Private Yard
  • Foundation Details: Poured Concrete
  • Other Structures: Shed(s)
  • Patio And Porch Features: Deck, Porch
  • Construction Materials:Brick2: Yes
  • Window Features:Insulated Window(s): Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Porch: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Lot Features:Level: Yes
  • Exterior Features:Private Yard: Yes
  • Lot Features:Sloped Down: Yes
  • Door Features:Sliding Doors: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Driveway, Garage, Garage Door Opener, Garage Faces Front, On Street
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Attached: Yes
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Garage Faces Front: Yes
  • Parking Features:On Street: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Electric Dryer Hookup, Lower Level, Washer Hookup
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: 220 Volts, Circuit Breakers
  • Utilities: Cable Available
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Moyer Elementary
  • Junior High Dist: Ft Thomas Indep
  • High School: Highlands High
  • Middle Or Junior School: Highlands Middle School

Lot Info

  • Lot Size Sq Ft: 30274.0
  • Zoning Description: Residential

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

Mortgage History

Date Status Borrower Loan Amount
Closed Smith Wm P $20,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/23/2025 06/23/25 Rented $2,350 0.0% --
06/09/2025 06/09/25 Under Contract -- -- --
06/06/2025 06/06/25 For Rent $2,350 0.0% --
05/20/2024 05/20/24 Rented $2,350 0.0% --
05/02/2024 05/02/24 Under Contract -- -- --
03/29/2024 03/29/24 For Rent $2,350 -- --
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 $1,192 $309,700 $100,800 $208,900
2023 $1,223 $309,700 $100,800 $208,900
2022 $1,299 $309,700 $100,800 $208,900
2021 $984 $223,725 $30,000 $193,725
2020 $1,003 $223,725 $30,000 $193,725
2019 $1,011 $223,725 $30,000 $193,725
2018 $997 $223,725 $30,000 $193,725
2017 $1,001 $223,725 $30,000 $193,725
2016 $965 $223,725 $0 $0
2015 $982 $223,725 $0 $0
2014 $647 $183,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 633241

Northern Kentucky Multiple Listing Service

APN: 999-99-16-589.00