Seller's Agent in 2023
Susan Huff
Huff Realty - Florence
(859) 802-2338
494 Total Sales
10 Queens View Ln Newport, KY 41076
Estimated Value: $1,064,000 - $1,268,000
5
Beds
7
Baths
7,000
Sq Ft
$167/Sq Ft
Est. Value
Highlights
- Skyline View
- Fireplace in Primary Bedroom
- Traditional Architecture
- Donald E. Cline Elementary School Rated A
- Deck
- Wood Flooring
About This Home
As of March 2023Stunning 7,000 square foot custom home situated on cul-de-sac lot with private, panoramic views of the Cincinnati skyline. Enjoy 4.9 Acres all to yourself! Convenient to NKU and downtown. First floor master suite with immaculate attached bath. Beautiful open kitchen with walkout to screened in patio. Perfect for sipping your morning coffee or sitting by the fireplace at night! The basement of this home is a dream for entertaining! Full wet bar with a media room, game room, and entertainment space plus three additional bedrooms. Guests can enjoy a private bedroom upstairs with an attached full bath! This home is immaculate and one of a kind!
Last Agent to Sell the Property
Huff Realty - Florence License #181847 Listed on: 01/16/2023
Last Buyer's Agent
The Cindy Shetterly Team
Keller Williams Realty Servs
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $9,895
Year Built
- Built in 2005
Lot Details
- 4.9 Acre Lot
- Cul-De-Sac
HOA Fees
- $17 Monthly HOA Fees
Parking
- 3 Car Garage
- Front Facing Garage
- Driveway
Property Views
- Skyline
- Woods
Home Design
- Traditional Architecture
- Brick Exterior Construction
- Poured Concrete
- Shingle Roof
- Stone
Interior Spaces
- 7,000 Sq Ft Home
- 1.5-Story Property
- Central Vacuum
- Crown Molding
- Tray Ceiling
- Ceiling Fan
- Recessed Lighting
- 5 Fireplaces
- Wood Burning Fireplace
- Marble Fireplace
- Gas Fireplace
- Insulated Windows
- Wood Frame Window
- French Doors
- Entryway
- Great Room
- Family Room
- Breakfast Room
- Formal Dining Room
- Game Room Downstairs
- Home Gym
- Home Security System
Kitchen
- Eat-In Kitchen
- Breakfast Bar
- Gas Cooktop
- Microwave
- Dishwasher
- Kitchen Island
- Disposal
Flooring
- Wood
- Carpet
Bedrooms and Bathrooms
- 5 Bedrooms
- Fireplace in Primary Bedroom
- En-Suite Primary Bedroom
- Walk-In Closet
- Dual Vanity Sinks in Primary Bathroom
Laundry
- Laundry Room
- Laundry on main level
Finished Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Finished Basement Bathroom
- Stubbed For A Bathroom
Outdoor Features
- Deck
- Enclosed patio or porch
Schools
- Donald E.Cline Elementary School
- Campbell County Middle School
- Campbell County High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- 220 Volts
- Cable TV Available
Community Details
- Sentinel Association, Phone Number (859) 655-2300
Listing and Financial Details
- Assessor Parcel Number 999-99-20-461.05
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jan 16, 2023
Closed on
Mar 17, 2023
Sold by
Vaidya Ashish K and Vaidya Nivedita
Bought by
Russo William Francis and Hiatt Kimberly Marie
Seller's Agent
Susan Huff
Huff Realty - Florence
Buyer's Agent
The Cindy Shetterly Team
Keller Williams Realty Servs
List Price
$1,050,000
Sold Price
$962,500
Premium/Discount to List
-$87,500
-8.33%
Total Days on Market
34
Views
135
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$204,129
Avg. Annual Appreciation
9.01%
Original Mortgage
$662,500
Outstanding Balance
$645,361
Interest Rate
6.12%
Mortgage Type
New Conventional
Estimated Equity
$521,268
Purchase Details
Closed on
Jun 18, 2018
Sold by
Dinn Michael J
Bought by
Vaidya Ashish K and Vaidya Nivedita
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$828,180
Interest Rate
4.37%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Jul 13, 2011
Sold by
Dinn Focused Marketing Llc
Bought by
Cutter Construction Inc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$410,526
Interest Rate
4.57%
Mortgage Type
Construction
Purchase Details
Closed on
Jun 14, 2004
Sold by
Dinn Focused Marketing Llc
Bought by
Dinn Michael J and Dinn Frances
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$750,000
Interest Rate
4.75%
Mortgage Type
Construction
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Russo William Francis | $962,500 | -- | |
| Vaidya Ashish K | $920,200 | None Available | |
| Cutter Construction Inc | $168,400 | None Available | |
| Dinn Michael J | $44,500 | -- |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Russo William Francis | $662,500 | |
| Previous Owner | Vaidya Ashish K | $800,000 | |
| Previous Owner | Vaidya Ashish K | $828,180 | |
| Previous Owner | Cutter Construction Inc | $410,526 | |
| Previous Owner | Dinn Michael | $250,000 | |
| Previous Owner | Dinn Michael | $150,000 | |
| Previous Owner | Dinn Michael J | $750,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 03/27/2023 03/27/23 | Sold | $962,500 | -8.3% | $138 / Sq Ft |
| 02/20/2023 02/20/23 | Pending | -- | -- | -- |
| 01/16/2023 01/16/23 | For Sale | $1,050,000 | -- | $150 / Sq Ft |
Source: Northern Kentucky Multiple Listing Service
Tax History Compared to Growth
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 | $9,895 | $962,500 | $200,000 | $762,500 |
| 2023 | $9,684 | $968,400 | $200,000 | $768,400 |
| 2022 | $10,035 | $968,400 | $200,000 | $768,400 |
| 2021 | $9,674 | $920,200 | $124,400 | $795,800 |
| 2020 | $9,841 | $920,200 | $124,400 | $795,800 |
| 2019 | $9,731 | $920,200 | $124,400 | $795,800 |
| 2018 | $11,196 | $1,051,400 | $124,400 | $927,000 |
| 2017 | $11,052 | $1,051,400 | $124,400 | $927,000 |
| 2016 | $10,872 | $1,051,400 | $0 | $0 |
| 2015 | $11,072 | $1,051,400 | $0 | $0 |
| 2014 | $10,778 | $1,051,400 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Susan Huff
-
T
Buyer's Agent in 2023
The Cindy Shetterly Team
Keller Williams Realty Servs
-
Cindy Shetterly
Buyer's Agent in 2023
Cindy Shetterly
Keller Williams Realty Services
(859) 992-9905
1,957 Total Sales
Map
Source: Northern Kentucky Multiple Listing Service
MLS Number: 610647
APN: 999-99-20-461.05
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 Ten-X 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 2025 Northern Kentucky Multiple Listing Service, Inc. All rights reserved.
Nearby Homes
- 21 Langview Dr
- 515 Telescope View Unit 103
- 370 Timber Ridge Dr Unit 3
- 330 Timber Ridge Dr Unit 9
- 786 Fairbanks Ln
- 4726 Bentwood Hills Dr Unit 6-302
- 4708 Bentwood Hills Dr Unit 6-104
- 4718 Bentwood Hills Dr Unit 6-103
- 4714 Bentwood Hills Dr Unit 6-305
- 4678 Bentwood Hills Dr Unit 5-304
- 4728 Bentwood Hills Dr Unit 6-300
- 4680 Bentwood Hills Dr Unit 5-305
- 4682 Bentwood Hills Dr Unit 5-303
- 4692 Bentwood Hills Dr Unit 5-302
- 4684 Bentwood Hills Dr Unit 5-103
- 4662 Bentwood Hills Dr Unit 4-300
- 4648 Bentwood Hills Dr Unit 4-305
- 4694 Bentwood Hills Dr Unit 5-300
- 4676 Bentwood Hills Dr Unit 5-104
- 4700 Bentwood Hills Dr Unit 5-101
- 10 Queens View Ln
- 9 Queens View Ln
- 8 Queens View Ln
- 6 Queens View Ln
- 7 Queens View Ln
- 5 Queens View Ln
- 4 Queens View Ln
- 3 Queens View Ln
- 2 Queens View Ln
- 1 Queens View Ln
- 7 Colonel Pointe Dr
- 67 Sentry Dr
- 10 Colonel Pointe Dr
- 63 Sentry Dr
- 8 Colonel Pointe Dr
- 61 Sentry Dr
- 65 Sentry Dr
- 73 Sentry Dr
- 69 Sentry Dr
- 5 Colonel Pointe Dr