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/644313/4847-S-Greenwood-Ave/Del-Rey/https://www.londonproperties.com/images/props/fresno/full/644313.jpgLondon Properties Del Rey Real Estate | 4847 S Greenwood Ave
Rare opportunity to own a beautiful country retreat just minutes from the city of Sanger! Enjoy the perfect balance of privacy, space, and convenience on over 2 acres of land with endless possibilities. This spacious ranch-style home offers over 2,200 sq. ft. of comfortable living space, ideal for a growing family or those who love to entertain. The newer remodeled kitchen features a newer cooktop (only 4 months old), making it both stylish and functional for everyday living and gatherings.
The property is fully electric, allowing you to maximize the benefits of the solar system. A newer A/C unit (approximately 4 years old) adds peace of mind and energy efficiency. Outside, you'll find plenty of room for RV parking, recreational toys, summer barbecues, and future expansion. The large shop in the back provides excellent space for storage, hobbies, or a potential workspace.
If you've been looking for country living with city convenience, this is the one you've been waiting for.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1956
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$265
Price Per Acre
$265,465
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
American Ave
Directions
Property is on Greenwood Ave., Between American Ave. & Central Ave.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 569952.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 629947.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2018 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2518 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` = 1704991 OR `props-main`.`id` = 1704994 OR `props-main`.`id` = 1698198 OR `props-main`.`id` = 1711302 OR `props-main`.`id` = 1693424 OR `props-main`.`id` = 1693425 OR `props-main`.`id` = 1684982 OR `props-main`.`id` = 1694468 OR `props-main`.`id` = 1684978 OR `props-main`.`id` = 1710272 OR `props-main`.`id` = 1707153 OR `props-main`.`id` = 1708073 OR `props-main`.`id` = 1700118 OR `props-main`.`id` = 63187 OR `props-main`.`id` = 224353)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644313' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 Nelson Garibay, London Properties-Kingsburg - [email protected] Last modified 3 hours ago Fresno MLS last checked for updates 7 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.
