Please provide the following information and Lorelei Van Sack will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.loreleisellshomes.com/agent/20413/lorelei-vansack/property/link/fresno/634482/4715-E-Copper-Ave/Clovis/https://www.loreleisellshomes.com/images/props/fresno/full/634482.jpgLondon Properties Clovis Real Estate | 4715 E Copper Ave
Lorelei Van Sack559.826.8808lvansack@londonproperties.comEmail Agent
Property Description
This listing consists of 3 parcels. 19.7 acres, 20 acres and 20 acres. Total acreage 59.7+/-. Custom built house is located on 1 parcel of 20 acres. This parcel also has a tennis court, indoor lap pool, and 2 very large metal buildings. Exceptional craftsmanship and high quality construction. Land is in the City of Clovis, North Urban Center General Plan. Prime development land for single family homes. Owner may consider sale of House, large metal buildings, and 5+/- acres, separately, with approved lot line adjustment completed. More pictures will be added later.
East on Copper Avenue past Minnewawa Ave, 1/2 mile to gravel road to the right. House and 20 acres on left side, 1/4 mile South of Copper. 19.7 acres open land on Left side, with Copper Frontage, 20 acres open land located East of House property
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
Built In Range/Oven, Disposal, Dishwasher, Microwave
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 12193725 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 13477275 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '7' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 8044 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 8544 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` = 1690107 OR `props-main`.`id` = 1665909 OR `props-main`.`id` = 1695631 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1679516 OR `props-main`.`id` = 1684006 OR `props-main`.`id` = 1693598 OR `props-main`.`id` = 1685077 OR `props-main`.`id` = 1693611 OR `props-main`.`id` = 1693616 OR `props-main`.`id` = 1693613 OR `props-main`.`id` = 1693597 OR `props-main`.`id` = 1693614 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1693615 OR `props-main`.`id` = 1693612 OR `props-main`.`id` = 1688989 OR `props-main`.`id` = 1693592 OR `props-main`.`id` = 1685980 OR `props-main`.`id` = 1690721 OR `props-main`.`id` = 1686437 OR `props-main`.`id` = 1687299 OR `props-main`.`id` = 1696286 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 820696 OR `props-main`.`id` = 1690411 OR `props-main`.`id` = 1693311 OR `props-main`.`id` = 1677889 OR `props-main`.`id` = 1690432 OR `props-main`.`id` = 1674389 OR `props-main`.`id` = 1689630 OR `props-main`.`id` = 1684194 OR `props-main`.`id` = 1653256 OR `props-main`.`id` = 1689446 OR `props-main`.`id` = 1696333 OR `props-main`.`id` = 1694812)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno634482' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-30' 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
Courtesy of Gregory Johnson, Landmark Properties - 4gregajohnson@gmail.com Last modified 3 weeks ago Fresno MLS last checked for updates 9 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.
