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

1417 Phillips Road
Taos, NM 87571

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $889,000
Beds: 4
Baths: 2
Status: Active
SqFt: 2441
Agency: Berkshire Hathaway HomeServices Taos Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: --
Notes: Elegance and Comfort in the Weimer Foothills ~ Welcome to Casa Verde, a charming and well cared for home in the Weimer neighborhood that couldn't be more ideal for full or part-time living in the enchanting Southwest. The home possesses endless charm, and numerous Southwestern architectural features throughout, such as saltillo and traditional tile work, arched doorways, rounded vigas with tongue & groove ceilings, nichos above the kiva fireplace, classic lighting, and the list goes on… Upon entering the home through the custom stained-glass double-doors and into the large foyer, you get an immediate sense of the grandness of Casa Verde. An open and comfortable flowing layout, especially within the living area, contain high ceilings, and plenty of windows that retain natural light throughout the day. The kitchen and dining room area are perfect for gathering friends and family, and will surely keep the chefs in the household excited to create delicious meals. The primary bedroom ensuite is spacious with a sizable closet, double vanity, and bathtub. The three other bedrooms and one full bathroom are equally spacious, and convenient for large families and hosting guests. The enclosed outdoor space at Casa Verde is a major draw to this residence, with several locations to enjoy morning coffee or evening wine, an outdoor hot tub for relaxing under the stars, and a plethora of trees and greenery. The home may be purchased fully furnished and turn-key. Don't miss this great opportunity in the Weimer neighborhood, come have a look at the magnificent Casa Verde.
MlsNumber: 111652


Listing Provided By: Berkshire Hathaway HomeServices Taos Real Estate, original listing
Name: Berkshire Hathaway HomeServices Taos Real Estate
Phone: (575) 758-1924
Office Name: Berkshire Hathaway HomeServices Taos Real Est
Office Phone: (575) 758-1924
Agent Name: Page Sullivan Real Estate Group
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