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/643190/6760-N-Price-Ave/Fresno/Hoover/https://www.quintanahomes.com/images/props/fresno/full/643190.jpgLondon Properties Fresno Real Estate | 6760 N Price Ave
Beautifully maintained and thoughtfully updated, this inviting home offers flexible living spaces designed to adapt to your lifestyle. The light and airy interior is filled with natural light, creating a warm and welcoming atmosphere throughout. Situated on a huge oversized lot, the property features mature, stunning landscaping and a variety of fruit trees, providing both beauty and functionality. There is ample space for outdoor living, entertaining, and RV parking. Conveniently located near shopping, dining, and everyday amenities, this turnkey home combines comfort, space, and convenience in a truly special setting.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1973
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$245
Price Per Acre
$2,649,007
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Herndon/Maple
Directions
From Herndon and Maple South on Maple. East on Magill. Right on Price.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 418000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 462000 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) >= 1544 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2044 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` = 1703111 OR `props-main`.`id` = 1694030 OR `props-main`.`id` = 1698002 OR `props-main`.`id` = 1698699 OR `props-main`.`id` = 1691561 OR `props-main`.`id` = 1704581 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1702242 OR `props-main`.`id` = 1701231 OR `props-main`.`id` = 1690978 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` = 235292 OR `props-main`.`id` = 1703840 OR `props-main`.`id` = 1705272 OR `props-main`.`id` = 1705271 OR `props-main`.`id` = 241543 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` = 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` = 1702556 OR `props-main`.`id` = 1705351 OR `props-main`.`id` = 1686412 OR `props-main`.`id` = 222632 OR `props-main`.`id` = 1680596 OR `props-main`.`id` = 1704790 OR `props-main`.`id` = 244266 OR `props-main`.`id` = 1705336 OR `props-main`.`id` = 1699036 OR `props-main`.`id` = 1705055 OR `props-main`.`id` = 1687404 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` = 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` = 1674613 OR `props-main`.`id` = 1704852 OR `props-main`.`id` = 1696890 OR `props-main`.`id` = 1691565 OR `props-main`.`id` = 1698489 OR `props-main`.`id` = 1701373 OR `props-main`.`id` = 1705398 OR `props-main`.`id` = 1686094 OR `props-main`.`id` = 1700108 OR `props-main`.`id` = 1697196 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 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` = 186522 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 OR `props-main`.`id` = 1703433 OR `props-main`.`id` = 1701109 OR `props-main`.`id` = 1705438 OR `props-main`.`id` = 1704380)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643190' 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();
4
Similar Properties
$454,900
4
2.5
1,861
0.10
7396 N Price Ave
Fresno, CA 93720
$450,000
3
3
1,904
0.17
6578 N Callisch
Fresno, CA 93710-3904
$430,000
3
2
1,616
0.14
1310 E Sample Ave
Fresno, CA 93710
$425,000
3
2
1,860
0.19
1288 E Sierra Ave
Fresno, CA 93710
Courtesy of Karen Johnson, Realty Concepts, Ltd. - Clovis - karen@realtyconcepts.com Last modified 1 day ago Fresno MLS last checked for updates 25 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.
