Agent profile image in chat bubble
Agent profile image in chat header

IDX Support

sales rep | Brivity IDX

Agent profile image in message

117 Mallard Dr , Lake Frederick, VA 22630
$800,000
Est. Payment: $4,191.10/mo
3 Bed
4 Bath
3604 Sqft
0.17 Acres
Status: active | Days on site: 106
Get Pre-Qualified
CTI1 - 3362053
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from IDX Support, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.

House Description

FREEDOM, WELLNESS & CONNECTION in Trilogy at Lake Frederick. “Take a look and you will get hooked,” with this exceptional Ascend model by Shea Builders. Thoughtfully designed for main-level living, nestled on a premium lot, on a peaceful street filled with caring neighbors' and a serene backdrop of protected parklands that offer plenty of privacy. Built in 2020, this stunning barely lived in residence offers an expansive open concept abode, luxurious comfort and breathtaking views. Featuring 3 spacious bedrooms, 3 bathrooms, and 1 powder room, over 3600 finished square feet, on one and a half levels of living. Showcasing more than $300,000+ in builder upgrades, this home is a must see! “Just one look and you will be hooked.” This extraordinary home offers a rare opportunity to enjoy new construction without the wait, the decisions, or the expense of starting from scratch. The distinctiveness is apparent the moment you walk through the door. The home blends timeless architecture with contemporary modern updates. A dramatic 10-foot foyer with a warm organic green hue that fosters a natural connectedness to nature and the greenery outdoors. Rich warm hand-scraped hardwood floors extend across the entire main level, and a custom Empire Chandelier with crystal leaves add to the sensational drama. It boasts a large flex area, that can be used as a living room, a dining room, an office, or a game/playroom. It can be used for sophisticated entertaining or good ole fashioned family fun. The great room has a cozy keeping room with a fireplace made for snuggling up with a good book or a night cap before retiring.The gourmet kitchen is packed with all the modern conveniences; it’s a chef’s dream with Shea’s upgraded package the Signature Kitchen series. Modern granite countertops, a neutral tile backsplash and stacked cabinetry pair seamlessly with high-end stainless-steel appliances including a massive island with seating and tons of useful storage. An eat in dining space sits adjacent to the kitchen and it opens up to a spacious great room ideal for everyday living and entertaining. The adjacent morning/sunroom is the perfect place to relax, enjoy a quiet morning coffee or unwind at the end of the day, with direct access to the rear porch and large stamped concrete patio, it creates a smooth indoor-outdoor living experience, which makes outdoor cooking and alfresco dining a treat. The main-level primary suite offers a tranquil retreat with embossed art deco wallpaper, an oversized closet with custom built-in drawers and shelving, and a spa-inspired bath featuring a glass shower and a grand soaking tub with a groovy modern chandelier above. The expansive laundry room is a true standout, equipped with abundant cabinetry, folding counters, and hanging space to keep everything in its identified place. Upstairs, a large recreation room creates a versatile space for family relaxation, recreation, crafting or media. It boasts Graham and Brown gold embossed geometric wallpaper, a third bedroom with a large walk-in closet and a full bathroom complete this level making it ideal for multigenerational living or cozy guest quarters. Added thoughtful upgrades include gutter guards, a beautifully landscaped lot with colorful flowers, blown in insulation, whole-house water filtration, irrigation, premium garage door and a tankless water heater. This is a rare opportunity to own a meticulously upgraded, nearly new home where every improvement has already been made and every detail is ready to enjoy. Offering a seamless blend of elegance, comfort, and accessibility, this magnificent home is an exceptional prospect for discerning buyers seeking refined living in a peaceful and private setting. Experience the pinnacle of resort living at Trilogy in Lake Frederick where your dream home and ideal lifestyle come together seamlessly.

Highlights

Listed by Stacey Renee Sutton-Ward , 5406210381 CTI Real Estate , 5407857800. Bright MLS

Property Type

Residential

Lot/Acreage
0.17

HOA Fee

405 Monthly

Year Built

2020

County

Frederick

Neighborhood

Shenandoah

School District

Frederick County Public Schools

Listing ID

VAFV2043178

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:3
  • ▪ Bathrooms:4
  • ▪ Full Bathrooms:3
  • ▪ 1/2 Bathrooms:1
Appliances:Built-In Microwave, Cooktop, Dishwasher, Disposal, Energy Efficient Appliances, Oven - Single, Oven - Self Cleaning, Oven - Wall, Oven/Range - Gas, Range Hood, Refrigerator, Water Heater - Tankless
Air Cond:Central A/C
Fireplaces:Fireplace - Glass Doors,Gas/Propane,Insert,Mantel(s),1 Fireplace
Floor:Engineered Wood,Carpet,Ceramic Tile
Above Ground Sq Ft:3604
Other:
  • ▪ Main Floor Bedrooms:2
  • ▪ Additional:Bathroom - Soaking Tub, Breakfast Area, Carpet, Ceiling Fan(s), Combination Kitchen/Dining, Floor Plan - Open, Family Room Off Kitchen, Kitchen - Gourmet, Kitchen - Island, Kitchen - Table Space, Sprinkler System, Upgraded Countertops, Walk-in Closet(s), Water Treat System, Wood Floors, No Pet Restrictions, Pets Allowed
Water:Public

Exterior Features

Lot:Backs - Parkland,Backs to Trees,Premium,Private,Trees/Wooded,Not In Development,Not New Construction,Horse Property: No
Garage Capacity:4
Zoning:Residential R5 District
Roof:Architectural Shingle,Metal,Pitched
Others:
  • ▪ Additional:Underground Lawn Sprinkler, Exterior Lighting, Gutter System, Street Lights, Excellent, Art Studio, Bar/Lounge, Billiard Room, Club House, Common Grounds, Dining Rooms, Dog Park, Exercise Room, Fitness Center, Game Room, Gated Community, Lake, Party Room, Pickleball Courts, Pool - Indoor, Pool - Outdoor, Recreational Center, Retirement Community, Security, Spa, Tennis Courts, Concierge, Common Area Maintenance, Lawn Maintenance, Management, Recreation Facility, Security Gate, Snow Removal, Trash, Insurance
Sewer:Public Sewer
Parking Features:Concrete Driveway,Garage - Front Entry,Garage Door Opener,Inside Access,Built In,Attached Garage,Driveway,4+ Spaces,3+ Spaces,2+ Spaces,1+ Spaces
Principal Interest
$4,191
Taxes
$331
HOA
$405

Home Price

$800,000

Loan Details

30 yrs
6.844%

Down Payment

20%
$160,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$4,191.10

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $4,191.10 $331.42 $405.00 $4,927.51
Yearly $50,293.15 $3,977.00 $4,860.00 $59,130.15
Total $1,508,794.60 $119,310.00 $145,800.00 $1,773,904.60
Lender profile image
Chico Gordy
Test
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Nov 2026

Average Price

All Price Ranges
N/A
Nov 2026

Average Days on Market

All Price Ranges
N/A
Nov 2026
Market insight data is pulled from the same city as the listing being viewed (Lake Frederick, VA).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Information provided by Bright MLS, and is deemed reliable but not guaranteed accurate.

IDX service by Blueroof 360

Data last updated: 2026-11-13T21:11:33.000Z

© 2026 Bright MLS