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.

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 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

**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 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

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

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

Just beautiful! Great location w/deck. Backs to woods. Large office, huge gourmet kitchen w/bumpouts in morning rm/ sun-filled fam. rm w/new carpet. Granite, hardwood, built-in desk, upgraded lighting. Huge bedrooms. Spacious Master w/bumpout; his/hers closets; lux bath:dbl sinks, make-up table, soaking tub. 2nd fl laundry. Walk-out basement w/full bath 5th bedrm. Near amenities/lazy river pool
Turning Point Real Estate

Many Potential Uses Include: Professional Office, Medical Office, Daycare, Residential, Senior Residential, Live/Work Units, and many more.Owner is a licensed Real Estate Agent.
Turning Point Real Estate

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




FranklyMLS.com is now just Frankly.com
More than just the MLS, now with Coming Soons, FSBOs & Classifieds too.
124 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/122 0% James Fitzgerald (List:'11+,'13+ x
2   FR8515032 $804k $849,900 $849,900 $633,000 134% '14   549104 CHARTERHOUSE RDFREDERICK 21704 ? VILLAGES OF 5/5/1020050.35130 1/34 3% Eric Steinhoff (List:'11+,'13+ x
3   FR8508177 $758k $799,500 $824,000 $650,800 123% '14   694210 ARABY CHURCH RDFREDERICK 21704 ? ARABY RIDGE 5/3/1464320064.07030 1/37 3% Gail Lee (List:'11+,'13+ x
4   FR8534731 $709k $719,000 $719,000 $537,200 134% '14   144123 TOTTENHAM STFREDERICK 21704 ? VILLAGES OF 4/4/1642420080.34130 0/21 0% Christopher Dyer (List:'11+,'13+ x
5   FR8522085 $691k $699,900 $749,900 $495,600 141% '14   329114 BELVEDERE DRFREDERICK 21704 ? VILLAGES OF 4/4/1567020070.24126 0/28 0% Angie HASHEMPOUR (List:'11+,'13+ x
6   FR8447763 $682k $800,000 $800,000 $598,400 134% '14   140/1994026 BROADSTONE CIRFREDERICK 21704 ? VILLAGES OF 4/3/1485620060.61229 0/50 0% Elaine Koch (List:'11+,'13+ x
7   FR8130733 $680k $685,000 $685,000 $182,600 375% '11   5684233 LAFAYETTE STFREDERICK 21704 ? KIDWILER PA 5/3/0020122.51141 0/49 0% Jacquelyn Murtagh (List:'11+,'13+ x
8   FR8515789 $663k $679,900 $699,900 $   53/1339205 SHAFERS MILL DRFREDERICK 21704 ? VILLAGES OF 4/3/1506220050.19530 0/28 0% Sue Collins (List:'11+,'13+ x
9   FR8163059 --- $632,900 $599,900 $   4523434 SUGARLOAF PARKWAYFREDERICK 21704 ? VILLAGES OF 4/3/1020140.181417 0/114 0% Johnice Comer (List:'11+,'13+ x
10   FR8541285 $617k $619,900 $619,900 $514,600 120% '14   43847 TRITON LNFREDERICK 21704 ? ^ VILLAGES OF 5/3/1020030.233130 0/12 0% Eric Steinhoff (List:'11+,'13+ x
11   FR8128338 --- $599,000 $1,490,000 $173,100 346% '13   503Land: 3536 URBANA PIKEFREDERICK 21704 ? URBANA //00.98142 0/48 0% Joseph Anselmo (List:'11+,'13+ x
12   FR8326553 $595k $699,900 $739,900 $730,700 96% '13   2648402 RIVER MEADOW DRFREDERICK 21704 ? RIVER MEADOW 4/4/1583220020.751230 0/54 0% Jan West (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