London Properties Raymond Real Estate

userID = NADA user_id = NADA alreadySaidHowdy = 0 userFirstName = NADA userLastName = NADA userName = NADA userStreetAddy = NADA userCity = NADA userState = NADA userZip = NADA userPhoneMobile = NADA userPhoneOther = NADA userEmail = NADA userEmailB = NADA userIsAdmin = 0 userIsMLS = 0 daAgentSiteLink = GETagent_SetABC = 10564 siteAgentID = 10564 siteAgentName = katie-miller propsearchcriteria = Array daHomePageUhDisSite = https://www.mountainmadam.com/agent/10564/katie-miller/ siteAgentContentDirectory = katiemiller-10564 agentLinkText = agent/10564/katie-miller/ findDaAgentInfoSQL_SetAB = SELECT * FROM `lpdotcom`.`users` WHERE `id` = '10564' siteAgentFirstName = Katie siteAgentLastName = Miller siteAgentJoint = 0 siteAgentJointIDs = siteAgentTitle = REALTOR^® siteAgentPhone = 5597608867 siteAgentLicNum = 01859458 siteAgentEmail = kmiller@londonproperties.com siteAgentSiteLevel = 3 siteAgentSiteLayout = a siteAgentOfficeIds = 6 siteAgentOfficesString = siteAgentImageOfficesString = privacyPolicyName = Katie Miller, REALTOR^® siteAgentPic = https://www.mountainmadam.com/agent/pics-new/katiemiller-10564.jpg layoutPrefix = notreallycustom_custom_jm-a apiKey = katiemiller-10564 fbPixel = katiemiller-10564 fb_chat = katiemiller-10564 yahooPixel = katiemiller-10564 yahooRetarget = katiemiller-10564 instawidge = katiemiller-10564 buyerzguide = katiemiller-10564 sellerzguide = katiemiller-10564 layoutfile = notreallycustom_custom_jm-a/notreallycustom_custom_jm-a.php chosenlayoutfileMethod = E layoutcss = notreallycustom_custom_jm-a/notreallycustom_custom_jm-a.css emailcss = notreallycustom_custom_jm-a.php siteAgentBGPU = 0 siteAgentOHPU = 0 siteAgentHideOH = 0 findDaSiteID_SetD = SELECT `id`,`layout_agent_id` FROM `lpdotcom`.`sites` WHERE `agent_id` = '10564' siteID = 3089 aboutPageID = 4083 findDaAgentInfoSQL_SetEF = SELECT * FROM `lpdotcom`.`users` WHERE `id` = '10564' daLayoutFile3 = /var/www2/layouts/katiemiller-10564/katiemiller-10564.php thisAgentSiteID = NADA userCanEditSite = 0 userCanEditMenus = 0 isLegitClient = 0 therebeSearches = 0 therebeProperties = 0 agentloggedin = 0 propsearchsettings = Array

37876 Road 600

Raymond, CA 93653

Copy Link Get Directions

Photo Gallery

$429,000

3 bd

2 ba

1,874 sq ft

35.44 acres

37876 Road 600

Raymond, CA 93653

Get Directions

Listed On: 07/25/2025

Status: Active

Listing Number: 634184 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

Katie Miller 559.760.8867 Email Agent

Property Description

Sunset views for days and possibilities as wide as the sky!This country spread comes with room to breathe, privacy to treasure, and a canvas ready for your personal touch. The main ranch-style home serves up 3 bedrooms, 2 baths, an enclosed porch, and vintage character just waiting for a refresh. Bonus? A second mobile home with its own driveway--perfect for guests, projects, or that independent streak.On the land, you'll find an old orchard (yes, grapes!), a barn that's game for animals or hobbies, two water tanks (one for each home), and former ponds with comeback potential. Word on the mountain is there's even a hidden spring nearby.It's not polished yet, but the bones are solid and the payoff is big: a rare chance to create your one-of-a-kind retreat where every evening ends with a front-row seat to the sunset. Bring your vision--this one's ready to glow up. 🌅

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

1978

Region

Rural

# of Stories

Single Story

Price Per Square Foot

$229

Price Per Acre

$12,105

Days On Market

Cumulative Days On Market

County

Madera

REO / Bank Owned

Cross Street Address

Highway 49

Directions

Highway 41 to Highway 49, turn left onto Road 600, go for 7.7 miles property on the right.

Style

Ranch

Heating & Cooling

Central Heating

Laundry

Inside

Roofing

Composition

Foundation

Concrete

Detached Structures

Shop, Barn

Kitchen

Electric Appliances, Disposal, Dishwasher, Microwave

Primary Bedroom Level

Main

# of Fireplaces

Fireplace Type

Wood Insert

Exterior

Wood

Pool

Spa

Yes

Spa Type

Above Ground

Patio Features

Other

Gas & Electric

Public Utilities, Propane

Sewer / Water

Septic Tank, Private Well

Solar

Parking Features

Carport, Work/Shop Area

Garage Type

Attached

Garage Spaces

Carport Spaces

Site Amenities

Other

APN

053 091 029 000

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

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 407550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 450450 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) >= 1624 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2124 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` = 1677143 OR `props-main`.`id` = 1677161 OR `props-main`.`id` = 1664559 OR `props-main`.`id` = 1666414 OR `props-main`.`id` = 1655109)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno634184' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-28' 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();

Courtesy of Katie Miller, London Properties, Ltd. - kmiller@londonproperties.com
Last modified 2 days ago
Fresno MLS last checked for updates 50 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.

Home

Buying

Selling

Community Links

About

Contact

559.760.8867

Get More Info

Print A Flyer

Get A Home Loan

Share

37876 Road 600

Raymond, CA 93653

Photo Gallery

$429,000

37876 Road 600

Raymond, CA 93653

Schedule a Tour

Contact Info

Presented By:

Home

Buying

Selling

Community Links

About

Contact

559.760.8867

Get More Info

Print A Flyer

Get A Home Loan

Share

37876 Road 600

Raymond, CA 93653

Photo Gallery

$429,000

37876 Road 600

Raymond, CA 93653

Schedule a Tour

Contact Info

Presented By:

Loading...

Saving...

Deleting...

Searching...