Please provide the following information and Larry Schrimp will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.lplenderservices.com/agent/10259/larry-schrimp/property/link/fresno/611438/3048-E-Los-Altos-Ave/Fresno/Hoover/https://www.lplenderservices.com/images/props/fresno/full/611438.jpgLondon Properties Fresno Real Estate | 3048 E Los Altos Ave
Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
Property Description
Centrally located home, nearby Fresno State, several Hospitals, shopping and freeway access. This 3Bed 2Ba home has recently had the interior painted, and new carpeting installed. Home boast of two family room areas. Kitchen is open to the large extended den with masonry fireplace. Kitchen has ample storage, counter space, and double overs. Large covered patio would be great for entertaining or just relaxing outdoors. Two large storage sheds and gated front yard are also couple more amenities that will make this property desirable to the future buyer. Contact your agent for private showing or visit the at the Open House Sunday April 26th from 11-2pm.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1980
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$208
Price Per Acre
$2,754,004
Days On Market
4
Cumulative Days On Market
4
County
Fresno
REO / Bank Owned
No
Cross Street Address
E/Chestnut S/Herndon
Directions
From Herndon Ave, head south on Chestnut Ave, to left onto Los Altos, home is on north side of street.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, In Closet
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Eating Area
A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451395 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) >= 1819 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2319 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` = 1582263 OR `props-main`.`id` = 1589228 OR `props-main`.`id` = 1582877 OR `props-main`.`id` = 1584591 OR `props-main`.`id` = 1572627 OR `props-main`.`id` = 1582291 OR `props-main`.`id` = 1583891 OR `props-main`.`id` = 1588290 OR `props-main`.`id` = 1570223 OR `props-main`.`id` = 1563337 OR `props-main`.`id` = 1586318 OR `props-main`.`id` = 1581683 OR `props-main`.`id` = 1581454 OR `props-main`.`id` = 1584117 OR `props-main`.`id` = 1590623 OR `props-main`.`id` = 1590573 OR `props-main`.`id` = 1588875 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 1590217 OR `props-main`.`id` = 1580689 OR `props-main`.`id` = 241543 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1583003 OR `props-main`.`id` = 1586510 OR `props-main`.`id` = 1587442 OR `props-main`.`id` = 1588821 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1578022 OR `props-main`.`id` = 1589663 OR `props-main`.`id` = 1584666 OR `props-main`.`id` = 1583382 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1585835 OR `props-main`.`id` = 1588897 OR `props-main`.`id` = 188254 OR `props-main`.`id` = 1589375 OR `props-main`.`id` = 1589353 OR `props-main`.`id` = 1589352 OR `props-main`.`id` = 1586750 OR `props-main`.`id` = 1588252 OR `props-main`.`id` = 1589809 OR `props-main`.`id` = 1589808 OR `props-main`.`id` = 1554217 OR `props-main`.`id` = 1585058 OR `props-main`.`id` = 1589389 OR `props-main`.`id` = 1588874 OR `props-main`.`id` = 1586513 OR `props-main`.`id` = 1580928 OR `props-main`.`id` = 1581980 OR `props-main`.`id` = 1581895 OR `props-main`.`id` = 1581967 OR `props-main`.`id` = 1581972 OR `props-main`.`id` = 1589373 OR `props-main`.`id` = 1588135 OR `props-main`.`id` = 1588718 OR `props-main`.`id` = 1586482 OR `props-main`.`id` = 1574396 OR `props-main`.`id` = 1574341 OR `props-main`.`id` = 1589483 OR `props-main`.`id` = 1571878 OR `props-main`.`id` = 1584197 OR `props-main`.`id` = 1585262 OR `props-main`.`id` = 1586570 OR `props-main`.`id` = 1586460 OR `props-main`.`id` = 1581366 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1586941 OR `props-main`.`id` = 1585161 OR `props-main`.`id` = 1584383 OR `props-main`.`id` = 1589912 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1588000 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1587745 OR `props-main`.`id` = 1580862 OR `props-main`.`id` = 1577949 OR `props-main`.`id` = 1588486 OR `props-main`.`id` = 1587250 OR `props-main`.`id` = 1585847 OR `props-main`.`id` = 1585513 OR `props-main`.`id` = 1583048 OR `props-main`.`id` = 1586464)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611438' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2024-05-10' 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();
Courtesy of Gregory Kosareff, Realty Concepts, Ltd. - Fresno - gregkosareff@gmail.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.