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
Courtesy of Vincent Reyna, Century 21 Select Real Estate - [email protected]
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
40
Cumulative Days On London
40
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` = 1705387 OR `props-main`.`id` = 1733971 OR `props-main`.`id` = 1745637 OR `props-main`.`id` = 1639054 OR `props-main`.`id` = 1744622 OR `props-main`.`id` = 1688797 OR `props-main`.`id` = 1742903 OR `props-main`.`id` = 1718462 OR `props-main`.`id` = 1726768 OR `props-main`.`id` = 1721619 OR `props-main`.`id` = 1738716 OR `props-main`.`id` = 1676595 OR `props-main`.`id` = 1739621 OR `props-main`.`id` = 1745675 OR `props-main`.`id` = 1717429 OR `props-main`.`id` = 1734846 OR `props-main`.`id` = 1739009 OR `props-main`.`id` = 1712941 OR `props-main`.`id` = 1730614 OR `props-main`.`id` = 1727351 OR `props-main`.`id` = 1738015 OR `props-main`.`id` = 1743935 OR `props-main`.`id` = 166956 OR `props-main`.`id` = 1717740 OR `props-main`.`id` = 1724621 OR `props-main`.`id` = 1727398 OR `props-main`.`id` = 1744708 OR `props-main`.`id` = 1737823 OR `props-main`.`id` = 1717540 OR `props-main`.`id` = 1724625 OR `props-main`.`id` = 1737844 OR `props-main`.`id` = 1715490 OR `props-main`.`id` = 1719013 OR `props-main`.`id` = 161024 OR `props-main`.`id` = 1725497 OR `props-main`.`id` = 1737028 OR `props-main`.`id` = 1738277 OR `props-main`.`id` = 1737031 OR `props-main`.`id` = 1717425 OR `props-main`.`id` = 1727449 OR `props-main`.`id` = 1727507 OR `props-main`.`id` = 1738974 OR `props-main`.`id` = 1708234 OR `props-main`.`id` = 1734771 OR `props-main`.`id` = 1742754 OR `props-main`.`id` = 1727682 OR `props-main`.`id` = 1742734 OR `props-main`.`id` = 1725398 OR `props-main`.`id` = 1718124 OR `props-main`.`id` = 1718134 OR `props-main`.`id` = 1739205 OR `props-main`.`id` = 1743261 OR `props-main`.`id` = 102280 OR `props-main`.`id` = 1722249 OR `props-main`.`id` = 1742481 OR `props-main`.`id` = 1728770 OR `props-main`.`id` = 1744616 OR `props-main`.`id` = 1727294 OR `props-main`.`id` = 1739623 OR `props-main`.`id` = 1704705 OR `props-main`.`id` = 1738601 OR `props-main`.`id` = 1725117 OR `props-main`.`id` = 265423 OR `props-main`.`id` = 1725789 OR `props-main`.`id` = 1717333 OR `props-main`.`id` = 1707004 OR `props-main`.`id` = 1735993 OR `props-main`.`id` = 1733185 OR `props-main`.`id` = 1733203 OR `props-main`.`id` = 1729009 OR `props-main`.`id` = 1732287 OR `props-main`.`id` = 1732751 OR `props-main`.`id` = 1736124 OR `props-main`.`id` = 1733196 OR `props-main`.`id` = 1740192 OR `props-main`.`id` = 1745317 OR `props-main`.`id` = 1745467 OR `props-main`.`id` = 1736456 OR `props-main`.`id` = 1744649 OR `props-main`.`id` = 1720531 OR `props-main`.`id` = 1720597 OR `props-main`.`id` = 1713631 OR `props-main`.`id` = 1742770 OR `props-main`.`id` = 1738670 OR `props-main`.`id` = 1717937 OR `props-main`.`id` = 1742091 OR `props-main`.`id` = 1713853 OR `props-main`.`id` = 1741331 OR `props-main`.`id` = 1741322 OR `props-main`.`id` = 1732340 OR `props-main`.`id` = 1729142 OR `props-main`.`id` = 1728383 OR `props-main`.`id` = 1732829 OR `props-main`.`id` = 1720639 OR `props-main`.`id` = 1738308 OR `props-main`.`id` = 1745373 OR `props-main`.`id` = 1745367 OR `props-main`.`id` = 1731199 OR `props-main`.`id` = 1720271 OR `props-main`.`id` = 1742239 OR `props-main`.`id` = 1731794 OR `props-main`.`id` = 1743045 OR `props-main`.`id` = 1745716 OR `props-main`.`id` = 1729097 OR `props-main`.`id` = 1720960 OR `props-main`.`id` = 1730972 OR `props-main`.`id` = 1716474 OR `props-main`.`id` = 1731809 OR `props-main`.`id` = 1726394 OR `props-main`.`id` = 1730801 OR `props-main`.`id` = 1726508 OR `props-main`.`id` = 1745222 OR `props-main`.`id` = 1741756 OR `props-main`.`id` = 1724077 OR `props-main`.`id` = 1742107 OR `props-main`.`id` = 1729309 OR `props-main`.`id` = 1700029 OR `props-main`.`id` = 1736498 OR `props-main`.`id` = 217382 OR `props-main`.`id` = 1739622 OR `props-main`.`id` = 305398 OR `props-main`.`id` = 1732030 OR `props-main`.`id` = 1731970 OR `props-main`.`id` = 1724986 OR `props-main`.`id` = 1735469 OR `props-main`.`id` = 1736039 OR `props-main`.`id` = 1745711 OR `props-main`.`id` = 1733237 OR `props-main`.`id` = 1723142 OR `props-main`.`id` = 1704539 OR `props-main`.`id` = 1726873 OR `props-main`.`id` = 1722436 OR `props-main`.`id` = 233922 OR `props-main`.`id` = 1736050 OR `props-main`.`id` = 1742901 OR `props-main`.`id` = 1745221 OR `props-main`.`id` = 1736965 OR `props-main`.`id` = 1722750 OR `props-main`.`id` = 222632 OR `props-main`.`id` = 1742708 OR `props-main`.`id` = 1736849 OR `props-main`.`id` = 330848 OR `props-main`.`id` = 1732262 OR `props-main`.`id` = 1739731 OR `props-main`.`id` = 1725652 OR `props-main`.`id` = 1721624 OR `props-main`.`id` = 1681969 OR `props-main`.`id` = 244266 OR `props-main`.`id` = 1728882 OR `props-main`.`id` = 1702968 OR `props-main`.`id` = 1703769 OR `props-main`.`id` = 1715764 OR `props-main`.`id` = 1742312 OR `props-main`.`id` = 1704188 OR `props-main`.`id` = 1716012 OR `props-main`.`id` = 325803 OR `props-main`.`id` = 1716413 OR `props-main`.`id` = 1688764 OR `props-main`.`id` = 1725926 OR `props-main`.`id` = 1702541 OR `props-main`.`id` = 1720498 OR `props-main`.`id` = 1744464 OR `props-main`.`id` = 1725391 OR `props-main`.`id` = 1719462 OR `props-main`.`id` = 1744673 OR `props-main`.`id` = 1728066 OR `props-main`.`id` = 1737788 OR `props-main`.`id` = 1725234 OR `props-main`.`id` = 1739088 OR `props-main`.`id` = 1741793 OR `props-main`.`id` = 1727880 OR `props-main`.`id` = 1723702 OR `props-main`.`id` = 1690778 OR `props-main`.`id` = 1730973 OR `props-main`.`id` = 1707020 OR `props-main`.`id` = 1707036 OR `props-main`.`id` = 1728583 OR `props-main`.`id` = 1719207 OR `props-main`.`id` = 1719015 OR `props-main`.`id` = 1728585 OR `props-main`.`id` = 1728693 OR `props-main`.`id` = 248378 OR `props-main`.`id` = 1729482 OR `props-main`.`id` = 1702495)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645958' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-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();
2
Similar Properties
$490,000
3
2.5
1,850
0.27
654 W Celeste
Fresno, CA 93704
$475,000
3
3
1,791
0.26
725 W Rialto Ave
Fresno, CA 93705
Last modified 1 month 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.
