NOT LISTED FOR SALE

1734 Grandview Dr Hebron, KY 41048

Hebron Neighborhood

Estimated Value: $867,000 - $1,124,000

3 Beds
4 Baths
4,800 Sq Ft
$212/Sq Ft Est. Value

Last Sold August 05, 2022

Last sale price $950,000 $198 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $6,443/month

11 Days on Market

Highlights

  • Eat-In Gourmet Kitchen
  • River View
  • Open Floorplan
  • North Pointe Elementary School Rated A
  • 4.02 Acre Lot
  • Heavily Wooded Lot

About This Home

As of August 2022

Impeccably designed & cared for custom Ranch on 4+ acres with breathtaking river valley views from almost every room! Peaceful park-like setting & natural privacy on this exceptional cul de sac lot. 4,800 sq. ft. of living space, 3/4 bedrooms, 4 baths, 3-car oversized garage. Open layout w/ 10-12 ft ceilings & stunning finishes throughout! Chef's Kitchen features Brazilian cherry floors, expansive island, double oven, Thermador gas cooktop, & adjoining family/hearth room. Indoor & outdoor entertaining made easy w/ formal dining room + morning room offering wet bar, ice maker, wine storage, & walkout to tiered deck with retractable awning. Main level primary suite w/ luxury bath, walk-in closet, tray ceiling & walkout to covered deck in addition to main level Study & laundry. Finished lower level offers wet bar w/ cherry cabinetry, billiards area, fitness room, craft room & 4-panel glass doors leading out to partially covered patio. Additional features include numerous built-ins, coffered ceiling, 2 gas fireplaces, central vac, cedar closet & abundant storage. Parlor Grove Estates is conveniently located just minutes to interstates, grocery, restaurants, & airport.

Last Agent to Sell the Property

Joey Zembrodt

Huff Realty - Florence License #206943 Listed on: 06/29/2022

Huff Realty - Florence

Last Buyer's Agent

Sherry Regenbogen

Huff Realty - Florence License #186120

Huff Realty - Florence

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,941

Year Built

  • Built in 2006

Lot Details

  • 4.02 Acre Lot
  • Cul-De-Sac
  • Heavily Wooded Lot
  • Private Yard

Parking

  • 3 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener
  • Driveway
  • On-Street Parking
  • Off-Street Parking

Property Views

  • River
  • Valley

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Stone

Interior Spaces

  • 4,800 Sq Ft Home
  • Open Floorplan
  • Wet Bar
  • Central Vacuum
  • Sound System
  • Built-In Features
  • Bookcases
  • Dry Bar
  • Crown Molding
  • Beamed Ceilings
  • Coffered Ceiling
  • Tray Ceiling
  • High Ceiling
  • Ceiling Fan
  • Skylights
  • Recessed Lighting
  • Chandelier
  • Self Contained Fireplace Unit Or Insert
  • Fireplace Features Blower Fan
  • Stone Fireplace
  • Gas Fireplace
  • Awning
  • Insulated Windows
  • Double Hung Windows
  • Picture Window
  • Entrance Foyer
  • Family Room with Fireplace
  • 2 Fireplaces
  • Great Room
  • Family Room with entrance to outdoor space
  • Living Room
  • Formal Dining Room
  • Bonus Room
  • Workshop
  • Storage
  • Home Gym

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Butlers Pantry
  • Double Oven
  • Gas Cooktop
  • Microwave
  • Ice Maker
  • Dishwasher
  • Wine Cooler
  • Stainless Steel Appliances
  • Kitchen Island
  • Granite Countertops
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Wood
  • Carpet
  • Laminate
  • Marble
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • Dressing Area
  • Entry through bedroom
  • Dual Vanity Sinks in Primary Bathroom
  • Jetted Soaking Tub in Primary Bathroom
  • Soaking Tub
  • Primary Bathroom includes a Walk-In Shower

Laundry

  • Laundry Room
  • Laundry on main level

Finished Basement

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

