Beautiful custom-built detached home (2006) available for lease in a high-demand Windsor location, offering 3+1 bedrooms and vacant possession. This well-maintained property features hardwood floors, a bright combined living and dining area, and an upgraded eat-in kitchen with granite countertops, tile flooring, and breakfast bar. The fully finished walkout basement with separate entrance includes additional bedroom(s), bathroom, and spacious great
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 29526247 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: "1262087" +post_author: 1 +"ListingKey": "29526247" +"ListingId": "X12929714" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-03-27T18:55:57Z" +"RFModificationTimestamp": "2026-03-27T19:39:55Z" +"ListPrice": 0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Windsor" +"PostalCode": "N8Y3P1" +"UnparsedAddress": "975 ALBERT ROAD, Windsor, Ontario N8Y3P1" +"Coordinates": array:2 [ 0 => -83.0026798 1 => 42.3214976 ] +"Latitude": 42.3214976 +"Longitude": -83.0026798 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Toronto Regional Real Estate Board" +"PublicRemarks": "Beautiful custom-built detached home (2006) available for lease in a high-demand Windsor location, offering 3+1 bedrooms and vacant possession. This well-maintained property features hardwood floors, a bright combined living and dining area, and an upgraded eat-in kitchen with granite countertops, tile flooring, and breakfast bar. The fully finished walkout basement with separate entrance includes additional bedroom(s), bathroom, and spacious great room - ideal for extended family or added living space. The primary bedroom offers a walk-in closet, and the home also features an upgraded driveway with concrete surrounding the property. Conveniently located near the University of Windsor, USA border, Detroit-Windsor Tunnel, schools, parks, transit, shopping, and all amenities. A great leasing opportunity in a prime location. (id:62650)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Window Coverings" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:5 [ 0 => "Finished" 1 => "Separate entrance" 2 => "Walk out" 3 => "N/A" 4 => "N/A" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2026-03-27T19:39:30.888317+00:00" +"Directions": "WALKER AND EDNA" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2057861" +"ListOfficeKey": "293109" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Carpet Free" ] +"LotSizeDimensions": "35 x 110 FT" +"ParkingFeatures": array:1 [ 0 => "Garage" ] +"PhotosChangeTimestamp": "2026-03-27T18:46:27Z" +"PhotosCount": 20 +"Sewer": array:1 [ 0 => "Sanitary sewer" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-03-27T18:46:27Z" +"Stories": "1.0" +"StreetName": "Albert" +"StreetNumber": "975" +"StreetSuffix": "Road" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Toronto" +"CityRegion": "Windsor" +"ListAORKey": "82" +"ListingURL": "www.realtor.ca/real-estate/29526247/975-albert-road-windsor-windsor" +"ParkingTotal": 7 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": false +"TotalActualRent": 2400 +"LivingAreaMaximum": 1500 +"LivingAreaMinimum": 1100 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 35.0 +"OriginalEntryTimestamp": "2026-03-27T18:46:27.27Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1333011" +"ListOfficeNationalAssociationId": "1422605" +"Media": array:20 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6546286264" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/e236a102453e4d2c9e1878147f0fb470.webp" "MediaSize" => 183430 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-e236a102453e4d2c9e1878147f0fb470.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6546286312" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/9b8a02a81a315cba75733efb38ee9ed5.webp" "MediaSize" => 179429 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-9b8a02a81a315cba75733efb38ee9ed5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6546286447" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/9a0714eae5932905f8f5bc5a4bdfa866.webp" "MediaSize" => 247186 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-9a0714eae5932905f8f5bc5a4bdfa866.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6546286498" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/dd3e63b288d131c3a27dd98efa1a3cc6.webp" "MediaSize" => 513130 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-dd3e63b288d131c3a27dd98efa1a3cc6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6546286575" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/ae018bd4dd09b9a6709f8854b74e09d9.webp" "MediaSize" => 166925 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-ae018bd4dd09b9a6709f8854b74e09d9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6546286642" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/f17ed25797e639838850634b741cba06.webp" "MediaSize" => 367866 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-f17ed25797e639838850634b741cba06.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6546286744" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/bcf979f64d9f0d605a478d1174a9297a.webp" "MediaSize" => 209461 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-bcf979f64d9f0d605a478d1174a9297a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6546286825" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/e65c242fa366ffb33f15760f80409cea.webp" "MediaSize" => 224454 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-e65c242fa366ffb33f15760f80409cea.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6546286861" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/5add230520d297a3c4bd12fbaa2102e5.webp" "MediaSize" => 354929 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-5add230520d297a3c4bd12fbaa2102e5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6546286958" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/d7ffbea0521a3256f7190c54fa0188e9.webp" "MediaSize" => 223331 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-d7ffbea0521a3256f7190c54fa0188e9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6546287030" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/45cb126b04d03c777293f56418145086.webp" "MediaSize" => 225422 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-45cb126b04d03c777293f56418145086.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6546287179" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/a08dd456a77d9cad148585a92b5b13dd.webp" "MediaSize" => 443285 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-a08dd456a77d9cad148585a92b5b13dd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6546287247" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/e73deed1b918fa7e0d438381afecf557.webp" "MediaSize" => 204699 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-e73deed1b918fa7e0d438381afecf557.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6546287309" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/b5ff9d21c73a888459f0c421cfe0da58.webp" "MediaSize" => 163806 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-b5ff9d21c73a888459f0c421cfe0da58.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6546287339" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/5e3354400e021a27786a7e964d7e0069.webp" "MediaSize" => 189540 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-5e3354400e021a27786a7e964d7e0069.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6546287352" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/9ac6e6154441888a1f0efdd55fa933be.webp" "MediaSize" => 205541 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-9ac6e6154441888a1f0efdd55fa933be.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6546287436" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/8e06e534142a4061ee6fd977404fdd38.webp" "MediaSize" => 190726 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-8e06e534142a4061ee6fd977404fdd38.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 17 => array:13 [ "Order" => 17 "MediaKey" => "6546287491" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/c178baabbfeff1778299600ce940003a.webp" "MediaSize" => 266263 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-c178baabbfeff1778299600ce940003a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 18 => array:13 [ "Order" => 18 "MediaKey" => "6546287588" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/fac7eeaafe2894dd62bf3aad8163df93.webp" "MediaSize" => 233649 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-fac7eeaafe2894dd62bf3aad8163df93.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] 19 => array:13 [ "Order" => 19 "MediaKey" => "6546287663" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29526247/1cc140d2eb1eb57c55e8c87f3709c36e.webp" "MediaSize" => 544182 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29526247/thumbnail-1cc140d2eb1eb57c55e8c87f3709c36e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X12929714" "ResourceRecordKey" => "29526247" "ModificationTimestamp" => "2026-03-27T18:46:27.28Z" ] ] +"DaysOnMarket": 99 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29526247')" +"ID": "1262087" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.13 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 293109" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24863 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2057861" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24821 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29526247'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25198 +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 '29526247'" => 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.16 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29526247' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-83.0026798 42.3214976)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25261 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.14 seconds" ] ]