Seller's Agent in 2025
Jay Day
LPT Realty, LLC
(866) 702-9038
1 in this area
1,192 Total Sales
492 Herringbone Way Frederick, MD 21701
East Frederick Neighborhood
3
Beds
3.5
Baths
2,532
Sq Ft
$112/mo
HOA Fee
Highlights
- Fitness Center
- Gourmet Kitchen
- Colonial Architecture
- Spring Ridge Elementary School Rated A-
- Open Floorplan
- Main Floor Bedroom
About This Home
As of February 2025**OPEN HOUSE SUNDAY 1/19/25 FROM 1:00 PM TO 3:00PM**
Welcome to your dream home, a stunning contemporary end unit villa that perfectly blends modern elegance with inviting warmth. Built in 2023, this exquisite property boasts 2,532 square feet of thoughtfully designed living space, featuring three spacious bedrooms, three and a half bathrooms, plus a large loft/recreation room. Step into the heart of the home, where the kitchen shines with upgraded countertops, stainless steel appliances, and a convenient island that invites culinary creativity. Enjoy the luxury of a main-level bedroom and a primary suite complete with a walk-in closet and a beautifully appointed bathroom. Natural light floods through double-pane windows, enhancing the inviting atmosphere throughout. The home is equipped with modern conveniences, including a monitored security system and main floor laundry hookups, ensuring comfort and peace of mind. Outside, the community offers a wealth of amenities, including a refreshing outdoor pool, fitness center, and scenic jog/walk paths, perfect for an active lifestyle. With an attached garage and driveway parking, convenience is at your fingertips. Nestled in a vibrant community, this property is not just a home; it’s a lifestyle. Experience the perfect blend of comfort, style, and community living. Don’t miss your chance to make this exceptional villa your own!
Last Agent to Sell the Property
(866) 702-9038 jayday@dayhometeam.com LPT Realty, LLC Listed on: 01/16/2025
Townhouse Details
Home Type
- Townhome
Est. Annual Taxes
- $9,340
Year Built
- Built in 2023
Lot Details
- 6,384 Sq Ft Lot
- Property is Fully Fenced
- Privacy Fence
- Vinyl Fence
- Property is in excellent condition
HOA Fees
- $112 Monthly HOA Fees
Parking
- 2 Car Direct Access Garage
- 2 Driveway Spaces
- Front Facing Garage
- Garage Door Opener
Home Design
- Colonial Architecture
- Contemporary Architecture
- Villa
- Slab Foundation
- Asphalt Roof
- Metal Roof
- HardiePlank Type
- Stick Built Home
- Masonry
Interior Spaces
- 2,532 Sq Ft Home
- Property has 2 Levels
- Open Floorplan
- Ceiling height of 9 feet or more
- Ceiling Fan
- Recessed Lighting
- Double Pane Windows
- Insulated Doors
- Entrance Foyer
- Great Room
- Family Room Off Kitchen
- Dining Room
- Loft
- Utility Room
- Monitored
Kitchen
- Gourmet Kitchen
- Built-In Oven
- Cooktop with Range Hood
- Built-In Microwave
- Ice Maker
- Dishwasher
- Stainless Steel Appliances
- Kitchen Island
- Upgraded Countertops
- Disposal
Flooring
- Carpet
- Ceramic Tile
- Luxury Vinyl Plank Tile
Bedrooms and Bathrooms
- En-Suite Bathroom
- Walk-In Closet
- Bathtub with Shower
- Walk-in Shower
Laundry
- Laundry Room
- Laundry on main level
- Washer and Dryer Hookup
Schools
- Spring Ridge Elementary School
- Gov. Thomas Johnson Middle School
- Gov. Thomas Johnson High School
Utilities
- Forced Air Heating and Cooling System
- Vented Exhaust Fan
- Water Dispenser
- Electric Water Heater
Listing and Financial Details
- Assessor Parcel Number 1102604775
- $350 Front Foot Fee per year
Community Details
Overview
- Association fees include common area maintenance, lawn care front, pool(s), reserve funds
- Renn Quarter HOA
- Built by DR Horton
- Renn Quarter Subdivision, Primrose Floorplan
Amenities
- Recreation Room
Recreation
- Community Playground
- Fitness Center
- Community Pool
- Dog Park
- Jogging Path
Pet Policy
- Pets Allowed
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jan 16, 2025
Closed on
Feb 21, 2025
Sold by
Lyons Jeffrey James and Lyons Tonya Kim
Bought by
Varakantham Bhagyalaxmi and Lingidi Virat Maharshi
Seller's Agent
Jay Day
LPT Realty, LLC
Buyer's Agent
Sunna Ahmad
Cummings & Co. Realtors
List Price
$665,000
Sold Price
$660,000
Premium/Discount to List
-$5,000
-0.75%
Views
21
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
$571
Avg. Annual Appreciation
0.10%
Original Mortgage
$627,000
Outstanding Balance
$622,836
Interest Rate
7.04%
Mortgage Type
New Conventional
Estimated Equity
$37,735
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Deed | $660,000 | Fidelity National Title | |
| Deed | $660,000 | Fidelity National Title |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $627,000 | New Conventional | |
| Closed | $627,000 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 02/21/2025 02/21/25 | Sold | $660,000 | -0.8% | $261 / Sq Ft |
| 01/16/2025 01/16/25 | For Sale | $665,000 | -- | $263 / Sq Ft |
Source: Bright MLS
Tax History Compared to Growth
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 | $9,340 | $545,700 | $150,000 | $395,700 |
| 2024 | $9,340 | $504,800 | $0 | $0 |
| 2023 | $8,428 | $463,900 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Jay Day
-
Christina Day
Seller Co-Listing Agent in 2025
Christina Day
LPT Realty, LLC
(240) 405-4883
1 in this area
222 Total Sales
-
Sunna Ahmad
Buyer's Agent in 2025
Sunna Ahmad
Cummings & Co. Realtors
(562) 787-0424
1 in this area
297 Total Sales
Map
Source: Bright MLS
MLS Number: MDFR2058544
APN: 02-604775
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 2025 Bright MLS, Inc.
Nearby Homes
- 485 Hanson St
- Carlton Plan at Renn Quarter
- Hadley Plan at Renn Quarter
- Summit Plan at Renn Quarter
- JADE Plan at Renn Quarter
- ALEC Plan at Renn Quarter
- Hampshire Plan at Renn Quarter
- Auburn Plan at Renn Quarter
- Norris Plan at Renn Quarter
- 459 Hanson St
- 480 Ensemble Way
- 461 Ensemble Way
- 459 Ensemble Way
- 455 Ensemble Way
- 449 Ensemble Way
- 447 Ensemble Way
- 445 Ensemble Way
- 443 Ensemble Way
- 721 Compass Way
- 719 Compass Way