Attention Investors & Renovators! Spacious home in the quiet community of Staples. Featuring 4 bedrooms and 2 bathrooms. This property offers a great layout with plenty of potential for updates or full renovation project. Property is being sold “”AS IS, WHERE IS.”” (id:62650)
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:6 [ "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29585844 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445 +post_id: "1308508" +post_author: 1 +"ListingKey": "29585844" +"ListingId": "26007679" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-09T20:05:26Z" +"RFModificationTimestamp": "2026-06-09T20:09:16Z" +"ListPrice": 327100.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Leamington" +"PostalCode": "N0P2J0" +"UnparsedAddress": "908 Mersea Rd 10, Leamington, Ontario N0P2J0" +"Coordinates": array:2 [ 0 => -82.576964 1 => 42.146195 ] +"Latitude": 42.146195 +"Longitude": -82.576964 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Windsor-Essex County Association of REALTORS®" +"PublicRemarks": "Attention Investors & Renovators! Spacious home in the quiet community of Staples. Featuring 4 bedrooms and 2 bathrooms. This property offers a great layout with plenty of potential for updates or full renovation project. Property is being sold ""AS IS, WHERE IS."" (id:62650)" +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-04-10T18:26:16.152609+00:00" +"ExteriorFeatures": array:1 [ 0 => "Concrete/Stucco" ] +"Flooring": array:2 [ 0 => "Laminate" 1 => "Carpeted" ] +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2111039" +"ListOfficeKey": "295736" +"LotFeatures": array:1 [ 0 => "Front Driveway" ] +"LotSizeDimensions": "95.4 X" +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-04-10T15:10:21Z" +"PhotosCount": 3 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T19:59:52Z" +"Stories": "1.5" +"StreetName": "Mersea Rd 10" +"StreetNumber": "908" +"Rooms": array:10 [ 0 => array:11 [ "RoomKey" => "1655831950" "RoomType" => "3pc Bathroom" "ListingId" => "26007679" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.65Z" ] 1 => array:11 [ "RoomKey" => "1655831951" "RoomType" => "4pc Bathroom" "ListingId" => "26007679" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.65Z" ] 2 => array:11 [ "RoomKey" => "1655831952" "RoomType" => "Bedroom" "ListingId" => "26007679" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.65Z" ] 3 => array:11 [ "RoomKey" => "1655831953" "RoomType" => "Bedroom" "ListingId" => "26007679" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.65Z" ] 4 => array:11 [ "RoomKey" => "1655831954" "RoomType" => "Bedroom" "ListingId" => "26007679" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.66Z" ] 5 => array:11 [ "RoomKey" => "1655831955" "RoomType" => "Bedroom" "ListingId" => "26007679" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.66Z" ] 6 => array:11 [ "RoomKey" => "1655831956" "RoomType" => "Utility room" "ListingId" => "26007679" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.66Z" ] 7 => array:11 [ "RoomKey" => "1655831957" "RoomType" => "Other" "ListingId" => "26007679" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.66Z" ] 8 => array:11 [ "RoomKey" => "1655831958" "RoomType" => "Living room" "ListingId" => "26007679" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.66Z" ] 9 => array:11 [ "RoomKey" => "1655831959" "RoomType" => "Kitchen/Dining room" "ListingId" => "26007679" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29585844" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T19:59:52.66Z" ] ] +"ListAOR": "Windsor" +"TaxYear": 2026 +"ListAORKey": "34" +"ListingURL": "www.realtor.ca/real-estate/29585844/908-mersea-rd-10-leamington" +"StructureType": array:1 [ 0 => "House" ] +"GeocodeManualYN": false +"ZoningDescription": "A1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"OriginalEntryTimestamp": "2026-04-10T15:10:20.96Z" +"ListAgentNationalAssociationId": "1379595" +"ListOfficeNationalAssociationId": "1453432" +"Media": array:3 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "6583907115" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29585844/7c5c8c8a0a20dcb8c8d8657702dcf88d.webp" "MediaSize" => 121780 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29585844/thumbnail-7c5c8c8a0a20dcb8c8d8657702dcf88d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "26007679" "ResourceRecordKey" => "29585844" "ModificationTimestamp" => "2026-04-10T15:10:20.97Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "6583907187" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29585844/0638fc882b2beb1b9053047996f47b97.webp" "MediaSize" => 85014 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29585844/thumbnail-0638fc882b2beb1b9053047996f47b97.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26007679" "ResourceRecordKey" => "29585844" "ModificationTimestamp" => "2026-04-10T15:10:20.97Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "6583907283" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29585844/8876ad28592c86d4669016cf44568b69.webp" "MediaSize" => 94996 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29585844/thumbnail-8876ad28592c86d4669016cf44568b69.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26007679" "ResourceRecordKey" => "29585844" "ModificationTimestamp" => "2026-04-10T15:10:20.97Z" ] ] +"DaysOnMarket": 83 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29585844')" +"ID": "1308508" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.25 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 295736" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24882 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24827 +post_id: ? mixed +post_author: ? mixed +"OfficeName": null +"OfficeEmail": null +"OfficePhone": null +"OfficeMlsId": "295736" +"ModificationTimestamp": "2026-03-03T12:05:49Z" +"OriginatingSystemName": "CREA" +"OfficeKey": "295736" +"IDXOfficeParticipationYN": null +"MainOfficeKey": null +"MainOfficeMlsId": null +"OfficeAddress1": null +"OfficeAddress2": null +"OfficeBrokerKey": null +"OfficeCity": null +"OfficePostalCode": null +"OfficePostalCodePlus4": null +"OfficeStateOrProvince": null +"OfficeStatus": null +"OfficeAOR": null +"OfficeType": null +"OfficePhoneExt": null +"OfficeNationalAssociationId": null +"OriginalEntryTimestamp": null +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('295736')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2111039" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24778 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.25 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29585844'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25151 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29585844'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25167 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29585844' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-82.576964 42.146195)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25214 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] ]