Please provide the following information and Connie Bowser will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/504/connie-bowser/property/link/fresno/646485/5356-N-Bond-St/Fresno/Hoover/https://www.londonproperties.com/images/props/fresno/full/646485.jpgLondon Properties Fresno Real Estate | 5356 N Bond St
This beautiful 3-bedroom, 2-bath home is filled with natural light, warm neutral tones, and plenty of space for a growing family. The bright kitchen offers generous storage and opens seamlessly to the dining area, making everyday meals and entertaining effortless.
The primary bedroom includes a walk-in closet that can easily double as a cozy nursery or private retreat. Both bathrooms have been tastefully updated, adding comfort and style.
Enjoy year-round gatherings on the inviting back patioperfect for relaxing, barbecuing, or hosting friends.
Located just around the corner from Fresno State and Hoover High School, this home offers convenience, comfort, and an unbeatable location.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1965
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$291
Price Per Acre
$2,697,089
Days On London
4
Cumulative Days On London
4
County
Fresno
REO / Bank Owned
No
Cross Street Address
Barstow
Directions
From FIRST and Barstow, go East on Barstow, South on Bond, property is on the left
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 370499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 409498.95 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) >= 1090 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1590 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` = 1719237 OR `props-main`.`id` = 1712603 OR `props-main`.`id` = 1712616 OR `props-main`.`id` = 1712615 OR `props-main`.`id` = 1695657 OR `props-main`.`id` = 1695663 OR `props-main`.`id` = 1712342 OR `props-main`.`id` = 1704717 OR `props-main`.`id` = 1716817 OR `props-main`.`id` = 1716753 OR `props-main`.`id` = 1705225 OR `props-main`.`id` = 1704426 OR `props-main`.`id` = 1704433 OR `props-main`.`id` = 1719801 OR `props-main`.`id` = 1704765 OR `props-main`.`id` = 1717759 OR `props-main`.`id` = 1704346 OR `props-main`.`id` = 1691767 OR `props-main`.`id` = 1713298 OR `props-main`.`id` = 1715477 OR `props-main`.`id` = 1705075 OR `props-main`.`id` = 1719438 OR `props-main`.`id` = 1695772 OR `props-main`.`id` = 1676891 OR `props-main`.`id` = 1718341 OR `props-main`.`id` = 1717214 OR `props-main`.`id` = 1676595 OR `props-main`.`id` = 37605 OR `props-main`.`id` = 1716344 OR `props-main`.`id` = 1705408 OR `props-main`.`id` = 1698164 OR `props-main`.`id` = 1706051 OR `props-main`.`id` = 1719376 OR `props-main`.`id` = 1719692 OR `props-main`.`id` = 1690540 OR `props-main`.`id` = 1700060 OR `props-main`.`id` = 1692404 OR `props-main`.`id` = 1716427 OR `props-main`.`id` = 1715834 OR `props-main`.`id` = 1716539 OR `props-main`.`id` = 1717743 OR `props-main`.`id` = 166956 OR `props-main`.`id` = 1715493 OR `props-main`.`id` = 1703478 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1713059 OR `props-main`.`id` = 1719065 OR `props-main`.`id` = 1709460 OR `props-main`.`id` = 1715735 OR `props-main`.`id` = 1719824 OR `props-main`.`id` = 1715490 OR `props-main`.`id` = 1694030 OR `props-main`.`id` = 1680361 OR `props-main`.`id` = 1696606 OR `props-main`.`id` = 1698002 OR `props-main`.`id` = 1698699 OR `props-main`.`id` = 1691561 OR `props-main`.`id` = 1719823 OR `props-main`.`id` = 1716760 OR `props-main`.`id` = 1717425 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1716143 OR `props-main`.`id` = 1716852 OR `props-main`.`id` = 1712714 OR `props-main`.`id` = 1718263 OR `props-main`.`id` = 1707127 OR `props-main`.`id` = 1712786 OR `props-main`.`id` = 1703751 OR `props-main`.`id` = 1717259 OR `props-main`.`id` = 1719846 OR `props-main`.`id` = 1704705 OR `props-main`.`id` = 265423 OR `props-main`.`id` = 1719601 OR `props-main`.`id` = 1702890 OR `props-main`.`id` = 1695738 OR `props-main`.`id` = 1715979 OR `props-main`.`id` = 1713964 OR `props-main`.`id` = 138928 OR `props-main`.`id` = 1707122 OR `props-main`.`id` = 1717514 OR `props-main`.`id` = 1701818 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 1713631 OR `props-main`.`id` = 1713654 OR `props-main`.`id` = 241543 OR `props-main`.`id` = 1713853 OR `props-main`.`id` = 1717169 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1710010 OR `props-main`.`id` = 1706099 OR `props-main`.`id` = 1714995 OR `props-main`.`id` = 1717449 OR `props-main`.`id` = 1717052 OR `props-main`.`id` = 1711498 OR `props-main`.`id` = 1719541 OR `props-main`.`id` = 1718164 OR `props-main`.`id` = 1710076 OR `props-main`.`id` = 1697378 OR `props-main`.`id` = 217382 OR `props-main`.`id` = 1707971 OR `props-main`.`id` = 1715869 OR `props-main`.`id` = 1709498 OR `props-main`.`id` = 1689729 OR `props-main`.`id` = 1720272 OR `props-main`.`id` = 1696769 OR `props-main`.`id` = 1718529 OR `props-main`.`id` = 1704511 OR `props-main`.`id` = 188254 OR `props-main`.`id` = 1705351 OR `props-main`.`id` = 1714998 OR `props-main`.`id` = 1686412 OR `props-main`.`id` = 222632 OR `props-main`.`id` = 1716952 OR `props-main`.`id` = 244266 OR `props-main`.`id` = 1702968 OR `props-main`.`id` = 1703769 OR `props-main`.`id` = 1715764 OR `props-main`.`id` = 1705055 OR `props-main`.`id` = 1706790 OR `props-main`.`id` = 1702438 OR `props-main`.`id` = 1715514 OR `props-main`.`id` = 1716012 OR `props-main`.`id` = 1706872 OR `props-main`.`id` = 1697236 OR `props-main`.`id` = 1720339 OR `props-main`.`id` = 896872 OR `props-main`.`id` = 1718566 OR `props-main`.`id` = 1715781)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646485' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-06' 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();
5
Similar Properties
$407,999
3
2
1,436
0.15
5136 N Sherman Ave N
Fresno, CA 93710
$397,000
3
2
1,460
0.16
4545 N Meridian
Fresno, CA 93726
$384,999
3
2
1,299
0.21
568 E San Ramon Ave
Fresno, CA 93710
$380,000
3
2
1,448
0.14
1478 E Magill Ave
Fresno, CA 93710
Courtesy of Jessica Ramirez, Vylla Home, Inc. - [email protected] Last modified 3 days ago Fresno MLS last checked for updates 30 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.
