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

50 Red Hill Rd
Weaverville, CA 96093

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,298,000
Beds: --
Baths: 16
Status: Active
SqFt: 9000
Agency: HG Realty & Rex Management

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: MultiFamily
Year Built: 1956
Notes: Welcome to the charming town of Weaverville, CA, nestled at the base of the Trinity Alps and in the shadow of majestic Shasta Mountain! Here's an exciting opportunity to own a piece of history, a thriving business, and a beautiful residence all rolled into one, presently the Red Hill Motel and Cabins. Or develop the complex into a business you like! Let me introduce you to this 1.8-acre property with a fascinating past. It features 14 rentable units and a delightful 1-bedroom cabin complete with an attached garage and a fenced backyard. The property offers a diverse range of accommodations, including a small cabin, 8 smaller cabins with carports (2 of which have kitchenettes), and 4 regular motel rooms. Surrounded by natural beauty, this property enjoys an unbeatable location near downtown Weaverville, the county library, the forestry division, and a transit stop. The grounds are adorned with apple and pear trees, grape vines, blackberry bushes, and a seasonal creek that once yielded 5 pounds of gold daily. For your peace of mind, the property boasts a state-of-the-art security system equipped with 7 high-tech cameras. The main house, which doubles as the office, features a spacious kitchen and living room with a hand-built fireplace that also serves as a BBQ on the back patio. Additional amenities include an RV or trailer space with full hookups, a fish cleaning station, a horseshoe pit, and a beautiful stone fire pit for those cozy summer evenings. The property is meticulously maintained, with operational carports, a sprinkler system, and even a golf cart with new batteries. Although some repairs are needed, most are cosmetic, and there's one cabin that requires electrical maintenance. Don't miss out on this unique opportunity to own a piece of history and a thriving business in one of California's most picturesque locations. For serious inquiries, contact us today for more info and a viewing.
MlsNumber: 11268942


Listing Provided By: HG Realty & Rex Management, original listing
Name: HG Realty & Rex Management
Phone: (929) 659-1408
Office Name: HG Realty & Rex Management
Office Phone: (929) 659-1408
Agent Name: Ed Heflin
Disclaimer: Copyright © 2024 My State 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