NOT LISTED FOR SALE

24116 Hammerhead Dr Millsboro, DE 19966

Estimated Value: $538,000 - $542,044

6 Beds
4.5 Baths
3,864 Sq Ft
$140/Sq Ft Est. Value

Last Sold October 28, 2024

Last sale price $529,990 $137 Per Sq Ft

Est. 3% increase in value since last sale

Current estimated payment $3,070/month

144 Days on Market

Highlights

  • Fitness Center
  • New Construction
  • Open Floorplan
  • Love Creek Elementary School Rated A
  • Pond View
  • Clubhouse

About This Home

As of October 2024

Welcome to your new home in Stonewater Creek at 24116 Hammerhead Drive in Millsboro, DE. The Ellerbe, a 3,864 square foot open concept two-story home with a finished basement, boasts six bedrooms, four-and-a-half bathrooms, a first-floor primary suite, a first-floor office, and a large second-floor loft. As you enter the home, the foyer leads you past the flex room which is the perfect space to use as a home office, formal dining space, den, or children’s play area. The well-designed kitchen, offering a large island, granite countertops, beautiful white cabinets, a walk-in corner pantry, and stainless steel appliances, flows neatly into the informal dining area and living room. Conveniently located on the first floor, the spacious primary suite has a private bathroom featuring a dual vanity, toilet closet, walk-in shower, and a large walk-in closet. The first-floor powder room is conveniently located down the hallway leading to the two-car garage. Upstairs, the huge loft area and additional four bedrooms provide enough space for everyone to rest and relax. Two additional bathrooms, an oversized linen closet, and a cozy laundry room complete the upstairs. This home includes a finished rec room, bedroom, and bathroom in the basement, an exclusive America’s Smart Home® package through ADT, and white window treatments. Pictures, artist renderings, photographs, colors, features, and sizes are for illustration purposes only and will vary from the homes as built. Image representative of plan only and may vary as built. Images are of model home and include custom design features that may not be available in other homes. Furnishings and decorative items not included with home purchase.

Last Agent to Sell the Property

Jay Heilman

(484) 643-3708 delawaremarketing@drhorton.com D.R. Horton Realty of Delaware, LLC License #RB-0020570 Listed on: 04/24/2024

D.R. Horton Realty of Delaware, LLC

Last Buyer's Agent

Elizabeth Johnson

(302) 677-0020 bethjohnsonsells@gmail.com Keller Williams Realty Central-Delaware License #RS-0024287

Keller Williams Realty Central-Delaware

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2023 | New Construction

Lot Details

  • 10,025 Sq Ft Lot
  • Cul-De-Sac
  • East Facing Home
  • Property is in excellent condition
  • Property is zoned AR-1

HOA Fees

  • $117 Monthly HOA Fees

Parking

  • 2 Car Direct Access Garage
  • 2 Driveway Spaces
  • Front Facing Garage

Home Design

  • Contemporary Architecture
  • Permanent Foundation
  • Poured Concrete
  • Blown-In Insulation
  • Batts Insulation
  • Architectural Shingle Roof
  • Vinyl Siding
  • Passive Radon Mitigation
  • Concrete Perimeter Foundation
  • Stick Built Home

Interior Spaces

  • Property has 2 Levels
  • Open Floorplan
  • Ceiling height of 9 feet or more
  • Recessed Lighting
  • Window Treatments
  • Home Office
  • Recreation Room
  • Loft
  • Carpet
  • Pond Views
  • Partially Finished Basement
  • Interior Basement Entry

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Upgraded Countertops
  • Disposal

Bedrooms and Bathrooms

  • En-Suite Bathroom
  • Walk-In Closet
  • Bathtub with Shower
  • Walk-in Shower

Laundry

  • Laundry Room
  • Laundry on upper level
  • Electric Dryer
  • Washer

Schools

  • Love Creek Elementary School
  • Beacon Middle School
  • Cape Henlopen High School

Utilities

  • 90% Forced Air Heating and Cooling System
  • Heating System Powered By Leased Propane
  • Programmable Thermostat
  • 200+ Amp Service
  • Electric Water Heater

Additional Features

  • More Than Two Accessible Exits
  • Energy-Efficient Appliances

Listing and Financial Details

  • Tax Lot 548
  • Assessor Parcel Number 234-16.00-257.00

Community Details

Overview

  • $500 Capital Contribution Fee
  • Association fees include common area maintenance, snow removal, trash
  • $175 Other One-Time Fees
  • Built by D.R. Horton
  • Stonewater Creek Subdivision, Ellerbe Floorplan
  • Property Manager

Amenities

  • Clubhouse

Recreation

  • Tennis Courts
  • Community Playground
  • Fitness Center
  • Community Pool

Home Details

Home Type

Single Family

Year Built

Built in 2023 | New Construction

Lot Details

0

HOA Fees

