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 one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/656146/1555-College/Dinuba/https://www.londonproperties.com/images/props/fresno/full/656146.jpgLondon Properties Dinuba Real Estate | 1555 College
Opportunity awaits at 1555 S College Ave! This property is being offered as-is and features a huge lot with convenient rear alley access, providing plenty of space and potential. The home also includes a garage conversion that is not reflected in the listed square footage, offering additional usable space beyond what the public record/listing square footage indicates. Property is a 3 Bed 2 Bath as is, and with garage conversion adds a 4th Bed. With its generous lot size, alley access, and additional converted space, this property presents an excellent opportunity for buyers looking to add value or customize a property to fit their needs.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1950
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$219
Price Per Acre
$893,673
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Yale
Directions
From Ave 416, head toward S College Ave. Continue on S College Ave to 1555 S College Ave. Property will be on the Right side.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 260300 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 287700 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) >= 1002 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1502 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` = 1748490 OR `props-main`.`id` = 1748522 OR `props-main`.`id` = 1776777 OR `props-main`.`id` = 1776776 OR `props-main`.`id` = 1748543 OR `props-main`.`id` = 1776779 OR `props-main`.`id` = 1748707 OR `props-main`.`id` = 1776780 OR `props-main`.`id` = 1748751 OR `props-main`.`id` = 1776781 OR `props-main`.`id` = 1783292 OR `props-main`.`id` = 1768603 OR `props-main`.`id` = 1785240 OR `props-main`.`id` = 1776129 OR `props-main`.`id` = 1726288 OR `props-main`.`id` = 1752871 OR `props-main`.`id` = 1773127 OR `props-main`.`id` = 1736924 OR `props-main`.`id` = 1746597 OR `props-main`.`id` = 1755440 OR `props-main`.`id` = 1722679 OR `props-main`.`id` = 1769135 OR `props-main`.`id` = 1769104 OR `props-main`.`id` = 1776287 OR `props-main`.`id` = 1715660 OR `props-main`.`id` = 1737344 OR `props-main`.`id` = 1770278 OR `props-main`.`id` = 1783398 OR `props-main`.`id` = 1768986 OR `props-main`.`id` = 1783294 OR `props-main`.`id` = 1784983 OR `props-main`.`id` = 246307 OR `props-main`.`id` = 1753547 OR `props-main`.`id` = 1748070 OR `props-main`.`id` = 1778384 OR `props-main`.`id` = 1727078 OR `props-main`.`id` = 1765526 OR `props-main`.`id` = 1757095)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656146' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-01' 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
Last modified 2 hours ago Fresno MLS last checked for updates 47 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.
