Please provide the following information and Jasmin Quintana will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.quintanahomes.com/agent/19708/jasmin-quintana/property/link/fresno/643114/6613-N-Chance-Ave/Fresno/Hoover/https://www.quintanahomes.com/images/props/fresno/full/643114.jpgLondon Properties Fresno Real Estate | 6613 N Chance Ave
Charming and well-maintained 3-bedroom, 1.75-bath home situated on a generous lot in a great neighborhood. This inviting property offers comfortable living spaces and a functional layout ideal for everyday living and entertaining. Lovingly cared for over the years, the home retains some classic character and offers a wonderful opportunity for buyers to update and personalize to their own taste. With plenty of outdoor space and a desirable location, this home combines charm, value, and potential in one appealing package.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1977
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$274
Price Per Acre
$2,521,264
Days On London
1
Cumulative Days On London
1
County
Fresno
Reports Available
Pest, NHD, Prelim Title Report
REO / Bank Owned
No
Cross Street Address
Cedar and Palo Alto
Directions
From Cedar, turn east on Palo Alto, then south on Chance to the property.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 394250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1264 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1764 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` = 1689450 OR `props-main`.`id` = 1703723 OR `props-main`.`id` = 1678175 OR `props-main`.`id` = 1705249 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1704121 OR `props-main`.`id` = 1703111 OR `props-main`.`id` = 1694030 OR `props-main`.`id` = 1680361 OR `props-main`.`id` = 1698002 OR `props-main`.`id` = 1698699 OR `props-main`.`id` = 1691561 OR `props-main`.`id` = 1693812 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1703581 OR `props-main`.`id` = 1704469 OR `props-main`.`id` = 1705391 OR `props-main`.`id` = 1704459 OR `props-main`.`id` = 1702242 OR `props-main`.`id` = 1704705 OR `props-main`.`id` = 265423 OR `props-main`.`id` = 1660355 OR `props-main`.`id` = 138928 OR `props-main`.`id` = 1703701 OR `props-main`.`id` = 1703795 OR `props-main`.`id` = 1704600 OR `props-main`.`id` = 1691716 OR `props-main`.`id` = 1691176 OR `props-main`.`id` = 1692236 OR `props-main`.`id` = 1702672 OR `props-main`.`id` = 1701818 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 1703840 OR `props-main`.`id` = 241543 OR `props-main`.`id` = 1696727 OR `props-main`.`id` = 1702745 OR `props-main`.`id` = 1704788 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1686274 OR `props-main`.`id` = 1702265 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1701105 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1697200 OR `props-main`.`id` = 1701735 OR `props-main`.`id` = 1697379 OR `props-main`.`id` = 1704798 OR `props-main`.`id` = 1697378 OR `props-main`.`id` = 1670908 OR `props-main`.`id` = 1696769 OR `props-main`.`id` = 1704511 OR `props-main`.`id` = 1702595 OR `props-main`.`id` = 188254 OR `props-main`.`id` = 1704623 OR `props-main`.`id` = 1705351 OR `props-main`.`id` = 1686412 OR `props-main`.`id` = 1696507 OR `props-main`.`id` = 1696615 OR `props-main`.`id` = 222632 OR `props-main`.`id` = 1701476 OR `props-main`.`id` = 1680596 OR `props-main`.`id` = 1704790 OR `props-main`.`id` = 1705576 OR `props-main`.`id` = 244266 OR `props-main`.`id` = 1705336 OR `props-main`.`id` = 1699036 OR `props-main`.`id` = 1705055 OR `props-main`.`id` = 1702375 OR `props-main`.`id` = 1699034 OR `props-main`.`id` = 1702438 OR `props-main`.`id` = 1701499 OR `props-main`.`id` = 1697236 OR `props-main`.`id` = 1704516 OR `props-main`.`id` = 1690962 OR `props-main`.`id` = 1701303 OR `props-main`.`id` = 1697265 OR `props-main`.`id` = 1690514 OR `props-main`.`id` = 1690528 OR `props-main`.`id` = 1705061 OR `props-main`.`id` = 896872 OR `props-main`.`id` = 1701945 OR `props-main`.`id` = 1704637 OR `props-main`.`id` = 1702464 OR `props-main`.`id` = 1705584 OR `props-main`.`id` = 186738 OR `props-main`.`id` = 1703333 OR `props-main`.`id` = 1704139 OR `props-main`.`id` = 1691341 OR `props-main`.`id` = 1702842 OR `props-main`.`id` = 1702857 OR `props-main`.`id` = 1704570 OR `props-main`.`id` = 1696501 OR `props-main`.`id` = 1674613 OR `props-main`.`id` = 1704852 OR `props-main`.`id` = 1696890 OR `props-main`.`id` = 1697786 OR `props-main`.`id` = 1688804 OR `props-main`.`id` = 1703409 OR `props-main`.`id` = 1703509 OR `props-main`.`id` = 1705441 OR `props-main`.`id` = 1691565 OR `props-main`.`id` = 1679646 OR `props-main`.`id` = 1698489 OR `props-main`.`id` = 1701373 OR `props-main`.`id` = 1705398 OR `props-main`.`id` = 1686094 OR `props-main`.`id` = 1696173 OR `props-main`.`id` = 1700108 OR `props-main`.`id` = 1697196 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1704485 OR `props-main`.`id` = 1697072 OR `props-main`.`id` = 1702373 OR `props-main`.`id` = 1692080 OR `props-main`.`id` = 1702844 OR `props-main`.`id` = 1703048 OR `props-main`.`id` = 1703130 OR `props-main`.`id` = 1703141 OR `props-main`.`id` = 1703118 OR `props-main`.`id` = 1703440 OR `props-main`.`id` = 1703689 OR `props-main`.`id` = 1702701 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1684568 OR `props-main`.`id` = 1703827 OR `props-main`.`id` = 1688809 OR `props-main`.`id` = 1695971 OR `props-main`.`id` = 1705110 OR `props-main`.`id` = 1702544 OR `props-main`.`id` = 1702470 OR `props-main`.`id` = 1694626 OR `props-main`.`id` = 1701984 OR `props-main`.`id` = 1702905 OR `props-main`.`id` = 1703308 OR `props-main`.`id` = 1702376 OR `props-main`.`id` = 1694367 OR `props-main`.`id` = 1704349 OR `props-main`.`id` = 1695705 OR `props-main`.`id` = 1705649 OR `props-main`.`id` = 1703612)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643114' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-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();
6
Similar Properties
$430,000
3
2
1,540
0.17
275 N Peach Ave
Clovis, CA 93612
$430,000
3
2
1,616
0.14
1310 E Sample Ave
Fresno, CA 93710
$419,300
3
2
1,588
0.15
5186 N Callisch Ave
Fresno, CA 93710
$409,000
3
2
1,554
0.13
6706 N Chestnut Ave #118
Fresno, CA 93710
Courtesy of Kimberly Howell, Iron Key Real Estate - kim@ironkeyrealestate.com Last modified 1 hour ago Fresno MLS last checked for updates 28 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.
