NOT LISTED FOR SALE

1237 Edinburgh Ln Union, KY 41091

Estimated Value: $304,109 - $388,000

3 Beds
2.5 Baths
1,306 Sq Ft
$254/Sq Ft Est. Value

Last Sold November 01, 2024

Last sale price $375,000 $287 Per Sq Ft

Est. 12% decrease in value since last sale

Current estimated payment $2,089/month

6 Days on Market

Highlights

  • 0.63 Acre Lot
  • Deck
  • Bonus Room
  • Shirley Mann Elementary School Rated A
  • Ranch Style House
  • Granite Countertops

About This Home

As of November 2024

YOU HAVE TO SEE THIS RANCH HOME TO BELIEVE IT!!! This meticulously maintained, updated 3 bedroom home with 2.5 baths, 2-car oversized garage, perfectly situated on a double lot in Boone County. The inviting kitchen boasts new cabinetry, stunning granite countertops with marble backsplash. The home has newer HVAC, windows, and exterior doors enhancing both energy efficiency and aesthetics along with NEW siding, gutters and carpet. The spacious primary bedroom suite features a built-in Bianco Puro marbled electric fireplace with an updated adjoining bath. Unique to this suite, is a Murphy closet with two built-in safes to convey with the property. The finished lower level is a versatile space, complete with updated lighting and two additional rooms that could be used as bedrooms, an office, study, etc. This home allows approximately 2,000 sq. ft. of usable living space with both levels. Not only is the inside of the home a show-stopper, the deck is a great place to entertain family and friends along with a beautiful back yard with a gazebo and fire pit to rest and relax. HURRY, YOU DON'T WANT TO MISS THIS HOME!

Last Agent to Sell the Property

Sherry Clark

Coldwell Banker Realty FM License #223056 Listed on: 09/27/2024

Coldwell Banker Realty FM

Last Buyer's Agent

Amy Brooks

Coldwell Banker Realty FM License #244302

Coldwell Banker Realty FM

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1995

Lot Details

  • 0.63 Acre Lot
  • Cleared Lot
  • Private Yard
  • Two lots

Parking

  • 2 Car Attached Garage
  • Rear-Facing Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Shingle Roof
  • Vinyl Siding

Interior Spaces

  • 1,306 Sq Ft Home
  • Ceiling Fan
  • Fireplace
  • Vinyl Clad Windows
  • Entryway
  • Living Room
  • Home Office
  • Bonus Room

Kitchen

  • Eat-In Kitchen
  • Electric Oven
  • Electric Cooktop
  • Microwave
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Carpet
  • Luxury Vinyl Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Finished Basement Bathroom
  • Stubbed For A Bathroom

Outdoor Features

  • Deck
  • Covered Patio or Porch
  • Shed
  • Pergola

Schools

  • Shirley Mann Elementary School
  • Gray Middle School
  • Ryle High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 063.00-15-017.00

Home Details

Home Type

Single Family

Year Built

Built in 1995

Lot Details

0

Parking

2