$117 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Contemporary
  • Sussex De Quadrants: Between Rt 1 & 113
  • Accessibility Features: 2+ Access Exits
  • Ownership: Fee Simple
  • New Construction: Yes
  • Story List: Lower 1, Main, Upper 1
  • Federal Flood Zone: No
  • Year Built: 2023
  • Automatically Close On Close Date: No
  • Special Features: NewHome
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer - Electric, Energy Efficient Appliances, Microwave, Refrigerator, Stainless Steel Appliances, Washer, Water Heater, Oven/Range - Gas
  • Flooring Type: Carpet
  • Interior Amenities: Carpet, Floor Plan - Open, Kitchen - Eat-In, Pantry, Primary Bath(s), Recessed Lighting, Bathroom - Stall Shower, Bathroom - Tub Shower, Upgraded Countertops, Walk-In Closet(s), Window Treatments, Kitchen - Island, Entry Level Bedroom
  • Fireplace: No
  • Wall Ceiling Types: 9'+ Ceilings, Dry Wall
  • Foundation Details: Passive Radon Mitigation, Permanent, Concrete Perimeter
  • Levels Count: 2
  • Room List: Basement, Laundry, Loft, Office, Recreation Room, Bedroom 6, Full Bath
  • Basement: Yes
  • Basement Type: Interior Access, Partially Finished, Poured Concrete
  • Laundry Type: Dryer In Unit, Washer In Unit, Upper Floor
  • Total Sq Ft: 3864
  • Living Area Sq Ft: 3864
  • Price Per Sq Ft: 191.89
  • Above Grade Finished Sq Ft: 2814
  • Below Grade Finished Sq Ft: 1050
  • Total Below Grade Sq Ft: 1050
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

  • Bedrooms: 6
  • Main Level Bedrooms: 1
  • All Lower Level Bedrooms: 1
  • Total Bathrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Level Bathrooms: 2.00
  • Upper Level Bathrooms: 2
  • Lower Levels Bathrooms: 1
  • Upper Level Bathrooms: 2.00
  • Lower Levels Bathrooms: 1.00
  • Main Level Full Bathrooms: 1
  • Lower Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Batts Insulation, Blown-In Insulation, Concrete, Stick Built, Vinyl Siding
  • Construction Completed: Yes
  • Exterior Features: Sidewalks, Street Lights
  • Roof: Architectural Shingle
  • View: Pond
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: Yes

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Features: Concrete Driveway
  • Garage Features: Garage - Front Entry, Inside Access
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 4
  • Type Of Parking: Attached Garage, Driveway
  • Number of Spaces in Driveway: 2

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C, Programmable Thermostat
  • Electric Service: 200+ Amp Service
  • Heating Fuel: Propane - Leased
  • Heating Type: 90% Forced Air, Programmable Thermostat
  • Heating: Yes
  • Hot Water: Electric
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 700.00
  • HOA Fee Frequency: Semi-Annually
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Club House, Fitness Center, Pool - Outdoor, Tennis Courts, Tot Lots/Playground
  • HOA Condo Co-Op Fee Includes: Common Area Maintenance, Snow Removal, Trash
  • HOA: Yes
  • Senior Community: No
  • Association Recreation Fee: No

Fee Information

  • Other Fees: 175.00
  • Other Fees Frequency: One Time
  • Capital Contribution Fee: 500.00

Schools

  • Elementary School Source: Listing Agent
  • High School Source: Listing Agent
  • Middle School Source: Listing Agent
  • School District Source: Listing Agent
  • Elementary School: LOVE CREEK
  • High School: CAPE HENLOPEN
  • Middle Or Junior School: BEACON

Lot Info

  • Lot Features: Cul-De-Sac
  • Lot Size Acres: 0.23
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 10025.00
  • Property Condition: Excellent
  • Zoning: AR-1
  • In City Limits: No

Green Features

  • R Factor Basement: 11

Building Info

  • Builder Name: D.R. Horton

Rental Info

  • Ground Rent Exists: No
  • Pets: Cats Ok, Dogs Ok
  • Pets Allowed: Yes
  • Vacation Rental: No
  • Property Manager: Yes

Tax Info

  • Assessor Parcel Number: 234-16.00-257.00
  • Tax Lot: 548

MLS Schools

  • School District Name: CAPE HENLOPEN

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 24, 2024
Closed on
Oct 28, 2024
Sold by
Jersey Dr Horton Inc-New
Bought by
Mcadam Ainsley and Mcadam Gwendolyn
Seller's Agent
Jay Heilman
D.R. Horton Realty of Delaware, LLC
Buyer's Agent
Elizabeth Johnson
Keller Williams Realty Central-Delaware
List Price
$556,490
Sold Price
$529,990
Premium/Discount to List
-$26,500
-4.76%
Views
38
Current Estimated Value
$546,518

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$16,528
Avg. Annual Appreciation
1.57%
Original Mortgage
$349,900
Outstanding Balance
$346,397
Interest Rate
6.09%
Mortgage Type
New Conventional
Estimated Equity
$193,114

Purchase Details

Closed on
Dec 20, 2023
Sold by
Double H Dev Corporation
Bought by
D R Horton Inc New Jersey

Purchase Details

Closed on
Nov 14, 2020
Sold by
7 Branch Llc
Bought by
Double H Development Llc
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
Mcadam Ainsley $529,990 None Listed On Document
Mcadam Ainsley $529,990 None Listed On Document
D R Horton Inc New Jersey $127,500 None Listed On Document
Double H Development Llc $2,550,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Mcadam Ainsley $349,900
Closed Mcadam Ainsley $349,900
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/28/2024 10/28/24 Sold $529,990 -1.9% $137 / Sq Ft
09/15/2024 09/15/24 Pending -- -- --
09/11/2024 09/11/24 Price Changed $539,990 -3.0% $140 / Sq Ft
04/24/2024 04/24/24 For Sale $556,490 -- $144 / Sq Ft
Source: Bright MLS

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 $944 $5,000 $5,000 $0
2024 $1,745 $5,000 $5,000 $0
2023 $246 $5,000 $5,000 $0
2022 $238 $5,000 $5,000 $0
2021 $235 $5,000 $5,000 $0
2020 $235 $5,000 $5,000 $0
2019 $235 $5,000 $5,000 $0
2018 $220 $5,000 $0 $0
2017 $210 $5,000 $0 $0
2016 $200 $5,000 $0 $0
2015 $191 $5,000 $0 $0
2014 $189 $5,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: DESU2061000

Bright MLS

APN: 234-16.00-257.00