Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/645958/696-W-Celeste-Ave/Fresno/Bullard-High/https://www.londonproperties.com/images/props/fresno/full/645958.jpgLondon Properties Fresno Real Estate | 696 W Celeste Ave
Located near the corner of Palm and Bullard you will find this 3 bedroom 2.5 bath home offers a front room with ample amount of natural lighting overlooking the front yard. To the right of the entry you come across the kitchen with attached dining area with availible counter and cabinet space. Off of the kitchen you will find a second living space complete with a stone faced fire place and French doors leading to a covered patio in the backyard. Each bedroom offers laminate flooring and ceiling fans with a built in vanity located in the primary bedroom. If you prefer to enter into the home from the attached two car garage you pass the laundry area complete with a sink and .5 bathroom. Also located in the garage is a bonus utility room that can serve a variety of uses. Contact your local Realtor today to schedule your private showing.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1963
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$247
Price Per Acre
$1,797,323
Days On London
24
Cumulative Days On London
24
County
Fresno
Reports Available
Home Inspection
REO / Bank Owned
No
Cross Street Address
Palm
Directions
From the intersection of W Bullard and N Palm travel South on Palm, Make a Left onto W Celeste, home will be on the Left
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 446500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 493500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1652 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2152 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` = 1687392 OR `props-main`.`id` = 1687383 OR `props-main`.`id` = 1666387 OR `props-main`.`id` = 1705387 OR `props-main`.`id` = 1721448 OR `props-main`.`id` = 1639054 OR `props-main`.`id` = 1723628 OR `props-main`.`id` = 1719742 OR `props-main`.`id` = 1688797 OR `props-main`.`id` = 1718462 OR `props-main`.`id` = 1709726 OR `props-main`.`id` = 1721619 OR `props-main`.`id` = 1676595 OR `props-main`.`id` = 1716344 OR `props-main`.`id` = 1665766 OR `props-main`.`id` = 1705408 OR `props-main`.`id` = 1724975 OR `props-main`.`id` = 1717429 OR `props-main`.`id` = 1722175 OR `props-main`.`id` = 1704773 OR `props-main`.`id` = 1718833 OR `props-main`.`id` = 1712941 OR `props-main`.`id` = 1712963 OR `props-main`.`id` = 1712931 OR `props-main`.`id` = 1712938 OR `props-main`.`id` = 1707879 OR `props-main`.`id` = 1713842 OR `props-main`.`id` = 1723581 OR `props-main`.`id` = 1724598 OR `props-main`.`id` = 166956 OR `props-main`.`id` = 1717740 OR `props-main`.`id` = 1724621 OR `props-main`.`id` = 1723773 OR `props-main`.`id` = 1703478 OR `props-main`.`id` = 1724771 OR `props-main`.`id` = 1715568 OR `props-main`.`id` = 1724286 OR `props-main`.`id` = 1717540 OR `props-main`.`id` = 1715761 OR `props-main`.`id` = 1724625 OR `props-main`.`id` = 1715490 OR `props-main`.`id` = 1719013 OR `props-main`.`id` = 161024 OR `props-main`.`id` = 1717425 OR `props-main`.`id` = 1715556 OR `props-main`.`id` = 1708234 OR `props-main`.`id` = 1716852 OR `props-main`.`id` = 1718684 OR `props-main`.`id` = 1718124 OR `props-main`.`id` = 1718134 OR `props-main`.`id` = 1720421 OR `props-main`.`id` = 1720424 OR `props-main`.`id` = 1716038 OR `props-main`.`id` = 1718650 OR `props-main`.`id` = 1718263 OR `props-main`.`id` = 1723003 OR `props-main`.`id` = 1712786 OR `props-main`.`id` = 102280 OR `props-main`.`id` = 1703751 OR `props-main`.`id` = 1718500 OR `props-main`.`id` = 1722249 OR `props-main`.`id` = 1717259 OR `props-main`.`id` = 1686281 OR `props-main`.`id` = 1721588 OR `props-main`.`id` = 1721597 OR `props-main`.`id` = 1704705 OR `props-main`.`id` = 1725117 OR `props-main`.`id` = 265423 OR `props-main`.`id` = 1691835 OR `props-main`.`id` = 1717333 OR `props-main`.`id` = 1707004 OR `props-main`.`id` = 1716645 OR `props-main`.`id` = 1722089 OR `props-main`.`id` = 1715979 OR `props-main`.`id` = 1722449 OR `props-main`.`id` = 1717096 OR `props-main`.`id` = 1702555 OR `props-main`.`id` = 1721225 OR `props-main`.`id` = 1723044 OR `props-main`.`id` = 1720531 OR `props-main`.`id` = 1720597 OR `props-main`.`id` = 1713631 OR `props-main`.`id` = 1713654 OR `props-main`.`id` = 1717937 OR `props-main`.`id` = 1713853 OR `props-main`.`id` = 1722979 OR `props-main`.`id` = 1721214 OR `props-main`.`id` = 1709934 OR `props-main`.`id` = 1720639 OR `props-main`.`id` = 1724371 OR `props-main`.`id` = 1722957 OR `props-main`.`id` = 1720271 OR `props-main`.`id` = 1706099 OR `props-main`.`id` = 1717052 OR `props-main`.`id` = 1720960 OR `props-main`.`id` = 1716474 OR `props-main`.`id` = 1715640 OR `props-main`.`id` = 1719541 OR `props-main`.`id` = 1724077 OR `props-main`.`id` = 1724904 OR `props-main`.`id` = 1714972 OR `props-main`.`id` = 1714992 OR `props-main`.`id` = 1719678 OR `props-main`.`id` = 1721936 OR `props-main`.`id` = 1721869 OR `props-main`.`id` = 1700029 OR `props-main`.`id` = 1697378 OR `props-main`.`id` = 217382 OR `props-main`.`id` = 1707971 OR `props-main`.`id` = 1718237 OR `props-main`.`id` = 305398 OR `props-main`.`id` = 1724986 OR `props-main`.`id` = 1724935 OR `props-main`.`id` = 1723142 OR `props-main`.`id` = 1720295 OR `props-main`.`id` = 1704539 OR `props-main`.`id` = 1702378 OR `props-main`.`id` = 1718750 OR `props-main`.`id` = 1722436 OR `props-main`.`id` = 1717353 OR `props-main`.`id` = 1717328 OR `props-main`.`id` = 1717410 OR `props-main`.`id` = 233922 OR `props-main`.`id` = 1704748 OR `props-main`.`id` = 1722750 OR `props-main`.`id` = 222632 OR `props-main`.`id` = 1724600 OR `props-main`.`id` = 330848 OR `props-main`.`id` = 1721624 OR `props-main`.`id` = 1681969 OR `props-main`.`id` = 244266 OR `props-main`.`id` = 1702968 OR `props-main`.`id` = 1703769 OR `props-main`.`id` = 1715764 OR `props-main`.`id` = 1701542 OR `props-main`.`id` = 1724860 OR `props-main`.`id` = 1704188 OR `props-main`.`id` = 1718563 OR `props-main`.`id` = 1718922 OR `props-main`.`id` = 1674615 OR `props-main`.`id` = 1717114 OR `props-main`.`id` = 1722844 OR `props-main`.`id` = 1716012 OR `props-main`.`id` = 325803 OR `props-main`.`id` = 1722002 OR `props-main`.`id` = 1716413 OR `props-main`.`id` = 1706872 OR `props-main`.`id` = 1688764 OR `props-main`.`id` = 1701233 OR `props-main`.`id` = 1702541 OR `props-main`.`id` = 1720498 OR `props-main`.`id` = 1709629 OR `props-main`.`id` = 1725103 OR `props-main`.`id` = 1701249 OR `props-main`.`id` = 1719462 OR `props-main`.`id` = 1716453 OR `props-main`.`id` = 1724926 OR `props-main`.`id` = 1704902 OR `props-main`.`id` = 1724978 OR `props-main`.`id` = 1715475 OR `props-main`.`id` = 1723795 OR `props-main`.`id` = 1722415 OR `props-main`.`id` = 1720747 OR `props-main`.`id` = 1723702 OR `props-main`.`id` = 1690778 OR `props-main`.`id` = 1707020 OR `props-main`.`id` = 1707036 OR `props-main`.`id` = 1724096 OR `props-main`.`id` = 1717219 OR `props-main`.`id` = 1719207 OR `props-main`.`id` = 1719015 OR `props-main`.`id` = 1719178 OR `props-main`.`id` = 1719184 OR `props-main`.`id` = 1708090 OR `props-main`.`id` = 248378 OR `props-main`.`id` = 1713837 OR `props-main`.`id` = 1702495 OR `props-main`.`id` = 1711188)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645958' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-04' 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();
1
Similar Properties
$484,999
3
2.75
2,038
0.19
6424 N vagedes
Fresno, CA 93711
Courtesy of Vincent Reyna, Century 21 Jordan-Link & Company - [email protected] Last modified 2 weeks ago Fresno MLS last checked for updates 44 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.
