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

2350 Old Highway
Catheys Valley, CA 95306

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 2
Baths: 2
Status: Active
SqFt: 1932
Agency: Realty executives

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4,521,528 sqft
Property Type: Residential
Year Built: 2020
Notes: Mountain view property nestled in the serenity of Cathey's Valley. This unique two story, 2 bedroom, 1 1/2 bath room Barndominium styled home in a country living setting. This property combines 1932 square feet of interior living space with additional approximately 3750 square feet of covered exterior open barn concept sitting in the middle of 103 acres of Ag land. Step into the farmhouse styled home, the ground floor features spacious open floor plan with cozy family room, kitchen, laundry room, half bath and large dining area. Large glass panel rollup door to enjoy the gorgeous views or open to combine your inside and outside entertainment areas. The kitchen features all Kitchenaid appliances with chef style propane stove, microwave, dishwasher, fridge and trash compactor. Charming breakfast bar and large island both feature pendant lighting. The wooden staircase leads to the upper floor with runway styled hallway and master bedroom and bathroom suite. Features oversized slate tile shower and floor, vanity with soapstone countertop. Second bedroom features built in bunkbeds, ceiling fan and barn doors. The steel building home features plenty of upgrades throughout the living space with ceiling fans, upgraded cabinetry, flooring, lighting, central heating and air conditioning and fire sprinkler system. The rolling hill acreage offers fully fenced property line with gate, underground electrical, seasonal pond, water tanks, storage container, well and septic. Perfect for entertaining and livestock.
MlsNumber: MC24039107


Listing Provided By: Realty executives, original listing
Name: Realty executives
Phone: (209) 205-1331
Office Name: Realty Executives Of Northern California
Office Phone: (209) 385-8500
Agent Name: Kelly Hasko
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, 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