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 = 1793 AND i.igate IN ('usahud','nmhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nmhud', 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 = 1793 AND i.igate IN ('usahud','nmhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nmhud', 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 = 1793 AND i.igate IN ('usahud','nmhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nmhud', 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;

36 Luna Drive
Angel Fire, NM 87710
Montee Sue Miller with REMAX Mountain Realty, original listing - (575) 377-1919

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,499,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3280 Square Feet
Agency: REMAX Mountain Realty
Agency Phone: (575) 377-1919

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Get ready to be wowed by this custom built Rocky mountain home. Perched on a beautifully treed double (1.65 acre) lot, the views from this home are stunning. At 3280 sqft, this 3 bedroom, 3 bath retreat is perfect for a couple or a family gathering. One of the primary suites is on the main floor as well as a second guest bedroom with bath close by. The open floor plan is designed for entertaining with a pool table right in the heart of the living space. Open kitchen, dining, living all flow out through multiple French doors leading to the spacious deck designed for outdoor entertaining. Mountain Views, views, views make this an outstanding Angel Fire mountain retreat. Built by one of Angel Fire's outstanding craftsmen, John Stegman, every attention to detail was addressed. From the hand hued hardwood floors, the resilient European tile in the kitchen, the soaring river rock fireplace with wood stove insert, the custom cabinetry and doors, this house speaks of timeless quality. Beamed tongue and grooved ceilings make a great surround for the spacious livingroom. Upstairs you are welcomed by a beautiful loft library with mountain views through the adjacent windows. This space is part of the second primary suite with a spacious bedroom, bathroom and cozy sitting area surrounding a second fireplace. The floor plan includes the all important mudroom, and an attached heated oversized double car garage. Located only 10 minutes to Angel Fire Resort village, championship golf course and ski mountain, this makes this luxury home a great investment property as well as private residence. Luna is being sold beautifully furnished and accessorized right down to the linens on the bed!. Bring your toothbrush! Welcome to Angel Fire where the fun begins.
MlsNumber: --
ListingId: 112594


Listing Provided By: REMAX Mountain Realty, original listing
Phone: (575) 377-1919
Office Phone: (575) 377-1919
Agent Name: Montee Sue Miller
Disclaimer: Copyright © 2024 Taos County Association of Realtors. 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