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

640-775 Iris Road
Mcarthur, CA 96056
Janet Jones with High Country Real Estate, original listing - (153) 033-5222 x2

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $469,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 2132 Square Feet
Agency: High Country Real Estate
Agency Phone: (153) 033-5222 x2

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1980
Notes: EMBRACE THE BEST OF COUNTRY LIVING WITH CHARMING 3 BEDROOM HOME THAT HAS THE WELCOME HOME FEEL WHEN YOU WALK IN THE FRONT DOOR! OPEN AIRY LOTS OF NATURAL LIGHT, COZY LIVING ROOM WITH A FREE STANDING WOOD STOVE TO KEEP THE WINTER CHILL AWAY, CEILING FANS IN ALL OF THE ROOMS, BEAUTIFUL SWEEPING STAIRCASE GOING UP STAIRS TO THE SLEEPING QUARTERS 3 BEDROOMS TWO BATH ,MASTER SUITE HAS GLASS BLOCK AND TILE SHOWER, WALK IN CLOSET, BEAUTIFUL OPEN KITCHEN DOWNSTAIRS SOLID OAK CABINETS, ISLAND WITH COOK TOP, NEW DOUBLE OVEN AND DISHWASHER ROOM FOR ALL YOUR POTS AND PANS, DISHWARE, STORAGE ROOM AND 1/2 BATH OFF THE KITCHEN, LAUNDRAY ROOM ON DEMAND HOT WATER, UNFINISHED BONUS ROOM POLE BARN THAT CAN HOLD 3 TON OF HAY. THIS IS A MUST SEE BRING YOUR HORSES, 4 H FFA PROJECTS KICK BACK RELAX ENJOY COUNTRY LIVING AT ITS FINEST
MlsNumber: --
ListingId: 25-538


Listing Provided By: High Country Real Estate, original listing
Phone: (530) 515-8891
Office Phone: (153) 033-5222 x2
Agent Name: Janet Jones
Disclaimer: Copyright © 2025 Shasta MLS. 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