Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/645018/14901-S-Highland-Ave/Selma/https://www.londonproperties.com/images/props/fresno/full/645018.jpgLondon Properties Selma Real Estate | 14901 S Highland Ave
24 Acre Horse Ranch! Two homes! Three Parcels! Once known as the Ranch of Noah's Ark.Possibilities are endless. Out buildings include 2 Horse Barns with 21 stall, Hay Barn, tractor barn, 8 Stall mare motel with extended runs, total of 27 runs, 37 galvanized water troughs, outside Bath with shower,pipe fencing, Pond has large deck, 3 years ago was filled and full of fish. 2 Wells, CID water, Breeding barn, Arena, large round pen, tack room, tool room, Hot & cold water wash racks, 3 hitching posts, large Aviary, 3 septic's, Pebble tech Pool with waterfall. Main house is 3 stories plus accessible unfinished 4th story, lots of remodeling throughout the years. recently, new bathroom, laundry room and pantry. New security system and new A/C and heating. balconies, hardwood floors and many other special features. 2nd home is 1,700 sq. ft. manufactured home that has been completely remodeled and offers 3 bedroom 2 bath. The Ark has been remodeled and you can go inside. 4 way stop light at corner of highland and conejo with market on corner. Seller is looking for someone special to take over this incredible property that can offer amazing opportunity! Private showings to qualified buyers!
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1757500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1942500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3050 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3550 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` = 1715595 OR `props-main`.`id` = 1709265 OR `props-main`.`id` = 1719437)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645018' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-22' 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();
0
Last modified 1 month ago Fresno MLS last checked for updates 19 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.
