$615,800
SOLD JAN 30, 2025

123 Song Sparrow Dr Lake Frederick, VA 22630

3 Beds
3 Baths
2,597 Sq Ft
6,970 Sq Ft Lot

Recently Sold

$237 Per Sq Ft

1% Below List Price

22 Days on Market

Highlights

  • Bar or Lounge
  • Active Adult
  • Gated Community
  • Fitness Center
  • Gourmet Kitchen
  • View of Trees or Woods

About This Home

As of January 2025

Step into this charming retreat where elegance and comfort blend seamlessly in the thoughtfully designed Aspen Model by Shea Homes featuring 3 beds, 3 baths, a loft, a screened porch, and a fenced yard. From the inviting wide front porch, ideal for unwinding on a quiet street, this home welcomes you with style and warmth.

Inside, beautiful hardwood floors span the main level, adding warmth and character to every space. Sunlight pours in through large windows, illuminating the home’s elegant details, including custom trim work, crown molding, chair railings, and wainscoting. With two bedrooms on the main floor, the convenience of first-floor living is truly maximized. Relax in the cozy living room by the gas fireplace, or stay productive in the home office, thoughtfully designed with a custom wall unit for a refined workspace.

The gourmet kitchen is a chef’s paradise, thoughtfully designed with a sprawling center island perfect for both prep work and casual dining. Elegant granite countertops complement the abundant custom cabinetry, providing ample storage for all your culinary essentials. Outfitted with high-end stainless steel appliances, this kitchen seamlessly combines style and function, making it an ideal space for everything from everyday meals to entertaining guests.

Upstairs, a spacious family room awaits, providing versatile living space that’s perfect for relaxation or entertainment. This level also includes an additional bedroom and full bathroom, creating an ideal private suite for guests.

At the back, a beautiful screened-in porch with a soaring cathedral ceiling and fan provides the perfect retreat to relax and take in views of the meticulously landscaped, fenced backyard. Surrounded by lush common areas and mature trees, the home offers a serene and private outdoor oasis, blending luxury with comfortable livability.

Nestled in a sought-after location, this home is part of a truly welcoming community, affectionately known as "The Magic Kingdom." Here, you'll enjoy the warmth of great neighbors and the camaraderie of a neighborhood that feels like family. With multiple locally organized events throughout the year, this vibrant community offers endless opportunities to connect, celebrate, and make lasting memories right at home.

As a resident of Trilogy at Lake Frederick, you'll enjoy a wealth of incredible amenities designed to enhance your lifestyle. Dive into relaxation with both indoor and outdoor pools, stay active in the state-of-the-art fitness center, and unwind at the well-equipped community clubhouse. Savor gourmet meals at the farm-to-table restaurant and socialize in the exclusive members-only lounge. For the sports enthusiasts, tennis and pickleball courts, as well as a dog park, offer ample opportunities for recreation, while extensive lake trails beckon for serene strolls and outdoor adventures. Join a vibrant community of welcoming neighbors and future friends. Experience the pinnacle of resort living at Trilogy at Lake Frederick—where your dream home and ideal lifestyle come together seamlessly.

Last Agent to Sell the Property

Matt Boyer

(540) 435-7839 matt@boyerre.com Keller Williams Realty License #0225230557 Listed on: 11/15/2024

Keller Williams Realty

Co-Listed By

Kelley Boyer

(703) 231-8815 kelley@boyerre.com Keller Williams Realty License #0225238737

Last Buyer's Agent

Paul Gallagher

(540) 550-7116 pjgallagherjr81@gmail.com Colony Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,742

Year Built

  • Built in 2019

Lot Details

  • 6,970 Sq Ft Lot
  • Backs To Open Common Area
  • Back Yard Fenced
  • Landscaped
  • Premium Lot
  • Property is zoned R5

HOA Fees

  • $380 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Craftsman Architecture
  • Slab Foundation
  • HardiePlank Type

