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

807 S Barlow Ln
Bishop, CA 93514
Linda Pasley with Mammoth Realty Team, original listing - (760) 934-3959

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,349,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2900 Square Feet
Agency: Mammoth Realty Team
Agency Phone: (760) 934-3959

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Rare Opportunity in Bishop " Custom Ranch-Style Retreat with Creek, RV Amenities & More! Don't miss this one-of-a-kind, newly built custom ranch-style home in the desirable Barlow neighborhood of Bishop, CA! Set on a beautifully landscaped 1/3-acre lot with a year-round creek, this property offers serenity, space, and direct access to adventure-just moments from the Bishop Country Club Golf Course and right on OHV routes to Coyote Flats, Chipmunk Canyon, and miles of USFS and BLM trails. Designed with comfort, efficiency, and lifestyle in mind, this Title24 Green Home features a spacious great room with vaulted ceilings, skylights, and a stunning floor-to-ceiling stone hearth with a Fireplace Xtrordinair insert. The kitchen is a chef's dream with Quartz Gold Oro counter tops and island, knotty alder cabinetry, and sleek luxury vinyl plank flooring throughout. Stunning, over sized Primary Bathroom with soaking tub right next to the creek will be your favorite place in the house.The Thoughtful layout includes walk-in closets with built-ins, an over sized laundry and pantry room, and a 900 sq ft garage with vaulted ceilings. 3+car garage, 60-amp hook ups for RV or EV.
MlsNumber: --
ListingId: 2312952


Listing Provided By: Mammoth Realty Team, original listing
Phone: (760) 934-3959
Office Phone: (760) 934-3959
Agent Name: Linda Pasley
Disclaimer: Copyright © 2025 Inyo County 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