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 = 275 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 = 275 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 = 275 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;

4819 Daven Road
Morrison, CO 80465
Tim Wade with Keller Williams Advantage Realty LLC, original listing - (303) 986-4300

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,000
Beds: 4
Baths: Full: 1, ½: 1, ¾: 2
Status: Active
SqFt: 2865 Square Feet
Agency: Keller Williams Advantage Realty LLC
Agency Phone: (303) 986-4300

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: **BRAND NEW & MOVE-IN BY THE END OF THE YEAR **Beautiful Westside community of Three Hills has easy access to downtown and the mountains. Enjoy the spectacular views. The Grafton floorplan is open w/an abundance of natural light; Featuring: Quartz Countertops, Canopy Hood & WPC Hardwood on main level. The upstairs features a spacious Primary Suite w/walk-in closet, luxurious bathroom, 2nd & 3rd bedroom & a full bath & laundry rm. Complete w/ 2-car attached garage, central a/c, tankless water heater. HOA's snow removal includes sidewalks adjacent to streets and alleys. Community amenities are provided thru the metro district & some thru the HOA** Just A Few Minutes to Downtown Morrison, Red Rock Amphitheater and close to parks, schools, and shopping. ***The information presented in this listing is considered reliable however, accuracy is NOT GUARANTEED. BUYERS ARE STRONGLY ADVISED AND BEAR RESPONSIBILITY TO INDEPENDENTLY VERIFY ALL INFORMATION AND DETAILS, including but not limited to; square footage, floorplans, designs, features, upgrades, specs, finishes, inclusions & their installation dates, as well as; lot size, taxes, utilities, HOA & Metro District fees & documents, applicable work permits, zoning requirements, and any specific use considerations. BUYER’S SHOULD CONDUCT THEIR OWN thorough investigation of all information, including, without limitation; research of local, city, county, and other public records, & should seek the advice of appropriate professionals. PHOTOS may be of a Model or rendering and Not the Actual Property. ACTUAL HOME AS CONSTRUCTED may Not contain the features & layouts depicted & may vary from photos, renderings & plans. Any SELLER/BUILDER INCENTIVES of any kind must be agreed upon in writing by Builder & Buyer. PROPERTY TAX AMOUNT shown is a Land Only Estimated Amount by County; NOT the actual future amount for the completed home.
MlsNumber: --
ListingId: 7505657


Listing Provided By: Keller Williams Advantage Realty LLC, original listing
Phone: (303) 846-9233
Office Phone: (303) 986-4300
Agent Name: Tim Wade
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 = 275 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 Skyler Howe
Skyler Howe
ASCIIExit Realty
Call Today!: (720) 661-2432

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App