Listing Details

  • Cooling: Central Air
  • Property Condition: Existing Structure
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 0.63
  • Year Built: 1995
  • Lot Size: of record
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Directions: I 75 South to Mt. Zion exit. Right off the exit and left into Hempsteade subdivision. Immediate right on Burleigh and then right on Bayswater, left on Farmcrest, right on Cardigan, and left on Edinburgh.
  • 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: Shirley Mann School
  • Location Tax Legal Info:Middle or Junior School: Gray Middle School
  • Location Tax Legal Info:High School: Ryle High
  • Location Tax Legal Info:Subdivision2: Hempsteade
  • Contract Info:Auction YN: No
  • General Property Description:Half Baths: 1
  • General Property Description:Basement YN2: Yes
  • General Property Description:Fireplace YN: No
  • General Property Description:Lot Size Dimensions: of record
  • General Property Description:Approx SqFt2: 1306.0
  • Remarks Misc:Agent Only Remarks: The televisions in the home do not convey. Trampoline does not convey. Refrigerator in the basement will convey. Black cabinets in the front corner of garage will convey. The refrigerator in the basement will convey. The two pergolas will convey. Shed and Suncast storage unit under deck will convey. Small red heater in the garage will convey. The two safes in the primary bedroom will convey. Timeline of improvements under miscellaneous tab in documents. There are video cameras in home.
  • Architecture:Ranch: Yes
  • Appliances Microwave: Yes
  • Cooling:Central Air: Yes
  • Foundation:Poured Concrete: Yes
  • Parking Features Parking Total: 8
  • Roof:Shingle: Yes
  • Room Type:Entry: Yes
  • Room Type:Office5: Yes
  • Sewer:Public Sewer: Yes
  • Levels:One: Yes
  • Utilities Electric Company: Duke Energy
  • Utilities Gas Company: Duke Energy
  • Water Company: Boone County
  • Water Source:Public: Yes
  • Room Details:Family Room YN: No
  • Room Details:Formal Dining Rm YN: No
  • General Property Description:Lot Size Acres: 0.63
  • General Property Description:Living Area: 1306.0
  • General Property Description:Lot Size Square Feet: 9583.0
  • Structure Type:House: Yes
  • Laundry Features:Main Level: Yes
  • Location Tax Legal Info:Tax ID: 063.00-15-017.00
  • Appliances Refrigerators: Yes
  • Room Type:Living Room4: Yes
  • Other Structures:Shed(s): Yes
  • Appliances Dryer: Yes
  • Washers: Yes
  • Room Type:Bonus Room2: Yes
  • Percent Basement Finished: Yes
  • Other Structures:Pergola: Yes
  • Special Features: None

Interior Features

  • Interior Amenities: Kitchen Island, Granite Counters, Eat-in Kitchen, Ceiling Fan(s)
  • Basement: Full, Finished, Bath/Stubbed, Walk-Out Access
  • Heating: Natural Gas, Forced Air
  • Levels: One
  • Flooring: Carpet, Vinyl
  • Property Type: Residential
  • Appliances: Electric Cooktop, Electric Oven, Electric Range, Disposal, Dryer, Microwave, Refrigerator, Washer
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace: No
  • Living Area: 1306.0
  • Window Features: Vinyl Clad Window(s)
  • Full Basement: Yes
  • Appliances:Electric Oven: Yes
  • Interior Features:Ceiling Fan(s): Yes
  • Interior Features:Granite Counters: Yes
  • Interior Features:Kitchen Island2: Yes
  • Basement:Walk-Out Access7: Yes
  • Appliances:Electric Range: Yes
  • Interior Features:Eat-in Kitchen2: Yes
  • Basement:Carpet Flooring7: Yes
  • Basement:Full Finished Half Bath: Yes
  • Appliances:Electric Cooktop: Yes
  • Basement:Luxury Vinyl Flooring2: Yes

Exterior Features

  • Roof: Shingle
  • Lot Features: Cleared
  • Construction Type: Brick, Vinyl Siding
  • Exterior Features: Private Yard
  • Foundation Details: Poured Concrete
  • Other Structures: Pergola, Shed(s)
  • Patio And Porch Features: Covered, Deck, Porch
  • Construction Materials:Brick2: Yes
  • Construction Materials:Vinyl Siding: Yes
  • Patio and Porch Features:Covered: Yes
  • Patio and Porch Features:Deck: Yes
  • Patio and Porch Features:Porch: Yes
  • Window Features:Vinyl Clad Window(s): Yes
  • Exterior Features:Private Yard: Yes
  • Lot Features:Cleared: Yes

Garage/Parking

  • Attached Garage: Yes
  • Parking Features: Attached, Garage, Garage Faces Rear
  • Total Parking Spaces: 8.0
  • General Property Description:Garage Spaces: 2.0
  • Parking Features:Attached: Yes
  • Parking Features:Garage5: Yes
  • Parking Features:Garage Faces Rear: Yes

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Laundry Features: Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Heating:Natural Gas2: Yes
  • Heating:Forced Air: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Information:Association YN: No

