Jeremy Burkholder
JAK Real Estate
(717) 748-5733
100 Total Sales
1 in Wilson-Conococheague
$152,000 Price
15918 Hosta Dr Hagerstown, MD 21740
Wilson-Conococheague NeighborhoodEstimated Value: $445,000 - $497,000
6
Beds
3
Baths
3,141
Sq Ft
$153/Sq Ft
Est. Value
Highlights
- Second Kitchen
- Open Floorplan
- Main Floor Bedroom
- Williamsport Elementary School Rated A-
- Rambler Architecture
- 1 Fireplace
About This Home
As of February 2025Step into a stunning transformation! This meticulously renovated 6-bedroom home boasts a modern aesthetic with sleek newly treated flooring, fresh paint throughout, new carpet, new heat pump, new windows, updated basement, perfect for entertaining with its own kitchen. The basement holds endless possibilities, it can be used as an in-law suite or rent it as an apartment with its 3 extra bedrooms. This home has 3 full bathrooms that have also been beautifully remodeled with new fixtures and finishes. Enjoy the open floor plan, high ceilings, abundant natural light, and a serene backyard - ideal for relaxing or outdoor dining. This move-in ready gem is the perfect blend of contemporary style and classic charm, located in the desirable neighborhood of Walnut Point Heights. This home is near commuter routes and minutes from shopping/dining areas. And did I mention! NO HOA!! Ready to view? Call me today!
Last Agent to Sell the Property
(681) 252-3002 burchregllc@gmail.com Burch Real Estate Group, LLC License #WVS220302161 Listed on: 12/12/2024
Last Buyer's Agent
(301) 975-9500 dtroupos@hotmail.com Long & Foster Real Estate, Inc. License #594784
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $3,409
Year Built
- Built in 2004 | Remodeled in 2024
Lot Details
- 15,045 Sq Ft Lot
- Property is in excellent condition
- Property is zoned RT
Parking
- 2 Car Attached Garage
- 2 Driveway Spaces
- Front Facing Garage
- On-Street Parking
Home Design
- Rambler Architecture
- Brick Exterior Construction
- Concrete Perimeter Foundation
Interior Spaces
- Property has 2 Levels
- Open Floorplan
- Ceiling Fan
- Recessed Lighting
- 1 Fireplace
- Double Pane Windows
- Dining Area
- Finished Basement
- Basement Windows
Kitchen
- Second Kitchen
- Electric Oven or Range
- Stove
- Built-In Microwave
- Extra Refrigerator or Freezer
- Ice Maker
- Dishwasher
- Disposal
Flooring
- Partially Carpeted
- Luxury Vinyl Plank Tile
Bedrooms and Bathrooms
- En-Suite Bathroom
- Walk-In Closet
Laundry
- Electric Dryer
- Washer
Accessible Home Design
- More Than Two Accessible Exits
- Level Entry For Accessibility
Outdoor Features
- Shed
Schools
- Clear Spring Middle School
- Clear Spring High School
Utilities
- Central Air
- Heat Pump System
- Vented Exhaust Fan
- Electric Water Heater
Community Details
- No Home Owners Association
- Walnut Point Heights Subdivision
Listing and Financial Details
- Tax Lot 4
- Assessor Parcel Number 2223021153
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Dec 12, 2024
Closed on
Feb 24, 2025
Sold by
Funes Freddie Zachary and Umanzor Nancy
Bought by
Seller's Agent
Tammi Tulloch
Burch Real Estate Group, LLC
Buyer's Agent
Danny Troupos
Long & Foster Real Estate, Inc.
List Price
$490,000
Sold Price
$470,000
Premium/Discount to List
-$20,000
-4.08%
Views
220
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$9,336
Avg. Annual Appreciation
1.29%
Original Mortgage
$376,000
Outstanding Balance
$370,886
Interest Rate
7.04%
Mortgage Type
New Conventional
Estimated Equity
$108,450
Purchase Details
Closed on
Nov 8, 2024
Sold by
Schieferstein Donna H
Bought by
Funes Freddie Zachary and Umanzor Lesly Gisselle
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$269,487
Interest Rate
6.32%
Mortgage Type
New Conventional
Purchase Details
Closed on
Nov 22, 2004
Sold by
Walnut Point Road Limited Ptnshp
Bought by
Schieferstein George J and Schieferstein Donna H
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Wilson-Conococheague, MD
-
Jeremy Burkholder
-
Lori Gardenhour
Lori Gardenhour
The KW Collective
(814) 747-6430
195 Total Sales
1 in Wilson-Conococheague
$427,000 Price
-
Josephine Cicolini
Josephine Cicolini
Berkshire Hathaway HomeServices PenFed Realty
(240) 663-5808
41 Total Sales
1 in Wilson-Conococheague
$320,000 Price
-
Steve Powell
Steve Powell
Samson Properties
(240) 730-4419
188 Total Sales
1 in Wilson-Conococheague
$185,000 Price
-
Chris Dickerson
Chris Dickerson
The Glocker Group Realty Results
(814) 747-6437
253 Total Sales
4 in Wilson-Conococheague
$69K - $350K Price Range
-
Jim Bass
Jim Bass
Real Estate Teams, LLC
(240) 693-3591
411 Total Sales
1 in Wilson-Conococheague
$308,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $470,000 | Rgs Title | ||
| Funes Freddie Zachary | $283,670 | None Listed On Document | |
| Schieferstein George J | $40,000 | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $376,000 | ||
| Previous Owner | Funes Freddie Zachary | $269,487 | |
| Previous Owner | Schieferstein George J | $179,500 | |
| Previous Owner | Schieferstein George J | $182,860 | |
| Previous Owner | Schieferstein George J | $164,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 02/24/2025 02/24/25 | Sold | $470,000 | 0.0% | $150 / Sq Ft |
| 01/08/2025 01/08/25 | Price Changed | $470,000 | -4.1% | $150 / Sq Ft |
| 12/12/2024 12/12/24 | For Sale | $490,000 | -- | $156 / Sq Ft |
Source: Bright MLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 |
|---|---|---|---|---|
| 2026 | $3,795 | $405,200 | $62,500 | $342,700 |
| 2025 | $3,795 | $366,500 | $0 | $0 |
| 2024 | $5,726 | $327,800 | $0 | $0 |
| 2023 | $2,988 | $289,100 | $62,500 | $226,600 |
| 2022 | $2,846 | $275,800 | $0 | $0 |
| 2021 | $2,630 | $262,500 | $0 | $0 |
| 2020 | $2,630 | $249,200 | $62,500 | $186,700 |
| 2019 | $2,642 | $249,200 | $62,500 | $186,700 |
| 2018 | $2,642 | $249,200 | $62,500 | $186,700 |
| 2017 | $2,586 | $254,300 | $0 | $0 |
| 2016 | -- | $239,433 | $0 | $0 |
| 2015 | $2,468 | $224,567 | $0 | $0 |
| 2014 | $2,468 | $209,700 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Tammi Tulloch
Seller's Agent in 2025
Tammi Tulloch
Burch Real Estate Group, LLC
(301) 547-9181
1 in this area
99 Total Sales
-
Danny Troupos
Buyer's Agent in 2025
Danny Troupos
Long & Foster
(301) 591-2120
1 in this area
31 Total Sales
Map
Source: Bright MLS
MLS Number: MDWA2025910
APN: 23-021153
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website appears in part through the BRIGHT Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by BRIGHT through a licensing agreement.
Listing information is from various brokers who participate in the Bright MLS IDX program and not all listings may be visible on the site.
The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale.
Property information displayed is deemed reliable but is not guaranteed.
Copyright 2026 Bright MLS, Inc.
Nearby Homes
- 16218 Mcgregor Dr
- 0 Walnut Point W
- 12021 Heather Dr
- 16256 Mcgregor Dr
- 12321 Walnut Point W
- 12115 Heather Dr
- 12331 Walnut Point W
- 16512 National Pike
- 15220 National Pike
- 12463 Gateway Ave
- 16105 Wright Rd
- 12527 Rockdale Rd
- 15029 Clear Spring Rd
- 10901 Hopewell Rd
- 16251 Mount Tabor Rd
- 11307 Hawthorne Ct
- 16935 Longfellow Ct
- 10738 Apple Tree Ln
- 10727 Apple Tree Ln
- 16904 Pickwick Ln Unit 307
- 15914 Hosta Dr
- 15922 Hosta Dr
- 15913 Rhododendron Dr
- 15910 Hosta Dr
- 15917 Rhododendron Dr
- 15919 Hosta Dr
- 15909 Rhododendron Dr
- 15921 Rhododendron Dr
- 15930 Hosta Dr
- 15906 Hosta Dr
- 15905 Rhododendron Dr
- 11808 Jasmine Ct
- 15927 Hosta Dr
- 15909 Hosta Dr
- 15925 Rhododendron Dr
- 15934 Hosta Dr
- 15905 Hosta Dr
- 15912 Rhododendron Dr
- 11720 White Pine Dr
- 15901 Rhododendron Dr
Your Personal Tour Guide
Ask me questions while you tour the home.