Attention all investors!Court-appointed receivership sale in Highway City. Property is currently boarded up with no active utilities and is being sold as-is due to existing code enforcement violations. Buyer may be required to sign a compliance agreement with the city and assume responsibility for correcting violations after close of escrow. Notice to Abate is available for review.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1945
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$349
Price Per Acre
$528,241
Days On London
121
Cumulative Days On London
121
County
Fresno
REO / Bank Owned
No
Cross Street Address
N State
Directions
-Travel North on Golden State -Turn Left on N State St -Turn Left on W mission -Property will be on the right hand side.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 247000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 273000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '1' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 494 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 994 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` = 1774756 OR `props-main`.`id` = 1702655 OR `props-main`.`id` = 1761130 OR `props-main`.`id` = 1742572 OR `props-main`.`id` = 1773080 OR `props-main`.`id` = 1697094 OR `props-main`.`id` = 1750806 OR `props-main`.`id` = 1723953 OR `props-main`.`id` = 1723248 OR `props-main`.`id` = 1721476 OR `props-main`.`id` = 1705462 OR `props-main`.`id` = 1719610 OR `props-main`.`id` = 1773701 OR `props-main`.`id` = 1719760 OR `props-main`.`id` = 1724114 OR `props-main`.`id` = 1756210 OR `props-main`.`id` = 1767043 OR `props-main`.`id` = 1777654 OR `props-main`.`id` = 1759373 OR `props-main`.`id` = 1737101 OR `props-main`.`id` = 1757276 OR `props-main`.`id` = 1742774 OR `props-main`.`id` = 1760272 OR `props-main`.`id` = 1771895 OR `props-main`.`id` = 1755391 OR `props-main`.`id` = 1749538 OR `props-main`.`id` = 1771967 OR `props-main`.`id` = 1726601 OR `props-main`.`id` = 1744671 OR `props-main`.`id` = 1744963 OR `props-main`.`id` = 1727875 OR `props-main`.`id` = 1752148 OR `props-main`.`id` = 1775344 OR `props-main`.`id` = 1750692 OR `props-main`.`id` = 1665709 OR `props-main`.`id` = 1749524 OR `props-main`.`id` = 1771952 OR `props-main`.`id` = 1772081 OR `props-main`.`id` = 1778675 OR `props-main`.`id` = 1778667 OR `props-main`.`id` = 1692298 OR `props-main`.`id` = 1767598 OR `props-main`.`id` = 1769862 OR `props-main`.`id` = 1765525 OR `props-main`.`id` = 1735399 OR `props-main`.`id` = 1758695 OR `props-main`.`id` = 1762368 OR `props-main`.`id` = 1773128 OR `props-main`.`id` = 1705358 OR `props-main`.`id` = 1771876 OR `props-main`.`id` = 1694336 OR `props-main`.`id` = 1756104 OR `props-main`.`id` = 1717138 OR `props-main`.`id` = 1766514 OR `props-main`.`id` = 1777867 OR `props-main`.`id` = 1768473 OR `props-main`.`id` = 1767699 OR `props-main`.`id` = 1773605 OR `props-main`.`id` = 1712861 OR `props-main`.`id` = 1762551 OR `props-main`.`id` = 1729146 OR `props-main`.`id` = 1766335 OR `props-main`.`id` = 1733312 OR `props-main`.`id` = 1726239 OR `props-main`.`id` = 1759619 OR `props-main`.`id` = 1778452 OR `props-main`.`id` = 1758994 OR `props-main`.`id` = 1681209 OR `props-main`.`id` = 1730779 OR `props-main`.`id` = 1771935 OR `props-main`.`id` = 1734718 OR `props-main`.`id` = 1753340 OR `props-main`.`id` = 1718865 OR `props-main`.`id` = 1770447 OR `props-main`.`id` = 1450737 OR `props-main`.`id` = 1720737 OR `props-main`.`id` = 1724053 OR `props-main`.`id` = 1725987 OR `props-main`.`id` = 1770356 OR `props-main`.`id` = 1770380 OR `props-main`.`id` = 1770400 OR `props-main`.`id` = 1770381 OR `props-main`.`id` = 1770804 OR `props-main`.`id` = 1775360 OR `props-main`.`id` = 1775370 OR `props-main`.`id` = 1690346 OR `props-main`.`id` = 1762776 OR `props-main`.`id` = 1773889 OR `props-main`.`id` = 1771286 OR `props-main`.`id` = 1749199 OR `props-main`.`id` = 1770162 OR `props-main`.`id` = 1742153 OR `props-main`.`id` = 1742181 OR `props-main`.`id` = 1738017 OR `props-main`.`id` = 1649227 OR `props-main`.`id` = 1742836 OR `props-main`.`id` = 1775018 OR `props-main`.`id` = 1777794 OR `props-main`.`id` = 228066 OR `props-main`.`id` = 1719012 OR `props-main`.`id` = 1713995 OR `props-main`.`id` = 1778644 OR `props-main`.`id` = 1778751 OR `props-main`.`id` = 1752720 OR `props-main`.`id` = 1765519 OR `props-main`.`id` = 1766397 OR `props-main`.`id` = 131234 OR `props-main`.`id` = 1746164 OR `props-main`.`id` = 1723971 OR `props-main`.`id` = 1733501 OR `props-main`.`id` = 1774983 OR `props-main`.`id` = 1744757 OR `props-main`.`id` = 1767039 OR `props-main`.`id` = 1775358 OR `props-main`.`id` = 1743425 OR `props-main`.`id` = 1772937 OR `props-main`.`id` = 70356 OR `props-main`.`id` = 1732705 OR `props-main`.`id` = 1733497 OR `props-main`.`id` = 1767731 OR `props-main`.`id` = 1722624 OR `props-main`.`id` = 1774366 OR `props-main`.`id` = 1759435)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649107' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-19' 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();
3
Similar Properties
$269,200
2
2
780
0.14
3243 E Platt
Fresno, CA 93702
$269,000
2
1
793
0.17
3141 E Butler Ave
Fresno, CA 93702
$265,000
2
1
730
0.15
3805 E Heaton Ave
Fresno, CA 93702
Last modified 1 month ago Fresno MLS last checked for updates 4 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.