Interior Spaces

  • 2,597 Sq Ft Home
  • Property has 2 Levels
  • Open Floorplan
  • Built-In Features
  • Chair Railings
  • Crown Molding
  • Wainscoting
  • Cathedral Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Gas Fireplace
  • Entrance Foyer
  • Sitting Room
  • Living Room
  • Dining Room
  • Home Office
  • Screened Porch
  • Views of Woods

Kitchen

  • Gourmet Kitchen
  • Gas Oven or Range
  • Built-In Microwave
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Kitchen Island
  • Upgraded Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

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

Laundry

  • Laundry Room
  • Laundry on main level

Outdoor Features

  • Deck
  • Screened Patio

Location

  • Suburban Location

Utilities

  • Forced Air Heating and Cooling System
  • Natural Gas Water Heater

Listing and Financial Details

  • Tax Lot 11
  • Assessor Parcel Number 87B 5 1 11

Community Details

Overview

  • Active Adult
  • $1,520 Capital Contribution Fee
  • Association fees include common area maintenance, lawn maintenance, recreation facility, security gate, snow removal, trash
  • $4,000 Other One-Time Fees
  • Active Adult | Residents must be 55 or older
  • Shenandoah HOA
  • Built by Shea Homes
  • Shenandoah Subdivision, Aspen Floorplan
  • Property Manager
  • Community Lake

Amenities

  • Common Area
  • Clubhouse
  • Game Room
  • Art Studio
  • Recreation Room
  • Bar or Lounge

Recreation

  • Tennis Courts
  • Fitness Center
  • Community Indoor Pool
  • Lap or Exercise Community Pool
  • Jogging Path

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,742

Year Built

Built in 2019

Lot Details

0

HOA Fees

$380 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Structure Type: Detached
  • Architectural Style: Craftsman
  • Ownership: Fee Simple
  • New Construction: No
  • Story List: Main, Upper 1
  • Expected On Market: 2024-11-15
  • Year Built: 2019
  • Automatically Close On Close Date: No
  • Special Features: VirtualTour
  • Property Sub Type: Detached

Interior Features

  • Appliances: Built-In Microwave, Dishwasher, Disposal, Refrigerator, Icemaker, Oven/Range - Gas, Stainless Steel Appliances
  • Flooring Type: Ceramic Tile, Carpet, Hardwood
  • Interior Amenities: Ceiling Fan(s), Crown Moldings, Chair Railings, Wainscotting, Wood Floors, Recessed Lighting, Floor Plan - Open, Upgraded Countertops, Built-Ins, Walk-In Closet(s), Bathroom - Walk-In Shower, Carpet, Dining Area, Entry Level Bedroom, Kitchen - Gourmet, Kitchen - Island, Pantry, Primary Bath(s)
  • Fireplace Features: Gas/Propane
  • Fireplaces Count: 1
  • Fireplace: Yes
  • Wall Ceiling Types: 9'+ Ceilings, Cathedral Ceilings
  • Foundation Details: Slab
  • Levels Count: 2
  • Room List: Living Room, Dining Room, Primary Bedroom, Sitting Room, Bedroom 3, Kitchen, Foyer, Bedroom 1, Laundry, Office, Bathroom 3, Primary Bathroom, Screened Porch
  • Basement: No
  • Laundry Type: Main Floor
  • Total Sq Ft: 2597
  • Living Area Sq Ft: 2597
  • Price Per Sq Ft: 240.66
  • Above Grade Finished Sq Ft: 2597
  • Above Grade Finished Area Units: Square Feet

Beds/Baths

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

Exterior Features

  • Other Structures: Above Grade, Below Grade
  • Construction Materials: Hardiplank Type, Mixed
  • View: Trees/Woods
  • Water Access: No
  • Waterfront: No
  • Water Oriented: No
  • Pool: Yes - Community
  • Tidal Water: No
  • Water View: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage: Yes
  • Garage Features: Garage - Front Entry, Garage Door Opener
  • Attached Garage Spaces: 2
  • Total Garage And Parking Spaces: 2
  • Type Of Parking: Attached Garage, Driveway

