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/642803/2202-W-Lincoln-Ave/Fresno/https://www.londonproperties.com/images/props/fresno/full/642803.jpgLondon Properties Fresno Real Estate | 2202 W Lincoln Ave
Courtesy of Gregory Kusch, Valley Land & Investment Co. - [email protected]
This property includes two homes on 18.65+/- acres, located at 2202 and 2218 W. Lincoln Ave. The Primary Home is a spacious 4 bedroom, 2.5 bath custom home featuring a large kitchen with oak cabinets, a Subzero Refrigerator and Freezer, double oven, gas range, and both tile and granite countertops. The family room has vaulted ceilings, a fireplace, and wood flooring. The Primary Bedroom also boasts vaulted ceilings, a jetted tub, separate shower, and double sinks. The home has a formal dining room, large utility room with built-in iron table, and a large, covered patio with ceiling fans throughout.The secondary 2 bedroom, 2 bath, 1,630+/- sqft. home, offers a family room, separate living room, and a 2 car garage. There's a 2 car detached garage with additional shop/office space. The property also includes a young almond ranch (Shasta variety almond), an 2,052+/- sqft. shop building, and a pole barn for equipment. There's a new Ag Well and an updated Domestic Well with a new holding tank and filters. The land is part of the Fresno Irrigation Distirict and receives surfact water from the district.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2001
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$641
Price Per Acre
$96,515
Days On London
130
Cumulative Days On London
130
County
Fresno
Special Features
Isolated Bedroom
REO / Bank Owned
No
Cross Street Address
West Ave
Directions
From Elm Ave., go west onto Lincoln Ave. and subject property is on the northwest corner of Lincoln Ave. and West Ave.
Style
Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room
Roofing
Tile
Foundation
Concrete
Detached Structures
Shop
Kitchen
Built In Range/Oven, Disposal, Dishwasher, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1710000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1890000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2560 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3060 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` = 1728351 OR `props-main`.`id` = 1731672 OR `props-main`.`id` = 1704338)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642803' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-05' 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 3 weeks ago Fresno MLS last checked for updates 1 minute 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.
