RENTED JUN 26, 2025

5 N Edinburgh Ct Houston, DE 19954

4 Beds
2.5 Baths
2,612 Sq Ft
0.5 Acres

Last Sold May 30, 2014

Last sale price $49,000 $19 Per Sq Ft

Highlights

  • In Ground Pool
  • Cape Cod Architecture
  • Attic
  • Water Oriented
  • Main Floor Bedroom
  • Loft

About This Home

As of June 2025

**Available July 1, 2025** Welcome to The Mists at Blairs Pond - a beautiful community nestled along Blairs Pond and centrally located between Rt. 13 & 113 and just minutes to Milford. Here you have a stunning custom built JBS home situated on half an acre with in-ground saltwater pool and pool shed. Step inside from the covered front porch to a grand foyer with two story ceilings that opens to the living room with gas fireplace. Just off the living area you have a dining room with slider doors leading out to the back yard and opens to the kitchen. This gorgeous kitchen design features a center island with eating bar, quartz countertops, tile backsplash, stainless Whirlpool appliances and upgraded cabinets. The entry level primary suite features a large walk in closet, ensuite with dual sink vanity, tile shower stall and whirlpool soaking tub. Head upstairs to find a loft space, three bedrooms and a full bathroom. Enjoy this summer poolside with this in-ground saltwater pool with slide and pool house/shed with rough in plumbing for a bathroom. Call today to schedule your private tour!

Last Agent to Rent the Property

Joni Barrow

Keller Williams Realty License #0670157 Listed on: 05/05/2025

Keller Williams Realty

Last Renter's Agent

Joni Barrow

Keller Williams Realty License #0670157 Listed on: 05/05/2025

Keller Williams Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2018

Lot Details

  • 0.5 Acre Lot
  • Lot Dimensions are 125.38 x 166.93
  • Cul-De-Sac
  • Extensive Hardscape
  • Cleared Lot
  • Back Yard Fenced and Front Yard
  • Property is zoned AR

HOA Fees

  • $17 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • 6 Driveway Spaces
  • Side Facing Garage
  • Garage Door Opener

Home Design

  • Cape Cod Architecture
  • Block Foundation
  • Vinyl Siding

Interior Spaces

  • 2,612 Sq Ft Home
  • Property has 2 Levels
  • Ceiling Fan
  • Recessed Lighting
  • Gas Fireplace
  • Window Treatments
  • Window Screens
  • Entrance Foyer
  • Living Room
  • Loft
  • Attic

Kitchen

  • Eat-In Kitchen
  • Built-In Oven
  • Electric Oven or Range
  • Range Hood
  • Microwave
  • Ice Maker
  • Kitchen Island
  • Upgraded Countertops

Flooring

  • Carpet
  • Luxury Vinyl Plank Tile

Bedrooms and Bathrooms

  • En-Suite Primary Bedroom
  • En-Suite Bathroom
  • Walk-In Closet
  • Soaking Tub
  • Bathtub with Shower
  • Walk-in Shower

Laundry

  • Laundry Room
  • Laundry on main level
  • Dryer
  • Washer

Home Security

  • Exterior Cameras
  • Surveillance System
  • Storm Doors
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Accessible Home Design

  • More Than Two Accessible Exits

Pool

  • In Ground Pool
  • Saltwater Pool
  • Pool Equipment Shed

Outdoor Features

  • Water Oriented
  • Property is near a pond
  • Patio
  • Rain Gutters
  • Porch

Utilities

  • Central Air
  • Heat Pump System
  • Well
  • Electric Water Heater
  • Gravity Septic Field

Community Details

  • Mists At Blairs Pond Subdivision

Listing and Financial Details

  • Residential Lease
  • Security Deposit $3,200
  • Tenant pays for all utilities
  • Rent includes hoa/condo fee, trash removal
  • No Smoking Allowed
  • 12-Month Lease Term
  • Available 7/1/25
  • Assessor Parcel Number MD-00-18104-02-0400-000

Home Details

Home Type

Single Family

Year Built

Built in 2018

Lot Details

0

HOA Fees

$17 per month

Parking

2

Rental Info

  • Date Available: 2025-07-01
  • Pets Allowed: No
  • Rent Includes: Hoa/Condo Fee, Trash Removal
  • Security Deposit: 3200.00
  • Smoking Allowed Yn: No
  • Tenant Pays: Utilities - All
  • Vacation Rental: No
  • Max Lease in Months: 12
  • Min Lease in Months: 12
  • Rent Spree Online Application: No

