Listing Agent: Jeffrey Sklar, Beycome Brokerage Realty Inc.
Welcome to this charming home situated in the heart of Livingston. This property is a spacious interior with an inviting living area, appropriate for relaxing or entertaining. The kitchen is well-appointed with modern appliances and ample counter space. Enjoy the comfort of the generously sized bedrooms and the convenience of updated bathrooms. Outside, the backyard provides a serene space for outdoor activities. Experience the blend of comfort and functionality in this lovely Livingston residence.
Property Sub Type
Single Family Residence
Year Built
2007
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Price Per Square Foot
$202
Days On London
0
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Drive north on Main St. Enter the roundabout and take the 3rd exit onto B St. Left to Robin Ave. Left to Lilac Lane. Left to Barcelona Drive. Property is on the left. Cross Street: BARCELONA DR
Heating
Central
Cooling
Central Air
Roof
Tile
Foundation Details
Slab
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Appliances Y/N
No
Flooring
Carpet
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Water Source
Public
Sewer
Public Sewer
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Size Area
6969.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
022115023000
Zoning
R-1
Association Y/N
No
High School District
Other
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 555750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 614250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2652 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3152 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` = 1702333 OR `props-main`.`id` = 1671927 OR `props-main`.`id` = 1721590 OR `props-main`.`id` = 1721233 OR `props-main`.`id` = 1721219 OR `props-main`.`id` = 1714738 OR `props-main`.`id` = 1707991 OR `props-main`.`id` = 1702779 OR `props-main`.`id` = 1714528 OR `props-main`.`id` = 1714718 OR `props-main`.`id` = 1683262 OR `props-main`.`id` = 1710224 OR `props-main`.`id` = 1710241 OR `props-main`.`id` = 1622858 OR `props-main`.`id` = 1723447 OR `props-main`.`id` = 1713763 OR `props-main`.`id` = 1717209 OR `props-main`.`id` = 1713427 OR `props-main`.`id` = 1717817 OR `props-main`.`id` = 1707898 OR `props-main`.`id` = 1707910 OR `props-main`.`id` = 1717407 OR `props-main`.`id` = 1704708 OR `props-main`.`id` = 1638025 OR `props-main`.`id` = 1714159 OR `props-main`.`id` = 1720332 OR `props-main`.`id` = 1718094 OR `props-main`.`id` = 1720335 OR `props-main`.`id` = 1693519 OR `props-main`.`id` = 1721207 OR `props-main`.`id` = 1714814 OR `props-main`.`id` = 1677807)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82044212' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-23' 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.
