Title Page Background
DEBUG FN args: Array ( [0] => 1811 [1] => [2] => [3] => agent ) BEFORE: Site: 1811 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1811 Igate: njhud LocID: 1811 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 = 1811 AND i.igate IN ('nmhud','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 = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1811 [1] => [2] => [3] => lender ) BEFORE: Site: 1811 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1811 Igate: njhud LocID: 1811 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 = 1811 AND i.igate IN ('nmhud','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 = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1811 [1] => [2] => [3] => other ) BEFORE: Site: 1811 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1811 Igate: njhud LocID: 1811 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 = 1811 AND i.igate IN ('nmhud','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 = 'nmhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

38b Pd 1754a
Chama, NM 87520

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $489,000
Beds: 2
Baths:
Status: Active
SqFt: 1750 Square Feet
Agency: Keller Williams

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer, Dryer
Architectural Style: Contemporary
Construction Materials: Wood Siding, Frame
Cooling: None
Flooring: Tile, Wood
Heating: Fireplace, Baseboard, Stove
Interior Features: Security System, Interior Steps
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2
Security Features: Security System

Window Features

Parking Features: Garage
Roof: Metal

Neighborhood/Schools

Elementary School/District: Tierra Amarilla
Middle/Junior High School/District:
High School/District: Escalante High School
Subvidision Name:

Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Come relax and enjoy wonderful northern New Mexico. One of the best-kept secrets in New Mexico is the enchanting Village of Chama. Chama is nestled high in the Southern Rockies, just 120 miles North of Santa Fe and mins from Colorado Boarder. Fishing, Hiking and The historic Cumbres & Toltec Scenic Railroad steam trains are just a short trip away! This newer custom-built home is located in the popular Brazos Canyon southeast of Chama. Situated at the end of a Gated private drive, this two bedroom two bath home has many upgrades. There are two decks with Trex decking material, hickory cabinets, pine floors, a hammered copper farm sink. Both bedrooms have attached baths and beautiful tile work in the baths. There is a beautiful custom stairway leading to the second level and a great covered deck upstairs with views of the 11,000 foot Brazos Cliffs. There is a large walkable crawl space for storage and a 22KW Generac generator for back up power. This home has a wood storage shed and a 16X34 barn/garage. The property is made up of a 2.45 acre lot. The land is covered with tall mature trees, including ponderosa pine, gambrel oak, and juniper. Public access to the Brazos River is nearby for fishing. This area has numerous rivers, lakes and streams. Chama is just 20 minutes away and Pagosa Springs, CO is less than an hour away. Less than 6 years old this log sided beauty has a pro panel roof and is located in a private gated area. Imagine the possibilities. This home is a great getaway or a full time live as well. Come on up and enjoy the cool green mountains of northern New Mexico.
MlsNumber: --


Listing Provided By: Keller Williams, original listing
Phone: (719) 243-1845
Office Phone: (505) 983-5151
Agent Name: Francesco Crisafulli
Disclaimer: Copyright © 2024 Santa Fe Association of REALTORS®, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App