London Properties Fish Camp Real Estate

Lic #00686056

Home Buying Selling Communities About Contact

Create Account

Fields marked with * are required. However, providing more information will allow us to better serve your needs.
* First Name:
* Last Name:
* Email Address:
* Password:
* Confirm Password:
Street Address:
City:
State:
Zip:
Cell Phone:
Other Phone:

Home

Buying

Selling

Home Value Calculator

Communities

About

Create Account | Login

Fresno Bee People's Choice Award Winner - #1 Best Real Estate Company

7730 Laurel Way

Fish Camp, CA 93623

Copy Link Get Directions

3 bd

2 ba

2,700 sq ft

0.22 acre

7730 Laurel Way

Fish Camp, CA 93623

Get Directions

Listed On: 04/09/2019

Status: Off Market

Listing Number: 520973 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

Donna Pride 559.642.8373 Email Agent

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 854905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 944895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2450 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2950 AND ((`props-main`.`PropertyType` = 'Residential' AND ( `props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR `props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR `props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR `props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR `props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR `props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR `props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1628264 OR `props-main`.`id` = 1636402 OR `props-main`.`id` = 1669922 OR `props-main`.`id` = 1719526 OR `props-main`.`id` = 1719530 OR `props-main`.`id` = 1669717 OR `props-main`.`id` = 1717218 OR `props-main`.`id` = 1717208 OR `props-main`.`id` = 1709772)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno520973' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();

We're sorry, this listing is no longer available.
Please click here to search from over 9,400 active listings.

Courtesy of Donna Pride, London Properties, Ltd.
Last modified 6 years, 11 months ago
Fresno MLS last checked for updates 53 minutes ago

The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.