The Aspen model by Shea Homes delivers the ease and convenience of single-level living, thoughtfully crafted with a focus on comfort, style, and functionality. Spanning 1,762 square feet, this beautifully designed home offers two generously sized bedrooms, two full bathrooms, and a versatile den—perfect for a home office or creative space. At the heart of the home, the open-concept layout seamlessly connects the gourmet kitchen, dining area, and great room, creating an inviting space ideal for entertaining or everyday living. The kitchen is a showstopper, featuring a spacious central island with seating, granite countertops, a subway tile backsplash, stainless steel appliances, a gas cooktop, double wall oven, and abundant cabinetry for storage. <br><br> Expansive windows fill the home with natural light, while the gas fireplace adds warmth and charm. The luxurious primary suite features a walk-in closet and a spa-inspired bath with double vanity and frameless glass shower. Hardwood floors flow through the main living areas, complemented by plush carpeting in the bedrooms for added comfort. <br><br> Outdoor living is just as thoughtfully designed with a charming covered front porch, a screened back porch perfect for relaxing year-round, and a paver patio with a seating wall—all surrounded by beautiful landscaping and tranquil views of the natural surroundings. Enjoy peaceful moments outdoors and frequent sightings of local wildlife. Additional highlights include a full laundry room with built-in storage and utility sink, and a two-car garage offering everyday convenience in this thoughtfully appointed home. <br><br> 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.
Sold for $550,000 on 07/31/25
$550,000
123 Mallard Dr, Lake Frederick, VA 22630
2beds
1,779sqft
Single Family Residence
Built in 2019
6,098 Square Feet Lot
$550,900 Zestimate®
$309/sqft
$2,233 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: July 31, 2025 at 10:55am
Listed by:
Matt Boyer 540-435-7839,
Keller Williams Realty,
Listing Team: Boyer Re Group, Co-Listing Team: Boyer Re Group,Co-Listing Agent: Kelley Christina Boyer 703-231-8815,
Keller Williams Realty
Bought with:
Lisa Cox, 0225194183
Colony Realty
Source: Bright MLS,MLS#: VAFV2034428

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
- Main level bathrooms: 2
- Main level bedrooms: 2
Primary bedroom
- Features: Walk-In Closet(s), Flooring - Carpet, Recessed Lighting
- Level: Main
- Area: 195 Square Feet
- Dimensions: 13 x 15
Bedroom 2
- Features: Flooring - Carpet, Recessed Lighting
- Level: Main
- Area: 132 Square Feet
- Dimensions: 12 x 11
Primary bathroom
- Features: Granite Counters, Recessed Lighting, Lighting - Pendants, Flooring - Ceramic Tile
- Level: Main
- Area: 99 Square Feet
- Dimensions: 9 x 11
Den
- Features: Flooring - HardWood, Recessed Lighting
- Level: Main
- Area: 143 Square Feet
- Dimensions: 13 x 11
Dining room
- Features: Flooring - HardWood, Lighting - Pendants
- Level: Main
- Area: 182 Square Feet
- Dimensions: 13 x 14
Foyer
- Features: Flooring - HardWood
- Level: Main
- Area: 95 Square Feet
- Dimensions: 5 x 19
Kitchen
- Features: Kitchen Island, Granite Counters, Kitchen - Gas Cooking, Lighting - Pendants, Recessed Lighting
- Level: Main
- Area: 143 Square Feet
- Dimensions: 13 x 11
Laundry
- Features: Flooring - Ceramic Tile, Built-in Features
- Level: Main
- Area: 120 Square Feet
- Dimensions: 20 x 6
Living room
- Features: Flooring - HardWood, Fireplace - Gas, Recessed Lighting
- Level: Main
- Area: 348 Square Feet
- Dimensions: 12 x 29
Screened porch
- Features: Recessed Lighting
- Level: Main
- Area: 132 Square Feet
- Dimensions: 12 x 11
Heating
- Forced Air, Natural Gas
Cooling
- Central Air, Electric
Appliances
- Included: Microwave, Dryer, Washer, Dishwasher, Disposal, Refrigerator, Ice Maker, Oven, Gas Water Heater
- Laundry: Laundry Room
Features
- Open Floorplan, Upgraded Countertops
- Flooring: Hardwood, Wood
- Windows: Window Treatments
- Has basement: No
- Number of fireplaces: 1
Interior area
- Total structure area: 1,779
- Total interior livable area: 1,779 sqft
- Finished area above ground: 1,779
- Finished area below ground: 0
Property
Parking
- Total spaces: 4
- Parking features: Garage Faces Front, Garage Door Opener, Attached, Driveway
- Attached garage spaces: 2
- Uncovered spaces: 2
Accessibility
- Accessibility features: None
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Enclosed, Screened Porch
- Pool features: Community
- Waterfront features: Boat - Electric Motor Only, Canoe/Kayak, Public Access, Lake
- Body of water: Lake Frederick
Lot
- Size: 6,098 sqft
- Features: Premium, Suburban
Details
- Additional structures: Above Grade, Below Grade
- Parcel number: 87B 2 5 81
- Zoning: R5
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Craftsman
- Property subtype: Single Family Residence
Materials
- Fiber Cement
- Foundation: Slab
Condition
- Very Good
- New construction: No
- Year built: 2019
Details
- Builder model: Aspen
- Builder name: Shea Homes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & neighborhood
Community
- Community features: Pool
Senior living
- Senior community: Yes
Location
- Region: Lake Frederick
- Subdivision: Shenandoah
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $395 monthly
- Amenities included: Art Studio, Bar/Lounge, Clubhouse, Common Grounds, Fitness Center, Game Room, Gated, Jogging Path, Lake, Indoor Pool, Pool, Recreation Facilities, Retirement Community, Tennis Court(s)
- Services included: Common Area Maintenance, Maintenance Grounds, Pool(s), Recreation Facility, Security, Trash, Snow Removal
- Association name: SHENANDOAH
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,FHA,VA Loan
- Ownership: Fee Simple
Services availability

Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.