NOT LISTED FOR SALE

1734 Grandview Dr Hebron, KY 41048

Estimated Value: $956,000 - $1,153,000

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

Last Sold August 05, 2022

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

Est. 11% increase in value since last sale

Current estimated payment $6,313/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

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

Year Built

Built in 2006

Lot Details

4.02 Acres

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,053,410

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$103,410
Avg. Annual Appreciation
2.95%
Original Mortgage
$550,000
Outstanding Balance
$459,802
Interest Rate
4.45%
Mortgage Type
New Conventional
Estimated Equity
$593,608

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
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 Kenenth G $650,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
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

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
2025 $10,121 $950,000 $150,000 $800,000
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

  • Section Image
  • 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

Your Personal Tour Guide

Ask me questions while you tour the home.