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/651187/7049-N-Cedar-Hill-Dr/Fresno/Bullard-High/https://www.londonproperties.com/images/props/fresno/full/651187.jpgLondon Properties Fresno Real Estate | 7049 N Cedar Hill Dr
This outstanding home was a McCaffrey former model at Liberty Square and has been beautifully maintained by the present owner as a model home too! The setting for this property is across the street from the gated community with all the nice amenities the HOA has to offer. The courtyard entry with stunning plantings and stoned flagstone bricks brings the outdoors to you for your enjoyment and relaxation as a lovely sitting area and an entry to your new home. The well designed downstairs living area has lovely tiled patterned floors, can lighting, ceiling fan, and side door access. All of this opens to a beautiful designer kitchen with an eating bar with stunning pendant lighting, quartz countertops with well designed backsplash with under counter lighting on dimmers, gas cooktop stove, microwave, dishwasher, very roomy walk in pantry with convenient pull out shelving and a very spacious dining area adjacent to the outside sliding doors. Additional touches include a barn door accent piece and a half bath with inviting design and touches that create such a welcoming touch. Enjoy all the shutters throughout and lovely woven woods too. The open well designed floor plan features 3 bedrooms (per tax records with one living area being used as a loft with shelving that can easily be walled for more privacy etc. and 2.5 bathrooms. The entire home is very well coordinated with endless decorative design and features that you will love. The primary bedroom has a fabulous featured wall and its own designer bathroom with double sinks, with quartz countertops and an extra counter space, privacy toilet area and outstanding bamboo look tiled walls in bathroom and shower area. You will enjoy the huge walk in closet. Another bedroom features lovely decorative paint and crown molding plus the hall bathroom with a shower and a tub, and quartz counters are well coordinated like every room in this fabulous home. For additional living space enjoy the beautiful backyard with its own gas fireplace, concrete block fence, outstanding landscaping with shrubberies, hedges and artificial turf, a pergola for a lovely addition to the setting, and a spa that is negotiable. As you view this lovely home you will thoroughly enjoy all the decorative designer touches waiting for your eyes to appreciate. In addition this listing has whole home air circulation for your good health. This convenient location has a wonderful park ,walking trails, freeway access, shopping and dining close by.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2015
Region
Urban
# of Stories
Two
Price Per Square Foot
$288
Price Per Acre
$6,047,715
Days On London
0
Cumulative Days On London
0
County
Fresno
Leased Equipment
Solar Panels
Special Features
Security System, Other/See Remarks
REO / Bank Owned
No
Cross Street Address
N/Herndon, E/Hayes
Directions
Traveling West on Herndon Turn Right (North) on Hayes to Caldwell Drive Turn East/ Right and then turn Left North to your new home on the left side.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, On Upper Level, Gas Hook Up
Roofing
Tile
Foundation
Both
Kitchen
F/S Range/Oven, Gas Appliances, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator
Dining Room Features
Living Room/Area
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower
Flooring
Carpet, Tile
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
No
Patio Features
Covered, Concrete, Stone, Other
Yard
Fenced, Mature Landscape, Fruit/Nut Trees, Synthetic Lawn, Drip System
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427452.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472447.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1310 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1810 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` = 1729354 OR `props-main`.`id` = 1721346 OR `props-main`.`id` = 1665855 OR `props-main`.`id` = 1726922 OR `props-main`.`id` = 1726942 OR `props-main`.`id` = 1741399 OR `props-main`.`id` = 166957 OR `props-main`.`id` = 1717545 OR `props-main`.`id` = 1732701 OR `props-main`.`id` = 1732728 OR `props-main`.`id` = 1728444 OR `props-main`.`id` = 1725573 OR `props-main`.`id` = 1739363 OR `props-main`.`id` = 1730932 OR `props-main`.`id` = 1723712 OR `props-main`.`id` = 1738648 OR `props-main`.`id` = 1729001 OR `props-main`.`id` = 1728643 OR `props-main`.`id` = 1725168 OR `props-main`.`id` = 1740608 OR `props-main`.`id` = 1727713 OR `props-main`.`id` = 1726282 OR `props-main`.`id` = 1742152 OR `props-main`.`id` = 1720289 OR `props-main`.`id` = 1729028 OR `props-main`.`id` = 1727320 OR `props-main`.`id` = 1704376 OR `props-main`.`id` = 1728517 OR `props-main`.`id` = 1723723 OR `props-main`.`id` = 1721722 OR `props-main`.`id` = 1732898 OR `props-main`.`id` = 1742149 OR `props-main`.`id` = 1725666 OR `props-main`.`id` = 1728439 OR `props-main`.`id` = 1741767 OR `props-main`.`id` = 1741525 OR `props-main`.`id` = 1741759 OR `props-main`.`id` = 1713827 OR `props-main`.`id` = 1698794 OR `props-main`.`id` = 1722414 OR `props-main`.`id` = 1734161 OR `props-main`.`id` = 166342 OR `props-main`.`id` = 1728609 OR `props-main`.`id` = 1740677 OR `props-main`.`id` = 1735579 OR `props-main`.`id` = 1736673 OR `props-main`.`id` = 1731930 OR `props-main`.`id` = 1704032 OR `props-main`.`id` = 1265238 OR `props-main`.`id` = 1704718 OR `props-main`.`id` = 1709253 OR `props-main`.`id` = 1742100 OR `props-main`.`id` = 1727523 OR `props-main`.`id` = 1734685 OR `props-main`.`id` = 1724330 OR `props-main`.`id` = 1703160 OR `props-main`.`id` = 1728743 OR `props-main`.`id` = 272846 OR `props-main`.`id` = 1743995 OR `props-main`.`id` = 1743933 OR `props-main`.`id` = 1727148 OR `props-main`.`id` = 1708477 OR `props-main`.`id` = 187711 OR `props-main`.`id` = 1717341 OR `props-main`.`id` = 1741846 OR `props-main`.`id` = 1729256 OR `props-main`.`id` = 1726877 OR `props-main`.`id` = 1718388 OR `props-main`.`id` = 1718764 OR `props-main`.`id` = 1731168 OR `props-main`.`id` = 1719319 OR `props-main`.`id` = 1724837 OR `props-main`.`id` = 1732338 OR `props-main`.`id` = 231417 OR `props-main`.`id` = 258175 OR `props-main`.`id` = 1732336 OR `props-main`.`id` = 1743374 OR `props-main`.`id` = 1728201 OR `props-main`.`id` = 1731112 OR `props-main`.`id` = 1743247 OR `props-main`.`id` = 1738644 OR `props-main`.`id` = 1743478 OR `props-main`.`id` = 1743575 OR `props-main`.`id` = 1721465 OR `props-main`.`id` = 1717593 OR `props-main`.`id` = 1728419 OR `props-main`.`id` = 1743451 OR `props-main`.`id` = 1742775 OR `props-main`.`id` = 256897 OR `props-main`.`id` = 1726564)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651187' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-29' 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();
4
Similar Properties
$469,000
3
3
1,659
0.15
7440 N Wheeler N
Fresno, CA 93722
$440,000
3
2.75
1,568
0.11
5569 W Stuart
Fresno, CA 93722
$435,000
3
3
1,472
0.10
4161 W Fremont Ave
Fresno, CA 93722
$430,000
4
3
1,617
0.20
6249 W Dovewood
Fresno, CA 93723
Last modified 2 hours ago Fresno MLS last checked for updates 9 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.
