Title Page Background
DEBUG FN args: Array ( [0] => 234 [1] => [2] => [3] => agent ) BEFORE: Site: 234 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 234 Igate: njhud LocID: 234 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 234 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 234 [1] => [2] => [3] => lender ) BEFORE: Site: 234 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 234 Igate: njhud LocID: 234 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 234 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 234 [1] => [2] => [3] => other ) BEFORE: Site: 234 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 234 Igate: njhud LocID: 234 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 234 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

0 Scarface
Gazelle, CA 96034

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $190,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: eXp Realty of California, Inc.

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other

Window Features

Exterior Features: Rural, Lake, Fishing, Mountainous, Hiking, Hunting, Foothills, Horse Trails, Watersports, Community Features Included: Blm/National Forest, Biking
View: Canyon, Mountain, Panorama, Valley, Hills

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 40 acre(s)
Property Type: Land-Other
Year Built: --
Notes: 40 acres with a private water well producing 10 Gallons per minute! Beautiful & extremely private! Tucked away for maximum privacy. This a gorgeous mountain retreat consisting of 4- adjacent 10 acre parcels that total 40 acres. Location - Location this property is only 7 miles from the 5 freeway in Gazelle in the beautiful Scarface Valley! Very easy to access! Property is as-is and transfers with greenhouse structure and 99 smart pots for gardening. It is the perfect location to build a family compound or make a main hub for generations to come! The garden is near the well, well has enough elevation to do a gravity feed to garden. With the right offer seller will put in the well pump for the well. You will love the peaceful drive in on a tranquil, private, and well maintained dirt road. From mountain peak tops to large areas of flat usable land at the base of the mountain ridge, these 40 acres have it all! To build a house it only requires 7 gallons per minute. Your dream home is waiting to be built! The owners have built a 10x12 cabin that is nearly complete and nestled behind the trees with wide open land in front of you. Additionally there have been 2 man-made ponds made that draw wildlife including black bear, brown cinnamon bear, elk, deer bobcat, skunk, raccoons, squirrels. This private oasis is so centrally located, it is just 14 miles from Yreka, one the largest cities in the area, in the other direction just 14 miles from Weed and 20 miles from the beautiful resort town of Mount Shasta, both offering small charming downtown areas and shopping. Yreka is a main hub with all your major franchises, such as McDonald's, Taco Bell, Walmart etc. Mount Shasta Ski Park just added a brand new chairlift. Additionally, Deer Mountain Snowmobile Park has over 300 miles of groomed trails which is approximately 30 miles from the property. There are plenty of other resort-style living activities as well such as mountain biking, paragliding, gold panning, hiking, Siskiyou Lake and 4 x 4 trails. Many of the photos are showing the tranquil drive in, majestic views and surrounding area like Mt Shasta. You must see it to appreciate all the beauty, privacy and usability, endless opportunities await you!
MlsNumber: --


Listing Provided By: eXp Realty of California, Inc., original listing
Phone: (888) 584-9427
Office Phone: (888) 584-9427
Agent Name: Bridgette Young
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