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/649936/297-W-Lilac-Ave/Reedley/https://www.londonproperties.com/images/props/fresno/full/649936.jpgLondon Properties Reedley Real Estate | 297 W Lilac Ave
Courtesy of Parminder Singh, London Properties-Kingsburg - [email protected]
Welcome to a home that truly checks all the boxes! Nestled in one of the Reedley's most desirable neighborhoods, this beautifully maintained residence offers outstanding curb appeal, plenty of character, and the kind of friendly community atmosphere buyers are searching for. Built in 2006, this spacious home features 4 bedrooms and 3 bathrooms, including a flexible next-generation setup that's ideal for multi-generational living, guests, or a private home office. Upon entering, you'll appreciate the elegant formal living and dining room that creates a warm first impression and provides the perfect space for entertaining. The heart of the home is the open-concept kitchen and family room, where gatherings come naturally. A cozy fireplace anchors the family room, creating an inviting space to relax and unwind. The well-designed floor plan also includes a large laundry room complete with a utility sink and abundant cabinet storage. Step outside to enjoy the expansive covered patio overlooking a beautifully landscaped backyard with mature greenery, offering a private and peaceful setting for outdoor dining, entertaining, or simply enjoying your morning coffee. Conveniently located near shopping, restaurants, parks, schools, and everyday amenities, this exceptional property combines comfort, functionality, and location into one incredible opportunity. Don't miss your chance to call this wonderful house your next home!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2006
Region
Urban
# of Stories
Two
Price Per Square Foot
$206
Price Per Acre
$2,978,860
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Frankwood
Directions
take Manning Ave, R on Frankwood, R on Lilac
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 441750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 488250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2012 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2512 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` = 1732788 OR `props-main`.`id` = 1724374 OR `props-main`.`id` = 1724341 OR `props-main`.`id` = 1729223 OR `props-main`.`id` = 1721743 OR `props-main`.`id` = 1723499 OR `props-main`.`id` = 1718749 OR `props-main`.`id` = 1720817 OR `props-main`.`id` = 1728249 OR `props-main`.`id` = 1710136 OR `props-main`.`id` = 1722660 OR `props-main`.`id` = 1709173 OR `props-main`.`id` = 1699072 OR `props-main`.`id` = 1717241 OR `props-main`.`id` = 1717236 OR `props-main`.`id` = 1717243 OR `props-main`.`id` = 1719316 OR `props-main`.`id` = 1731979 OR `props-main`.`id` = 1732025 OR `props-main`.`id` = 1705996 OR `props-main`.`id` = 1717994 OR `props-main`.`id` = 1713866 OR `props-main`.`id` = 1725463 OR `props-main`.`id` = 1718512 OR `props-main`.`id` = 1716581 OR `props-main`.`id` = 1716543 OR `props-main`.`id` = 1723243 OR `props-main`.`id` = 1730734 OR `props-main`.`id` = 1722434 OR `props-main`.`id` = 1730242 OR `props-main`.`id` = 1720482)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649936' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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();
0
Last modified 2 hours 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.