Accessible Home Design

  • Accessible Kitchen
  • Accessible Doors

Outdoor Features

  • Tiered Deck
  • Covered patio or porch
  • Water Fountains
  • Fire Pit
  • Outdoor Grill

Schools

  • North Pointe Elementary School
  • Conner Middle School
  • Conner Senior High School

Utilities

  • Forced Air Heating and Cooling System
  • Underground Utilities
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 035.00-05-280.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,941

Year Built

Built in 2006

Lot Details

0

Parking

3

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 4.02
  • Year Built: 2006
  • Lot Size: irregular
  • Road Frontage Type: City Street
  • Directions: I275W to Hebron/237N(6A) exit - at traffic circle, take 1st exit to Old N Bend Rd - L on Britt to R Brandon to R Hawes to L Grandview - House is at end in cul de sac
  • Architectural Style: Ranch
  • 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: North Pointe Elementary
  • 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: Parlor Grove 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
  • General Property Description:Approx SqFt2: 5000.0
  • Architecture:Ranch: Yes
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Roof:Shingle: Yes
  • Room Type:Dining Room4: Yes
  • Room Type:Entry: Yes
  • Room Type:Family Room4: Yes
  • Room Type:Laundry Room3: Yes
  • Sewer:Public Sewer: Yes
  • Levels:One: Yes
  • Utilities:Cable Available: Yes
  • Utilities:Natural Gas Available: Yes
  • Utilities Electric Company: Owen Electric Company
  • 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: 4.016
  • General Property Description:Living Area: 4800.0
  • General Property Description:Lot Size Square Feet: 174936.0
  • Structure Type:House: Yes
  • Laundry Features:Main Level: Yes
  • Location Tax Legal Info:Tax ID: 035.00-05-280.00
  • Appliances Refrigerators: Yes
  • Room Type:Living Room4: Yes
  • General Property Description:Fireplaces Total: 2
  • Room Type:Bonus Room2: Yes
  • Utilities:Sewer Available: Yes
  • Utilities:Water Available: Yes
  • Utilities:Underground Utilities: Yes
  • Other Equipment:Sump Pump: Yes
  • Percent Basement Finished: Yes
  • Vegetation:Heavily Wooded: Yes
  • Room Type:Great Room4: Yes
  • Great Room Features:Bookcases6: Yes
  • Great Room Features:Recessed Lighting2: Yes
  • Laundry Room Features:Tile Flooring15: Yes
  • View:Valley: Yes
  • Great Room Features:Built-in Features5: Yes
  • Room Type:Exercise Room: Yes
  • Room Type:Exercise Room Level: Lower
  • Great Room Features:Ceiling Fan(s)4: Yes
  • Room Type:Workshop2: Yes
  • Room Type:Workshop Level: Lower
  • Great Room Features:Sound System3: Yes
  • Great Room Features:Tile Flooring13: Yes
  • View:River: Yes
  • Bonus Room Features:High Ceiling(s)2: Yes
  • Entry Features:Marble Flooring: Yes
  • Bonus Room Features:Tile Flooring10: Yes
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Kitchen Island, Wet Bar, Walk-In Closet(s), Tray Ceiling(s), Storage, Soaking Tub, Open Floorplan, High Speed Internet, Granite Counters, Entrance Foyer, Eat-in Kitchen, Double Vanity, Dry Bar, Crown Molding, Coffered Ceiling(s), Chandelier, Bookcases, Built-in Features, Beamed Ceilings, Butler's Pantry, Ceiling Fan(s), Central Vacuum, High Ceilings, Recess Ceiling(s), Recessed Lighting
  • Basement: Finished, Bath/Stubbed, Walk-Out Access
  • Heating: Forced Air
  • Levels: One
  • Flooring: Carpet
  • Property Type: Residential
  • Appliances: Stainless Steel Appliance(s), Gas Cooktop, Dishwasher, Disposal, Double Oven, Ice Cooler, Microwave, Refrigerator, Wine/Beverage Cooler
  • Other Equipment: Sump Pump
  • Accessibility Features: Accessible Doors, Accessible Kitchen
  • Full Bathrooms: 2
  • Half Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: Stone, Blower Fan, Gas, Insert
  • Fireplaces: 2
  • Fireplace: Yes
  • Living Area: 4800.0
  • Window Features: Double Hung, Insulated Window(s), Picture Window(s)
  • Appliances Dishwasher: Yes
  • Appliances:Double Oven: Yes
  • Appliances:Gas Cooktop: Yes
  • Appliances:Stainless Steel Appliance(s): 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: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
  • Basement:Walk-Out Access7: Yes
  • Kitchen Features Pantry: Yes
  • Kitchen Features:Wood Cabinets: Yes
  • Primary Bedroom Features:Carpet Flooring5: Yes
  • Primary Bedroom Features:Walk-In Closet(s): Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Living Room Features:Walk-Out Access: Yes
  • Kitchen Features:Walk-Out Access3: Yes
  • Interior Features:Crown Molding: 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
  • Basement:Carpet Flooring7: Yes
  • Fireplace Features:Gas: Yes
  • Interior Features:High Speed Internet: Yes
  • Living Room Features:Carpet Flooring2: Yes
  • Kitchen Features:Laminate Flooring4: Yes
  • Interior Features:Chandelier2: Yes
  • Living Room Features:Ceiling Fan(s)6: Yes
  • Dining Room Features:Walk-Out Access2: Yes
  • Kitchen Features:Breakfast Bar: Yes
  • Kitchen Features:Window Treatments3: Yes
  • Primary Bedroom Features:Window Treatments6: Yes
  • Primary Bath Features:Soaking Tub2: Yes
  • Primary Bedroom Features:High Ceiling(s)6: Yes
  • Interior Features:Recessed Lighting: Yes
  • Primary Bath Features:Jetted Tub: Yes
  • Basement:Wet Bar5: Yes
  • Interior Features:Bookcases4: Yes
  • Interior Features:Central Vacuum: Yes
  • Interior Features:Soaking Tub: Yes
  • Kitchen Features:Gourmet Kitchen: Yes
  • Kitchen Features:Recessed Lighting3: Yes
  • Primary Bath Features:Double Vanity: Yes
  • Fireplace Features:Stone4: Yes
  • Interior Features:Butler_squote_s Pantry: Yes
  • Interior Features:Coffered Ceiling(s): Yes
  • Interior Features:Recess Ceiling(s): Yes
  • Kitchen Features:Butler_squote_s Pantry2: Yes
  • Fireplace Features:Blower Fan: Yes
  • Dining Room Features:Window Treatments2: Yes
  • Dining Room Features:Carpet Flooring3: Yes
  • Basement:Built-in Features3: Yes
  • Interior Features:Beamed Ceilings: Yes
  • Primary Bath Features:Shower With Bench: Yes
  • Primary Bedroom Features:Walk-Out Access6: Yes
  • Primary Bedroom Features:Dressing Area: Yes
  • Interior Features:Tray Ceiling(s): Yes
  • Appliances:WineBeverage Cooler: Yes
  • Fireplace Features:Insert: Yes
  • Interior Features:Dry Bar4: Yes
  • Primary Bath Features:Skylight(s)6: Yes
  • Appliances:Ice Cooler: Yes
  • Living Room Features:Wet Bar: Yes
  • Primary Bedroom Features:See Remarks16: Yes

