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 Jim Cavanaugh will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.jimcavanaughre.com/agent/233/jim-cavanaugh/property/link/fresno/633955/742-N-Marion-Ave/Clovis/https://www.jimcavanaughre.com/images/props/fresno/full/633955.jpgLondon Properties Clovis Real Estate | 742 N Marion Ave
Jim Cavanaugh559.270.5571cavanaugh@londonproperties.comEmail Agent
Property Description
Black Horse Estates, built by Gary Masson. Awarding floorplan and unique design. Updated throughout, 4-bedroom, 3-bath, open floor plan with living room, family room, large open gourmet kitchen, sunny breakfast nook, 3 car garage, tile roof, neighborhood park, close to shopping, restaurants, Clovis Unified School District.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1992
Region
Urban
# of Stories
Two
Price Per Square Foot
$231
Price Per Acre
$3,477,261
Days On Market
51
Cumulative Days On Market
51
County
Fresno
REO / Bank Owned
No
Cross Street Address
E/Clovis Ave S/Alluvial
Directions
From Herndon go north on Clovis Ave to Alluvial, then east to Marion Ave, then south to property.
Special Disclosure
Flood Zone
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 617405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 682395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2559 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3059 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` = 1679769 OR `props-main`.`id` = 1648636 OR `props-main`.`id` = 1679693 OR `props-main`.`id` = 1683973 OR `props-main`.`id` = 1679272 OR `props-main`.`id` = 1672856 OR `props-main`.`id` = 1673208 OR `props-main`.`id` = 1671240 OR `props-main`.`id` = 1679584 OR `props-main`.`id` = 1668069 OR `props-main`.`id` = 1668077 OR `props-main`.`id` = 1668087 OR `props-main`.`id` = 1652560 OR `props-main`.`id` = 1677639 OR `props-main`.`id` = 1681275 OR `props-main`.`id` = 1681289 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1683791 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1646806 OR `props-main`.`id` = 1640942 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1683175 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1678889 OR `props-main`.`id` = 1681859 OR `props-main`.`id` = 1635722 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1664141 OR `props-main`.`id` = 1680568 OR `props-main`.`id` = 1677731 OR `props-main`.`id` = 1682032 OR `props-main`.`id` = 1678146 OR `props-main`.`id` = 1678325 OR `props-main`.`id` = 1670908 OR `props-main`.`id` = 1681580 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1662349 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1678670 OR `props-main`.`id` = 1682061 OR `props-main`.`id` = 1668584 OR `props-main`.`id` = 1684199 OR `props-main`.`id` = 1681256 OR `props-main`.`id` = 1683853 OR `props-main`.`id` = 1683905 OR `props-main`.`id` = 1678135 OR `props-main`.`id` = 1683472 OR `props-main`.`id` = 1662525 OR `props-main`.`id` = 1672855 OR `props-main`.`id` = 1668366 OR `props-main`.`id` = 1682157 OR `props-main`.`id` = 1674952 OR `props-main`.`id` = 1678515 OR `props-main`.`id` = 1636126 OR `props-main`.`id` = 1675039 OR `props-main`.`id` = 1668534 OR `props-main`.`id` = 1681156 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1678079 OR `props-main`.`id` = 1678087 OR `props-main`.`id` = 1676621 OR `props-main`.`id` = 1677203 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1684171 OR `props-main`.`id` = 1683753 OR `props-main`.`id` = 1681595 OR `props-main`.`id` = 1678410 OR `props-main`.`id` = 1668111 OR `props-main`.`id` = 1683321 OR `props-main`.`id` = 1683559 OR `props-main`.`id` = 1677277 OR `props-main`.`id` = 1682082 OR `props-main`.`id` = 1681691 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1681373 OR `props-main`.`id` = 1676181 OR `props-main`.`id` = 1679529 OR `props-main`.`id` = 1656659 OR `props-main`.`id` = 1656650 OR `props-main`.`id` = 1659506 OR `props-main`.`id` = 1659491 OR `props-main`.`id` = 1680688 OR `props-main`.`id` = 1665922 OR `props-main`.`id` = 1622629 OR `props-main`.`id` = 1684081 OR `props-main`.`id` = 1681274 OR `props-main`.`id` = 1683038 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1663227 OR `props-main`.`id` = 1680784 OR `props-main`.`id` = 1682027 OR `props-main`.`id` = 1665909 OR `props-main`.`id` = 1677547 OR `props-main`.`id` = 1681090 OR `props-main`.`id` = 1656704 OR `props-main`.`id` = 1667490 OR `props-main`.`id` = 1666636 OR `props-main`.`id` = 1666512 OR `props-main`.`id` = 1680292 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1668704 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1684107 OR `props-main`.`id` = 1679516 OR `props-main`.`id` = 1684006 OR `props-main`.`id` = 1680099 OR `props-main`.`id` = 1683230 OR `props-main`.`id` = 1681607 OR `props-main`.`id` = 1681606 OR `props-main`.`id` = 1681608 OR `props-main`.`id` = 1677541 OR `props-main`.`id` = 1681604 OR `props-main`.`id` = 1681602 OR `props-main`.`id` = 1658132 OR `props-main`.`id` = 1681596 OR `props-main`.`id` = 1681598 OR `props-main`.`id` = 1681599 OR `props-main`.`id` = 1667424 OR `props-main`.`id` = 1681600 OR `props-main`.`id` = 1680832 OR `props-main`.`id` = 1667425 OR `props-main`.`id` = 1684067 OR `props-main`.`id` = 1673257 OR `props-main`.`id` = 1678487 OR `props-main`.`id` = 1683291 OR `props-main`.`id` = 1683084 OR `props-main`.`id` = 1680834 OR `props-main`.`id` = 1680379 OR `props-main`.`id` = 1655608 OR `props-main`.`id` = 1683086)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno633955' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-06' 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();
4
Similar Properties
$675,000
4
3
2,800
0.20
837 Cypress Ave
Clovis, CA 93611
$655,000
4
3
2,826
0.18
1976 Decatur Ave
Clovis, CA 93611
$635,000
5
3.25
2,998
0.18
2162 Decatur Ave
Clovis, CA 93611
$630,000
4
3.5
2,900
0.35
254 W Sierra Ave
Clovis, CA 93612
Courtesy of James Cavanaugh, London Properties, Ltd. - cavanaugh@londonproperties.com Last modified 1 week ago Fresno MLS last checked for updates 5 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.
