$564,900
SOLD JUL 11, 2025

506 Sheffield Rd Hopkinsville, KY 42240

4 Beds
3.5 Baths
3,450 Sq Ft
0.77 Acres

Recently Sold

$164 Per Sq Ft

12 Days on Market

Highlights

  • In Ground Pool
  • No HOA
  • 2 Car Attached Garage
  • 0.77 Acre Lot
  • Porch
  • Walk-In Closet

About This Home

As of July 2025

Step into luxury with this remodeled 4 bed, 3.5 bath all-brick home that has it all! From the moment you walk in, you’ll love the open split floor plan with two spacious living areas, stunning tray ceiling, built-in shelf, cozy fireplace, and stylish LVP flooring throughout. The custom kitchen is a showstopper with quartz countertops, custom cabinetry, and a walk-in pantry. The primary suite is your personal retreat with a spa-like bath featuring double vanities, a soaking tub, separate tile shower, and a dream closet with custom shelving. You'll love the large utility/mud room loaded with storage, plus top-notch extras like plantation shutters, a tankless water heater, and a whole-house generator for peace of mind. Step outside and enjoy your private backyard oasis—complete with a covered back patio, in-ground pool with diving board, built-in Weber grill, beautiful landscaping, and a fenced-in yard. Plus, a storage building provides the perfect spot for tools, equipment or pool toys!

Last Agent to Sell the Property

Rachel Diuguid Smith

Legacy Real Estate Co. Brokerage Phone: 2703485610 License #275912 Listed on: 05/17/2025

Last Buyer's Agent

Rachel Diuguid Smith

Legacy Real Estate Co. Brokerage Phone: 2703485610 License #275912 Listed on: 05/17/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,404

Year Built

  • Built in 1991

Lot Details

  • 0.77 Acre Lot
  • Lot Dimensions are 171x245x101x250
  • Privacy Fence

Parking

  • 2 Car Attached Garage

Home Design

  • Brick Exterior Construction

Interior Spaces

  • 3,450 Sq Ft Home
  • Property has 1 Level
  • Ceiling Fan
  • Living Room with Fireplace
  • Interior Storage Closet
  • Tile Flooring

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 4 Main Level Bedrooms
  • Walk-In Closet

Outdoor Features

  • In Ground Pool
  • Patio
  • Outdoor Gas Grill
  • Porch

Schools

  • Indian Hills Elementary School
  • Hopkinsville Middle School
  • Hopkinsville High School

Utilities

  • Cooling Available
  • Heating System Uses Natural Gas

Community Details

  • No Home Owners Association
  • Cox Mill Est Ph Iv Subdivision

Listing and Financial Details

  • Assessor Parcel Number 240-00 06 037.00

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,404

Year Built

Built in 1991

Lot Details

0

Parking

2

Listing Details

  • Prop. Type: Residential
  • Property Sub Type: Single Family Residence
  • Year Built: 1991
  • Unit Levels: One
  • Building Stories: 1
  • Year Built Details: EXIST
  • Attribution Contact: 2703485610
  • Special Features: None
  • Stories: 1

Interior Features

  • Interior Amenities: Bookcases, Built-in Features, Ceiling Fan(s), Entrance Foyer, Extra Closets, Open Floorplan, Pantry, Storage, Walk-In Closet(s)
  • Appliances: Range, Dishwasher, Microwave, Refrigerator
  • Fireplace Features: Living Room
  • Fireplace: Yes
  • Fireplaces: 1
  • Flooring: Wood, Tile
  • Total Bedrooms: 4
  • Main Level Bedrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 3450
  • Building Area Units: Square Feet
  • Living Area: 3450
  • Living Area Units: Square Feet

Exterior Features

  • Exterior Features: Gas Grill, Sprinkler System, Storage Building
  • Construction Type: Brick
  • Fencing: Privacy
  • Patio And Porch Features: Patio, Covered, Porch
  • Pool Features: In Ground
  • Pool Private: Yes
  • View: No
  • Waterfront: No

Garage/Parking

  • Attached Garage: Yes
  • Carport Y N: No
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Garage Yn: Yes
  • Parking Features: Attached
  • Total Parking Spaces: 2

Utilities

  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating: Natural Gas
  • Heating Yn: Yes
  • Utilities: Natural Gas Available, Water Available

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Lot Info

  • Lot Size Acres: 0.77
  • Lot Size: 171x245x101x250
  • Lot Size Units: Acres
  • Parcel #: 240-00 06 037.00
  • Property Attached Yn: No

Multi Family

  • Above Grade Finished Area Units: Square Feet

Tax Info

  • Tax Annual Amount: 3404

