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/640341/33099-Road-800/Raymond/https://www.londonproperties.com/images/props/fresno/full/640341.jpgLondon Properties Raymond Real Estate | 33099 Road 800
Exquisite Custom Home! A one of a kind from top to bottom that is a real showpiece w/great thought & care in the design & use of materials throughout. From the gated entry to the grand entry w/a circular staircase leading to the primary suite, there is so much to see in this home. Acacia floors throughout w/sealed aggregate flooring in the kitchen & BAs for easy clean up. A very lg. gorgeous kitchen w/an island for eating or just chatting w/friends while you cook those scrumptious meals, makes for a fun time entertaining friends or family. A step-down living room & propane fireplace add an air of comfort w/the design, all while having easy access to the formal dining room & kitchen. As you stroll down the hall you will come to the other BDs, BAs & the oversized game/family room w/plenty of room for a pool table, bar, or dance studio space. Just let your imagination run wild. Be sure to go up to the primary suite & stroll out to the oversized partially covered patio to sit & relax or add a private spa there. The primary BA is very spacious & the huge walk-in closet that feels like it just keeps going. As you look over this 2.51+/- acre property, you will see the land is all usable, fenced, cross-fenced w/chicken coops, storage building, lg. gazebo on the back side of the home w/built-in barbecue & so much more. Tankless water system, wired for generator, security system, built-in wall safe & cameras & oversized garage w/additional 10x13 workspace.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2013
Region
Foothill
# of Stories
Two
Price Per Square Foot
$239
Price Per Acre
$354,183
Days On Market
38
Cumulative Days On Market
38
County
Madera
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, Built In Cabinets, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Road 613
Directions
Road 600 to Road 613 to Road 800 to sign.
Unit Description
Split Level
Heating & Cooling
Central Heating, Central Cooling
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
Gas Appliances, Dishwasher, Eating Area, Pantry, Other
Dining Room Features
Formal
Primary Bedroom Level
Upper
Bath Features
Shower, Tub
Extra Rooms
Great Room, Game Room, Other
Flooring
Tile, Hardwood
# of Fireplaces
1
Exterior
Stucco, Stone
Pool
No
Pool
No
Spa
No
Patio Features
Covered, Uncovered, Concrete, Other
Yard
Fenced
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Septic Tank
Solar
No
Parking Features
Work/Shop Area, Other
Garage Type
Attached
Garage Spaces
4
APN
053 320 027 000
Zoning
RMS
School District
Raymond Knowles
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Raymond Knowles
School Type 3
Grade School
School Name 3
Raymond Knowles
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 844550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 933450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3466 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3966 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` = 1677683 OR `props-main`.`id` = 1677646 OR `props-main`.`id` = 1686413 OR `props-main`.`id` = 1686416 OR `props-main`.`id` = 1687779 OR `props-main`.`id` = 1698957 OR `props-main`.`id` = 1666124 OR `props-main`.`id` = 1687609 OR `props-main`.`id` = 1666219 OR `props-main`.`id` = 1695909 OR `props-main`.`id` = 1695900 OR `props-main`.`id` = 1696851)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640341' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-30' 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 John Bortz, Century 21 Ditton Realty - [email protected] Last modified 4 hours ago Fresno MLS last checked for updates 15 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.
