London Properties, Ltd.559.436.4071Email Agentinfo@londonproperties.com
Property Description
Courtesy of Samuel Jacques, 168 Real Estate - info@srjrealtor.com
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
102
Cumulative Days On London
102
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` = 1760464 OR `props-main`.`id` = 1760849 OR `props-main`.`id` = 1765285 OR `props-main`.`id` = 1734769 OR `props-main`.`id` = 1702655 OR `props-main`.`id` = 1758380 OR `props-main`.`id` = 1768401 OR `props-main`.`id` = 1761130 OR `props-main`.`id` = 1761749 OR `props-main`.`id` = 1742572 OR `props-main`.`id` = 1768987 OR `props-main`.`id` = 1697094 OR `props-main`.`id` = 1763214 OR `props-main`.`id` = 1754723 OR `props-main`.`id` = 1750806 OR `props-main`.`id` = 1723953 OR `props-main`.`id` = 1723248 OR `props-main`.`id` = 1721476 OR `props-main`.`id` = 1709462 OR `props-main`.`id` = 1705462 OR `props-main`.`id` = 1683287 OR `props-main`.`id` = 1719610 OR `props-main`.`id` = 1731563 OR `props-main`.`id` = 1719760 OR `props-main`.`id` = 1724114 OR `props-main`.`id` = 1756210 OR `props-main`.`id` = 1767043 OR `props-main`.`id` = 1762476 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` = 1684372 OR `props-main`.`id` = 1750468 OR `props-main`.`id` = 1755391 OR `props-main`.`id` = 1749538 OR `props-main`.`id` = 1726601 OR `props-main`.`id` = 1744671 OR `props-main`.`id` = 1744963 OR `props-main`.`id` = 1727875 OR `props-main`.`id` = 1761046 OR `props-main`.`id` = 1752148 OR `props-main`.`id` = 1750692 OR `props-main`.`id` = 1665709 OR `props-main`.`id` = 1749524 OR `props-main`.`id` = 1708219 OR `props-main`.`id` = 1756223 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` = 1726805 OR `props-main`.`id` = 1758695 OR `props-main`.`id` = 1762368 OR `props-main`.`id` = 1705358 OR `props-main`.`id` = 1757474 OR `props-main`.`id` = 1694336 OR `props-main`.`id` = 1756104 OR `props-main`.`id` = 1717138 OR `props-main`.`id` = 1766514 OR `props-main`.`id` = 1768473 OR `props-main`.`id` = 1767699 OR `props-main`.`id` = 1754429 OR `props-main`.`id` = 1712861 OR `props-main`.`id` = 1762551 OR `props-main`.`id` = 1729146 OR `props-main`.`id` = 1766335 OR `props-main`.`id` = 1744670 OR `props-main`.`id` = 1733312 OR `props-main`.`id` = 1767276 OR `props-main`.`id` = 1726239 OR `props-main`.`id` = 1759619 OR `props-main`.`id` = 1766707 OR `props-main`.`id` = 1758994 OR `props-main`.`id` = 1681209 OR `props-main`.`id` = 1730779 OR `props-main`.`id` = 1763631 OR `props-main`.`id` = 1734718 OR `props-main`.`id` = 1753340 OR `props-main`.`id` = 1718865 OR `props-main`.`id` = 1450737 OR `props-main`.`id` = 1720737 OR `props-main`.`id` = 1724053 OR `props-main`.`id` = 1725987 OR `props-main`.`id` = 1690346 OR `props-main`.`id` = 1762776 OR `props-main`.`id` = 1749199 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` = 228066 OR `props-main`.`id` = 1719012 OR `props-main`.`id` = 1713995 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` = 1708178 OR `props-main`.`id` = 1733501 OR `props-main`.`id` = 1744757 OR `props-main`.`id` = 1746591 OR `props-main`.`id` = 1722408 OR `props-main`.`id` = 1739448 OR `props-main`.`id` = 1746528 OR `props-main`.`id` = 1746588 OR `props-main`.`id` = 1746590 OR `props-main`.`id` = 1767039 OR `props-main`.`id` = 1728443 OR `props-main`.`id` = 1743425 OR `props-main`.`id` = 70356 OR `props-main`.`id` = 1732705 OR `props-main`.`id` = 1733497 OR `props-main`.`id` = 1719404 OR `props-main`.`id` = 1761812 OR `props-main`.`id` = 1767731 OR `props-main`.`id` = 1722624 OR `props-main`.`id` = 1759435)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649107' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-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();
3
Similar Properties
$269,900
3
1
921
0.17
1017 E Vine Ave
Fresno, CA 93706
$269,000
2
1
793
0.17
3141 E Butler Ave
Fresno, CA 93702
$259,900
2
1
834
0.16
322 E Kearney Blvd
Fresno, CA 93706
Last modified 1 week ago Fresno MLS last checked for updates 20 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.
