PRIME FUTURE DEVELOPMENT LAND POTENTIAL--88 ACS LOCATED ADJACENT TO THE "VILLAGES OF URBANA" ON RT 80 WITH LOTS OF ROAD FRONTAGE ON 3 ROADS--SIGNALIZED INTERSECTION--SUPER VIEWS FROM PROPERTY--LEVEL LAND!!!
Long Foster Real Estate, Inc.

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.

*First OPEN Today SUNDAY 1-3**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*Expanded Owners Suite Luxury BA*NO HOA!*Est. Fred.Co.Taxes $7,541
W.C. A.N. Miller, Realtors, A Long Foster Co.

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

Model perfect! Absolutely gorgeous floor-to-ceiling stone fireplace in family room w/20 ft+ ceilings. Upgraded lighting, hardwoods, crown molding, bay window, pillars, french doors. Gourmet kitchen: huge granite island, breakfast bar, stainless, light-filled morning rm. Lux master bedroom/ bath: soaking tub, dual sinks. Finished basement walks up to prof. landscaped patio. Near pool w/lazy river
Turning Point Real Estate

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

Lovely NVHome-Wynterhall brick front, 4 beds, 3.5 baths, cherry hardwood floor on main level with 4" bump out on all 3 level, bay window in living room, large center island in kitchen with cherry cabinets, stainless steel. Upgraded master bath with designed ceramic tiles and walk-in closet. Sold As-Is. Subject to third party approval.
Excel Realty Corp.

Gorgeous former model on professionally-landscaped lot complete w/6 bedrooms/4.5 baths. Upgrades throughout: hardwood, bay windows, chair rail, crown molding. Gourmet kitchen: granite/stainless steel. Stone fireplace in huge family room. Master w/sitting area, lux bath. Basement w/full bath, rec area/wet bar bonus room w/built-in desk. Walk out to patio/koi pond. Near pool, playground, amenities
Turning Point Real Estate

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

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

Fabulously remodeled colonial over 4000 sq/ft! This home is all about new. Best resale in Urbana! New kitchen w linen cabinets with espresso glaze, espresso island, stainless appliances, Alaska White granite. 5" hardwoods, stone FP morning rm. New carpet, cabinets, fixtures, lighting. LL w/ Rec w wet bar, hobby + den/br, full bath. Deck, fenced yard, slate patio and exterior painted. .
Sell Rite Real Estate

Breathtaking views open space from a beautiful Trex deck! Tax record does not reflect addl finished bonus rm, bedrm full bath on 2nd upper lvl. Enormous fully fin lwr lvl w/walk out to fully fenced backyard. Features morning room, granite counters, maple cabinets, SS appliances, large pantry, columns, 2nd floor laundry, wood floors extensive trim. Master suite w/garden tub his/her closets.
Real Estate Teams, LLC




FranklyMLS.com is now just Frankly.com
More than just the MLS, now with Coming Soons, FSBOs & Classifieds too.
127 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   FR8227504 $8,500k $10,000,000 $10,000,000 $   370Land: RT. 80URBANA 21704 ? NONE //087.876912 0/43 0% Thomas Poss (List:'11+,'13+ x
2   FR7903491 --- $4,750,000 $4,400,000 $4,400 107955% '12   722Land: BROAD BRANCH WAYFREDERICK 21704 ? PRESTON //027.54343 0/104 0% James Fitzgerald (List:'11+,'13+ x
3   FR8508177 $819k $824,000 $824,000 $650,800 % '14   64210 ARABY CHURCH RDFREDERICK 21704 ? ARABY RIDGE 5/3/1464320064.07030 0/9 0% Gail Lee (List:'11+,'13+ x
4   FR8447763 $732k $800,000 $800,000 $598,400 134% '14   75/1344026 BROADSTONE CIRFREDERICK 21704 ? VILLAGES OF 4/3/1485620060.61229 0/42 0% Elaine Koch (List:'11+,'13+ x
5   FR8461049 $697k $710,000 $749,900 $519,600 % '14   709205 SHAFERS MILL DRFREDERICK 21704 ? VILLAGES OF 4/3/1020050.191730 0/27 0% Eric Steinhoff (List:'11+,'13+ x
6   FR8130733 $680k $685,000 $685,000 $182,600 375% '11   5024233 LAFAYETTE STFREDERICK 21704 ? KIDWILER PA 5/3/0020122.51141 0/38 0% Jacquelyn Murtagh (List:'11+,'13+ x
7   FR8501879 $659k $669,000** $669,000 $564,700 118% '14   134010 CARRIAGE HILL DRFREDERICK 21704 ? VILLAGES OF 4/3/1020060.25101 0/17 0% LINH HANG (List:'11+,'13+ x
8   FR8459399 $632k $669,999 $679,900 $474,600 % '14   713820 BRAVEHEART LNFREDERICK 21704 ? URBANA HIGH 6/4/1020000.411430 0/21 0% Eric Steinhoff (List:'11+,'13+ x
9   FR8163059 --- $632,900 $599,900 $   4523434 SUGARLOAF PARKWAYFREDERICK 21704 ? VILLAGES OF 4/3/1020140.181417 0/105 0% Johnice Comer (List:'11+,'13+ x
10   FR8326553 $620k $699,900 $739,900 $730,700 % '13   2018402 RIVER MEADOW DRFREDERICK 21704 ? RIVER MEADOW 4/4/1583220020.751230 0/43 0% Jan West (List:'11+,'13+ x
11   FR8502619 --- $585,000 $585,000 $399,900 % '14   143711 SPRIGG STREET NORTH STFREDERICK 21704 ? VILLAGES OF 4/3/1020010.19362 1/16 6% Robert Jeffery (List:'11+,'13+ x
12   FR8414886 $576k $579,900 $594,900 $489,800 118% '14   1239177 BEALLS FARM RDFREDERICK 21704 ? VILLAGES OF 5/4/1020120.152830 0/43 0% James Bass (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