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

Foreclosure: 20423 Redstone Avenue
Caliente, CA 93518
Valerie H Colb with Walker Basin Ranch and Home, original listing - (661) 867-2001

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,000
Beds: 3
Baths: ¾: 2
Status: Active
SqFt: 2178 Square Feet
Agency: Walker Basin Ranch and Home
Agency Phone: (661) 867-2001

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 50 acre(s)
Garage: Garage
Property Type: Residential-Manufactured On Land
Year Built: 1978
Notes: A rare opportunity to own a move-in ready 3 Bedroom/2 Bath Home on 50 usable acres with spectacular mountain and panoramic valley views. Enjoy the mature oaks and pines offering shade and privacy. The home offers almost 2200 sq ft of living space, 3 spacious bedrooms with large closets, 2 baths. Extra large living room with wood-burning stove and new recessed lighting. Perfect second/vacation home! New stainless oven and refrigerator in large kitchen with dishwasher. New HVAC for heat plus ceiling fans.New carpet with transferable warranty plus upgraded pad. New Luxury Vinyl Plank. Formal dining room. Full kitchen pantry with separate exterior door. Master bedroom with large walk-in closet and a master bathroom with a jetted tub. Bonus home features include stick built property additions that include a large paneled and carpeted room for home office/craft room/den with large windows and an upstairs bedroom with its own magnificent views and 3 generous closets. Exterior highlights include a newly updated deck for you and your guests to enjoy the views, a flower garden, an attached garage with extensive shelving and utility hook-ups, a barn and a separate shed/workshop with electricity for your projects.. Private Well with new pump installed in 2023 and large water storage tank. Two gated private entrances with second interior gate to home. Interior and exterior of home newly painted. Property is Perimeter fenced with the home separately fenced. Owned propane tank. Starlink, Satellite internet and Satellite TV available. No HOA. Located close to the main paved road for easy access. The 50 acre parcel is zoned for 2.5 acre parcels, offering an exceptional development opportunity as well as robust opportunities for orchards, gardens, storage, garages and other structures. Area is excellent for gardening and recreation! Horses, cows, sheep and dogs are welcome! Propane tank is owned. Walker Basin is nestled in the Tehachapi Mountains and at the southern end of the Sequoia National Forest. Easy access to Kern River & Lake Isabella activities, including fishing, hiking, horseback riding, river rafting, camping and skiing. Numerous open trails for horseback riding and motorcycles. Easy drive to the antique Mecca in Kernville. Approximately 1 hour from Bakersfield and Tehachapi, just a few hours from Los Angeles and Santa Barbara. Adjacent 20 acre parcel available for sale: 0 Redstone Ave, Lot 5, APN 397-18-005. Come and enjoy your peaceful and tranquil retreat.
MlsNumber: --
ListingId: P1-18092


Listing Provided By: Walker Basin Ranch and Home, original listing
Phone: (661) 867-2001
Office Phone: (661) 867-2001
Agent Name: Valerie H Colb
Disclaimer: Copyright © 2024 California Regional MLS - Pasadena-Foothills and Ventura County Coastal. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 197 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;
Real Estate Expert Photo for Gabriel Gomez
Gabriel Gomez
ASCIICentury 21 Jordan Link & Company
Call Today!: (661) 497-2985

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App