Listing Details

  • Property Type: Residential Lease
  • Structure Type: Detached
  • Architectural Style: Cape Cod
  • Accessibility Features: 2+ Access Exits
  • New Construction: No
  • Story List: Main, Upper 1
  • Year Built: 2018
  • Remarks Public: **Available July 1, 2025** Welcome to The Mists at Blairs Pond - a beautiful community nestled along Blairs Pond and centrally located between Rt. 13 & 113 and just minutes to Milford. Here you have a stunning custom built JBS home situated on half an acre with in-ground saltwater pool and pool shed. Step inside from the covered front porch to a grand foyer with two story ceilings that opens to the living room with gas fireplace. Just off the living area you have a dining room with slider doors leading out to the back yard and opens to the kitchen. This gorgeous kitchen design features a center island with eating bar, quartz countertops, tile backsplash, stainless Whirlpool appliances and upgraded cabinets. The entry level primary suite features a large walk in closet, ensuite with dual sink vanity, tile shower stall and whirlpool soaking tub. Head upstairs to find a loft space, three bedrooms and a full bathroom. Enjoy this summer poolside with this in-ground saltwater pool with slide and pool house/shed with rough in plumbing for a bathroom. Call today to schedule your private tour!
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Oven/Range - Electric, Range Hood, Oven - Wall, Refrigerator, Icemaker, Microwave, Washer, Dryer
  • Flooring Type: Carpet, Luxury Vinyl Plank
  • Interior Amenities: Attic, Ceiling Fan(s), Entry Level Bedroom, Kitchen - Eat-In, Kitchen - Island, Primary Bath(s), Recessed Lighting, Bathroom - Soaking Tub, Bathroom - Stall Shower, Bathroom - Tub Shower, Upgraded Countertops, Walk-In Closet(s), Window Treatments
  • Window Features: Screens
  • Fireplace Features: Gas/Propane
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Door Features: Storm
  • Foundation Details: Block
  • Levels Count: 2
  • Room List: Living Room, Primary Bedroom, Bedroom 2, Bedroom 3, Kitchen, Foyer, Laundry, Loft, Primary Bathroom, Full Bath, Half Bath
  • Basement: No
  • Laundry Type: Has Laundry, Main Floor
  • Total Sq Ft: 2612
  • Living Area Sq Ft: 2612
  • Price Per Sq Ft: 1.15
  • Above Grade Finished Sq Ft: 2612
  • Above Grade Finished Area Units: Square Feet
  • Street Number Modifier: 5

Beds/Baths

  • Bedrooms: 4
  • Main Level Bedrooms: 1
  • Total Bathrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Main Level Bathrooms: 2.00
  • Upper Level Bathrooms: 1
  • Upper Level Bathrooms: 1.00
  • Main Level Full Bathrooms: 1
  • Upper Level Full Bathrooms: 1
  • Main Level Half Bathrooms: 1

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Other Structures List: Pool Equipment Shed
  • Construction Materials: Vinyl Siding
  • Exterior Features: Extensive Hardscape, Gutter System, Sidewalks
  • Pool Features: In Ground, Saltwater
  • Water Access: No
  • Water Body Name: Blairs Pond
  • Water Body Type: Pond
  • Waterfront: No
  • Water Oriented: Yes
  • Pool: Yes - Personal
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Parking Features: Paved Driveway
  • Garage Features: Garage Door Opener, Garage - Side Entry
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 8
  • Type Of Parking: Attached Garage, Driveway
  • Number of Spaces in Driveway: 6

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C
  • Electric Service: Circuit Breakers
  • Heating Fuel: Electric
  • Heating Type: Heat Pump(s)
  • Heating: Yes
  • Hot Water: Electric
  • Security: Exterior Cameras, Surveillance Sys, Smoke Detector, Carbon Monoxide Detector(s)
  • Sewer/Septic System: Gravity Sept Fld
  • Water Source: Well

Condo/Co-op/Association

  • HOA Fees: 200.00
  • HOA Fee Frequency: Annually
  • Condo Co-Op Association: No
  • HOA: Yes
  • Senior Community: No

Schools

  • School District: MILFORD
  • School District Key: 300200396885
  • School District Source: Listing Agent

Lot Info

  • Fencing: Fully, Rear
  • Lot Features: Cleared, Cul-De-Sac, Front Yard, Rear Yard
  • Lot Size Acres: 0.50
  • Lot Dimensions: 125.38 x 166.93
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 21789.00
  • Outdoor Living Structures: Porch(es), Patio(s)
  • Zoning: AR
  • In City Limits: No

Tax Info

  • Assessor Parcel Number: MD-00-18104-02-0400-000
  • Close Date: 06/26/2025

MLS Schools

  • School District Name: MILFORD

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

Property History

Date Event Price Change Sq Ft Price
06/26/2025 06/26/25 Rented $3,000 0.0% --
05/27/2025 05/27/25 Price Changed $3,000 -6.3% $1 / Sq Ft
05/05/2025 05/05/25 For Rent $3,200 +14.3% --
04/17/2023 04/17/23 Rented $2,800 0.0% --
04/17/2023 04/17/23 Under Contract -- -- --
04/10/2023 04/10/23 Price Changed $2,800 -6.7% $1 / Sq Ft
03/31/2023 03/31/23 For Rent $3,000 0.0% --
05/30/2014 05/30/14 Sold $49,000 -10.9% --
05/09/2014 05/09/14 Pending -- -- --
10/10/2012 10/10/12 For Sale $55,000 -- --
Source: Bright MLS

Tax History Compared to Growth

Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Bright MLS

MLS Number: DEKT2037330

Bright MLS