Seize the Opportunity! This 3 bedroom, 2 bath home with large back yard in established neighborhood has so much potential! Needs someone with a vision and willingness to take on a project to transform this into a beautiful home!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached, Flat
Property Condition
Fixer
Year Built
1972
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Levels
One
Pets Allowed
Yes
Home Warranty
No
Directions to Property
From CA-99 South, exit 16th St; left onto Ashby Rd; rights onto Beachwood Dr; right onto Cabot Ave; left onto Meadowbrook Ave; right on to Balboa Ave; house on right.
Cross Street
Meadowbrook Ave
County
Merced
Special Listing Conditions
Probate Listing
Main Level
Bedroom(s), Living Room, Dining Room, Primary Bedroom, Full Bath(s), Garage, Kitchen, Street Entrance
Architectural Style
Other
Construction Materials
Stucco, Wood, Wood Siding
Foundation
Raised
Roof
Composition
Heating
Central, See Remarks
Cooling
See Remarks
Laundry Features
Electric, Hookups Only, In Garage
Other Structures
Storage, Other
Full Bathrooms
2
Bath Features
Tub w/Shower Over
Flooring
Carpet, Linoleum
Appliances
Microwave, Free Standing Electric Range
Room Type
Primary Bedroom, Kitchen, Living Room
Kitchen Features
Laminate Counter
Dining Room Features
Space in Kitchen
Living Room Features
Other
Primary Bathroom Features
Shower Stall(s)
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Electric, Sewer In & Connected, Natural Gas Connected
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 236550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 261450 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) >= 926 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1426 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` = 1726773 OR `props-main`.`id` = 1693807 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1696651 OR `props-main`.`id` = 1714499 OR `props-main`.`id` = 1722113 OR `props-main`.`id` = 1722109 OR `props-main`.`id` = 1726066 OR `props-main`.`id` = 1726074 OR `props-main`.`id` = 1723282 OR `props-main`.`id` = 1731018 OR `props-main`.`id` = 1688050 OR `props-main`.`id` = 1688040 OR `props-main`.`id` = 1703457 OR `props-main`.`id` = 1717582 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1726243 OR `props-main`.`id` = 1725552 OR `props-main`.`id` = 1728219 OR `props-main`.`id` = 1728270 OR `props-main`.`id` = 1679706 OR `props-main`.`id` = 1686825 OR `props-main`.`id` = 1690564 OR `props-main`.`id` = 1695318 OR `props-main`.`id` = 1704152 OR `props-main`.`id` = 1723059 OR `props-main`.`id` = 1729663 OR `props-main`.`id` = 1714687 OR `props-main`.`id` = 1720840 OR `props-main`.`id` = 1714599 OR `props-main`.`id` = 1725148 OR `props-main`.`id` = 1723291 OR `props-main`.`id` = 1725710 OR `props-main`.`id` = 1731155 OR `props-main`.`id` = 1728823 OR `props-main`.`id` = 1695615 OR `props-main`.`id` = 1730790 OR `props-main`.`id` = 1719076 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1724893 OR `props-main`.`id` = 1716876 OR `props-main`.`id` = 1716882 OR `props-main`.`id` = 1717810 OR `props-main`.`id` = 1716863 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1726701 OR `props-main`.`id` = 1726706 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1725317 OR `props-main`.`id` = 1725758 OR `props-main`.`id` = 1697488 OR `props-main`.`id` = 1727530 OR `props-main`.`id` = 1726941 OR `props-main`.`id` = 1726930 OR `props-main`.`id` = 1727524 OR `props-main`.`id` = 1720609 OR `props-main`.`id` = 1723698 OR `props-main`.`id` = 1723697 OR `props-main`.`id` = 1064604 OR `props-main`.`id` = 1729727 OR `props-main`.`id` = 1722229 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1724609 OR `props-main`.`id` = 1728677 OR `props-main`.`id` = 1724196 OR `props-main`.`id` = 1714570 OR `props-main`.`id` = 1721038 OR `props-main`.`id` = 1715798 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` = 1726570 OR `props-main`.`id` = 1726410)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226068894' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-01' 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 Brenda Comfort, eXp Realty of California 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.
