Courtesy of Barbara Thongsavat, Real Brokerage Technologies - [email protected]
Back on market with a fresh edit.467 Brimmer returns with a few beautiful updates worth noting: new carpet, new vinyl flooring, new interior paint, newer HVAC, and a brand new roof underway - courtesy of the Seller.A charming home with good bones and ready for its next chapter. Updated photos to come.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1959
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$293
Price Per Acre
$2,020,785
Days On London
53
Cumulative Days On London
53
County
Merced
REO / Bank Owned
No
Cross Street Address
Gerard/Parsons
Directions
From the major intersection of E. Childs Avenue and S. Parsons Avenue, head east on E. Childs Avenue. Turn right/south onto Brimmer Road. Continue south; 467 Brimmer Road will be on Brimmer Road.
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Main
Flooring
Carpet, Tile, Hardwood
# of Fireplaces
1
Fireplace Type
Masonry
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
061 276 008 000
School District
Merced Union
School Type 1
High School
School Name 1
Golden Valley High
School Type 2
Junior High School
School Name 2
Rivera
School Type 3
Grade School
School Name 3
Rivera
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367500 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) >= 944 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1444 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` = 1773287 OR `props-main`.`id` = 1773288 OR `props-main`.`id` = 1724910 OR `props-main`.`id` = 1771665 OR `props-main`.`id` = 1667395 OR `props-main`.`id` = 1667390 OR `props-main`.`id` = 1723303 OR `props-main`.`id` = 1773289 OR `props-main`.`id` = 1667389 OR `props-main`.`id` = 1667396 OR `props-main`.`id` = 1773286 OR `props-main`.`id` = 1773291 OR `props-main`.`id` = 1773511 OR `props-main`.`id` = 1667912 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1773294 OR `props-main`.`id` = 1773293 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1773292 OR `props-main`.`id` = 1773273 OR `props-main`.`id` = 1704658 OR `props-main`.`id` = 1762260 OR `props-main`.`id` = 1730583 OR `props-main`.`id` = 1730586 OR `props-main`.`id` = 1730692 OR `props-main`.`id` = 1774351 OR `props-main`.`id` = 1763526 OR `props-main`.`id` = 1763605 OR `props-main`.`id` = 1765079 OR `props-main`.`id` = 1765531 OR `props-main`.`id` = 1778559 OR `props-main`.`id` = 1745418 OR `props-main`.`id` = 1773331 OR `props-main`.`id` = 1709550 OR `props-main`.`id` = 1771771 OR `props-main`.`id` = 1759076 OR `props-main`.`id` = 1738341 OR `props-main`.`id` = 1747695 OR `props-main`.`id` = 1762534 OR `props-main`.`id` = 1773612 OR `props-main`.`id` = 1708287 OR `props-main`.`id` = 1773686 OR `props-main`.`id` = 1776712 OR `props-main`.`id` = 1744294 OR `props-main`.`id` = 1757619 OR `props-main`.`id` = 1757617 OR `props-main`.`id` = 1747521 OR `props-main`.`id` = 1746444 OR `props-main`.`id` = 1773367 OR `props-main`.`id` = 1702508 OR `props-main`.`id` = 1749244 OR `props-main`.`id` = 1734544 OR `props-main`.`id` = 1734533 OR `props-main`.`id` = 1746437 OR `props-main`.`id` = 1773580 OR `props-main`.`id` = 1755747 OR `props-main`.`id` = 1756050 OR `props-main`.`id` = 1753455 OR `props-main`.`id` = 1773600 OR `props-main`.`id` = 1727938 OR `props-main`.`id` = 1773832 OR `props-main`.`id` = 1771710 OR `props-main`.`id` = 1746130 OR `props-main`.`id` = 1705935 OR `props-main`.`id` = 1716724 OR `props-main`.`id` = 1749924 OR `props-main`.`id` = 196010 OR `props-main`.`id` = 1754756 OR `props-main`.`id` = 1754803 OR `props-main`.`id` = 1744437 OR `props-main`.`id` = 1756154 OR `props-main`.`id` = 1776152 OR `props-main`.`id` = 1701206 OR `props-main`.`id` = 1680643 OR `props-main`.`id` = 1773515 OR `props-main`.`id` = 1757800 OR `props-main`.`id` = 1763563 OR `props-main`.`id` = 1762261 OR `props-main`.`id` = 1760928 OR `props-main`.`id` = 1714053 OR `props-main`.`id` = 1719554 OR `props-main`.`id` = 1727779 OR `props-main`.`id` = 1719524 OR `props-main`.`id` = 1771608 OR `props-main`.`id` = 1771678 OR `props-main`.`id` = 1771701 OR `props-main`.`id` = 1701468 OR `props-main`.`id` = 1758229 OR `props-main`.`id` = 1769787 OR `props-main`.`id` = 1725968 OR `props-main`.`id` = 1734301 OR `props-main`.`id` = 1771398 OR `props-main`.`id` = 1723225 OR `props-main`.`id` = 1723794 OR `props-main`.`id` = 1740678 OR `props-main`.`id` = 1775784 OR `props-main`.`id` = 1725535 OR `props-main`.`id` = 1725536 OR `props-main`.`id` = 1041230 OR `props-main`.`id` = 1760812 OR `props-main`.`id` = 1741942 OR `props-main`.`id` = 1756128 OR `props-main`.`id` = 1706026 OR `props-main`.`id` = 1767855 OR `props-main`.`id` = 1775882 OR `props-main`.`id` = 1775886 OR `props-main`.`id` = 1775862 OR `props-main`.`id` = 1770893 OR `props-main`.`id` = 1774387 OR `props-main`.`id` = 1770864 OR `props-main`.`id` = 1750122 OR `props-main`.`id` = 1779407 OR `props-main`.`id` = 1633654 OR `props-main`.`id` = 1694963 OR `props-main`.`id` = 1757114 OR `props-main`.`id` = 1758757 OR `props-main`.`id` = 1779513 OR `props-main`.`id` = 1777075 OR `props-main`.`id` = 1770690 OR `props-main`.`id` = 1726945 OR `props-main`.`id` = 1776696 OR `props-main`.`id` = 1774631 OR `props-main`.`id` = 1743939 OR `props-main`.`id` = 1776186 OR `props-main`.`id` = 1772295 OR `props-main`.`id` = 291212 OR `props-main`.`id` = 1722828 OR `props-main`.`id` = 1766326 OR `props-main`.`id` = 1736077)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651414' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-21' 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();
4
Similar Properties
$365,000
3
2
1,412
0.16
2747 Saratoga Ave
Merced, CA 95340
$359,998
3
2
1,256
0.21
365 E Main St
Merced, CA 95340
$359,900
3
2
1,065
0.19
2581 E Gerard
Merced, CA 95341
$335,000
3
2
1,086
0.17
207 Yorktown
Merced, CA 95341
Last modified 1 week ago Fresno MLS last checked for updates 28 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.
