Ideal for Builder or Developer - 98 Preliminary Approved Lots in Preston, an extremely well located community just off MD Route 144 across from the very successful Spring Ridge PUD and only minutes from Frederick City, the MARC Train, New Market and Holly Hills Country Club and within easy reach of Urbana and the I-270 corridor to Montgomery County and Washington, DC as well as I-70 to Baltimore.
Fitzgerald Realty Group Inc.

The property has location, location location !! Quality material components with craftsmanship construction. Convenient to commuter routes and MARC station. Additional detached workshop 2 car garage is sure to please. This home is a must see to appreciate. Building Specifications and Features in Property Brochure available at the home; please enjoy the Virtual Tour, and come buy!
RE/MAX Results

Stunning! Rare opportunity. One of the best homes on one of the best lots in the Villages of Urbana! Custom built-ins, molding designer finishes throughout. Open floor plan, floor-to-ceiling windows. Master suite w/super luxurious Master Bath. Custom built-ins in HUGE closet. Incredible finished walk-out basement w/basketball court. Covered porch w/skylights/bar/grill circ. stairs to patio.
Turning Point Real Estate

***Beautiful 2006 CUSTOM Wynterhall Model*Over 4+ PRIVATE acres w/STUNNING views out every window! Exceptional UPGRADES*4,600+ SF of Gracious Living*Dual Staircase*Main Level Office*Morning Room off Center Island Chefs Kitchen*Composite Decking*GRANITE*Warm Cherry Cabinets*STAINLESS*Butlers Pantry*GAS FP*PRIVATE Expanded Owners Suite Luxury BA*NO HOA!*Est. Fred.Co.Taxes $7,541
W.C. A.N. Miller, Realtors, A Long Foster Co.

Absolutely gorgeous Colonial on secluded street. Feels like a mini estate. Very unique private flat fully fenced rear yard gives this home a "country" feel in the heart of desirable Villages community. Fantastic lower level has huge recreation room with separate areas for fitness, gaming, media, or even crafting! Main level office/study could be used for work at home professional. Easy to show
Keller Williams Capital Properties

Stunning home on .86 acres. All bldr upgrades selected and more, l/l kitchenette, gourmet kitchen with Thermador cook top, wine and beverage coolers, warming drawer, custom cabinets, oversize island. Oversized master suite with fireplace and 3 closets. Enjoy views of the professionally landscaped, fenced yard from the screened deck and morning rm. Custom built 2-story shed with water and electric.
Redfin Corp

Stunning 4BR,3.5 BA brick front custom home on premium lot w/ breathtaking views! 2 story foyer. Hardwoods, custom molding, windows, columns, paint. Conservatory. Upgraded professional gourmet Kitchen. Sep DR w/ Butlers Pantry. Office w/built-ins. Morning Rm. FR w/ vaulted ceiling, gas FP. Wrap-around custom Deck. Owners Suite w/ trey ceiling, Spa Bath, 2 walk-ins. Attached 2 car garage.
RE/MAX Metropolitan Realty

To BE Built--Beautiful custom home near Urbana. Beautiful 2.5 acre lot. Amenities galore!
Horizon Realty

**EXQUISITE BRICK FRONT SINGLE FAMILY HOME W/4BEDROOMS***4.5 BATH*MAIN W/CHERRY HARDWOOD FLOORS***KITCHEN TO LOVE W/GRANITE COUNTER TOPS+STAINLESS STEEL APPLIANCES+CHERRY CABINETS**CERAMIC TILE**BREAKFAST AREA W/ACCESS TO THE SPACIOUS DECK**FAMILY ROOM/FP**DEN***MASTER BEDROOM W/TRAY CEILING/BUMP OUT+WALK IN CLOSET**BASEMENT W/WALK-OUT LEVEL***2 CAR GARAGE**WALKING DISTANCE TO ALL SHOPPING NEEDS*
Realty Executives Leading Edge

Stunning NV Home in the Villages of Urbana. Main level features~2 story family room with stacked stone fireplace, gourmet kitchen with stainless steel appliances, granite, a morning room, an office and model perfect living and dining room. The master bedroom is huge with a luxury master bath and all the upgrades. A finished lower level, professional landscaping and hardscape complete the package.
RE/MAX Results

Spectacular, custom home perfect for entertaining 5800+ SQ Ft!. 2-story entry foyer w/sweeping staircase, DR w/tray ceiling, formal LR office. Gourmet kitchen w/cherry cabinets, oversize center island, SS appliances breakfast room opens to FR w/FP. Sunroom w/vaulted ceiling opens to deck. Luxury master w/sitting rm, FP luxury bath. Walkout LL w/media room, game room, bath storage.
RE/MAX Results

