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

44420 Shaffer Road
Lake Hughes, CA 93532
Jennifer Stewart with eXp Realty of California, Inc., original listing - (888) 832-7179

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,400,000
Beds: 7
Baths: Full: 3, ½: 1, ¾: 2
Status: Active
SqFt: 3600 Square Feet
Agency: eXp Realty of California, Inc.
Agency Phone: (888) 832-7179

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 62 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1990
Notes: Welcome to Quail Run Ostrich Ranch This stunning property spans 62 acres across four parcels, offering a unique chance to embrace country living at its finest. Quail Run Ranch is the perfect retreat for those seeking tranquility, space, and the freedom to enjoy nature and animals.The 25-acre parcel features a 600' well, two 20,000-gallon water storage tanks, a three-acre fenced horse paddock with shading structures, a metal barn, and heritage grapevines. Electricity is available on this parcel.The 16.28-acre parcel offers a 600' well, a well house pumping to a 10,000-gallon storage tank, & a separate electrical meter. This parcel also includes a 20-apple-tree orchard, over 500 cherry trees, and a fenced garden area. There are five 8x15 wooden storage buildings on concrete slabs & seven 80' x 150' fenced paddocks, each with three-sided block shelters, automatic waterers, & feed tubs. Additional features include an 8' x 15' block bathroom with a private sewer tank, a children's play area, a large parking lot, a 40' octagon concrete and block dance floor/stage, a camping area, and an archery field.The 20-acre parcel hosts a 3,600 sq ft home with 6 bedrooms, 3 bathrooms, 2 kitchens, 2 living areas, & 2 laundry rooms, ideal for large families or multi-generational living. The home includes a 4-6 unit apartment-size sewer system, two custom fireplaces, & a free-standing fireplace. Outdoor amenities feature an octagon step-up patio made of concrete and block, a 20' x 20' wood-on-concrete storage building, and a 12' x 60' mobile home with 1 bed, 1 bath. The parcel also includes a concrete driveway, aviary, 1,000-gallon water storage, a 24' x 54' above-ground pool, BBQ area, & a small shooting range for target practice.Escape the hustle and bustle of city life & bring your animals to Quail Run Ranch. This extraordinary property offers endless possibilities and is ready for you to create your own rural paradise. Excluded: Horses. Ostriches and Emus negotiable.
MlsNumber: --
ListingId: 24005718


Listing Provided By: eXp Realty of California, Inc., original listing
Phone: (661) 494-3267
Office Phone: (888) 832-7179
Agent Name: Jennifer Stewart
Disclaimer: Copyright © 2024 Greater Antelope Valley Association of Realtors. 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