Title Page Background
DEBUG FN args: Array ( [0] => 284 [1] => [2] => [3] => agent ) BEFORE: Site: 284 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 284 Igate: njhud LocID: 284 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 284 AND i.igate IN ('cohud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 284 [1] => [2] => [3] => lender ) BEFORE: Site: 284 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 284 Igate: njhud LocID: 284 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 284 AND i.igate IN ('cohud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 284 [1] => [2] => [3] => other ) BEFORE: Site: 284 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 284 Igate: njhud LocID: 284 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 284 AND i.igate IN ('cohud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

680 Horizon Glen Drive
Grand Junction, CO 81506

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $789,900
Beds: 3
Baths: --
Status: Active
SqFt: 2128 Square Feet
Agency: NextHome Virtual

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Rooms: Bedroom 1, Bedroom 2, Bedroom 3

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: RESIDENTIAL NEW CONSTRUCTION PAYS HOMAGE TO VINTAGE ELEGANCE. If you're tired of the mundane, cookie-cutter homes lining the streets, prepare to be captivated by this extraordinary gem in the North area. Stepping into this property is like stepping into a time capsule from 1966, but with all the modern comforts you could desire. Say goodbye to the ordinary and hello to a home that exudes character and charm at every turn. Designed with the entertainer in mind, this home boasts an open-concept layout that's perfect for hosting intimate dinners or lively gatherings. Imagine evenings spent entertaining friends and family in the spacious living area, with conversations flowing freely from the kitchen to the dining room. Speaking of the kitchen, prepare to be amazed by its functionality and style. Featuring not one, but two dishwashers, a large pantry, and sleek, state-of-the-art appliances, it's a chef's dream come true. But the indulgence doesn't end there. Step outside to see the possibilities waiting to be enjoyed. The hot tub pad off of the Master Bathroom, complete with electrical already run to it, beckons you to unwind and relax under the starlit sky, creating the perfect end to any day. Located in a coveted neighborhood, this home offers the perfect blend of privacy, convenience, and style. Don't miss your chance to own a piece of history with all the comforts of modern living. Schedule your showing today and prepare to be swept away by the timeless allure of this remarkable residence. This description emphasizes the unique vintage-inspired features of the home while highlighting its modern amenities and suitability for entertaining. a truly one-of-a-kind living experience!
MlsNumber: --


Listing Provided By: NextHome Virtual, original listing
Phone: (970) 314-3356
Office Phone: (970) 258-9300
Agent Name: Shanon Secrest
Disclaimer: Copyright © 2024 NextHome, Inc. 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => mesa-county [3] => CO [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: mesa-county State: CO Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: mesa-county State: CO Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 284 AND i.igate IN ('cohud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Brandy Chaffin
Brandy Chaffin
ASCIIMAVERICK HOMES POWERED BY EXP
Call Today!: (970) 216-7606

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App