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/646866/2004-S-Renn-Ave/Fresno/Sunnyside/https://www.londonproperties.com/images/props/fresno/full/646866.jpgLondon Properties Fresno Real Estate | 2004 S Renn Ave
Beautiful custom home on a large Sunnyside lot of .41 acres. This home is near the historic Sunnyside Golf and Country Club. It's a secluded neighborhood, yet a convenient location as it is about a mile away from the 180 Freeway and Fresno's newest major shopping center. This one level home was custom built and even the interior walls are insulated. Lots of upgrades has made this home fresh and modern. All the rooms are spacious and light, bright and airy. There is a separate living room and family room. The kitchen opens to the family room with a big granite breakfast bar. All three bedrooms have an ensuite bathroom. This home has been modernized with dual pane windows, a presidential roof, fresh paint and flooring and its in spotless condition. Check out the photos for a more detailed description.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1970
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$242
Price Per Acre
$1,512,585
Days On London
0
Cumulative Days On London
0
County
Fresno
Special Features
Built In Cabinets, Skylight
REO / Bank Owned
No
Cross Street Address
S/Butler, W/Fowler
Directions
From Butler and Fowler go south on Fowler then turn right onto Dwight and then turn right onto Renn.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Kitchen
Gas Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar, Pantry
Dining Room Features
Family Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Extra Rooms
Family Room
Disabled Features
One Level Floor
Flooring
Carpet, Laminate, Tile
# of Fireplaces
2
Fireplace Type
Gas Insert, Wood Insert
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Patio Features
Covered, Concrete
Yard
Sprinklers Auto, Fenced, Mature Landscape, Garden Area
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Septic Tank
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Existing RV Parking, Work/Shop Area, Auto Opener, Circular Driveway
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 593750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 656250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2333 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2833 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` = 1715491 OR `props-main`.`id` = 1713129 OR `props-main`.`id` = 1665721 OR `props-main`.`id` = 1720769 OR `props-main`.`id` = 1720796 OR `props-main`.`id` = 1704972 OR `props-main`.`id` = 1721087 OR `props-main`.`id` = 168045 OR `props-main`.`id` = 1709148 OR `props-main`.`id` = 1719053 OR `props-main`.`id` = 1720600 OR `props-main`.`id` = 1702572 OR `props-main`.`id` = 1721154 OR `props-main`.`id` = 1711226 OR `props-main`.`id` = 1719675 OR `props-main`.`id` = 1713809 OR `props-main`.`id` = 1712532 OR `props-main`.`id` = 1718569 OR `props-main`.`id` = 1718570 OR `props-main`.`id` = 1720802 OR `props-main`.`id` = 1720706 OR `props-main`.`id` = 1720694 OR `props-main`.`id` = 1720704 OR `props-main`.`id` = 1695956 OR `props-main`.`id` = 1690285 OR `props-main`.`id` = 1715480 OR `props-main`.`id` = 1694333 OR `props-main`.`id` = 1664666 OR `props-main`.`id` = 1721088 OR `props-main`.`id` = 1667622 OR `props-main`.`id` = 1719840 OR `props-main`.`id` = 1710189 OR `props-main`.`id` = 1703969 OR `props-main`.`id` = 1721136 OR `props-main`.`id` = 1721158 OR `props-main`.`id` = 1715576 OR `props-main`.`id` = 1703463 OR `props-main`.`id` = 1713351 OR `props-main`.`id` = 1707115 OR `props-main`.`id` = 1717023 OR `props-main`.`id` = 1717019 OR `props-main`.`id` = 1697805 OR `props-main`.`id` = 1712965 OR `props-main`.`id` = 735701 OR `props-main`.`id` = 1715922 OR `props-main`.`id` = 1646681 OR `props-main`.`id` = 1709869 OR `props-main`.`id` = 1720297 OR `props-main`.`id` = 165776 OR `props-main`.`id` = 1708358 OR `props-main`.`id` = 1710115 OR `props-main`.`id` = 1713569 OR `props-main`.`id` = 1719658 OR `props-main`.`id` = 1696750 OR `props-main`.`id` = 1719715 OR `props-main`.`id` = 1718830 OR `props-main`.`id` = 1717710 OR `props-main`.`id` = 1711090 OR `props-main`.`id` = 1715966 OR `props-main`.`id` = 1718652 OR `props-main`.`id` = 1716178 OR `props-main`.`id` = 839521 OR `props-main`.`id` = 1719766 OR `props-main`.`id` = 1716187 OR `props-main`.`id` = 1695731 OR `props-main`.`id` = 1719747 OR `props-main`.`id` = 1705942 OR `props-main`.`id` = 1717782 OR `props-main`.`id` = 1701796 OR `props-main`.`id` = 1704514 OR `props-main`.`id` = 1709931 OR `props-main`.`id` = 1703929 OR `props-main`.`id` = 1717899 OR `props-main`.`id` = 1718662 OR `props-main`.`id` = 1703763 OR `props-main`.`id` = 1696453 OR `props-main`.`id` = 1705930 OR `props-main`.`id` = 1702954 OR `props-main`.`id` = 1702982 OR `props-main`.`id` = 1702961)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646866' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-10' 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();
1
Similar Properties
$627,999
4
3
2,544
0.45
5867 E Club View
Fresno, CA 93727
Courtesy of Don Scordino, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 4 hours ago Fresno MLS last checked for updates 11 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.
