Listing Agent: Mario Zazueta, Century 21 Select Real Estate, Turlock
Opportunity awaits with this 3-bedroom, 2-bath home of potential? Featuring title flooring and a spacious inviting layout. Enjoy a large family room complete with a cozy fireplace perfect for relaxing evenings or entertaining guests. The kitchen offers abundant cabinet space, a convenient dining bar, and a bright eating area for casual meals. For more formal gatherings, the separate dining room provides direct access to the backyard, creating a semaless indoor-outdoor flow. Primary bedroom with walk-in closet and bath with dual sinks. Inside laundry room. Front yard has a cherry, nectarine tree and back yard with a Plum, limon and mandarin tree. Conveniently located near a park and shopping centers. Garage coverted in to 2-bedrooms. This home does need repairs and updates, making it ideal for investors, handy homeowners or buyers looking to customize their dream home.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1990
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$217
Days On London
0
Cumulative Days On London
0
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
Santa Fe Ave to Winton Way, Right on Arlene Dr.
Architectural Style
Contemporary
Room Type
Laundry, All Bedrooms Down, Kitchen, Family Room
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside, Individual Room
Roof
Tile
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Construction Materials
Wood Siding
Door Features
Sliding Doors
Foundation Details
Slab
Main Level Bedrooms
3
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
2
Eating Area
Breakfast Counter / Bar, Dining Room, In Kitchen, Area
Appliances Y/N
Yes
Appliances
Gas Range
Room Bathroom Features
Tile Counters, Shower in Tub
Accessibility Features
None
Flooring
Tile, Vinyl
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Electric
Electricity - On Property, 220 Volts in Laundry
Utilities
Natural Gas Connected, Sewer Connected, Electricity Connected
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Features
Off Street, Garage Faces Front, Driveway
Lot Features
Rectangular Lot, Front Yard
Lot Size Area
5400.0000
Lot Size Units
Square Feet
Road Frontage Type
City Street
Road Surface Type
Paved
View Y/N
Yes
View
Neighborhood
Fencing
Wood
Common Interest
None
Parcel Number
146252006000
Additional Parcels Y/N
No
Community Features
Urban
Senior Community Y/N
No
Association Y/N
No
High School District
Merced Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
38
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 318155 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 351645 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) >= 1290 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1790 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` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 1718402 OR `props-main`.`id` = 1718421 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 1717457 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 1720828 OR `props-main`.`id` = 1724661 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1707011 OR `props-main`.`id` = 1716394 OR `props-main`.`id` = 1694847 OR `props-main`.`id` = 1696793 OR `props-main`.`id` = 1656585 OR `props-main`.`id` = 1718564 OR `props-main`.`id` = 1718572 OR `props-main`.`id` = 1718575 OR `props-main`.`id` = 1723307 OR `props-main`.`id` = 1723023 OR `props-main`.`id` = 1723645 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` = 1716478 OR `props-main`.`id` = 1718923 OR `props-main`.`id` = 586564 OR `props-main`.`id` = 1717697 OR `props-main`.`id` = 1687986 OR `props-main`.`id` = 1724707 OR `props-main`.`id` = 1697635 OR `props-main`.`id` = 874388 OR `props-main`.`id` = 1515932 OR `props-main`.`id` = 1714086 OR `props-main`.`id` = 1637763 OR `props-main`.`id` = 1637752)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26094289' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-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
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.
