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/crmls/MC26029301/5995-W-BROOKS-RD/Merced/https://www.londonproperties.com/images/props/crmls/full/MC26029301.jpgLondon Properties Merced Real Estate | 5995 W. BROOKS RD
Listing Agent: John Ballard, ELM Realty and Property Mgmt. Inc.
PEACEFUL COUNTRY LIVING IN THE HIGHLY DESIRED McSWAIN DISTRICT. 5BED 4BA WITH HUGE COVERED PATIO FOR ENTERTAINING PERFECT FOR LARGE FAMILIES. OPEN LIVING FLOOR PLAN WITH IMMACULANT UPDATED KITCHEN. *FLOOR PLAN PHOTOS PROVIDED BY CUBI CASA; MEASUREMENTS DEEMED RELIABLE BUT NOT GUARANTEED
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1956
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
GROUND
Price Per Square Foot
$196
Days On London
15
Cumulative Days On London
15
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Directions
140 TO SOUTH BUHACH THEN RIGHT ON W. BROOKS RD
Room Type
All Bedrooms Down, Main Floor Primary Bedroom
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside
Main Level Bedrooms
5
Bathrooms Full
4
Bathrooms Full And Three Quarter
4
Main Level Bathrooms
4
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
Private, In Ground
Pool Private Y/N
Yes
Water Source
Well
Sewer
Private Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
0-1 Unit/Acre
Lot Size Area
25464.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Canal
Common Interest
None
Parcel Number
215121001000
Additional Parcels Y/N
No
Community Features
Rural
Senior Community Y/N
No
Association Y/N
No
High School District
Merced Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 664905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 734895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3315 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3815 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` = 1706971 OR `props-main`.`id` = 1701847 OR `props-main`.`id` = 274199 OR `props-main`.`id` = 1691442 OR `props-main`.`id` = 1710680 OR `props-main`.`id` = 1691451 OR `props-main`.`id` = 1710677 OR `props-main`.`id` = 1691448 OR `props-main`.`id` = 1691439 OR `props-main`.`id` = 1691443 OR `props-main`.`id` = 1691452 OR `props-main`.`id` = 1710679 OR `props-main`.`id` = 221849 OR `props-main`.`id` = 1622825 OR `props-main`.`id` = 1702364 OR `props-main`.`id` = 144493 OR `props-main`.`id` = 1664241 OR `props-main`.`id` = 1710416 OR `props-main`.`id` = 236633 OR `props-main`.`id` = 1667973 OR `props-main`.`id` = 1687773 OR `props-main`.`id` = 1622799 OR `props-main`.`id` = 1687772 OR `props-main`.`id` = 1710239)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26029301' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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
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.
