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/metrolist/226005731/2590-N-Gurr-Rd/Atwater/https://www.londonproperties.com/images/props/metrolist/full/226005731.jpgLondon Properties Atwater Real Estate | 2590 N Gurr Rd
Welcome to this beautiful 2,724 sq. ft. custom home on 1.33 acres in the desirable McSwain area. This property offers 4 bedrooms and 3 full bathrooms, including a spacious primary suite with dual walk-in closets, a jetted soaking tub, walk-in shower, and private fireplace. The open-concept living area features a wood-burning fireplace and flows seamlessly into the dining area and kitchen, complete with a large island, double ovens, and a walk-in pantry, ideal for entertaining. Additional highlights include an indoor laundry room, an attached 3-car covered carport with extra storage, and expansive outdoor space. Enjoy peaceful country living with the convenience of being close to town, top-rated schools, and modern amenities. Now back on the market at no fault of the seller, this is your second chance to make it yours.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Custom, Ranchette/Country
Year Built
1971
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Levels
One
Pets Allowed
Yes
Home Warranty
No
Directions to Property
From 99 take Buhach to SP Ave, turn onto Gurr Rd. Home is on the left.
Cross Street
SP Ave
County
Merced
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Primary Bedroom, Full Bath(s), Kitchen, Street Entrance
Construction Materials
Wood, Wood Siding
Foundation
Raised
Roof
Composition
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central
Laundry Features
Cabinets, Sink, Hookups Only, Inside Room
Window Features
Bay Window(s)
Other Structures
Workshop
Interior Features
Storage Area(s)
Full Bathrooms
3
Bath Features
Tub w/Shower Over
# of Fireplaces
2
Fireplace Features
Brick, Living Room, Primary Bedroom, Wood Burning, Gas Log
Flooring
Carpet, Linoleum
Appliances
Built-In Electric Oven, Dishwasher, Disposal, Microwave, Double Oven, Electric Cook Top
Room Type
Primary Bedrooms 2+, Kitchen, Laundry, Workshop, Living Room
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 707750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 782250 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) >= 2474 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2974 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` = 221849 OR `props-main`.`id` = 1713477 OR `props-main`.`id` = 1702364 OR `props-main`.`id` = 144493 OR `props-main`.`id` = 1713337 OR `props-main`.`id` = 1713468 OR `props-main`.`id` = 1713597 OR `props-main`.`id` = 1667973 OR `props-main`.`id` = 1687773 OR `props-main`.`id` = 1622799 OR `props-main`.`id` = 1687772 OR `props-main`.`id` = 1720591 OR `props-main`.`id` = 1721685 OR `props-main`.`id` = 1718576 OR `props-main`.`id` = 1695615 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1715691 OR `props-main`.`id` = 1716876 OR `props-main`.`id` = 1716882 OR `props-main`.`id` = 1717810 OR `props-main`.`id` = 1717805 OR `props-main`.`id` = 1716863 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1646767 OR `props-main`.`id` = 1714099 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1697488 OR `props-main`.`id` = 1705931 OR `props-main`.`id` = 1702939 OR `props-main`.`id` = 1702920 OR `props-main`.`id` = 1714627 OR `props-main`.`id` = 1722199 OR `props-main`.`id` = 1697930 OR `props-main`.`id` = 1722212 OR `props-main`.`id` = 1706801 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1717756 OR `props-main`.`id` = 1717748 OR `props-main`.`id` = 1701745 OR `props-main`.`id` = 1701484 OR `props-main`.`id` = 1720609 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 1721761 OR `props-main`.`id` = 1717679 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 1721950 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1714061 OR `props-main`.`id` = 1698404 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1714734 OR `props-main`.`id` = 1714733 OR `props-main`.`id` = 1705804 OR `props-main`.`id` = 1707152 OR `props-main`.`id` = 1705917 OR `props-main`.`id` = 1705889 OR `props-main`.`id` = 1707126 OR `props-main`.`id` = 1707154 OR `props-main`.`id` = 1705043 OR `props-main`.`id` = 1704605 OR `props-main`.`id` = 1722015 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1690469 OR `props-main`.`id` = 1714402 OR `props-main`.`id` = 1690474 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1719235 OR `props-main`.`id` = 1720707 OR `props-main`.`id` = 1720899 OR `props-main`.`id` = 1719056 OR `props-main`.`id` = 1717369 OR `props-main`.`id` = 1722132 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1717379 OR `props-main`.`id` = 101784)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226005731' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-16' 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();
1
Similar Properties
$745,000
4
3
2,724
1.33
2590 N Gurr Rd
Atwater, CA 95301
Courtesy of Cassidy Sousa, Sousa Realty Group, Inc. IDX provided by Reliance Marketing
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.