Over $40,000 in savings!!! Stunning Veranda model with DOUBLE Wrap Porches by Main Street Homes! Nov/Dec 2014 delivery. 3 finished levels loaded with options including hardwood floors, Oak stairs, gas fireplace, gourmet kitchen, granite counters, maple cabinets, stainless steel appliances, rec room with den and full bath more! A showcase home on a great lot. Images for representation only.
RE/MAX Town Center




FranklyMLS.com is now just Frankly.com
More than just the MLS, now with Coming Soons, FSBOs & Classifieds too.
131 results for: 21704
  Don't be silly! Register for 1/2 hourly Email Alerts!        ?  
Page: 1  2  3  4  5  6  7  8  9  10  11  
# Listing ID ▼FPP?x List Price OrigPrice Tax A.? LP/Tax + DOM p? Address City x Zip x Mi. OH Subdivision x Fee BrBa½ Sqft Built Lot ws Pix #S/#Vx Listing Agent x C% X Pick
1   FR7903491 --- $4,750,000 $4,400,000 $4,400 107955% '12   722Land: BROAD BRANCH WAYFREDERICK 21704 ? PRESTON //027.54343 0/129 0% James Fitzgerald (List:'11+,'13+ x
2   FR9005277 $805k $810,000 $810,000 $773,060 105% '09   54241 LAFAYETTE STFREDERICK 21704 ? ^ KIDWILER PA 4/4/1020051.31030 0/12 0% JoAnna Ford (List:'11+,'13+ x
3   FR8515032 --- $849,900 $849,900 $633,000 134% '14   669104 CHARTERHOUSE RDFREDERICK 21704 ? VILLAGES OF 5/5/1020050.35130 0/39 0% Eric Steinhoff (List:'11+,'13+ x
4   FR8508177 $734k $799,500 $824,000 $650,800 123% '14   994210 ARABY CHURCH RDFREDERICK 21704 ? ARABY RIDGE 5/3/1464320064.07030 1/39 3% Gail Lee (List:'11+,'13+ x
5   FR8534731 $687k $699,900 $719,000 $537,200 130% '14   444123 TOTTENHAM STFREDERICK 21704 ? VILLAGES OF 4/4/1642420080.34130 0/29 0% Christopher Dyer (List:'11+,'13+ x
6   FR8546558 --- $699,000 $699,000 $500,600 140% '14   238503 DOUBLETREE CTFREDERICK 21704 ? DOUBLETREE 4/3/1020040.86030 0/19 0% Margaret Plumly (List:'11+,'13+ x
7   FR8447763 $680k $800,000 $800,000 $598,400 134% '14   170/2294026 BROADSTONE CIRFREDERICK 21704 ? VILLAGES OF 4/3/1485620060.61229 0/54 0% Elaine Koch (List:'11+,'13+ x
8   FR8130733 $680k $685,000 $685,000 $182,600 375% '11   5984233 LAFAYETTE STFREDERICK 21704 ? KIDWILER PA 5/3/0020122.51141 0/51 0% Jacquelyn Murtagh (List:'11+,'13+ x
9   FR8522085 $670k $699,900 $749,900 $495,600 141% '14   629114 BELVEDERE DRFREDERICK 21704 ? VILLAGES OF 4/4/1567020070.24126 0/36 0% Angie HASHEMPOUR (List:'11+,'13+ x
10   FR8515789 $642k $679,900 $699,900 $   83/1639205 SHAFERS MILL DRFREDERICK 21704 ? VILLAGES OF 4/3/1506220050.19530 0/33 0% Sue Collins (List:'11+,'13+ x
11   FR8326553 $629k $684,900 $739,900 $730,700 94% '13   2948402 RIVER MEADOW DRFREDERICK 21704 ? RIVER MEADOW 4/4/1583220020.751230 0/61 0% Jan West (List:'11+,'13+ x
12   FR8163059 --- $632,900 $599,900 $   4523434 SUGARLOAF PARKWAYFREDERICK 21704 ? VILLAGES OF 4/3/1020140.181417 0/121 0% Johnice Comer (List:'11+,'13+ x
# Listing ID ▼FPP? x List Price OrigPrice Tax A.? LP/Tax + DOM p? Address City  x Zip x Mi. OH Subdivision x Fee BrBa½ Sqft Built Lot ws Pix #S/#V x Listing Agent x C% X Pick

Pages Returned: 11 Page: 1  2  3  4  5  6  7  8  9  10  11    See more at one time! Change to homes per page.   
ALL