Please provide the following information and Jasmin Quintana will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.quintanahomes.com/agent/19708/jasmin-quintana/property/link/fresno/647547/1261-E-Adams-Ave/Fresno/https://www.quintanahomes.com/images/props/fresno/full/647547.jpgLondon Properties Fresno Real Estate | 1261 E Adams Ave
Move in ready and set on just under one acre, this property offers the best of both worlds with a peaceful country feel while still being conveniently close to town. Fully fenced for horses or other livestock, it gives you the kind of space, privacy, and flexibility that is hard to find. From the moment you arrive, the beautiful landscaping and open layout create a setting that feels welcoming, comfortable, and full of potential.Inside, you'll find an open floor plan with an updated kitchen featuring granite countertops and stainless steel appliances, along with indoor laundry and a newer roof for added peace of mind. The detached workshop adds even more versatility, whether you need extra storage, a hobby space, or room for projects. With plenty of outdoor space to enjoy and room to truly make it your own, this property delivers the lifestyle so many buyers are looking for.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1986
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$301
Price Per Acre
$483,505
Days On London
1
Cumulative Days On London
1
County
Fresno
REO / Bank Owned
No
Cross Street Address
S East and E Adams
Directions
From central Fresno, take CA 41 South and exit at Adams Avenue. Head east on Adams Avenue and continue to 1261 E Adams Ave, Fresno, CA 93725. The property will be on the right side, between South East Avenue and South Orange Avenue.
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Both
Detached Structures
Shop, Shed
Kitchen
F/S Range/Oven, Disposal, Dishwasher, Breakfast Bar
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 445550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 492450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1306 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1806 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` = 1722458 OR `props-main`.`id` = 1693416 OR `props-main`.`id` = 1694867 OR `props-main`.`id` = 1723027 OR `props-main`.`id` = 1666364 OR `props-main`.`id` = 1706155 OR `props-main`.`id` = 1688900 OR `props-main`.`id` = 1689007 OR `props-main`.`id` = 1706834 OR `props-main`.`id` = 1700823 OR `props-main`.`id` = 1697330 OR `props-main`.`id` = 1715993 OR `props-main`.`id` = 1718092 OR `props-main`.`id` = 1716341 OR `props-main`.`id` = 1716364)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647547' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-23' 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
Courtesy of Ricardo Santos, Real Broker - ricky.el.realtor@gmail.com Last modified 18 hours ago Fresno MLS last checked for updates 56 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.