Exterior Features

  • View: River, Valley
  • Roof: Shingle
  • Lot Features: Cul-De-Sac, Wooded
  • View: Yes
  • Construction Type: Brick, Stone
  • Exterior Features: Private Yard, Fire Pit, Fountain, Outdoor Grill
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Covered, Deck, Patio, Porch, Tiered Deck
  • Construction Materials:Brick2: 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
  • Patio and Porch Features:Porch: Yes
  • Construction Materials:Stone2: Yes
  • Window Features:Double Hung: Yes
  • Window Features:Picture Window(s): Yes
  • Lot Features:Wooded: Yes
  • Lot Features:Cul-De-Sac: Yes
  • Exterior Features:Private Yard: Yes
  • Exterior Features:Fire Pit: Yes
  • Exterior Features:Outdoor Grill: Yes
  • Patio and Porch Features:Tiered Deck: Yes
  • Patio and Porch Features:Awning(s): Yes
  • Accessibility Features:Accessible Doors: Yes
  • Accessibility Features:Accessible Kitchen: Yes
  • Exterior Features:Fountain: Yes

Garage/Parking

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

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Utility Sink, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Utilities: Cable Available, Natural Gas Available, Sewer Available, Underground Utilities, Water Available
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

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

Lot Info

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 29, 2022
Closed on
Aug 4, 2022
Sold by
Hess Kenneth G and Hess Alison S
Bought by
Beard Herman Wayne and Beard Mary
Seller's Agent
Joey Zembrodt
Huff Realty - Florence
Buyer's Agent
Sherry Regenbogen
Huff Realty - Florence
List Price
$1,050,000
Sold Price
$950,000
Premium/Discount to List
-$100,000
-9.52%
Views
16
Current Estimated Value
$1,016,623

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$66,623
Avg. Annual Appreciation
3.12%
Original Mortgage
$550,000
Outstanding Balance
$476,965
Interest Rate
4.45%
Mortgage Type
New Conventional
Estimated Equity
$564,360

