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/611196/5473-W-Corona-Ave/Fresno/Bullard-High/https://www.lplenderservices.com/images/props/fresno/full/611196.jpgLondon Properties Fresno Real Estate | 5473 W Corona Ave
Larry Schrimp559.281.4061larry@londonproperties.comEmail Agent
Property Description
Situated near Fig Garden Loop, this exceptional home showcases timeless interiors and an easy indoor/outdoor lifestyle. Beautifully remodeled, the layout offers 1,584 sq ft of pristine living space. Entertaining areas boast a formal living room with vaulted ceiling open to an elegant dining room. A casual family room with fireplace joins a first class eat-in kitchen lined with white cabinetry. Neutral decor and wood look flooring make decorating easy in each of the three bedrooms, presenting contemporary fixtures and spacious closets. An updated shared bath plus a private primary bath provide superb accommodations. An extensive covered porch leads to a full-length sun patio, forming an outstanding venue for outdoor entertaining. Additional amenities include ample parking, new lighting and low maintenance yard. The location in Northwest Fresno is ideal, just moments to schools, Stallion Park, golf courses, a community trail, and close to shopping like the Marketplace at El Paseo and GB3.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1989
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$252
Price Per Acre
$2,765,560
Days On Market
14
Cumulative Days On Market
14
County
Fresno
REO / Bank Owned
No
Cross Street Address
Polk & Sierra
Directions
From Herndon head South on Polk. Left on Corona and home will be on your right.
A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 419895 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) >= 1334 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1834 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` = 1586238 OR `props-main`.`id` = 1569574 OR `props-main`.`id` = 1585210 OR `props-main`.`id` = 280658 OR `props-main`.`id` = 1585606 OR `props-main`.`id` = 1585211 OR `props-main`.`id` = 1583756 OR `props-main`.`id` = 1553986 OR `props-main`.`id` = 1587092 OR `props-main`.`id` = 1585780 OR `props-main`.`id` = 1588493 OR `props-main`.`id` = 1577067 OR `props-main`.`id` = 1577279 OR `props-main`.`id` = 1554061 OR `props-main`.`id` = 1533059 OR `props-main`.`id` = 1545586 OR `props-main`.`id` = 1533061 OR `props-main`.`id` = 1533060 OR `props-main`.`id` = 1587139 OR `props-main`.`id` = 1587827 OR `props-main`.`id` = 1587850 OR `props-main`.`id` = 1587836 OR `props-main`.`id` = 1585208 OR `props-main`.`id` = 1582736 OR `props-main`.`id` = 1583747 OR `props-main`.`id` = 1588782 OR `props-main`.`id` = 1576630 OR `props-main`.`id` = 1579544 OR `props-main`.`id` = 1579919 OR `props-main`.`id` = 1519514 OR `props-main`.`id` = 1583614 OR `props-main`.`id` = 1583603 OR `props-main`.`id` = 1587852 OR `props-main`.`id` = 1589224 OR `props-main`.`id` = 1588892 OR `props-main`.`id` = 1534086 OR `props-main`.`id` = 1585042 OR `props-main`.`id` = 1587464 OR `props-main`.`id` = 1579461 OR `props-main`.`id` = 166957 OR `props-main`.`id` = 1589084 OR `props-main`.`id` = 1582047 OR `props-main`.`id` = 37604 OR `props-main`.`id` = 1585607 OR `props-main`.`id` = 1585888 OR `props-main`.`id` = 1585849 OR `props-main`.`id` = 1587973 OR `props-main`.`id` = 1579524 OR `props-main`.`id` = 1589099 OR `props-main`.`id` = 1589698 OR `props-main`.`id` = 1585387 OR `props-main`.`id` = 1549573 OR `props-main`.`id` = 1582160 OR `props-main`.`id` = 1582022 OR `props-main`.`id` = 1587498 OR `props-main`.`id` = 1581582 OR `props-main`.`id` = 1574081 OR `props-main`.`id` = 1583746 OR `props-main`.`id` = 1584871 OR `props-main`.`id` = 1588612 OR `props-main`.`id` = 1587664 OR `props-main`.`id` = 1588116 OR `props-main`.`id` = 1587111 OR `props-main`.`id` = 1588137 OR `props-main`.`id` = 1583735 OR `props-main`.`id` = 1546356 OR `props-main`.`id` = 1583316 OR `props-main`.`id` = 1584385 OR `props-main`.`id` = 1583541 OR `props-main`.`id` = 1585564 OR `props-main`.`id` = 1589195 OR `props-main`.`id` = 166342 OR `props-main`.`id` = 1587974 OR `props-main`.`id` = 1587988 OR `props-main`.`id` = 1265238 OR `props-main`.`id` = 1588743 OR `props-main`.`id` = 1588813 OR `props-main`.`id` = 1584633 OR `props-main`.`id` = 1585160 OR `props-main`.`id` = 1582467 OR `props-main`.`id` = 1586053 OR `props-main`.`id` = 1589722 OR `props-main`.`id` = 1589670 OR `props-main`.`id` = 1589440 OR `props-main`.`id` = 272846 OR `props-main`.`id` = 1578500 OR `props-main`.`id` = 1587443 OR `props-main`.`id` = 1584386 OR `props-main`.`id` = 1542400 OR `props-main`.`id` = 187711 OR `props-main`.`id` = 1588893 OR `props-main`.`id` = 1589489 OR `props-main`.`id` = 1579122 OR `props-main`.`id` = 195780 OR `props-main`.`id` = 231417 OR `props-main`.`id` = 258175 OR `props-main`.`id` = 1582755 OR `props-main`.`id` = 1582829 OR `props-main`.`id` = 1588106 OR `props-main`.`id` = 1585690 OR `props-main`.`id` = 1585451 OR `props-main`.`id` = 1585777 OR `props-main`.`id` = 1584559 OR `props-main`.`id` = 1587575 OR `props-main`.`id` = 256897 OR `props-main`.`id` = 1589415 OR `props-main`.`id` = 1586822 OR `props-main`.`id` = 1589530 OR `props-main`.`id` = 1589540)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611196' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2024-05-03' 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();
Similar Properties
$410,000
3
2
1,659
0.14
7437 N Lola Ave
Fresno, CA 93722
$405,000
3
2.75
1,398
0.06
5423 W Santa Barbara Dr
Fresno, CA 93722
$399,950
3
2.75
1,680
0.06
5414 W Santa Barbara Dr
Fresno, CA 93722
$385,000
3
2.25
1,525
0.15
5362 N Contessa Ave
Fresno, CA 93723
Courtesy of Gracelyn Martinez, Iron Key Real Estate - gracelynre@gmail.com Last modified 4 days ago Fresno MLS last checked for updates 1 hour 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.