Schools

  • Elementary School: Shirley Mann School
  • Junior High Dist: Boone Co Public
  • High School: Ryle High
  • Middle Or Junior School: Gray Middle School

Lot Info

  • Lot Size Sq Ft: 9583.0
  • Additional Parcels Description: Two lots
  • Zoning Description: Residential
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 27, 2024
Closed on
Nov 1, 2024
Sold by
Edwards John
Bought by
Ventura Nicholas C and Rider Kelsey E
Seller's Agent
Sherry Clark
Coldwell Banker Realty FM
Buyer's Agent
Amy Brooks
Coldwell Banker Realty FM
List Price
$389,900
Sold Price
$375,000
Premium/Discount to List
-$14,900
-3.82%
Views
11
Current Estimated Value
$331,277

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$43,723
Avg. Annual Appreciation
-10.66%
Original Mortgage
$240,000
Outstanding Balance
$237,097
Interest Rate
6.08%
Mortgage Type
New Conventional
Estimated Equity
$94,180

Purchase Details

Closed on
Jan 14, 2016
Sold by
Schutte Thomas J and Schutte Michelle L
Bought by
Edwards John

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$180,000
Interest Rate
3.96%
Mortgage Type
VA

Purchase Details

Closed on
Jul 8, 2014
Sold by
Stephenson James H and Stephenson Greta G
Bought by
Schutte Thomas J and Schutte Michelle L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$131,100
Interest Rate
4.17%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 21, 2012
Sold by
Dean Charles E and Dean Patricia F
Bought by
Stephenson James H and Stephenson Greta G

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$110,000
Interest Rate
3.91%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 15, 2005
Sold by
Cook James O and Cook Shirley Lou
Bought by
Dean Charles E and Dean Patricia F

Purchase Details

Closed on
Nov 1, 2002
Sold by
Perkins Dorothy B
Bought by
Dean Charles E and Dean Patricia F

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$154,500
Interest Rate
6.01%
Mortgage Type
VA

Purchase Details

Closed on
Dec 27, 1994
Sold by
Keystone Home Builders I
Bought by
Brantley Kirk R and Brantley Deborah L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$95,850
Interest Rate
9.23%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Ventura Nicholas C $375,000 Chicago Title
Ventura Nicholas C $375,000 Chicago Title
Edwards John $180,000 Lawyers Title Of Cincinnati
Schutte Thomas J $138,000 360 American Title Svcs Llc
Stephenson James H $145,000 Kentucky Land Title Agency
Dean Charles E $6,000 None Available
Dean Charles E $150,000 --
Brantley Kirk R $106,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ventura Nicholas C $240,000
Closed Ventura Nicholas C $240,000
Previous Owner Edwards John $180,000
Previous Owner Schutte Thomas J $131,100
Previous Owner Stephenson James H $110,000
Previous Owner Dean Charles E $154,500
Previous Owner Brantley Kirk R $95,850
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/01/2024 11/01/24 Sold $375,000 -3.8% $287 / Sq Ft
10/03/2024 10/03/24 Pending -- -- --
09/27/2024 09/27/24 For Sale $389,900 -- $299 / 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
2025 $4,154 $365,000 $30,000 $335,000
2024 $1,986 $174,000 $30,000 $144,000
2023 $2,055 $174,000 $30,000 $144,000
2022 $1,954 $174,000 $30,000 $144,000
2021 $2,033 $174,000 $30,000 $144,000
2020 $1,992 $174,000 $30,000 $144,000
2019 $2,015 $174,000 $30,000 $144,000
2018 $2,060 $174,000 $30,000 $144,000
2017 $1,985 $174,000 $30,000 $144,000
2015 $1,555 $138,000 $25,000 $113,000
2013 -- $139,000 $20,000 $119,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Kentucky Multiple Listing Service

MLS Number: 626863

Northern Kentucky Multiple Listing Service

APN: 063.00-15-017.00