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

25 Agua Caliente Road
San Jose, NM 87565
Manuel Miramontes with Keller Williams, original listing - (505) 983-5151

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $844,000
Beds: 1
Baths: ¾: 1
Status: Active
SqFt: 490 Square Feet
Agency: Keller Williams
Agency Phone: (505) 983-5151

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Other-Farm
Year Built: --
Notes: This exceptional riverfront property in San Jose, NM, spans nearly 12 flat and usable acres, offering stunning natural beauty and unique amenities, including 430 feet of Pecos River frontage. Featuring a charming one-bedroom yurt on a permanent foundation, equipped with a modern Mitsubishi mini-split system, it provides comfort year-round. The land is not only expansive but also highly usable with a flat topography, making it ideal for various activities and developments. New private well and septic tank. <br /> <br /> The property is enhanced by 9.97 acre-feet of irrigation water rights—a rare and valuable resource. Mature fruit trees, including pears and apples, add both charm and utility to the landscape. There are hookups available for up to three recreational vehicles, offering convenient options for guests or additional accommodations. The grounds also feature a spacious gazebo perfect for hosting special events, adding to the property's versatility. This property with the right ideas can be a great business opportunity for farming and the hospitality industry alike. <br /> <br /> For nature lovers, the private river front creates a serene atmosphere, while the property’s gated access ensures privacy. A 15' x 15' fishpond, currently home to ten koi fish, provides a tranquil setting with the potential for stocking trout. With mountain views, opportunities for fishing, horseback riding, this unique property promises a beautiful outdoor lifestyle in the heart of New Mexico’s scenic landscape.
MlsNumber: --
ListingId: 202404547


Listing Provided By: Keller Williams, original listing
Phone: (505) 310-1994
Office Phone: (505) 983-5151
Agent Name: Manuel Miramontes
Disclaimer: Copyright © 2024 Santa Fe Association of REALTORS&#174;, 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