Beautiful 4-bedroom, 3-bath home situated on a large cul-de-sac lot in close proximity to schools. Thoughtfully designed floor plan featuring a downstairs bedroom and full bath, along with formal living and dining rooms perfect for entertaining. Spacious open and updated kitchen includes an eating area, built-in desk space, and overlooks the inviting family room with cozy fireplace and access to the backyard. Upstairs offers two additional guest bedrooms, full bath, convenient laundry room, and a spacious owner's suite complete with walk-in closet. Separate third-car garage offers excellent potential for a multi-generational living space, home office, or workshop. Backyard features extra concrete work, storage shed, ample grassy area, and plenty of room to relax or entertain.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2005
Region
Urban
# of Stories
Two
Price Per Square Foot
$212
Price Per Acre
$2,724,796
Days On London
20
Cumulative Days On London
20
County
Fresno
Reports Available
NHD
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
Bethel & Annadale
Directions
Please use GPS
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, On Upper Level
Roofing
Tile
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
Dining Room Features
Formal, Family Room/Area
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower, Tub
Extra Rooms
Family Room
Flooring
Carpet, Tile
# of Fireplaces
1
Fireplace Type
Masonry
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Covered, Uncovered, Concrete
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 570000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 630000 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) >= 2586 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3086 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` = 1693424 OR `props-main`.`id` = 1693425 OR `props-main`.`id` = 1684982 OR `props-main`.`id` = 1722920 OR `props-main`.`id` = 1694468 OR `props-main`.`id` = 1684978 OR `props-main`.`id` = 1724146 OR `props-main`.`id` = 63187 OR `props-main`.`id` = 224353 OR `props-main`.`id` = 1720651 OR `props-main`.`id` = 1713289 OR `props-main`.`id` = 1728797 OR `props-main`.`id` = 1732305 OR `props-main`.`id` = 1719853 OR `props-main`.`id` = 1727804 OR `props-main`.`id` = 1720823 OR `props-main`.`id` = 1717930 OR `props-main`.`id` = 1695260 OR `props-main`.`id` = 1726910 OR `props-main`.`id` = 1729320 OR `props-main`.`id` = 1728664 OR `props-main`.`id` = 1713583 OR `props-main`.`id` = 1717365 OR `props-main`.`id` = 1717366 OR `props-main`.`id` = 1724747 OR `props-main`.`id` = 1717346 OR `props-main`.`id` = 1701454 OR `props-main`.`id` = 1718252 OR `props-main`.`id` = 994639 OR `props-main`.`id` = 1726629 OR `props-main`.`id` = 1713858 OR `props-main`.`id` = 1716600 OR `props-main`.`id` = 1722165 OR `props-main`.`id` = 1726040 OR `props-main`.`id` = 1724543 OR `props-main`.`id` = 1730797 OR `props-main`.`id` = 1702895 OR `props-main`.`id` = 1702893 OR `props-main`.`id` = 1728629 OR `props-main`.`id` = 1726048 OR `props-main`.`id` = 1726871 OR `props-main`.`id` = 1712402 OR `props-main`.`id` = 1722751)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648819' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-03' 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 4 days ago Fresno MLS last checked for updates 20 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.
