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 pantryideal 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.
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
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) >= 741000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 819000 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` = 1702364 OR `props-main`.`id` = 144493 OR `props-main`.`id` = 1664241 OR `props-main`.`id` = 1700384 OR `props-main`.`id` = 1667973 OR `props-main`.`id` = 1687773 OR `props-main`.`id` = 1622799 OR `props-main`.`id` = 1687772 OR `props-main`.`id` = 1695615 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1688095 OR `props-main`.`id` = 1701652 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1702505 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1693749 OR `props-main`.`id` = 1693818 OR `props-main`.`id` = 1646767 OR `props-main`.`id` = 1700256 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1697488 OR `props-main`.`id` = 1698910 OR `props-main`.`id` = 1702939 OR `props-main`.`id` = 1702916 OR `props-main`.`id` = 1702920 OR `props-main`.`id` = 1703285 OR `props-main`.`id` = 1697930 OR `props-main`.`id` = 1690931 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1701745 OR `props-main`.`id` = 1701484 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1693840 OR `props-main`.`id` = 1696012 OR `props-main`.`id` = 1699137 OR `props-main`.`id` = 1699134 OR `props-main`.`id` = 1702022 OR `props-main`.`id` = 1702025 OR `props-main`.`id` = 1702031 OR `props-main`.`id` = 1692028 OR `props-main`.`id` = 1692023 OR `props-main`.`id` = 1695048 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1700779 OR `props-main`.`id` = 1698404 OR `props-main`.`id` = 1696912 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1702947 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1703091 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1691764 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1700943 OR `props-main`.`id` = 1701001 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 1694839 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 1701023 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1702986 OR `props-main`.`id` = 1690469 OR `props-main`.`id` = 1700654 OR `props-main`.`id` = 1690474 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1702915 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 101784)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226005731' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-17' 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 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.
