North from Winton way, West from Gertrude Ave., South from Almond Ave. East from Cypress Ave.
Cross Street
Cypress Ave.
County
Merced
Special Listing Conditions
In Foreclosure
Main Level
Kitchen, Street Entrance
Construction Materials
Stucco, Glass, Wood, Other
Foundation
Slab
Roof
Other
Heating
Central, Fireplace(s)
Cooling
Other
Laundry Features
Other
Full Bathrooms
3
Bath Features
Other
# of Fireplaces
1
Fireplace Features
Other
Flooring
Tile, Other
Kitchen Features
Breakfast Area, Ceramic Counter
Dining Room Features
Other
Living Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
Other
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Garage Facing Front
Garage Spaces
2.00
Lot Features
Corner, Landscape Front, Other
APN
147 273 025 000
Horse Property
No
Zoning Description
R-1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Winton
Middle or Junior School District
Winton
Senior High School District
Merced Union High
Census Tract
5.05
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 299250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 330750 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) >= 1688 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2188 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` = 1622792 OR `props-main`.`id` = 1702415 OR `props-main`.`id` = 1703338 OR `props-main`.`id` = 1688629 OR `props-main`.`id` = 1688587 OR `props-main`.`id` = 1688598 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1702507 OR `props-main`.`id` = 1700148 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1691960 OR `props-main`.`id` = 1691872 OR `props-main`.`id` = 1691969 OR `props-main`.`id` = 1700180 OR `props-main`.`id` = 1701011 OR `props-main`.`id` = 1683927 OR `props-main`.`id` = 1693696 OR `props-main`.`id` = 1702899 OR `props-main`.`id` = 1701763 OR `props-main`.`id` = 1702081 OR `props-main`.`id` = 1697622 OR `props-main`.`id` = 1696843 OR `props-main`.`id` = 1695667 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1694068 OR `props-main`.`id` = 1701739 OR `props-main`.`id` = 1701720 OR `props-main`.`id` = 1701729 OR `props-main`.`id` = 1700648 OR `props-main`.`id` = 1703361 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1702762 OR `props-main`.`id` = 1702847 OR `props-main`.`id` = 1700967 OR `props-main`.`id` = 1692458 OR `props-main`.`id` = 1693700 OR `props-main`.`id` = 1696460 OR `props-main`.`id` = 1697464 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 1703410 OR `props-main`.`id` = 1703407 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 1702582 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1702763 OR `props-main`.`id` = 1703380 OR `props-main`.`id` = 1700162 OR `props-main`.`id` = 1694847 OR `props-main`.`id` = 1687780 OR `props-main`.`id` = 1700249 OR `props-main`.`id` = 1703387 OR `props-main`.`id` = 1696793 OR `props-main`.`id` = 1690176 OR `props-main`.`id` = 1690198 OR `props-main`.`id` = 1678843 OR `props-main`.`id` = 1656585 OR `props-main`.`id` = 1703045 OR `props-main`.`id` = 1699808 OR `props-main`.`id` = 1703033 OR `props-main`.`id` = 1692125 OR `props-main`.`id` = 1700013 OR `props-main`.`id` = 1685496 OR `props-main`.`id` = 1691063 OR `props-main`.`id` = 1697937 OR `props-main`.`id` = 1697917 OR `props-main`.`id` = 1622832 OR `props-main`.`id` = 1622833 OR `props-main`.`id` = 1700939 OR `props-main`.`id` = 1700940 OR `props-main`.`id` = 1683263 OR `props-main`.`id` = 1667509 OR `props-main`.`id` = 1700987 OR `props-main`.`id` = 1691534 OR `props-main`.`id` = 1698501 OR `props-main`.`id` = 1690963 OR `props-main`.`id` = 1691914 OR `props-main`.`id` = 1692176 OR `props-main`.`id` = 586564 OR `props-main`.`id` = 1687986 OR `props-main`.`id` = 1697635 OR `props-main`.`id` = 874388)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226006202' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-19' 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 Antonio Jaime, HomeSmart PV & Associates 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.