Utilities

  • Central Air Conditioning: Yes
  • Cooling Fuel: Electric
  • Cooling Type: Central A/C, Ceiling Fan(s)
  • Heating Fuel: Natural Gas
  • Heating Type: Forced Air
  • Heating: Yes
  • Hot Water: Natural Gas
  • Sewer/Septic System: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • HOA Fees: 380.00
  • HOA Fee Frequency: Monthly
  • Condo Co-Op Association: No
  • HOA Condo Co-Op Amenities: Art Studio, Bar/Lounge, Club House, Common Grounds, Exercise Room, Fitness Center, Game Room, Gated Community, Jog/Walk Path, Lake, Pool - Outdoor, Pool - Indoor, Recreational Center, Retirement Community, Swimming Pool, Tennis Courts
  • HOA Condo Co-Op Fee Includes: Common Area Maintenance, Lawn Maintenance, Recreation Facility, Security Gate, Snow Removal, Trash
  • HOA Name: SHENANDOAH HOA
  • HOA: Yes
  • Senior Community Age Requirement: 55
  • Senior Community: Yes
  • Community Pool Features: In Ground, Indoor, Lap/Exercise

Fee Information

  • Other Fees: 4000.00
  • Other Fees Frequency: One Time
  • Capital Contribution Fee: 1520.00

Schools

  • School District Source: Listing Agent

Lot Info

  • Fencing: Rear
  • Lot Features: Backs - Open Common Area, Landscaping, Premium
  • Lot Size Acres: 0.16
  • Lot Size Units: Square Feet
  • Lot Sq Ft: 6970.00
  • Outdoor Living Structures: Deck(s), Porch(es), Screened
  • Zoning: R5
  • In City Limits: No

Building Info

  • Builder Name: Shea Homes

Rental Info

  • Vacation Rental: No
  • Property Manager: Yes

Tax Info

  • Tax Annual Amount: 2742.00
  • Assessor Parcel Number: 87B 5 1 11
  • Tax Lot: 11
  • County Tax Payment Frequency: Annually
  • Tax Year: 2022

MLS Schools

  • School District Name: FREDERICK COUNTY PUBLIC SCHOOLS

Matterport 3D Tour

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 15, 2024
Closed on
Jan 27, 2025
Sold by
Pingrey Jeffrey Wayne and Pingrey Anne Louise
Bought by
Menefee Robin F
Seller's Agent
Matt Boyer
Keller Williams Realty
Buyer's Agent
Paul Gallagher
Colony Realty
List Price
$625,000
Sold Price
$615,800
Premium/Discount to List
-$9,200
-1.47%
Views
38
Current Estimated Value
$642,370

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$26,570
Avg. Annual Appreciation
5.35%
Original Mortgage
$225,000
Outstanding Balance
$223,613
Interest Rate
6.72%
Mortgage Type
New Conventional
Estimated Equity
$418,757

Purchase Details

Closed on
Feb 28, 2019
Sold by
Shea Homes Lp
Bought by
Pingrey Jeffrey Wayne and Pingrey Anne Louise

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$109,000
Interest Rate
4.4%
Mortgage Type
New Conventional
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 Type Sale Price Title Company
Deed $615,800 Accommodation/Courtesy Recordi
Special Warranty Deed $425,502 Walker Title Llc
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $225,000 New Conventional
Previous Owner $109,000 New Conventional
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/30/2025 01/30/25 Sold $615,800 -1.5% $237 / Sq Ft
11/15/2024 11/15/24 For Sale $625,000 -- $241 / 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 $3,039 $633,100 $108,000 $525,100
2024 $1,250 $490,000 $92,000 $398,000
2023 $2,499 $490,000 $92,000 $398,000
2022 $2,742 $449,500 $87,000 $362,500
2021 $2,742 $449,500 $87,000 $362,500
2020 $2,431 $398,600 $87,000 $311,600
2019 $1,939 $394,300 $87,000 $307,300
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Bright MLS

MLS Number: VAFV2022700

Bright MLS

APN: 87B5-1-11