MLS Schools

  • Elementary School: Indian Hills Elementary School
  • High School: Hopkinsville High School
  • Middle Or Junior School: Hopkinsville Middle School

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 17, 2025
Closed on
Jul 11, 2025
Sold by
Nimon Brian and Nimon Loriel
Bought by
Mullins Sean and Mullins Rebecca Joy
Seller's Agent
Rachel Diuguid Smith
Legacy Real Estate Co.
Buyer's Agent
Rachel Diuguid Smith
Legacy Real Estate Co.
List Price
$564,900
Sold Price
$564,900
Views
29

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-8.00%
Original Mortgage
$451,920
Outstanding Balance
$451,920
Interest Rate
6.85%
Mortgage Type
New Conventional
Estimated Equity
$106,424

Purchase Details

Listed on
May 17, 2025
Closed on
Jun 16, 2025
Sold by
Dixon John M and Dixon Janet
Bought by
Nimon Loriel
Seller's Agent
Rachel Diuguid Smith
Legacy Real Estate Co.
Buyer's Agent
Rachel Diuguid Smith
Legacy Real Estate Co.
List Price
$564,900
Sold Price
$564,900
Views
29

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$451,920
Outstanding Balance
$451,920
Interest Rate
6.85%
Mortgage Type
New Conventional
Estimated Equity
$106,424

Purchase Details

Closed on
Oct 31, 2017
Sold by
Cavanah Barbara
Bought by
Wallace Properties Llc

Purchase Details

Closed on
Nov 25, 2013
Sold by
Federal Home Loan Mortgage Corporation
Bought by
Wallace Properties Llc

Purchase Details

Closed on
Mar 1, 2010
Sold by
Bond James D and Bond Janet R
Bought by
Wallace Russell H and Wallace Elizabeth A
Source: Public Records

