Price Reduced56
$585,000
4 bd · 4 ba · 3,108 sqft
1954 Moran Dr, Frederick, MD
Michael Kurtianyk · Mackintosh, Inc.
Est. $3,861/mo$191/sqft · 95 days on Realty
4
Beds
4
Baths
3,032
Sqft
2012
Built
Welcome to beautiful 2104 Artillery Rd! This lovely well-maintained home was built with upgrades not common in the desirable neighborhood of Cannon Bluff. High ceilings, beautiful open foyer, large bedrooms, oversized 2-car garage and custom surround sound system! As you walk in, the formal living room and formal dining room welcome you on each side. The spacious kitchen has stainless steel appliances, including a brand new stove, lots of cabinet and counter space, and a butler's pantry. The family room features a gas fireplace for the cold winter nights that are approaching. This level also includes a half bath and the laundry room.Upstairs, you'll find the 4 very well sized bedrooms with ceiling fans. The primary bedroom has vaulted ceilings and walk-in closets, opening to the en-suite bathroom that includes a box window, a jacuzzi tub, separate shower and double vanities. The basement is fully finished and includes a full bathroom, a rec room with a water hookup that can be turned into a wet bar, and an additional room that can be used as a den or office. The large detached garage has a workspace and can actually fit 2 cars! The solar panels are leased and transferrable to the buyer, making your electric bills lower. The whole house is freshly painted and all the flooring has been replaced. Located only minutes from downtown Frederick, shopping, and dining, this is one you won't want to miss!
Listing agent
Livia Gebran Miranda Brow
Courtesy of RE/MAX Realty Group
(301) 904-7482
Bright MLS · Listing MDFR2089338
$116,000
Estimated monthly payment
$3,861/mo
Loan amount $464,000. Estimate only — your actual rate and payment depend on credit, location, and lender.
2026 roll
Within 2 miles of this home: 3 restaurants and cafés, 1 grocery store, and 3 parks and green spaces.
Place data from OpenStreetMap.
Dunkin
Pizza Blitz
McDonald's
Yellow Spring Road
Food Lion
Whittier Lake Park
Lake Whittier
Greenleaf Park
School ratings (A+ to F) from HJN community data.
Yellow Springs Elementary School
KG-5 · Regular · Frederick County Public Schools
628 students · 16.6:1 student–teacher
Whittier Elementary School
KG-5 · Regular · Frederick County Public Schools
779 students · 16.0:1 student–teacher
St John Regional Catholic School
PK-8 · Regular
517 students · 16.2:1 student–teacher
Rings at ½ mile and 1 mile. Basemap © OpenMapTiles © OpenStreetMap contributors.
Open the Frederick camera map2 devices mapped within 1 mile of this home: 1 license-plate reader and 1 speed camera; one of them identified as a Flock Safety device. None within ½ mile. Nearest: 0.5 mi south.
| Device type | Within ½ mi | Within 1 mi |
|---|---|---|
| License-plate readers | 0 | 1 |
| of which Flock Safety | 0 | 1 |
| Speed cameras | 0 | 1 |
Community-reported via OpenStreetMap; may be incomplete. Data as of . © OpenStreetMap contributors (ODbL)
License-plate readers (ALPR) are fixed cameras that photograph passing vehicles and read their plates. Records are typically shared with the agency or association that operates the camera.
Flock Safety is a company whose plate-reader cameras are used by police departments, cities, HOAs and businesses. Its devices are usually solar-powered and pole-mounted.
Speed cameras photograph vehicles over the speed limit for automated tickets.
Bright MLSThis content last refreshed on 2026-10-17 23:01:12 UTC. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Price Reduced56
$585,000
4 bd · 4 ba · 3,108 sqft
1954 Moran Dr, Frederick, MD
Michael Kurtianyk · Mackintosh, Inc.
New15$569,990
3 bd · 3 ba · 1,559 sqft
283-Gc Heartleaf St, Frederick, MD
Erica Stevenson · NVR, INC.
New15$599,990
3 bd · 4 ba · 2,397 sqft
2109-A Yosemite Dr, Frederick, MD
Heather M. Richardson · NVR, INC.
Price Reduced51$719,000
5 bd · 4 ba · 3,950 sqft
1621 Hobble Trl, Frederick, MD
Troy A. Grossnickle · Long & Foster Real Estate, Inc.
33$599,000
4 bd · 4 ba · 3,097 sqft
95 Siegel Ct, Frederick, MD
Deborah K Berger · RE/MAX Town Center
18$450,000
3 bd · 3 ba · 1,700 sqft
1005 Eastbourne Ct, Frederick, MD
Jennifer Fernandez · EXP Realty, LLC




