Calling all builders, investors, and rehabbers. Exciting opportunity to renovate this townhome in Hazelwood. Townhome is being sold AS IS, needs extensive renovation. With home being sold as-is no inspections or repairs are being offered by the seller.
Come design the townhome of your dreams!
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835 +post_id: "22091" +post_author: 1 +"ListingKey": "MIS203427068" +"ListingId": "25040677" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-17T15:32:38Z" +"RFModificationTimestamp": "2025-06-17T15:40:47.360360+00:00" +"ListPrice": 65000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1254.0 +"BuildingAreaTotal": 0 +"City": "Hazelwood" +"PostalCode": "63042" +"UnparsedAddress": "7214 Hazelcrest Drive, Hazelwood, Missouri 63042" +"Coordinates": array:2 [ 0 => -90.340744 1 => 38.780413 ] +"Latitude": 38.780413 +"Longitude": -90.340744 +"YearBuilt": 1965 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Adam Hoff" +"ListOfficeName": "Homebound Realty LLC" +"ListAgentMlsId": "ADAMHOFF" +"ListOfficeMlsId": "HMBD01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Calling all builders, investors, and rehabbers. Exciting opportunity to renovate this townhome in Hazelwood. Townhome is being sold AS IS, needs extensive renovation. With home being sold as-is no inspections or repairs are being offered by the seller.\n \n Come design the townhome of your dreams! """ +"AboveGradeFinishedArea": 1254 +"AboveGradeFinishedAreaSource": "Other" +"ArchitecturalStyle": array:2 [ 0 => "Apartment Style" 1 => "Contemporary" ] +"AssociationAmenities": "Association Management,Common Ground,Parking" +"AssociationFee": "206" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ 0 => "Maintenance Grounds" 1 => "Maintenance Parking/Roads" 2 => "Common Area Maintenance" ] +"AssociationYN": true +"Basement": array:1 [ 0 => "None" ] +"BathroomsFull": 1 +"CoListAgentAOR": "St. Charles County Association of REALTORS" +"CoListAgentFullName": "Dominic Franke" +"CoListAgentKey": "91021888" +"CoListAgentMlsId": "DOFRANKE" +"CoListOfficeKey": "35115922" +"CoListOfficeMlsId": "HMBD01" +"CoListOfficeName": "Homebound Realty LLC" +"CoListOfficePhone": "314-200-2184" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:2 [ 0 => "Ceiling Fan(s)" 1 => "Wall Unit(s)" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-06-13T20:34:45.657014+00:00" +"CumulativeDaysOnMarket": 4 +"DaysOnMarket": 4 +"Disclosures": array:1 [ 0 => "Lead Paint" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-17T15:32:38Z" +"DocumentsCount": 2 +"ElementarySchool": "Combs Elem." +"Fencing": array:1 [ 0 => "Vinyl" ] +"Flooring": array:1 [ 0 => "Carpet" ] +"Heating": array:1 [ 0 => "Electric" ] +"HighSchool": "Mccluer High" +"HighSchoolDistrict": "Ferguson-Florissant R-II" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "58355453" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "35115922" +"ListOfficePhone": "314-200-2184" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Other" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 38.23 +"LotSizeSource": "Other" +"MLSAreaMajor": "63 - McCluer" +"MajorChangeTimestamp": "2025-06-13T20:27:33Z" +"MiddleOrJuniorSchool": "Ferguson Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfUnitsInCommunity": 498 +"OnMarketDate": "2025-06-13" +"OriginalEntryTimestamp": "2025-06-13T20:27:33Z" +"OriginalListPrice": 65000 +"OwnershipType": "Private" +"ParcelNumber": "09K-61-6284" +"PatioAndPorchFeatures": array:1 [ 0 => "Patio" ] +"PhotosChangeTimestamp": "2025-06-13T20:28:39Z" +"PhotosCount": 16 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ 0 => "Fixer" ] +"RoadSurfaceType": array:1 [ 0 => "Asphalt" ] +"RoomsTotal": "6" +"ShowingRequirements": array:3 [ 0 => "Appointment Only" 1 => "Combination Lock Box" 2 => "Vacant" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-06-13T20:27:33Z" +"StreetName": "Hazelcrest" +"StreetNumber": "7214" +"StreetNumberNumeric": "7214" +"StreetSuffix": "Drive" +"SubdivisionName": "Hazelcrest Condo" +"TaxAnnualAmount": "852" +"TaxYear": "2024" +"Township": "Hazelwood" +"YearBuiltSource": "Other" +"MIS_Section": "HAZELWOOD" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "4" +"MIS_CurrentPrice": "65000.00" +"MIS_EfficiencyYN": "0" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "3" +"MIS_MainLevelBathroomsFull": "0" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainAndUpperLevelBathrooms": "2" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203427068')" +"provider_name": "MARIS" +"Media": array:16 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "684c89c2e2a48c733627710a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/b59ca37dddf9515740a183513c68f999.webp" "MediaSize" => 145948 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-b59ca37dddf9515740a183513c68f999.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.037Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "684c89c2e2a48c733627710b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/e3f078128cae20a9457761d1299d8d1d.webp" "MediaSize" => 96817 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-e3f078128cae20a9457761d1299d8d1d.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.000Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "684c89c2e2a48c733627710c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/bd10cec5cf7933155301030cbb80e4e8.webp" "MediaSize" => 100254 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-bd10cec5cf7933155301030cbb80e4e8.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Entryway featuring unfinished concrete floors, stairs, and baseboard heating" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.960Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "684c89c2e2a48c733627710d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/6c745c7d63d1c103e5e13b85e0a4161d.webp" "MediaSize" => 103295 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-6c745c7d63d1c103e5e13b85e0a4161d.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Spare room featuring concrete floors and stairs" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.955Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "684c89c2e2a48c733627710e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/5ab5856564aea8d7d0ea248cb77b8558.webp" "MediaSize" => 117454 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-5ab5856564aea8d7d0ea248cb77b8558.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "View of unfurnished living room" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.001Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "684c89c2e2a48c733627710f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/82811f03ff667a96538c764bcd10c77b.webp" "MediaSize" => 105759 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-82811f03ff667a96538c764bcd10c77b.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.958Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "684c89c2e2a48c7336277110" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/fc48f96dce60386207b9db033ae4491e.webp" "MediaSize" => 68432 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-fc48f96dce60386207b9db033ae4491e.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "View of staircase" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.990Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "684c89c2e2a48c7336277111" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/77edd9f5a021df796598d3fd9e810d96.webp" "MediaSize" => 96410 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-77edd9f5a021df796598d3fd9e810d96.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Spare room with carpet flooring, a baseboard heating unit, and an AC wall unit" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.952Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "684c89c2e2a48c7336277112" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/409cbca97a14a0a5eeb8793dc4bbd766.webp" "MediaSize" => 76045 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-409cbca97a14a0a5eeb8793dc4bbd766.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom featuring a baseboard heating unit" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.023Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "684c89c2e2a48c7336277113" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/037d1e95a74be3aa9cce4bf773964559.webp" "MediaSize" => 87464 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-037d1e95a74be3aa9cce4bf773964559.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Carpeted empty room featuring a baseboard radiator and a wall mounted air conditioner" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.950Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "684c89c2e2a48c7336277114" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/5bff579823dcf821d3fbba1923dd7318.webp" "MediaSize" => 56901 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-5bff579823dcf821d3fbba1923dd7318.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom featuring concrete floors and a closet" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.032Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "684c89c2e2a48c7336277115" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/465bae522bcc4525e4e5d55c553b5b5e.webp" "MediaSize" => 74714 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-465bae522bcc4525e4e5d55c553b5b5e.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Bathroom featuring tub / shower combination, vanity, and baseboard heating" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.011Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "684c89c2e2a48c7336277116" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/b730db3dd36907e93970e4eacda91b22.webp" "MediaSize" => 65396 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-b730db3dd36907e93970e4eacda91b22.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Carpeted spare room with baseboard heating and plenty of natural light" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.980Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "684c89c2e2a48c7336277117" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/ad076d3ddbd4461dfccbc07f0092745b.webp" "MediaSize" => 58585 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-ad076d3ddbd4461dfccbc07f0092745b.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom with a closet" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.990Z" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "684c89c2e2a48c7336277118" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/e3c98b01f3f85cf397757ec7f09ecab0.webp" "MediaSize" => 150705 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-e3c98b01f3f85cf397757ec7f09ecab0.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.957Z" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "684c89c2e2a48c7336277119" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/528a45245838fae743c05d3f5c82117f.webp" "MediaSize" => 181343 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-528a45245838fae743c05d3f5c82117f.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.006Z" ] ] +"ID": "22091" }
array:1 [ "RF Query: /Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS203427068'/Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS203427068'&$expand=Media/Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS203427068'/Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS203427068'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2833 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835 +post_id: "22091" +post_author: 1 +"ListingKey": "MIS203427068" +"ListingId": "25040677" +"PropertyType": "Residential" +"PropertySubType": "Condominium" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-17T15:32:38Z" +"RFModificationTimestamp": "2025-06-17T15:40:47.360360+00:00" +"ListPrice": 65000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1254.0 +"BuildingAreaTotal": 0 +"City": "Hazelwood" +"PostalCode": "63042" +"UnparsedAddress": "7214 Hazelcrest Drive, Hazelwood, Missouri 63042" +"Coordinates": array:2 [ 0 => -90.340744 1 => 38.780413 ] +"Latitude": 38.780413 +"Longitude": -90.340744 +"YearBuilt": 1965 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Adam Hoff" +"ListOfficeName": "Homebound Realty LLC" +"ListAgentMlsId": "ADAMHOFF" +"ListOfficeMlsId": "HMBD01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Calling all builders, investors, and rehabbers. Exciting opportunity to renovate this townhome in Hazelwood. Townhome is being sold AS IS, needs extensive renovation. With home being sold as-is no inspections or repairs are being offered by the seller.\n \n Come design the townhome of your dreams! """ +"AboveGradeFinishedArea": 1254 +"AboveGradeFinishedAreaSource": "Other" +"ArchitecturalStyle": array:2 [ 0 => "Apartment Style" 1 => "Contemporary" ] +"AssociationAmenities": "Association Management,Common Ground,Parking" +"AssociationFee": "206" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:3 [ 0 => "Maintenance Grounds" 1 => "Maintenance Parking/Roads" 2 => "Common Area Maintenance" ] +"AssociationYN": true +"Basement": array:1 [ 0 => "None" ] +"BathroomsFull": 1 +"CoListAgentAOR": "St. Charles County Association of REALTORS" +"CoListAgentFullName": "Dominic Franke" +"CoListAgentKey": "91021888" +"CoListAgentMlsId": "DOFRANKE" +"CoListOfficeKey": "35115922" +"CoListOfficeMlsId": "HMBD01" +"CoListOfficeName": "Homebound Realty LLC" +"CoListOfficePhone": "314-200-2184" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:2 [ 0 => "Ceiling Fan(s)" 1 => "Wall Unit(s)" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-06-13T20:34:45.657014+00:00" +"CumulativeDaysOnMarket": 4 +"DaysOnMarket": 4 +"Disclosures": array:1 [ 0 => "Lead Paint" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-17T15:32:38Z" +"DocumentsCount": 2 +"ElementarySchool": "Combs Elem." +"Fencing": array:1 [ 0 => "Vinyl" ] +"Flooring": array:1 [ 0 => "Carpet" ] +"Heating": array:1 [ 0 => "Electric" ] +"HighSchool": "Mccluer High" +"HighSchoolDistrict": "Ferguson-Florissant R-II" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "58355453" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "35115922" +"ListOfficePhone": "314-200-2184" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Other" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 38.23 +"LotSizeSource": "Other" +"MLSAreaMajor": "63 - McCluer" +"MajorChangeTimestamp": "2025-06-13T20:27:33Z" +"MiddleOrJuniorSchool": "Ferguson Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfUnitsInCommunity": 498 +"OnMarketDate": "2025-06-13" +"OriginalEntryTimestamp": "2025-06-13T20:27:33Z" +"OriginalListPrice": 65000 +"OwnershipType": "Private" +"ParcelNumber": "09K-61-6284" +"PatioAndPorchFeatures": array:1 [ 0 => "Patio" ] +"PhotosChangeTimestamp": "2025-06-13T20:28:39Z" +"PhotosCount": 16 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PropertyAttachedYN": true +"PropertyCondition": array:1 [ 0 => "Fixer" ] +"RoadSurfaceType": array:1 [ 0 => "Asphalt" ] +"RoomsTotal": "6" +"ShowingRequirements": array:3 [ 0 => "Appointment Only" 1 => "Combination Lock Box" 2 => "Vacant" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-06-13T20:27:33Z" +"StreetName": "Hazelcrest" +"StreetNumber": "7214" +"StreetNumberNumeric": "7214" +"StreetSuffix": "Drive" +"SubdivisionName": "Hazelcrest Condo" +"TaxAnnualAmount": "852" +"TaxYear": "2024" +"Township": "Hazelwood" +"YearBuiltSource": "Other" +"MIS_Section": "HAZELWOOD" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "4" +"MIS_CurrentPrice": "65000.00" +"MIS_EfficiencyYN": "0" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "3" +"MIS_MainLevelBathroomsFull": "0" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainAndUpperLevelBathrooms": "2" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203427068')" +"provider_name": "MARIS" +"Media": array:16 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "684c89c2e2a48c733627710a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/b59ca37dddf9515740a183513c68f999.webp" "MediaSize" => 145948 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-b59ca37dddf9515740a183513c68f999.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.037Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "684c89c2e2a48c733627710b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/e3f078128cae20a9457761d1299d8d1d.webp" "MediaSize" => 96817 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-e3f078128cae20a9457761d1299d8d1d.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.000Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "684c89c2e2a48c733627710c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/bd10cec5cf7933155301030cbb80e4e8.webp" "MediaSize" => 100254 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-bd10cec5cf7933155301030cbb80e4e8.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Entryway featuring unfinished concrete floors, stairs, and baseboard heating" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.960Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "684c89c2e2a48c733627710d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/6c745c7d63d1c103e5e13b85e0a4161d.webp" "MediaSize" => 103295 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-6c745c7d63d1c103e5e13b85e0a4161d.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Spare room featuring concrete floors and stairs" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.955Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "684c89c2e2a48c733627710e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/5ab5856564aea8d7d0ea248cb77b8558.webp" "MediaSize" => 117454 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-5ab5856564aea8d7d0ea248cb77b8558.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "View of unfurnished living room" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.001Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "684c89c2e2a48c733627710f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/82811f03ff667a96538c764bcd10c77b.webp" "MediaSize" => 105759 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-82811f03ff667a96538c764bcd10c77b.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.958Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "684c89c2e2a48c7336277110" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/fc48f96dce60386207b9db033ae4491e.webp" "MediaSize" => 68432 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-fc48f96dce60386207b9db033ae4491e.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "View of staircase" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.990Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "684c89c2e2a48c7336277111" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/77edd9f5a021df796598d3fd9e810d96.webp" "MediaSize" => 96410 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-77edd9f5a021df796598d3fd9e810d96.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Spare room with carpet flooring, a baseboard heating unit, and an AC wall unit" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.952Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "684c89c2e2a48c7336277112" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/409cbca97a14a0a5eeb8793dc4bbd766.webp" "MediaSize" => 76045 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-409cbca97a14a0a5eeb8793dc4bbd766.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom featuring a baseboard heating unit" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.023Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "684c89c2e2a48c7336277113" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/037d1e95a74be3aa9cce4bf773964559.webp" "MediaSize" => 87464 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-037d1e95a74be3aa9cce4bf773964559.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Carpeted empty room featuring a baseboard radiator and a wall mounted air conditioner" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.950Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "684c89c2e2a48c7336277114" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/5bff579823dcf821d3fbba1923dd7318.webp" "MediaSize" => 56901 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-5bff579823dcf821d3fbba1923dd7318.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom featuring concrete floors and a closet" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.032Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "684c89c2e2a48c7336277115" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/465bae522bcc4525e4e5d55c553b5b5e.webp" "MediaSize" => 74714 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-465bae522bcc4525e4e5d55c553b5b5e.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Bathroom featuring tub / shower combination, vanity, and baseboard heating" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.011Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "684c89c2e2a48c7336277116" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/b730db3dd36907e93970e4eacda91b22.webp" "MediaSize" => 65396 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-b730db3dd36907e93970e4eacda91b22.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Carpeted spare room with baseboard heating and plenty of natural light" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.980Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "684c89c2e2a48c7336277117" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/ad076d3ddbd4461dfccbc07f0092745b.webp" "MediaSize" => 58585 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-ad076d3ddbd4461dfccbc07f0092745b.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom with a closet" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.990Z" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "684c89c2e2a48c7336277118" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/e3c98b01f3f85cf397757ec7f09ecab0.webp" "MediaSize" => 150705 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-e3c98b01f3f85cf397757ec7f09ecab0.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:45.957Z" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "684c89c2e2a48c7336277119" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/528a45245838fae743c05d3f5c82117f.webp" "MediaSize" => 181343 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203427068/thumbnail-528a45245838fae743c05d3f5c82117f.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-13T20:27:46.006Z" ] ] +"ID": "22091" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.2 seconds" ] ]