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/634509/38289-Road-415/Raymond/https://www.londonproperties.com/images/props/fresno/full/634509.jpgLondon Properties Raymond Real Estate | 38289 Road 415
Nestled on 48.8 acres of picturesque countryside, this diamond in the rough is the deal of the year for those seeking a fixer-upper with incredible potential. The property boasts a private pond, perfect for fishing or watering livestock, and is fully equipped to support up to 70 cows. The main home, built in 1920, is a 3-bedroom, 2-bathroom farmhouse in need of renovation, offering 1,588 square feet of rustic charm ready for a transformation. Additionally, a mobile home on-site requires significant repairs, presenting an opportunity for extra living space or rental income. With the right vision, this could be a fantastic flip or the foundation for your dream homestead. Don't miss out on this rare opportunity
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1920
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$295
Price Per Acre
$9,611
Days On Market
121
Cumulative Days On Market
216
County
Madera
REO / Bank Owned
No
Cross Street Address
Road 603 to Raymond Rd
Directions
99 South, Take CA-233/Robertson Blvd, Turn left on Robertson, Turn right on Road 29, Left on Road 603, Left on Raymond Rd.
Heating & Cooling
Central Heat & Cool, Window or Wall A/C
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Lower
# of Fireplaces
1
Fireplace Type
Wood Insert
Exterior
Other
Pool
No
Pool
No
Yard
Fenced
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Septic Tank, Private Well
Solar
No
Parking Features
Existing RV Parking
APN
054 030 013 000
School District
Madera Unified
School Type 1
High School
School Name 1
Madera
School Type 2
Junior High School
School Name 2
Martin Luther King
School Type 3
Grade School
School Name 3
Madison
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 445550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 492450 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) >= 1338 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1838 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` = 1691998 OR `props-main`.`id` = 1677613 OR `props-main`.`id` = 1677659 OR `props-main`.`id` = 1660361 OR `props-main`.`id` = 1691995 OR `props-main`.`id` = 1686864 OR `props-main`.`id` = 1686865 OR `props-main`.`id` = 1687555)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno634509' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-15' 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 Kris Klair, EXIT Realty Consultants - [email protected] Last modified 4 months ago Fresno MLS last checked for updates 33 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.