Purchase Details

Closed on
Nov 17, 2005
Sold by
Hess Alison S and Hess Kenenth G
Bought by
Hess Kenenth G and Hess Alison S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$650,000
Interest Rate
5.5%
Mortgage Type
Adjustable Rate Mortgage/ARM
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
Beard Herman Wayne $950,000 Northwest Title
Hess Kenenth G -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Beard Herman Wayne $550,000
Previous Owner Hess Kenneth G $369,000
Previous Owner Hess Kenneth G $64,188
Previous Owner Hess Kenneth G $377,000
Previous Owner Hess Alison S $316,000
Previous Owner Hess Kenneth G $70,478
Previous Owner Hess Kenneth G $318,200
Previous Owner Hess Kenenth G $650,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/05/2022 08/05/22 Sold $950,000 -9.5% $198 / Sq Ft
07/11/2022 07/11/22 Pending -- -- --
06/29/2022 06/29/22 For Sale $1,050,000 -- $219 / 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 $9,941 $950,000 $150,000 $800,000
2023 $10,146 $950,000 $150,000 $800,000
2022 $5,226 $527,700 $150,000 $377,700
2021 $5,293 $527,700 $150,000 $377,700
2020 $4,547 $456,180 $150,000 $306,180
2019 $4,583 $456,180 $150,000 $306,180
2018 $4,604 $456,180 $150,000 $306,180
2017 $4,563 $456,180 $150,000 $306,180
2015 $4,537 $456,180 $150,000 $306,180
2013 -- $456,180 $150,000 $306,180
Source: Public Records

Agents Affiliated with this Home

  • Joey Zembrodt

    Seller's Agent in 2022

    Joey Zembrodt

    Huff Realty - Florence

    (859) 250-4557

    2 in this area

    97 Total Sales

    Section Image
  • Sherry Regenbogen

    Buyer's Agent in 2022

    Sherry Regenbogen

    Huff Realty - Florence

    (859) 653-2809

    14 in this area

    126 Total Sales

    Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 605538

Northern Kentucky Multiple Listing Service

APN: 035.00-05-280.00

Kentucky Boone County Hebron 41048 Hebron

1734 Grandview Dr, Hebron, KY

This home is located at 1734 Grandview Dr, Hebron, KY 41048 since 29 June 2022 and is currently estimated at $1,016,114, approximately $211 per square foot. This property was built in 2006. 1734 Grandview Dr is a home located in Boone County with nearby schools including North Pointe Elementary School, Conner Middle School, and Conner High School.

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.

Northern Kentucky Multiple Listing Service 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