It’s not common you get a chance to purchase your dream, but this is just that. Eight acres of some of the most gorgeous land in Missouri accompanied by two barns, fruit tree orchard, rose garden, a stocked pond, horse stalls, riding lots, and a cozy ranch make this home a once in a lifetime opprotunity. “Windy Acres Heights” sits cozy on hills overlooking your valley, a heritage pole barn able to comfortably hold four horse along with all your tack, and a private pond often alive with the sound of frogs and bird song in summer. This would make for the most prime of building lots in West County, with several large flat fields situated on the property along with electric and a well. The classic farmhouse on-site is a 3/1 and is undergoing a tasteful remodel to accompany the great location. With new soapstone countertops, completely new kitchen, new bathroom, luxury flooring, and an addition adding a mud room and an office. Owner wishes to sell the home as-is but has taken on some of the largest jobs already meaning minimum sweat recquired to finish this beautiful home. The current ranch is dreamy enough, but would make an excellent temporary house for anyone who wanted to be near the magic as they built their dream home. Just minutes from the Downtown Wildwood shopping district, local schools, great bike and horse trails, as well as scenic drives down historic route 66 the dream just keeps getting better. This one wont last long so reach out and grab your dream now
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "23804" +post_author: 1 +"ListingKey": "MIS203718464" +"ListingId": "25046528" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T23:54:38Z" +"RFModificationTimestamp": "2025-07-07T23:55:58.341109+00:00" +"ListPrice": 579000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1232.0 +"BuildingAreaTotal": 0 +"City": "Wildwood" +"PostalCode": "63038" +"UnparsedAddress": "18543 Melrose Road, Wildwood, Missouri 63038" +"Coordinates": array:2 [ 0 => -90.696353 1 => 38.560754 ] +"Latitude": 38.560754 +"Longitude": -90.696353 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jack Mccurdy" +"ListOfficeName": "S. R. Stock Properties, Inc." +"ListAgentMlsId": "JMCCURDY" +"ListOfficeMlsId": "SRSP01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "It's not common you get a chance to purchase your dream, but this is just that. Eight acres of some of the most gorgeous land in Missouri accompanied by two barns, fruit tree orchard, rose garden, a stocked pond, horse stalls, riding lots, and a cozy ranch make this home a once in a lifetime opprotunity. "Windy Acres Heights" sits cozy on hills overlooking your valley, a heritage pole barn able to comfortably hold four horse along with all your tack, and a private pond often alive with the sound of frogs and bird song in summer. This would make for the most prime of building lots in West County, with several large flat fields situated on the property along with electric and a well. The classic farmhouse on-site is a 3/1 and is undergoing a tasteful remodel to accompany the great location. With new soapstone countertops, completely new kitchen, new bathroom, luxury flooring, and an addition adding a mud room and an office. Owner wishes to sell the home as-is but has taken on some of the largest jobs already meaning minimum sweat recquired to finish this beautiful home. The current ranch is dreamy enough, but would make an excellent temporary house for anyone who wanted to be near the magic as they built their dream home. Just minutes from the Downtown Wildwood shopping district, local schools, great bike and horse trails, as well as scenic drives down historic route 66 the dream just keeps getting better. This one wont last long so reach out and grab your dream now" +"AboveGradeFinishedArea": 1232 +"AboveGradeFinishedAreaSource": "Owner" +"Appliances": array:5 [ 0 => "Stainless Steel Appliance(s)" 1 => "Electric Cooktop" 2 => "Dishwasher" 3 => "Range Hood" 4 => "Refrigerator" ] +"ArchitecturalStyle": array:1 [ 0 => "Ranch" ] +"Basement": array:1 [ 0 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:1 [ 0 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-07-07T13:48:20.196646+00:00" +"Disclosures": array:2 [ 0 => "Occupancy Permit Required" 1 => "Seller Property Disclosure" ] +"DocumentsAvailable": array:2 [ 0 => "Aerial Photos" 1 => "Boundary Survey" ] +"DocumentsChangeTimestamp": "2025-07-07T23:54:38Z" +"DocumentsCount": 4 +"ElementarySchool": "Pond Elem." +"FireplaceFeatures": array:1 [ 0 => "Gas" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Lafayette Sr. High" +"HighSchoolDistrict": "Rockwood R-VI" +"HomeWarrantyYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "60388444" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "75670797" +"ListOfficePhone": "314-495-7667" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Owner" +"LotFeatures": array:12 [ 0 => "Adjoins Wooded Area" 1 => "Agricultural" 2 => "Back Yard" 3 => "Cleared" 4 => "Garden" 5 => "Gently Rolling" 6 => "Meadow" 7 => "Orchard(s)" 8 => "Pasture" 9 => "Pond on Lot" 10 => "Private" 11 => "Suitable for Horses" ] +"LotSizeAcres": 8.08 +"LotSizeSource": "Survey" +"MLSAreaMajor": "347 - Lafayette" +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-07-07T13:43:35Z" +"MiddleOrJuniorSchool": "Wildwood Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-07" +"OriginalEntryTimestamp": "2025-07-07T13:43:35Z" +"OriginalListPrice": 579000 +"ParcelNumber": "25X420163" +"PhotosChangeTimestamp": "2025-07-07T13:44:38Z" +"PhotosCount": 14 +"RoomsTotal": "8" +"Sewer": array:1 [ 0 => "Septic Tank" ] +"ShowingContactType": array:1 [ 0 => "Listing Agent" ] +"ShowingRequirements": array:2 [ 0 => "Occupied" 1 => "Register and Show" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-07T13:43:35Z" +"StreetName": "Melrose" +"StreetNumber": "18543" +"StreetNumberNumeric": "18543" +"StreetSuffix": "Road" +"SubdivisionName": "Windy Acres" +"TaxAnnualAmount": "3637" +"TaxYear": "2024" +"Township": "Wildwood" +"WaterSource": array:1 [ 0 => "Well" ] +"WaterfrontFeatures": array:1 [ 0 => "Pond" ] +"WaterfrontYN": true +"YearBuiltSource": "Public Records" +"MIS_MainAndUpperLevelBathrooms": "2" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "579000.00" +"MIS_SecondMortgageYN": "0" +"MIS_AuctionYN": "0" +"MIS_PoolYN": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainLevelBathroomsHalf": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203718464')" +"provider_name": "MARIS" +"Media": array:14 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "686bcf0faf76bf68973c17c0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/87b10abad0b4064a8af519e7a2c3e9d3.webp" "MediaSize" => 54039 "LongDescription" => "View of yard with an outdoor structure and a barn" "ImageHeight" => 570 "MediaModificationTimestamp" => "2025-07-07T13:43:43.399Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-87b10abad0b4064a8af519e7a2c3e9d3.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x570" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "686bcf0faf76bf68973c17c1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/268442db9b7f8ad2da1af474520f69f5.webp" "MediaSize" => 175636 "LongDescription" => "View of yard" "ImageHeight" => 760 "MediaModificationTimestamp" => "2025-07-07T13:43:43.424Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-268442db9b7f8ad2da1af474520f69f5.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x760" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "686bcf0faf76bf68973c17c2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/9a17c4b0b12f35583d01f7bdf023ced5.webp" "MediaSize" => 76421 "ImageHeight" => 565 "MediaModificationTimestamp" => "2025-07-07T13:43:43.400Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-9a17c4b0b12f35583d01f7bdf023ced5.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x565" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "686bcf0faf76bf68973c17c3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/cbdab2732d2002d818e5b7173a12f7c1.webp" "MediaSize" => 88718 "LongDescription" => "Exterior view of an outdoor fire pit" "ImageHeight" => 758 "MediaModificationTimestamp" => "2025-07-07T13:43:43.398Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-cbdab2732d2002d818e5b7173a12f7c1.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x758" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "686bcf0faf76bf68973c17c4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/ae254c7254964f20c17da230571cc8ff.webp" "MediaSize" => 132861 "LongDescription" => "View of tree filled area featuring a view of rural / pastoral area" "ImageHeight" => 752 "MediaModificationTimestamp" => "2025-07-07T13:43:43.464Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-ae254c7254964f20c17da230571cc8ff.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x752" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "686bcf0faf76bf68973c17c5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/436432274f5b8f5c5235d2286b0e291e.webp" "MediaSize" => 119961 "ImageHeight" => 752 "MediaModificationTimestamp" => "2025-07-07T13:43:43.407Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-436432274f5b8f5c5235d2286b0e291e.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x752" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "686bcf0faf76bf68973c17c6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/afdf4da07bd54d1f0184780ec58e7e58.webp" "MediaSize" => 112539 "LongDescription" => "View of pole building with driveway" "ImageHeight" => 738 "MediaModificationTimestamp" => "2025-07-07T13:43:43.462Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-afdf4da07bd54d1f0184780ec58e7e58.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x738" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "686bcf0faf76bf68973c17c7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/db6c1b0dbbd61d25d5eaf8ad888581c0.webp" "MediaSize" => 111985 "LongDescription" => "View of yard with a water view, an outbuilding, and an outdoor structure" "ImageHeight" => 753 "MediaModificationTimestamp" => "2025-07-07T13:43:43.403Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-db6c1b0dbbd61d25d5eaf8ad888581c0.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x753" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "686bcf0faf76bf68973c17c8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/4f36c6b7e273519061b2c363fb766e0a.webp" "MediaSize" => 222752 "LongDescription" => "Single story home with french doors, a chimney, covered porch, and brick siding" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-07T13:43:43.448Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-4f36c6b7e273519061b2c363fb766e0a.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "686bcf0faf76bf68973c17c9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/f101b58ab4d29595f9c023fc0dfa0bf7.webp" "MediaSize" => 203800 "LongDescription" => "Ranch-style house featuring french doors, a front yard, a chimney, and brick siding" "ImageHeight" => 603 "MediaModificationTimestamp" => "2025-07-07T13:43:43.449Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-f101b58ab4d29595f9c023fc0dfa0bf7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x603" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "686bcf0faf76bf68973c17ca" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/6b8e87a26b2b0d687f632c501b3cb492.webp" "MediaSize" => 187591 "LongDescription" => "Doorway to property" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-07T13:43:43.437Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-6b8e87a26b2b0d687f632c501b3cb492.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "686bcf0faf76bf68973c17cb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/00f4562e9f72a7e220dd65cece236bc4.webp" "MediaSize" => 61209 "LongDescription" => "Kitchen with stainless steel appliances, decorative backsplash, light wood-style flooring, a chandelier, and white cabinetry" "ImageHeight" => 549 "MediaModificationTimestamp" => "2025-07-07T13:43:43.398Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-00f4562e9f72a7e220dd65cece236bc4.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x549" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "686bcf0faf76bf68973c17cc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/dc74efcc39f31a10773e8a56c1c39cc5.webp" "MediaSize" => 64617 "LongDescription" => "Bathroom featuring vanity and shower / bathtub combination with curtain" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-07T13:43:43.408Z" "ImageWidth" => 662 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-dc74efcc39f31a10773e8a56c1c39cc5.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "662x768" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "686bcf0faf76bf68973c17cd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/4ba928e4774b419560f08fd4ef094a8e.webp" "MediaSize" => 78691 "LongDescription" => "Survey map / technical document" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-07T13:43:43.461Z" "ImageWidth" => 653 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-4ba928e4774b419560f08fd4ef094a8e.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "653x768" ] ] +"ID": "23804" }
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 'MIS203718464'/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 'MIS203718464'&$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 'MIS203718464'/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 'MIS203718464'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2834 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "23804" +post_author: 1 +"ListingKey": "MIS203718464" +"ListingId": "25046528" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-07T23:54:38Z" +"RFModificationTimestamp": "2025-07-07T23:55:58.341109+00:00" +"ListPrice": 579000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 1232.0 +"BuildingAreaTotal": 0 +"City": "Wildwood" +"PostalCode": "63038" +"UnparsedAddress": "18543 Melrose Road, Wildwood, Missouri 63038" +"Coordinates": array:2 [ 0 => -90.696353 1 => 38.560754 ] +"Latitude": 38.560754 +"Longitude": -90.696353 +"YearBuilt": 1961 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jack Mccurdy" +"ListOfficeName": "S. R. Stock Properties, Inc." +"ListAgentMlsId": "JMCCURDY" +"ListOfficeMlsId": "SRSP01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "It's not common you get a chance to purchase your dream, but this is just that. Eight acres of some of the most gorgeous land in Missouri accompanied by two barns, fruit tree orchard, rose garden, a stocked pond, horse stalls, riding lots, and a cozy ranch make this home a once in a lifetime opprotunity. "Windy Acres Heights" sits cozy on hills overlooking your valley, a heritage pole barn able to comfortably hold four horse along with all your tack, and a private pond often alive with the sound of frogs and bird song in summer. This would make for the most prime of building lots in West County, with several large flat fields situated on the property along with electric and a well. The classic farmhouse on-site is a 3/1 and is undergoing a tasteful remodel to accompany the great location. With new soapstone countertops, completely new kitchen, new bathroom, luxury flooring, and an addition adding a mud room and an office. Owner wishes to sell the home as-is but has taken on some of the largest jobs already meaning minimum sweat recquired to finish this beautiful home. The current ranch is dreamy enough, but would make an excellent temporary house for anyone who wanted to be near the magic as they built their dream home. Just minutes from the Downtown Wildwood shopping district, local schools, great bike and horse trails, as well as scenic drives down historic route 66 the dream just keeps getting better. This one wont last long so reach out and grab your dream now" +"AboveGradeFinishedArea": 1232 +"AboveGradeFinishedAreaSource": "Owner" +"Appliances": array:5 [ 0 => "Stainless Steel Appliance(s)" 1 => "Electric Cooktop" 2 => "Dishwasher" 3 => "Range Hood" 4 => "Refrigerator" ] +"ArchitecturalStyle": array:1 [ 0 => "Ranch" ] +"Basement": array:1 [ 0 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:1 [ 0 => "Aluminum Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-07-07T13:48:20.196646+00:00" +"Disclosures": array:2 [ 0 => "Occupancy Permit Required" 1 => "Seller Property Disclosure" ] +"DocumentsAvailable": array:2 [ 0 => "Aerial Photos" 1 => "Boundary Survey" ] +"DocumentsChangeTimestamp": "2025-07-07T23:54:38Z" +"DocumentsCount": 4 +"ElementarySchool": "Pond Elem." +"FireplaceFeatures": array:1 [ 0 => "Gas" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Lafayette Sr. High" +"HighSchoolDistrict": "Rockwood R-VI" +"HomeWarrantyYN": true +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "60388444" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "75670797" +"ListOfficePhone": "314-495-7667" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Owner" +"LotFeatures": array:12 [ 0 => "Adjoins Wooded Area" 1 => "Agricultural" 2 => "Back Yard" 3 => "Cleared" 4 => "Garden" 5 => "Gently Rolling" 6 => "Meadow" 7 => "Orchard(s)" 8 => "Pasture" 9 => "Pond on Lot" 10 => "Private" 11 => "Suitable for Horses" ] +"LotSizeAcres": 8.08 +"LotSizeSource": "Survey" +"MLSAreaMajor": "347 - Lafayette" +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-07-07T13:43:35Z" +"MiddleOrJuniorSchool": "Wildwood Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-07" +"OriginalEntryTimestamp": "2025-07-07T13:43:35Z" +"OriginalListPrice": 579000 +"ParcelNumber": "25X420163" +"PhotosChangeTimestamp": "2025-07-07T13:44:38Z" +"PhotosCount": 14 +"RoomsTotal": "8" +"Sewer": array:1 [ 0 => "Septic Tank" ] +"ShowingContactType": array:1 [ 0 => "Listing Agent" ] +"ShowingRequirements": array:2 [ 0 => "Occupied" 1 => "Register and Show" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-07T13:43:35Z" +"StreetName": "Melrose" +"StreetNumber": "18543" +"StreetNumberNumeric": "18543" +"StreetSuffix": "Road" +"SubdivisionName": "Windy Acres" +"TaxAnnualAmount": "3637" +"TaxYear": "2024" +"Township": "Wildwood" +"WaterSource": array:1 [ 0 => "Well" ] +"WaterfrontFeatures": array:1 [ 0 => "Pond" ] +"WaterfrontYN": true +"YearBuiltSource": "Public Records" +"MIS_MainAndUpperLevelBathrooms": "2" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "579000.00" +"MIS_SecondMortgageYN": "0" +"MIS_AuctionYN": "0" +"MIS_PoolYN": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainLevelBathroomsHalf": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203718464')" +"provider_name": "MARIS" +"Media": array:14 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "686bcf0faf76bf68973c17c0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/87b10abad0b4064a8af519e7a2c3e9d3.webp" "MediaSize" => 54039 "LongDescription" => "View of yard with an outdoor structure and a barn" "ImageHeight" => 570 "MediaModificationTimestamp" => "2025-07-07T13:43:43.399Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-87b10abad0b4064a8af519e7a2c3e9d3.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x570" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "686bcf0faf76bf68973c17c1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/268442db9b7f8ad2da1af474520f69f5.webp" "MediaSize" => 175636 "LongDescription" => "View of yard" "ImageHeight" => 760 "MediaModificationTimestamp" => "2025-07-07T13:43:43.424Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-268442db9b7f8ad2da1af474520f69f5.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x760" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "686bcf0faf76bf68973c17c2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/9a17c4b0b12f35583d01f7bdf023ced5.webp" "MediaSize" => 76421 "ImageHeight" => 565 "MediaModificationTimestamp" => "2025-07-07T13:43:43.400Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-9a17c4b0b12f35583d01f7bdf023ced5.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x565" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "686bcf0faf76bf68973c17c3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/cbdab2732d2002d818e5b7173a12f7c1.webp" "MediaSize" => 88718 "LongDescription" => "Exterior view of an outdoor fire pit" "ImageHeight" => 758 "MediaModificationTimestamp" => "2025-07-07T13:43:43.398Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-cbdab2732d2002d818e5b7173a12f7c1.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x758" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "686bcf0faf76bf68973c17c4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/ae254c7254964f20c17da230571cc8ff.webp" "MediaSize" => 132861 "LongDescription" => "View of tree filled area featuring a view of rural / pastoral area" "ImageHeight" => 752 "MediaModificationTimestamp" => "2025-07-07T13:43:43.464Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-ae254c7254964f20c17da230571cc8ff.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x752" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "686bcf0faf76bf68973c17c5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/436432274f5b8f5c5235d2286b0e291e.webp" "MediaSize" => 119961 "ImageHeight" => 752 "MediaModificationTimestamp" => "2025-07-07T13:43:43.407Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-436432274f5b8f5c5235d2286b0e291e.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x752" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "686bcf0faf76bf68973c17c6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/afdf4da07bd54d1f0184780ec58e7e58.webp" "MediaSize" => 112539 "LongDescription" => "View of pole building with driveway" "ImageHeight" => 738 "MediaModificationTimestamp" => "2025-07-07T13:43:43.462Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-afdf4da07bd54d1f0184780ec58e7e58.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x738" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "686bcf0faf76bf68973c17c7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/db6c1b0dbbd61d25d5eaf8ad888581c0.webp" "MediaSize" => 111985 "LongDescription" => "View of yard with a water view, an outbuilding, and an outdoor structure" "ImageHeight" => 753 "MediaModificationTimestamp" => "2025-07-07T13:43:43.403Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-db6c1b0dbbd61d25d5eaf8ad888581c0.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x753" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "686bcf0faf76bf68973c17c8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/4f36c6b7e273519061b2c363fb766e0a.webp" "MediaSize" => 222752 "LongDescription" => "Single story home with french doors, a chimney, covered porch, and brick siding" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-07T13:43:43.448Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-4f36c6b7e273519061b2c363fb766e0a.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "686bcf0faf76bf68973c17c9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/f101b58ab4d29595f9c023fc0dfa0bf7.webp" "MediaSize" => 203800 "LongDescription" => "Ranch-style house featuring french doors, a front yard, a chimney, and brick siding" "ImageHeight" => 603 "MediaModificationTimestamp" => "2025-07-07T13:43:43.449Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-f101b58ab4d29595f9c023fc0dfa0bf7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x603" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "686bcf0faf76bf68973c17ca" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/6b8e87a26b2b0d687f632c501b3cb492.webp" "MediaSize" => 187591 "LongDescription" => "Doorway to property" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-07T13:43:43.437Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-6b8e87a26b2b0d687f632c501b3cb492.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "686bcf0faf76bf68973c17cb" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/00f4562e9f72a7e220dd65cece236bc4.webp" "MediaSize" => 61209 "LongDescription" => "Kitchen with stainless steel appliances, decorative backsplash, light wood-style flooring, a chandelier, and white cabinetry" "ImageHeight" => 549 "MediaModificationTimestamp" => "2025-07-07T13:43:43.398Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-00f4562e9f72a7e220dd65cece236bc4.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x549" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "686bcf0faf76bf68973c17cc" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/dc74efcc39f31a10773e8a56c1c39cc5.webp" "MediaSize" => 64617 "LongDescription" => "Bathroom featuring vanity and shower / bathtub combination with curtain" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-07T13:43:43.408Z" "ImageWidth" => 662 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-dc74efcc39f31a10773e8a56c1c39cc5.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "662x768" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "686bcf0faf76bf68973c17cd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/4ba928e4774b419560f08fd4ef094a8e.webp" "MediaSize" => 78691 "LongDescription" => "Survey map / technical document" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-07-07T13:43:43.461Z" "ImageWidth" => 653 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203718464/thumbnail-4ba928e4774b419560f08fd4ef094a8e.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "653x768" ] ] +"ID": "23804" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.2 seconds" ] ]