Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/crmls/MC26077413/1054-W-24th/Merced/https://www.londonproperties.com/images/props/crmls/full/MC26077413.jpgLondon Properties Merced Real Estate | 1054 W 24th
Listing Agent: Rosa Kindred-Winzer, London Properties Ltd - Merced
Perfect opportunity for first time homebuyer or investor. This small but mighty home has improvements that will allow you to move in and make it your cozy style! Roof replaced in 2017, HVAC/AC installed in 2013, insulated walls with R-13 insulation throughout the home completed in 2020, double pain windows installed in 2023, 30-gallon hot water heater installed in 2024, and a single car garage converted to a bonus room with french doors leading outside to the backyard. Walking distance to John C. Fremont Elementary and Applegate Zoo and park. Don't miss out on this wonderful opportunity!
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1957
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
front door
Price Per Square Foot
$253
Days On London
20
Cumulative Days On London
20
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
West on 23rd Street, right on Q Street, left on W 24th Street
Architectural Style
Bungalow
Room Type
Bonus Room, All Bedrooms Down
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Electric Dryer Hookup, In Kitchen
Roof
Composition, Flat, Shingle
Construction Materials
Unknown
Direction Faces
West
Door Features
Panel Doors
Window Features
Double Pane Windows
Foundation Details
Slab
Main Level Bedrooms
3
Bathrooms Full
1
Bathrooms Full And Three Quarter
1
Main Level Bathrooms
1
Room Kitchen Features
Tile Counters, Kitchen Open to Family Room
Eating Area
In Kitchen
Appliances Y/N
Yes
Appliances
Water Heater, Gas Range, High Efficiency Water Heater, Gas Oven
Room Bathroom Features
Formica Counters, Shower in Tub
Interior Features
Unfurnished, Ceiling Fan(s), Tile Counters
Flooring
Tile, Wood
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Patio Y/N
Yes
Patio And Porch Features
None
Electric
220 Volts in Kitchen,Electricity - On Property
Utilities
Natural Gas Connected, Phone Available, Sewer Connected, Cable Available, Electricity Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Well Report Y/N
No
Parking Total
3.00
Parking Features
Driveway Up Slope From Street, Paved, Asphalt, Driveway, Street
Attached Garage Y/N
No
Garage Spaces
1.00
Uncovered Spaces
2.00
Lot Features
Level with Street, Rectangular Lot, 0-1 Unit/Acre, Front Yard, Back Yard, Lawn
Lot Size Area
6500.0000
Lot Size Units
Square Feet
Lot Dimensions Source
Public Records
Road Frontage Type
City Street
Road Surface Type
Paved
View Y/N
Yes
View
Neighborhood
Fencing
Wood, Fair Condition
Common Interest
None
Parcel Number
030153015000
Additional Parcels Y/N
No
Zoning
R16
Community Features
Valley, Gutters, Street Lights, Storm Drains, Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Merced City
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
13
Tax Tract Number
005000
Tax Census Tract
13.01
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 304000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 336000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1014 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1514 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` = 1723809 OR `props-main`.`id` = 1723820 OR `props-main`.`id` = 1702687 OR `props-main`.`id` = 1723864 OR `props-main`.`id` = 1722613 OR `props-main`.`id` = 1714607 OR `props-main`.`id` = 1702508 OR `props-main`.`id` = 1722045 OR `props-main`.`id` = 1722036 OR `props-main`.`id` = 1694967 OR `props-main`.`id` = 1701468 OR `props-main`.`id` = 1665493 OR `props-main`.`id` = 1723281 OR `props-main`.`id` = 1714387 OR `props-main`.`id` = 1724253 OR `props-main`.`id` = 1719749 OR `props-main`.`id` = 1720405 OR `props-main`.`id` = 1041230 OR `props-main`.`id` = 1693807 OR `props-main`.`id` = 1693713 OR `props-main`.`id` = 1693694 OR `props-main`.`id` = 1714454 OR `props-main`.`id` = 1694962 OR `props-main`.`id` = 1674548 OR `props-main`.`id` = 1706026 OR `props-main`.`id` = 1692454 OR `props-main`.`id` = 1692435 OR `props-main`.`id` = 1723584 OR `props-main`.`id` = 1723575 OR `props-main`.`id` = 1723825 OR `props-main`.`id` = 1724574 OR `props-main`.`id` = 1717007 OR `props-main`.`id` = 1703178 OR `props-main`.`id` = 1703174 OR `props-main`.`id` = 1703265 OR `props-main`.`id` = 1712413 OR `props-main`.`id` = 1723483 OR `props-main`.`id` = 1714340 OR `props-main`.`id` = 1724892 OR `props-main`.`id` = 1724914 OR `props-main`.`id` = 1724946 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1718808 OR `props-main`.`id` = 1723296 OR `props-main`.`id` = 1714743 OR `props-main`.`id` = 1714759 OR `props-main`.`id` = 1723264 OR `props-main`.`id` = 1708251 OR `props-main`.`id` = 1696651 OR `props-main`.`id` = 1714499 OR `props-main`.`id` = 1717979 OR `props-main`.`id` = 1722385 OR `props-main`.`id` = 1724000 OR `props-main`.`id` = 1716553 OR `props-main`.`id` = 1720206 OR `props-main`.`id` = 1690062 OR `props-main`.`id` = 1716559 OR `props-main`.`id` = 1724001 OR `props-main`.`id` = 1724706 OR `props-main`.`id` = 1724819 OR `props-main`.`id` = 1722113 OR `props-main`.`id` = 1722109 OR `props-main`.`id` = 1716763 OR `props-main`.`id` = 1718415 OR `props-main`.`id` = 1724848 OR `props-main`.`id` = 1724959 OR `props-main`.`id` = 1717008 OR `props-main`.`id` = 1724054 OR `props-main`.`id` = 1723665 OR `props-main`.`id` = 1710126 OR `props-main`.`id` = 1718502 OR `props-main`.`id` = 1714294 OR `props-main`.`id` = 1704870 OR `props-main`.`id` = 1704891 OR `props-main`.`id` = 1704917 OR `props-main`.`id` = 1723274 OR `props-main`.`id` = 1724705 OR `props-main`.`id` = 1724818 OR `props-main`.`id` = 1723269 OR `props-main`.`id` = 1724314 OR `props-main`.`id` = 1695165 OR `props-main`.`id` = 1724226 OR `props-main`.`id` = 1703320 OR `props-main`.`id` = 1721560 OR `props-main`.`id` = 1721552 OR `props-main`.`id` = 1723282 OR `props-main`.`id` = 1705830 OR `props-main`.`id` = 1690433 OR `props-main`.`id` = 1690429 OR `props-main`.`id` = 1722046 OR `props-main`.`id` = 1722186 OR `props-main`.`id` = 1722196 OR `props-main`.`id` = 1718325 OR `props-main`.`id` = 262682 OR `props-main`.`id` = 1688050 OR `props-main`.`id` = 1688040 OR `props-main`.`id` = 1703457 OR `props-main`.`id` = 1704693 OR `props-main`.`id` = 1717582 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1704003 OR `props-main`.`id` = 1716629 OR `props-main`.`id` = 1724513 OR `props-main`.`id` = 1723278 OR `props-main`.`id` = 1723295 OR `props-main`.`id` = 1686965 OR `props-main`.`id` = 1714366 OR `props-main`.`id` = 289931 OR `props-main`.`id` = 1725038 OR `props-main`.`id` = 1720494 OR `props-main`.`id` = 1724891 OR `props-main`.`id` = 1721525 OR `props-main`.`id` = 1708410 OR `props-main`.`id` = 1708334 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` = 1714687 OR `props-main`.`id` = 1720840 OR `props-main`.`id` = 1723265 OR `props-main`.`id` = 1723620 OR `props-main`.`id` = 1714599 OR `props-main`.`id` = 1725148 OR `props-main`.`id` = 1722112 OR `props-main`.`id` = 87746 OR `props-main`.`id` = 1723291 OR `props-main`.`id` = 1717391 OR `props-main`.`id` = 1681378 OR `props-main`.`id` = 1724224 OR `props-main`.`id` = 1718682 OR `props-main`.`id` = 270485 OR `props-main`.`id` = 1701576 OR `props-main`.`id` = 1699025 OR `props-main`.`id` = 1724422 OR `props-main`.`id` = 1724635 OR `props-main`.`id` = 1696131 OR `props-main`.`id` = 1723934 OR `props-main`.`id` = 224715 OR `props-main`.`id` = 224717 OR `props-main`.`id` = 1687504 OR `props-main`.`id` = 1696130 OR `props-main`.`id` = 1722592 OR `props-main`.`id` = 1684373 OR `props-main`.`id` = 1722739 OR `props-main`.`id` = 93375 OR `props-main`.`id` = 1720346 OR `props-main`.`id` = 1719076 OR `props-main`.`id` = 1723615 OR `props-main`.`id` = 1723624 OR `props-main`.`id` = 1722481 OR `props-main`.`id` = 1724893 OR `props-main`.`id` = 1724717 OR `props-main`.`id` = 1707864 OR `props-main`.`id` = 1713102 OR `props-main`.`id` = 1709552 OR `props-main`.`id` = 1723298 OR `props-main`.`id` = 1724278 OR `props-main`.`id` = 1720291 OR `props-main`.`id` = 1720493 OR `props-main`.`id` = 1697562 OR `props-main`.`id` = 1711179 OR `props-main`.`id` = 1711176 OR `props-main`.`id` = 1696579 OR `props-main`.`id` = 1723290 OR `props-main`.`id` = 1722662 OR `props-main`.`id` = 1720387 OR `props-main`.`id` = 1724244 OR `props-main`.`id` = 1721995 OR `props-main`.`id` = 1721563 OR `props-main`.`id` = 1721565 OR `props-main`.`id` = 1721572 OR `props-main`.`id` = 1714839 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1719687 OR `props-main`.`id` = 1719832 OR `props-main`.`id` = 1719830 OR `props-main`.`id` = 1721362 OR `props-main`.`id` = 1721406 OR `props-main`.`id` = 1720457 OR `props-main`.`id` = 1717010 OR `props-main`.`id` = 1722616 OR `props-main`.`id` = 1722618 OR `props-main`.`id` = 1723955 OR `props-main`.`id` = 1723966 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1724609 OR `props-main`.`id` = 1717006 OR `props-main`.`id` = 1716047 OR `props-main`.`id` = 1716133 OR `props-main`.`id` = 1722966 OR `props-main`.`id` = 1723153 OR `props-main`.`id` = 1723158 OR `props-main`.`id` = 1711272 OR `props-main`.`id` = 1721036 OR `props-main`.`id` = 1721042 OR `props-main`.`id` = 1704802 OR `props-main`.`id` = 1707000 OR `props-main`.`id` = 1714876 OR `props-main`.`id` = 1723057 OR `props-main`.`id` = 1724196 OR `props-main`.`id` = 1714570 OR `props-main`.`id` = 1721038 OR `props-main`.`id` = 1715798 OR `props-main`.`id` = 1709672 OR `props-main`.`id` = 1712818 OR `props-main`.`id` = 1716572 OR `props-main`.`id` = 1724031 OR `props-main`.`id` = 1713146)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26077413' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-03' 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();
6
Similar Properties
$335,000
3
1
1,288
0.17
1251 W 9th
Merced, CA 95341
$335,000
3
2
1,327
0.14
3125 El Capitan
Merced, CA 95340
$335,000
3
2
1,144
0.20
1843 W 8th
Merced, CA 95341
$315,000
3
2
1,195
0.14
2720 Glen Ave
Merced, CA 95340
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.
