Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

37670 County Road 69
Briggsdale, CO 80611
Luz Daniels with Keller Williams DTC, original listing - (303) 771-7500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 4072 Square Feet
Agency: Keller Williams DTC
Agency Phone: (303) 771-7500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 61 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Experience Breathtaking Mountain And Prairie Vistas With Abundant Wildlife Including Bald Eagles, Antelope, And Deer. This Spacious 4-Bedroom Ranch Home Sits On 61.2 Peaceful Acres, Featuring Vaulted Ceilings, Custom Cabinets, And Granite Countertops In The Kitchen And Bathrooms. With Hardwood Floors Throughout The Main Level, An Oversized 3-Car Garage, A 48x48 Barn, And A 60x52 Corral, This Property Offers Everything You Need For Country Living. Fully Fenced, With 4 Pastures And 4 Frost-Free Hydrants, As Well As A 220-Equipped Garage And Barn, This Well-Maintained Home Is Ready For You To Move In, Bring Your Horses, Cattle And Other Animals. Conveniently Located Just 20 Minutes From Greeley. Great school district, very involved community, lots of sport programs. School bus picks up kids at the mailbox. Weekly dirt Road Maintenance. Outdoor activities galore !Pawnee grasslands are near by. There's a wild bird sanctuary near so you'll get to see some beautiful birds. Next door neighbor leases his 80 acres ** Impresionantes Vistas De Montañas Y Praderas Con Abundante Vida Silvestre, Incluidas Águilas Calvas, Antílopes Y Ciervos. Esta Espaciosa Casa Tipo Rancho De 4 Dormitorios Se Encuentra En 61,2 Acres Tranquilos Y Cuenta Con Techos Abovedados, Gabinetes Personalizados Y Encimeras De Granito En La Cocina Y Los Baños. Con Pisos De Madera En Todo El Nivel Principal, Un Garaje De Gran Tamaño Para 3 Autos, Un Granero De 48x48 Y Un Corral De 60x52, Esta Propiedad Ofrece Todo Lo Que Necesita Para Vivir En El Campo Con Sus Caballos, Vacas Y Otros Animales. Totalmente Cercada, Con 4 Pastos Y 4 Hidrantes Antiescarcha, Además De Un Garaje Y Granero Equipados Con Capacidad Para 220 Personas, Esta Casa Bien Mantenida Está Lista Para Que Usted Se Mude. Convenientemente Ubicada A Solo 20 Minutos De Greeley. Excelente distrito escolar, comunidad muy involucrada, muchos programas deportivos. El bús escolar recoge a los niños en el buzón. Mantenimiento semanal de camino de tierra
MlsNumber: --
ListingId: 5087534


Listing Provided By: Keller Williams DTC, original listing
Phone: (303) 915-0350
Office Phone: (303) 771-7500
Agent Name: Luz Daniels
Disclaimer: Copyright © 2024 REcolorado. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Kelly Giddens
Kelly Giddens
ASCIIBerkshire Hathaway HomeServices Rocky Mountain, REALTORS
Call Today!: (503) 866-5962

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App