Please provide the following information and Parminder Singh will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.singhre.com/agent/10465/parminder-singh/property/link/fresno/608980/2970-S-Martin-L-King-Jr-Blvd/Fresno/https://www.singhre.com/images/props/fresno/full/608980.jpgLondon Properties Fresno Real Estate | 2970 S Martin L King Jr Blvd
Welcome to your next project: This 3 bedroom, 2 bath home is in need of an investor buyer to come in and remodel. Spacious floor plan, around 1,050 sq ft and a large yard.Bed, Bath & Square footage are different than tax records, buyer to verify if important.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1972
Region
Urban
Unique Conditions
Probate
# of Stories
Single Story
Price Per Square Foot
$190
Price Per Acre
$1,583,531
Days On Market
49
Cumulative Days On Market
49
County
Fresno
REO / Bank Owned
No
Cross Street Address
North Ave
Directions
Head West on North Ave from Hwy 41, turn north on MLK Blvd.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 190000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 210000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 800 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1300 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` = 1679664 OR `props-main`.`id` = 1693114 OR `props-main`.`id` = 1688827 OR `props-main`.`id` = 1666081 OR `props-main`.`id` = 1658356 OR `props-main`.`id` = 1666382 OR `props-main`.`id` = 1680143 OR `props-main`.`id` = 1689977 OR `props-main`.`id` = 1665972 OR `props-main`.`id` = 1666314 OR `props-main`.`id` = 1665971 OR `props-main`.`id` = 1660400 OR `props-main`.`id` = 1660401 OR `props-main`.`id` = 1690032 OR `props-main`.`id` = 1674536 OR `props-main`.`id` = 1681564 OR `props-main`.`id` = 1674614 OR `props-main`.`id` = 1686222 OR `props-main`.`id` = 1692050 OR `props-main`.`id` = 1689420 OR `props-main`.`id` = 1680728 OR `props-main`.`id` = 1684236 OR `props-main`.`id` = 1686172 OR `props-main`.`id` = 1689025 OR `props-main`.`id` = 1683287 OR `props-main`.`id` = 1686721 OR `props-main`.`id` = 1677467 OR `props-main`.`id` = 1691288 OR `props-main`.`id` = 1684712 OR `props-main`.`id` = 1662537 OR `props-main`.`id` = 1681519 OR `props-main`.`id` = 1678452 OR `props-main`.`id` = 1679671 OR `props-main`.`id` = 1636479 OR `props-main`.`id` = 1693433 OR `props-main`.`id` = 1683102 OR `props-main`.`id` = 1683103 OR `props-main`.`id` = 1693467)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno608980' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-11' 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 Parminder Singh, London Properties-Kingsburg - psingh@londonproperties.com Last modified 2 weeks 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.
