NOT LISTED FOR SALE

Estimated Value: $437,000 - $574,348

4 Beds
4 Baths
3,514 Sq Ft
$140/Sq Ft Est. Value

Last Sold March 22, 2024

Last sale price $493,900 $141 Per Sq Ft

Current estimated payment $2,732/month

71 Days on Market

Highlights

  • Under Construction
  • Open Floorplan
  • Soaking Tub in Primary Bathroom
  • Thornwilde Elementary School Rated A
  • Deck
  • Traditional Architecture

About This Home

As of March 2024

Brand New, Energy efficient home by Arlinghaus Builders under construction in the Treetops Estates community. Popular Mariemont floor plan offers an amazing layout, a finished basement & numerous upgrades. This home has 9' ceilings on the 1st flr, a large kitchen with an island, staggered cabinets, walk in pantry, granite countertops & luxury vinyl plank flooring. Study with french doors. Great room has a gas fireplace with cabinets/built-in bookshelves. Mudroom with built-in cubbies. Walk-in closets in all bedrooms. Second floor laundry & loft area. Primary bedroom/bath has cathedral ceiling, soaking tub & tile shower. Walkout basement has a finished family room & 1/2 bath! Brick wrap home with Trane gas heat & a tankless water heater. All on a wooded home site. A must see!

Last Agent to Sell the Property

Carey Bailey

A+ Realty LLC License #218623 Listed on: 11/28/2023

Last Buyer's Agent

Judy Behan

Berkshire Hathaway Home Services Professional Realty License #210078

Berkshire Hathaway Home Services Professional Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $542

Year Built

  • Built in 2023 | Under Construction

Lot Details

  • 0.25 Acre Lot

Parking

  • 2 Car Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 3,514 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Built-In Features
  • Bookcases
  • Crown Molding
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Fireplace Features Blower Fan
  • Electric Fireplace
  • Vinyl Clad Windows
  • French Doors
  • Panel Doors
  • Great Room
  • Family Room
  • Breakfast Room
  • Home Office
  • Loft
  • Smart Thermostat

Kitchen

  • Breakfast Bar
  • Electric Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops

Flooring

  • Carpet
  • Luxury Vinyl Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • En-Suite Primary Bedroom
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Soaking Tub in Primary Bathroom
  • Soaking Tub
  • Primary Bathroom includes a Walk-In Shower

Laundry

  • Laundry Room
  • Laundry on upper level
  • Washer and Electric Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • Finished Basement Bathroom
  • Stubbed For A Bathroom

Outdoor Features

  • Deck
  • Patio
  • Porch

Schools

  • Thornwilde Elementary School
  • Conner Middle School
  • Conner Senior High School

Utilities

  • Dehumidifier
  • Central Air
  • Heating System Uses Natural Gas
  • Tankless Water Heater
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Home warranty included in the sale of the property

Home Details

Home Type

Single Family

Est. Annual Taxes

$542

Year Built

Built in 2023 | Under Construction

Lot Details

0

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Under Construction
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.25
  • Year Built: 2023
  • Lot Size: irregular
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Directions: North on 237, Left onto Treetops Lane, Right onto Oakview Court, Left onto Elmburn Lane, Right onto Wernz Drive. The house is on the left.
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • New Construction: Yes
  • Property Attached Yn: No
  • Structure Type: House
  • ResoPropertyType: Residential
  • Location Tax Legal Info:Property Attached YN: No
  • Location Tax Legal Info:New Construction: Yes
  • Location Tax Legal Info:Elementary School: Thornwilde
  • Location Tax Legal Info:Middle or Junior School: Conner Middle School
  • Location Tax Legal Info:High School: Conner Senior High
  • Location Tax Legal Info:Subdivision2: Treetops Estates
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 2
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: Yes
  • General Property Description:Lot Size Dimensions: irregular
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Room Type:Family Room4: Yes
  • Room Type:Laundry Room3: Yes
  • Sewer:Public Sewer: Yes
  • Utilities:Cable Available: Yes
  • Utilities Electric Company: Owen Electric
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone Co. Water District
  • Water Source:Public: Yes
  • Room Details:Family Room YN: Yes
  • Room Details:Formal Dining Rm YN: No
  • General Property Description:Lot Size Acres: 0.253
  • General Property Description:Living Area: 3514.0
  • General Property Description:Lot Size Square Feet: 11021.0
  • Structure Type:House: Yes
  • Laundry Features:Laundry Room2: Yes
  • Miscellaneous Home Warranty: Yes
  • Room Type:Breakfast Room2: Yes
  • Room Type:Breakfast Room Level: First
  • Architecture:Traditional: Yes
  • Laundry Features:Upper Level: Yes
  • Room Type:Loft3: Yes
  • Levels:Two: Yes
  • Loft Features:Carpet Flooring9: Yes
  • Laundry Features:Electric Dryer Hookup: Yes
  • Laundry Features:Washer Hookup: Yes
  • General Property Description:Fireplaces Total: 1
  • Room Type:Study: Yes
  • Percent Basement Finished: Yes
  • Room Type:Great Room4: Yes
  • Great Room Features:Bookcases6: Yes
  • Great Room Features:Recessed Lighting2: Yes
  • Other Equipment:Dehumidifier: Yes
  • Property Condition:Under Construction: Yes
  • Great Room Features:Carpet Flooring8: Yes
  • Study Room Features:Luxury Vinyl Flooring23: Yes
  • Special Features: NewHome

