Bedroom(s), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Architectural Style
A-Frame
Construction Materials
Stucco, Frame
Foundation
Slab
Roof
Tile
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Cabinets, Gas Hook-Up
Other Structures
Storage
Full Bathrooms
3
Bath Features
Granite, Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Living Room
Flooring
Carpet, Tile
Appliances
Gas Cook Top, Gas Water Heater, Hood Over Range, Dishwasher, Microwave, Double Oven
Room Type
Primary Bedroom, Game Room, Storage, Laundry
Kitchen Features
Breakfast Area, Pantry Closet, Granite Counter, Island
Dining Room Features
Formal Area
Living Room Features
Other
Primary Bedroom Features
Sitting Room, Closet, Walk-In Closet
Primary Bathroom Features
Double Sinks, Granite
Patio And Porch Features
Covered Deck
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public, Internet Available
Electric
220 Volts in Laundry
Irrigation
Other
Water Source
Well
Sewer
Septic System
Parking Features
Attached, Garage Door Opener, Garage Facing Side
Garage Spaces
3.00
Lot Features
Auto Sprinkler F&R, Cul-De-Sac, Curb(s)/Gutter(s), Landscape Back, Landscape Front
APN
147 210 033 000
Fencing
Back Yard
Horse Property
No
Zoning Description
R-1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Merced
Elementary School District
Atwater Elementary
Middle or Junior School District
Atwater Elementary
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) >= 1033600 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1142400 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) >= 3415 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3915 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` = 1723294 OR `props-main`.`id` = 1724484 OR `props-main`.`id` = 1724483 OR `props-main`.`id` = 1723293 OR `props-main`.`id` = 1731003 OR `props-main`.`id` = 1723297 OR `props-main`.`id` = 1732522 OR `props-main`.`id` = 1726751 OR `props-main`.`id` = 1715714 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1727284 OR `props-main`.`id` = 1732272 OR `props-main`.`id` = 1732285 OR `props-main`.`id` = 1725250 OR `props-main`.`id` = 1724879 OR `props-main`.`id` = 1727965 OR `props-main`.`id` = 1727164 OR `props-main`.`id` = 1727181 OR `props-main`.`id` = 1723056 OR `props-main`.`id` = 1723051 OR `props-main`.`id` = 1723046 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 1731001 OR `props-main`.`id` = 1730984 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1726183 OR `props-main`.`id` = 1732098 OR `props-main`.`id` = 1721235 OR `props-main`.`id` = 1728911 OR `props-main`.`id` = 1732524 OR `props-main`.`id` = 1724453 OR `props-main`.`id` = 1731063 OR `props-main`.`id` = 1732735 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1721783 OR `props-main`.`id` = 1725742 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1714397 OR `props-main`.`id` = 1731191 OR `props-main`.`id` = 1731165 OR `props-main`.`id` = 1731179 OR `props-main`.`id` = 1726708 OR `props-main`.`id` = 1726817 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1732022 OR `props-main`.`id` = 1731998 OR `props-main`.`id` = 1732027 OR `props-main`.`id` = 1708105 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 1721198 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 1717457 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 1730628 OR `props-main`.`id` = 1720828 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1707011 OR `props-main`.`id` = 1716394 OR `props-main`.`id` = 1694847 OR `props-main`.`id` = 1732939 OR `props-main`.`id` = 1731156 OR `props-main`.`id` = 1696793 OR `props-main`.`id` = 1718564 OR `props-main`.`id` = 1718572 OR `props-main`.`id` = 1718575 OR `props-main`.`id` = 1725512 OR `props-main`.`id` = 1711370 OR `props-main`.`id` = 1622833 OR `props-main`.`id` = 1723263 OR `props-main`.`id` = 1714082 OR `props-main`.`id` = 1722014 OR `props-main`.`id` = 1723273 OR `props-main`.`id` = 1714261 OR `props-main`.`id` = 1698501 OR `props-main`.`id` = 1723300 OR `props-main`.`id` = 1721116 OR `props-main`.`id` = 1691914 OR `props-main`.`id` = 1692176 OR `props-main`.`id` = 1728289 OR `props-main`.`id` = 1728848 OR `props-main`.`id` = 1731956 OR `props-main`.`id` = 1718923 OR `props-main`.`id` = 586564 OR `props-main`.`id` = 1697635 OR `props-main`.`id` = 874388)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226071245' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-04' 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 Luis Naranjo-Villalobos, Lupita's Z & N Realty 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.
