 |
MLS: 556302
Updated: October 12, 2008 Price: $4,229,600 - bdrm baths
Type: Vacant Land/Lots City: Longmont, 80504
Subdiv: TBD
Remarks: Prime multi-family residential property. Just south of the new Walmart Super Center & proposed Sam's Club just off of State Hwy. 119, approx. 62.2 acres of mostly level ground ready for development. Zoned within the City of Longmont with the PUD-R zoning. This zoning will allow for High and Medium density residential developments. Properties nearby include city parks, residential developments and office/flex spaces. Details...
Listing Office: Prudential Rky Mtn Realtors Lg
|
|
MLS: 563803
Updated: October 12, 2008 Price: $4,300,000 - 4 bdrm 7 baths
Type: Single Family Home
Sqft: 8814
Cost / Sq Ft: $488 City: Longmont, 80503
Subdiv: Meadow Green Farm
Design Features: Cathedral/Vaulted Ceilings,Eat-in Kitchen,Open Floor Plan,Pantry,Separate Dining Room,Stain/Natural Trim,Walk-in Closet,Washer/Dryer Hookups,Wood Floors,Wood Windows Remarks: INCREDIBLE HOME W/AWE INSPIRING MTN VIEWS on pastoral 10 (+/-) acre lot w/professional landscaping in gated subdiv. Flawless attention to detail,Mstr w/Morning Bar,19x18 retreat w/see-thru frplc,Covered Deck, & access to Library/Study.Gourmet kit w/Butler's Pantry,Pot Filler Sink at the Gas Cktp,Alder Cabinetry, Walkin Pantry. Elevator to Wlkout Bsmt w/In-law suite, Lg. Rec.Rrm w/frplc & wet bar, wine cellar,Multi-Purpose rm(5th Bedrm). Wraparnd Deck & Many More Distinctive Features & Finishes. Amenities: Common Recreation/Park Area Details...
Listing Office: RE/MAX Traditions, Inc
|
 |
 |
MLS: 551742
Updated: October 12, 2008 Price: $5,900,000 - 5 bdrm 7 baths
Type: Single Family Home
Sqft: 10670
Cost / Sq Ft: $553 City: Longmont, 80503
Subdiv: None
Design Features: Cathedral/Vaulted Ceilings,Loft,Open Floor Plan,Pantry,Sauna,Separate Dining Room,Skylights,Walk-in Closet,Washer/Dryer Hookups,Wet Bar,Wood Floors,Jack & Jill Bathroom Remarks: 40 acres, foothill views, open space, & mins to Boulder. Art sculptures, fruit orchard, 2 volleyball courts, 2 ponds, guest apartment, 11,000 + sq ft recreational barn w/greenhouse, offices, & climbing wall. Designed Carl Rhode & Mickey Amirob design. Murals by Mario Echevarria. Indoor pool, hot tub, steam room, 5 fireplaces, wine cellar, & stately dining room. Professional kitchen, granite counter tops, & cherry hardwood flooring. Master bath w/stone, double shower & sky-lights. Details...
Listing Office: Fuller Sotheby's Intl Realty
|
|
MLS: 570806
Updated: October 12, 2008 Price: $6,450,000 - 3 bdrm 5 baths
Type: Single Family Home
Sqft: 8928
Cost / Sq Ft: $722 City: Longmont, 80503
Subdiv: Tr Nbr 135 803-840 Rural
Design Features: Bay or Bow Window,Cathedral/Vaulted Ceilings,Fire Alarm,Open Floor Plan,Pantry,Separate Dining Room,Walk-in Closet,Washer/Dryer Hookups,Wet Bar,Wood Floors,Wood Windows Remarks: Boulder's Finest Estate. Enter the massive stone gates and tree lined drive to a Shangri-La of lush trees, flowers and rolling lawns. The formal gardens, tea house, fish pond, waterfall, and sunken rose pavilion. Bar BQ cafe has wood fireplace and Viking Grill. Stables host 20 horses-6 outdoor paddocks and hay barn. You must see this park like setting complete with beautiful pond and swans. Details...
Listing Office: Mayer Properties
|
 |
 |
MLS: 542625
Updated: October 12, 2008 Price: $6,900,000 - 3 bdrm 6 baths
Type: Single Family Home
Sqft: 10631
Cost / Sq Ft: $649 City: Longmont, 80503
Subdiv: Robl Farm Nupud
Design Features: Bay or Bow Window,Cathedral/Vaulted Ceilings,Eat-in Kitchen,Open Floor Plan,Pantry,Sauna,Separate Dining Room,Skylights,Walk-in Closet,Washer/Dryer Hookups,Wet Bar,Workshop Remarks: PICTURESQUE SETTING WITH BREATHTAKING VIEWS! Private 44 ac gated estate bordering 100s of acres of open space*Custom 10,000+ sq ft ranch hm designed for enjoying the views*High-end appls*Slab granite*Radiant heat flr*3 Masters*Primary Master Ste has Retreat w/ FP, balcony, & spa-like bath*W-O lower lvl*Bang & Olufsen Home Theater w/humidor*Heated indoor pool*2 car & 3 car garages*Greenhouse*Minutes from town. Details...
Listing Office: ERA Tradewind Real Estate
|
|
MLS: 474085
Updated: October 12, 2008 Price: $6,950,000 - bdrm baths
Type: Vacant Land/Lots City: Longmont, 80504
Subdiv: n/a
Remarks: Approx 28 Acres, with water. Located at Hiways 287 and 66, just East of New Walmart Development. Zoning: Currently-Bldr Cty Ag, As of Aug 6, 06,Conditional PUD-C, City of Lgmt. Call Listing office for Proposed Commercial Development Packet and explanation of existing homes on property. Seller requests all showings be with prequalified buyers. Listing Agent is Licensed CO Realtor, and also President of Selling Entity. ---- Conceptual Site Plan shown in picture. Details...
Listing Office: K-II Realty
|
 |
 |
MLS: 499509
Updated: October 12, 2008 Price: $7,995,000 - 6 bdrm 8 baths
Type: Single Family Home
Sqft: 9819
Cost / Sq Ft: $814 City: Longmont, 80503
Subdiv: Boulder county
Design Features: Cathedral/Vaulted Ceilings,Eat-in Kitchen,Open Floor Plan,Separate Dining Room,Walk-in Closet,Wet Bar,Wood Floors Remarks: Dramatic 40 acre gentleman's ranch. New 6 bedroom home 8 baths with finished walkout basement, in floor radiant heat in both the home and the 4800 foot barn, 2 Left hand water taps, 30 shares Big T water and 25 shares of Swede Ditch. Barn, tennis courts, 30*50 pool with integrated hot tub, extensive gate and fencing, over 100 trees are planted and irrigated. Magnificant 360 degree views. Must see! Please call listing agent to arrange a tour. Details...
Listing Office: CAVU Real Estate
|
|
MLS: 545226
Updated: October 12, 2008 Price: $13,920,000 - bdrm baths
Type: Vacant Land/Lots City: Longmont, 80504
Subdiv: NONE
Remarks: Area north,south,east & west of property rapidly developing .Rd.9 1/2 to be completed in next few months,making site accessible from Frontage Road & I-25 and St.Hwy 66 on the west and north,and Rd.9 1/2 on the east .10 shares Little Thompson & 1/2 share of Highland Ditch Company go with sale. This property has been annexed into the town of Mead Co., and is zoned Comm./ Indust. Property lays fairly flat.& will be Ideal opportunity for large project concern.Utilities & water readily available . Details...
Listing Office: Loretta Kilgore Real Estate
|
 |
|