Interior Features

  • Interior Amenities: Kitchen Island, Walk-In Closet(s), Soaking Tub, Smart Thermostat, Pantry, Open Floorplan, Granite Counters, Double Vanity, Crown Molding, Bookcases, Built-in Features, Cathedral Ceiling(s), French Doors, Multi Panel Doors, Recessed Lighting
  • Basement: Finished, Bath/Stubbed, Walk-Out Access
  • Heating: Natural Gas
  • Levels: Two
  • Flooring: Carpet, Vinyl
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Electric Range, Dishwasher, Microwave, Tankless Water Heater
  • Other Equipment: Dehumidifier
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Total Bedrooms: 4
  • Fireplace Features: Blower Fan, Electric
  • Fireplaces: 1
  • Fireplace: Yes
  • Living Area: 3514.0
  • Window Features: Vinyl Frames
  • Appliances Dishwasher: Yes
  • Appliances:Stainless Steel Appliance(s): Yes
  • Interior Features:Built-in Features2: Yes
  • Interior Features:Double Vanity2: Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Multi Panel Doors: Yes
  • Interior Features:Open Floorplan: Yes
  • Interior Features:Pantry2: Yes
  • Interior Features:Smart Thermostat: Yes
  • Interior Features:Walk-In Closet(s)2: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Primary Bedroom Features:Ceiling Fan(s)8: Yes
  • Basement:Walk-Out Access7: Yes
  • Interior Features:French Doors: Yes
  • Kitchen Features Pantry: Yes
  • Primary Bedroom Features:Bath Adjoins: Yes
  • Primary Bedroom Features:Carpet Flooring5: Yes
  • Appliances:Electric Range: Yes
  • Family Room Features:Carpet Flooring4: Yes
  • Primary Bath Features:Shower: Yes
  • Interior Features:Crown Molding: Yes
  • Basement:Carpet Flooring7: Yes
  • Basement:Full Finished Half Bath: Yes
  • Interior Features:Cathedral Ceiling(s): Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Primary Bath Features:Soaking Tub2: Yes
  • Interior Features:Recessed Lighting: Yes
  • Interior Features:Bookcases4: Yes
  • Interior Features:Soaking Tub: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Family Room Features:Recessed Lighting6: Yes
  • Appliances:Tankless Water Heater: Yes
  • Fireplace Features:Blower Fan: Yes
  • Primary Bedroom Features:Cathedral Ceiling(s)2: Yes
  • Fireplace Features:Electric: Yes
  • Primary Bath Features:Vinyl Flooring7: Yes
  • Basement:Vinyl Flooring8: Yes

Exterior Features

  • Roof: Shingle
  • Home Warranty: Yes
  • Construction Type: Brick Veneer, Vinyl Siding
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Deck, Patio, Porch
  • Construction Materials:Vinyl Siding: Yes
  • Window Features:Vinyl Frames: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Patio: Yes
  • Patio and Porch Features:Porch: Yes
  • Construction Materials:Brick Veneer: Yes
  • Study Room Features:French Doors7: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Driveway, Garage
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Driveway: Yes
  • Parking Features:Garage5: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Electric Dryer Hookup, Laundry Room, Upper Level, Washer Hookup
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available
  • Heating:Natural Gas2: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Thornwilde
  • Junior High Dist: Boone Co Public
  • High School: Conner Senior High
  • Middle Or Junior School: Conner Middle School

Lot Info

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 28, 2023
Closed on
Feb 13, 2024
Sold by
Arlinghaus Builders Llc
Bought by
Paudal Aakash and Khine Phoo Pwint
Seller's Agent
Carey Bailey
A+ Realty LLC
Buyer's Agent
Judy Behan
Berkshire Hathaway Home Services Professional Realty
List Price
$493,900
Sold Price
$493,900
Views
31
Current Estimated Value
$493,087

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$813
Avg. Annual Appreciation
-0.64%
Original Mortgage
$275,000
Outstanding Balance
$270,700
Interest Rate
6.64%
Mortgage Type
New Conventional
Estimated Equity
$218,696
Source: Public Records

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
Paudal Aakash $493,900 None Listed On Document
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Paudal Aakash $275,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/22/2024 03/22/24 Sold $493,900 0.0% $141 / Sq Ft
02/08/2024 02/08/24 Pending -- -- --
11/28/2023 11/28/23 For Sale $493,900 -- $141 / 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 $542 $45,000 $45,000 $0
2023 $481 $45,000 $45,000 $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: 618857

Northern Kentucky Multiple Listing Service

APN: 035.00-16-286.00