Similar Homes in Hopkinsville, KY

  • 1241 Emerson Cir, Hopkinsville, KY 42240

    $515,000

    • 5 Beds
    • 3.5 Baths
    • 2,800 Sq Ft
    • 1241 Emerson Cir
    • Hopkinsville, KY

    Gorgeous home on just over 1 acre! Beautiful floors and tile in all wet areas. Large primary bedroom with separate tile shower and soaking tub. Kitchen has plenty of cabinet and counter space. SS appliances convey. Kitchen island tops off this amazing kitchen dining room. Formal dining room has plenty of space for a table. Privacy fence in backyard completes this gorgeous home. All personal items

    Joann Garcia Front Porch Realty & Property Management

    Section Image
  • 401 Cromwell Place, Hopkinsville, KY 42240

    $547,500

    • 4 Beds
    • 2.5 Baths
    • 3,600 Sq Ft
    • 401 Cromwell Place
    • Hopkinsville, KY

    LOCATION, LOCATION, LOCATION THIS EXCEPTIONALLY NICE 4 BEDROOM, 2.5 BATH ALL BRICK HOME SITS ON A BEAUTIFUL CORNER LOT IN COX MILL ESTATES. THE HOME HAS BEEN TASTEFULLY UPDATED WITH MANY MODERN FIXTURES. IT HAS A BEAUTIFUL TWO STORY STAIRCASE, PLANTATION SHUTTERS AND CROWN MOLDING THROUGHOUT. THE LARGE KITCHEN FEATURES AN ISLAND, GRANITE COUNTERTOPS, UNDER COUNTER LIGHTING AND A GAS STOVE. THE

    Janie Ezell TOWN AND COUNTRY REALTY

    Section Image
  • 17 Harton Place, Hopkinsville, KY 42240

    $699,900

    • 5 Beds
    • 3.5 Baths
    • 4,935 Sq Ft
    • 17 Harton Place
    • Hopkinsville, KY

    Stunning all-brick 5 bedroom, 3.5 bath home featuring a spacious bonus room with dual entries—one from inside the home and one from the garage. The open living room boasts soaring 23-ft ceilings, a cozy fireplace, and glass French sliding doors leading to the backyard. The large kitchen offers custom cabinetry, granite countertops, and plenty of workspace. Additional highlights include a workout

    Rachel Diuguid Smith Legacy Real Estate Co.

    Section Image
  • 28 Harton Place, Hopkinsville, KY 42240

    $595,000

    • 4 Beds
    • 5 Baths
    • 4,222 Sq Ft
    • 28 Harton Place
    • Hopkinsville, KY

    Spacious all-brick home tucked in a quiet cul-de-sac featuring 4 bedrooms (with potential for a 5th), 3 full bathrooms, and 2 half baths. This home offers a dedicated office, large kitchen with granite countertops, gas fireplace in the living room with built-ins, walk-in closets, and abundant storage throughout. Soaring vaulted ceilings, a convenient laundry chute from upstairs, and fresh

    Rachel Diuguid Smith LEGACY REAL ESTATE CO.

    Section Image
  • 230 Fairway Ct, Hopkinsville, KY 42240

    $489,900

    • 4 Beds
    • 2.5 Baths
    • 2,910 Sq Ft
    • 230 Fairway Ct
    • Hopkinsville, KY

    Prime location located on the golf course! This beautiful and spacious all brick home is located in Hunting Creek Subdivision. The home has two spacious living areas with two fireplaces with gas logs. There is a large formal dining room for all your entertainment needs. The home has four bedrooms, two and a half baths. The primary bedroom suite has an updated bathroom complete with a tiled shower

    Janie Ezell TOWN AND COUNTRY REALTY

    Section Image
  • 403 W Riverwood Dr, Hopkinsville, KY 42240

    $449,900

    • 3 Beds
    • 5 Baths
    • 3,349 Sq Ft
    • 403 W Riverwood Dr
    • Hopkinsville, KY

    Welcome to this stunning brick ranch offering over 3,000 sq ft of timeless elegance and modern comfort. Designed with both everyday living and entertaining in mind, this home features an open floor plan that spaciously connects the living, dining and kitchen areas - perfect for hosting friends and family. This home boasts three generously sized bedrooms, three full baths, and two convenient half

    Holly Hampton LEGACY REAL ESTATE CO.

    Section Image
  • 308 W Riverwood Dr, Hopkinsville, KY 42240

    $575,000

    • 5 Beds
    • 5 Baths
    • 3,674 Sq Ft
    • 308 W Riverwood Dr
    • Hopkinsville, KY

    Exquisite 5BR, 3F/2H BA all-brick estate, fully renovated to perfection. Gourmet custom kitchen boasts a grand quartz island & wood-burning fireplace, complemented by a spacious utility room w/ extra refrigerator, dishwasher, & abundant storage. Sophisticated details throughout: tile roof with extra tiles, elegant wood parquet floors, marble flooring in entry & hallway, rich built-ins, gas

    Rachel Diuguid Smith Legacy Real Estate Co.

    Section Image
  • 404 Cook Ct, Hopkinsville, KY 42240

    $499,900

    • 5 Beds
    • 3.5 Baths
    • 3,578 Sq Ft
    • 404 Cook Ct
    • Hopkinsville, KY

    Looking For A Spacious Home With Room For Everyone? This Is The One! Step Into A Large Open Entryway That Sets The tone For This Home. To The Right, You'll Find A Formal Dining Room And To The Left An Office With Sliding Wood Doors- Easily Converted Into A 6th Bedroom If Needed. Continue Into The Generously Sized Family Room Is Perfect For Large Gatherings, Featuring Wood Ceilings That Add

    Holly Gilkey Home Front Real Estate

    Section Image
  • 1711 Lovers Ln, Hopkinsville, KY 42240

    $474,900

    • 3 Beds
    • 2 Baths
    • 2,834 Sq Ft
    • 1711 Lovers Ln
    • Hopkinsville, KY

    Nestled in a serene setting just outside town, this expansive 2,800 sq ft home offers a perfect blend of comfort and convenience. Boasting three generously sized bedrooms and two full bathrooms, the residence provides ample space for family living. A highlight of the home is the large sunroom, which bathes the interior in natural light and offers a tranquil space to relax or entertain. The

    Scott Sanders Bolinger Real Estate & Auction, LLC

    Section Image

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 Type Sale Price Title Company
Deed $564,900 None Listed On Document
Deed $564,900 None Listed On Document
Deed -- None Listed On Document
Deed -- None Listed On Document
Deed $85,500 None Available
Special Warranty Deed $86,250 None Available
Deed $315,000 None Available
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $451,920 New Conventional
Closed $451,920 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/11/2025 07/11/25 Sold $564,900 0.0% $164 / Sq Ft
05/29/2025 05/29/25 Pending -- -- --
05/17/2025 05/17/25 For Sale $564,900 -- $164 / Sq Ft
Source: Realtracs

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 $3,404 $460,000 $0 $0
2023 $3,574 $460,000 $0 $0
2022 $3,116 $400,000 $0 $0
2021 $2,565 $325,500 $0 $0
2020 $2,578 $325,500 $0 $0
2019 $2,594 $325,500 $0 $0
2018 $2,594 $325,500 $0 $0
2017 $2,555 $325,500 $0 $0
2016 $2,529 $325,500 $0 $0
2015 $752 $325,500 $0 $0
2014 $752 $325,500 $0 $0
2013 -- $325,500 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Realtracs

MLS Number: 2887489

Realtracs

APN: 240-00-06-037.00