WordPress database error: [The table 'DZl3SCX_mls_on_the_fly_cache' is full]
REPLACE INTO `DZl3SCX_mls_on_the_fly_cache` (`cache_key`, `cache_value`, `expires_at`, `type`, `count`, `created_at`, `updated_at`) VALUES ('RF-Query-Cache-d2b31112fd78a29ab04debcf292c20182903f1d5281c4fcaac049fe992725fc1', 'O:82:\"Realtyna\\MlsOnTheFly\\Components\\CloudPost\\SubComponents\\RFClient\\SDK\\RF\\RFResponse\":6:{s:5:\"items\";a:1:{i:0;O:91:\"Realtyna\\MlsOnTheFly\\Components\\CloudPost\\SubComponents\\RFClient\\SDK\\RF\\Entities\\RFProperty\":61:{s:10:\"ListingKey\";s:8:\"29762572\";s:9:\"ListingId\";s:8:\"SK036182\";s:12:\"PropertyType\";s:11:\"Residential\";s:15:\"PropertySubType\";s:13:\"Single Family\";s:14:\"StandardStatus\";s:6:\"Active\";s:21:\"ModificationTimestamp\";s:20:\"2026-05-20T23:20:31Z\";s:23:\"RFModificationTimestamp\";s:20:\"2026-05-20T23:38:04Z\";s:9:\"ListPrice\";d:499900;s:21:\"BathroomsTotalInteger\";d:3;s:13:\"BathroomsHalf\";i:0;s:13:\"BedroomsTotal\";d:5;s:11:\"LotSizeArea\";i:0;s:10:\"LivingArea\";d:1091;s:17:\"BuildingAreaTotal\";i:0;s:4:\"City\";s:9:\"Saskatoon\";s:10:\"PostalCode\";s:6:\"S7W1M9\";s:15:\"UnparsedAddress\";s:51:\"439 Stehwien STREET, Saskatoon, Saskatchewan S7W1M9\";s:11:\"Coordinates\";a:2:{i:0;d:-106.535868;i:1;d:52.176329;}s:8:\"Latitude\";d:52.176329;s:9:\"Longitude\";d:-106.535868;s:9:\"YearBuilt\";i:2026;s:24:\"InternetAddressDisplayYN\";b:1;s:9:\"FeedTypes\";s:3:\"IDX\";s:21:\"OriginatingSystemName\";s:35:\"Saskatchewan REALTORS® Association\";s:13:\"PublicRemarks\";s:1541:\"*ACCEPTING 5% DEPOSIT! RARE INVESTMENT OPPORTUNITY!!! FULLY DEVELOPED 2 BEDROOM LEGAL BASEMENT SUITE WITH SEPARATE SIDE DOOR ENTRY IS INCLUDED!!! Welcome to The Aspen Collection by Decora Homes, located in the highly sought-after neighbourhood of Aspen Ridge. The Phoenix model is a Bi-Level home offering 1,091 sq ft of open-concept living space with 3 bedrooms and 2 bathrooms on the main level, featuring luxury vinyl plank flooring throughout and quartz counter tops in the main kitchen. The primary bedroom includes a walk-in closet & 4-piece ensuite bathroom. This model includes a 2 bedroom, 1 bathroom legal basement suite with separate side entry — a great option for rental income or multi-generational living. Additional features include xeriscaped front landscaping, a concrete walkway from the sidewalk to the front door, and a 20x20 concrete parking pad with back alley access. Now available for Pre-Sale, with estimated completion roughly 6months from purchase. Buyers can choose from three thoughtfully curated colour palettes: Harmony, Tranquil, or Horizon. This lot also offers the option to add the \"Malibu Detached Garage,\" which features an additional ONE BEDROOM LEGAL RENTAL SUITE \"LOFT\" above the double detached garage. Add-on and upgrade options are available. These prices are based off of the buyers qualifying for their own construction mortgage. First time home buyer pricing starting at $478,000, please inquire for more details! Contact your Realtor today for more information and add-on pricing! (id:62783)\";s:18:\"ArchitecturalStyle\";a:1:{i:0;s:8:\"Bi-level\";}s:8:\"Basement\";a:2:{i:0;s:18:\"Partially finished\";i:1;s:4:\"Full\";}s:7:\"Cooling\";a:1:{i:0;s:13:\"Air exchanger\";}s:12:\"CreationDate\";s:32:\"2026-05-16T01:16:44.003869+00:00\";s:7:\"Heating\";a:2:{i:0;s:10:\"Forced air\";i:1;s:11:\"Natural gas\";}s:30:\"InternetEntireListingDisplayYN\";b:1;s:12:\"ListAgentKey\";s:7:\"1934192\";s:13:\"ListOfficeKey\";s:5:\"48299\";s:15:\"LivingAreaUnits\";s:11:\"square feet\";s:11:\"LotFeatures\";a:2:{i:0;s:11:\"Rectangular\";i:1;s:9:\"Sump Pump\";}s:17:\"LotSizeDimensions\";s:8:\"30x127.9\";s:15:\"ParkingFeatures\";a:3:{i:0;s:11:\"Parking Pad\";i:1;s:4:\"None\";i:2;s:16:\"Parking Space(s)\";}s:21:\"PhotosChangeTimestamp\";s:20:\"2026-05-15T22:37:00Z\";s:11:\"PhotosCount\";i:11;s:15:\"StateOrProvince\";s:12:\"Saskatchewan\";s:21:\"StatusChangeTimestamp\";s:20:\"2026-05-20T23:14:30Z\";s:5:\"Rooms\";a:16:{i:0;a:11:{s:7:\"RoomKey\";s:10:\"1640121894\";s:8:\"RoomType\";s:5:\"Foyer\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:7.3;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:4;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.19Z\";}i:1;a:11:{s:7:\"RoomKey\";s:10:\"1640121895\";s:8:\"RoomType\";s:11:\"Living room\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:11.3;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:10;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.19Z\";}i:2;a:11:{s:7:\"RoomKey\";s:10:\"1640121896\";s:8:\"RoomType\";s:11:\"Dining room\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:9.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:8;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.19Z\";}i:3;a:11:{s:7:\"RoomKey\";s:10:\"1640121897\";s:8:\"RoomType\";s:7:\"Kitchen\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:7.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:13.9;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:4;a:11:{s:7:\"RoomKey\";s:10:\"1640121898\";s:8:\"RoomType\";s:12:\"4pc Bathroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";N;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";N;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";N;s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:5;a:11:{s:7:\"RoomKey\";s:10:\"1640121899\";s:8:\"RoomType\";s:15:\"Primary Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:9.8;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:11.6;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:6;a:11:{s:7:\"RoomKey\";s:10:\"1640121900\";s:8:\"RoomType\";s:16:\"4pc Ensuite bath\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";N;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";N;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";N;s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:7;a:11:{s:7:\"RoomKey\";s:10:\"1640121901\";s:8:\"RoomType\";s:7:\"Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:9.6;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:9;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:8;a:11:{s:7:\"RoomKey\";s:10:\"1640121902\";s:8:\"RoomType\";s:7:\"Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:9.6;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:9;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:9;a:11:{s:7:\"RoomKey\";s:10:\"1640121903\";s:8:\"RoomType\";s:5:\"Other\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:10.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:13.2;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:10;a:11:{s:7:\"RoomKey\";s:10:\"1640121904\";s:8:\"RoomType\";s:12:\"Laundry room\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";N;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";N;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";N;s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:11;a:11:{s:7:\"RoomKey\";s:10:\"1640121905\";s:8:\"RoomType\";s:7:\"Kitchen\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:7.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:9;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}i:12;a:11:{s:7:\"RoomKey\";s:10:\"1640121906\";s:8:\"RoomType\";s:11:\"Living room\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:12;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:15;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}i:13;a:11:{s:7:\"RoomKey\";s:10:\"1640121907\";s:8:\"RoomType\";s:12:\"4pc Bathroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";N;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";N;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";N;s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}i:14;a:11:{s:7:\"RoomKey\";s:10:\"1640121908\";s:8:\"RoomType\";s:7:\"Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:11.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:9.1;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}i:15;a:11:{s:7:\"RoomKey\";s:10:\"1640121909\";s:8:\"RoomType\";s:7:\"Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:8.6;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:8;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}}s:7:\"ListAOR\";s:12:\"Saskatchewan\";s:10:\"CityRegion\";s:11:\"Aspen Ridge\";s:10:\"ListAORKey\";s:2:\"27\";s:10:\"ListingURL\";s:77:\"www.realtor.ca/real-estate/29762572/439-stehwien-street-saskatoon-aspen-ridge\";s:13:\"StructureType\";a:1:{i:0;s:5:\"House\";}s:14:\"CoListAgentKey\";s:7:\"2178164\";s:14:\"CommonInterest\";s:8:\"Freehold\";s:15:\"CoListOfficeKey\";s:5:\"48299\";s:15:\"GeocodeManualYN\";b:1;s:21:\"FrontageLengthNumeric\";d:30;s:22:\"OriginalEntryTimestamp\";s:23:\"2026-05-15T22:37:00.76Z\";s:26:\"FrontageLengthNumericUnits\";s:4:\"feet\";s:30:\"ListAgentNationalAssociationId\";s:7:\"1233968\";s:31:\"ListOfficeNationalAssociationId\";s:7:\"1008841\";s:32:\"CoListAgentNationalAssociationId\";s:7:\"1428072\";s:33:\"CoListOfficeNationalAssociationId\";s:7:\"1008841\";s:5:\"Media\";a:11:{i:0;a:13:{s:5:\"Order\";i:1;s:8:\"MediaKey\";s:15:\"29762572_4890_1\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/5d099c9de0ab73db339ba9f0c84bf702.webp\";s:9:\"MediaSize\";i:238402;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-5d099c9de0ab73db339ba9f0c84bf702.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:1;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:1;a:13:{s:5:\"Order\";i:2;s:8:\"MediaKey\";s:15:\"29762572_4890_2\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/645860c25a8939b0becc3c9ae02b906a.webp\";s:9:\"MediaSize\";i:69047;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-645860c25a8939b0becc3c9ae02b906a.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:2;a:13:{s:5:\"Order\";i:3;s:8:\"MediaKey\";s:15:\"29762572_4890_3\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/4b66f164bf9c13159909d07ec858ea12.webp\";s:9:\"MediaSize\";i:69175;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-4b66f164bf9c13159909d07ec858ea12.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:3;a:13:{s:5:\"Order\";i:4;s:8:\"MediaKey\";s:15:\"29762572_4890_4\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/3c5d6674bf064407d90208a72161e6d3.webp\";s:9:\"MediaSize\";i:121512;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-3c5d6674bf064407d90208a72161e6d3.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:4;a:13:{s:5:\"Order\";i:5;s:8:\"MediaKey\";s:15:\"29762572_4890_5\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/cf960cff8ee8e62b70a87eb27c8bccd3.webp\";s:9:\"MediaSize\";i:167214;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-cf960cff8ee8e62b70a87eb27c8bccd3.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:5;a:13:{s:5:\"Order\";i:6;s:8:\"MediaKey\";s:15:\"29762572_4890_6\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/238156478aaec302485f3a903f1846db.webp\";s:9:\"MediaSize\";i:135760;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-238156478aaec302485f3a903f1846db.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:6;a:13:{s:5:\"Order\";i:7;s:8:\"MediaKey\";s:15:\"29762572_4890_7\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/50bbf2d45e50f5a43e05106d006d2ede.webp\";s:9:\"MediaSize\";i:174316;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-50bbf2d45e50f5a43e05106d006d2ede.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:7;a:13:{s:5:\"Order\";i:8;s:8:\"MediaKey\";s:15:\"29762572_4890_8\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/0c234466ab6679c61f64017491d4d63f.webp\";s:9:\"MediaSize\";i:195181;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-0c234466ab6679c61f64017491d4d63f.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:8;a:13:{s:5:\"Order\";i:9;s:8:\"MediaKey\";s:15:\"29762572_4890_9\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/02969e3d6f1de8fe358064ea1b9772aa.webp\";s:9:\"MediaSize\";i:131586;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-02969e3d6f1de8fe358064ea1b9772aa.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:9;a:13:{s:5:\"Order\";i:10;s:8:\"MediaKey\";s:16:\"29762572_4890_10\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/fc2d01f71ddeea49ea8d347c5e654889.webp\";s:9:\"MediaSize\";i:180335;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-fc2d01f71ddeea49ea8d347c5e654889.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:10;a:13:{s:5:\"Order\";i:11;s:8:\"MediaKey\";s:16:\"29762572_4890_11\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/7de9ebb16f92b884a60b189b8d797ac3.webp\";s:9:\"MediaSize\";i:22662;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-7de9ebb16f92b884a60b189b8d797ac3.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}}s:12:\"DaysOnMarket\";i:28;s:9:\"@odata.id\";s:64:\"https://api.realtyfeed.com/realtyfeed/odata/Property(\'29762572\')\";}}s:7:\"success\";b:1;s:9:\"page_size\";i:1;s:10:\"page_count\";i:1;s:5:\"count\";i:1;s:9:\"after_key\";s:0:\"\";}', '2026-06-13 07:16:26', 'temporary', 1, '2026-06-13 07:11:26', '2026-06-13 07:11:26')

WordPress database error: [The table 'DZl3SCX_mls_on_the_fly_cache' is full]
REPLACE INTO `DZl3SCX_mls_on_the_fly_cache` (`cache_key`, `cache_value`, `expires_at`, `type`, `count`, `created_at`, `updated_at`) VALUES ('RF-Query-Cache-Posts-d2b31112fd78a29ab04debcf292c20182903f1d5281c4fcaac049fe992725fc1', 'a:1:{i:0;O:7:\"WP_Post\":26:{s:2:\"ID\";s:7:\"1429852\";s:11:\"post_author\";i:1;s:9:\"post_date\";s:19:\"0000-00-00 00:00:00\";s:13:\"post_date_gmt\";s:19:\"0000-00-00 00:00:00\";s:12:\"post_content\";s:1544:\"*ACCEPTING 5% DEPOSIT! RARE INVESTMENT OPPORTUNITY!!! FULLY DEVELOPED 2 BEDROOM LEGAL BASEMENT SUITE WITH SEPARATE SIDE DOOR ENTRY IS INCLUDED!!! Welcome to The Aspen Collection by Decora Homes, located in the highly sought-after neighbourhood of Aspen Ridge. The Phoenix model is a Bi-Level home offering 1, 091 sq ft of open-concept living space with 3 bedrooms and 2 bathrooms on the main level, featuring luxury vinyl plank flooring throughout and quartz counter tops in the main kitchen. The primary bedroom includes a walk-in closet & 4-piece ensuite bathroom. This model includes a 2 bedroom, 1 bathroom legal basement suite with separate side entry — a great option for rental income or multi-generational living. Additional features include xeriscaped front landscaping, a concrete walkway from the sidewalk to the front door, and a 20x20 concrete parking pad with back alley access. Now available for Pre-Sale, with estimated completion roughly 6months from purchase. Buyers can choose from three thoughtfully curated colour palettes: Harmony, Tranquil, or Horizon. This lot also offers the option to add the \"Malibu Detached Garage, \" which features an additional ONE BEDROOM LEGAL RENTAL SUITE \"LOFT\" above the double detached garage. Add-on and upgrade options are available. These prices are based off of the buyers qualifying for their own construction mortgage. First time home buyer pricing starting at $478, 000, please inquire for more details! Contact your Realtor today for more information and add-on pricing! (id:62783)\";s:10:\"post_title\";s:31:\"Saskatoon, Saskatchewan, S7W1M9\";s:12:\"post_excerpt\";s:27:\"Residential - Single Family\";s:11:\"post_status\";s:7:\"publish\";s:14:\"comment_status\";s:4:\"open\";s:11:\"ping_status\";s:4:\"open\";s:13:\"post_password\";s:0:\"\";s:9:\"post_name\";s:8:\"29762572\";s:7:\"to_ping\";s:0:\"\";s:6:\"pinged\";s:0:\"\";s:13:\"post_modified\";s:19:\"0000-00-00 00:00:00\";s:17:\"post_modified_gmt\";s:19:\"0000-00-00 00:00:00\";s:21:\"post_content_filtered\";s:0:\"\";s:11:\"post_parent\";i:0;s:4:\"guid\";s:0:\"\";s:10:\"menu_order\";i:0;s:9:\"post_type\";s:8:\"property\";s:14:\"post_mime_type\";s:0:\"\";s:13:\"comment_count\";s:1:\"0\";s:6:\"filter\";s:3:\"raw\";s:6:\"medias\";a:11:{i:0;a:13:{s:5:\"Order\";i:1;s:8:\"MediaKey\";s:15:\"29762572_4890_1\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/5d099c9de0ab73db339ba9f0c84bf702.webp\";s:9:\"MediaSize\";i:238402;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-5d099c9de0ab73db339ba9f0c84bf702.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:1;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:1;a:13:{s:5:\"Order\";i:2;s:8:\"MediaKey\";s:15:\"29762572_4890_2\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/645860c25a8939b0becc3c9ae02b906a.webp\";s:9:\"MediaSize\";i:69047;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-645860c25a8939b0becc3c9ae02b906a.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:2;a:13:{s:5:\"Order\";i:3;s:8:\"MediaKey\";s:15:\"29762572_4890_3\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/4b66f164bf9c13159909d07ec858ea12.webp\";s:9:\"MediaSize\";i:69175;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-4b66f164bf9c13159909d07ec858ea12.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:3;a:13:{s:5:\"Order\";i:4;s:8:\"MediaKey\";s:15:\"29762572_4890_4\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/3c5d6674bf064407d90208a72161e6d3.webp\";s:9:\"MediaSize\";i:121512;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-3c5d6674bf064407d90208a72161e6d3.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:4;a:13:{s:5:\"Order\";i:5;s:8:\"MediaKey\";s:15:\"29762572_4890_5\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/cf960cff8ee8e62b70a87eb27c8bccd3.webp\";s:9:\"MediaSize\";i:167214;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-cf960cff8ee8e62b70a87eb27c8bccd3.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:5;a:13:{s:5:\"Order\";i:6;s:8:\"MediaKey\";s:15:\"29762572_4890_6\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/238156478aaec302485f3a903f1846db.webp\";s:9:\"MediaSize\";i:135760;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-238156478aaec302485f3a903f1846db.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:6;a:13:{s:5:\"Order\";i:7;s:8:\"MediaKey\";s:15:\"29762572_4890_7\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/50bbf2d45e50f5a43e05106d006d2ede.webp\";s:9:\"MediaSize\";i:174316;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-50bbf2d45e50f5a43e05106d006d2ede.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:7;a:13:{s:5:\"Order\";i:8;s:8:\"MediaKey\";s:15:\"29762572_4890_8\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/0c234466ab6679c61f64017491d4d63f.webp\";s:9:\"MediaSize\";i:195181;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-0c234466ab6679c61f64017491d4d63f.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:8;a:13:{s:5:\"Order\";i:9;s:8:\"MediaKey\";s:15:\"29762572_4890_9\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/02969e3d6f1de8fe358064ea1b9772aa.webp\";s:9:\"MediaSize\";i:131586;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-02969e3d6f1de8fe358064ea1b9772aa.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:9;a:13:{s:5:\"Order\";i:10;s:8:\"MediaKey\";s:16:\"29762572_4890_10\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/fc2d01f71ddeea49ea8d347c5e654889.webp\";s:9:\"MediaSize\";i:180335;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-fc2d01f71ddeea49ea8d347c5e654889.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:10;a:13:{s:5:\"Order\";i:11;s:8:\"MediaKey\";s:16:\"29762572_4890_11\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/7de9ebb16f92b884a60b189b8d797ac3.webp\";s:9:\"MediaSize\";i:22662;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-7de9ebb16f92b884a60b189b8d797ac3.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}}s:9:\"meta_data\";a:113:{s:12:\"wpl_add_date\";s:23:\"2026-05-15T22:37:00.76Z\";s:23:\"wpl_architectural_style\";a:1:{i:0;s:8:\"Bi-level\";}s:13:\"wpl_bathrooms\";s:1:\"3\";s:12:\"wpl_bedrooms\";s:1:\"5\";s:14:\"wpl_build_year\";s:4:\"2026\";s:13:\"wpl_confirmed\";s:1:\"1\";s:9:\"wpl_f_130\";a:2:{i:0;s:10:\"Forced air\";i:1;s:11:\"Natural gas\";}s:9:\"wpl_f_134\";a:1:{i:0;s:13:\"Air exchanger\";}s:9:\"wpl_f_137\";a:2:{i:0;s:18:\"Partially finished\";i:1;s:4:\"Full\";}s:9:\"wpl_f_150\";a:3:{i:0;s:11:\"Parking Pad\";i:1;s:4:\"None\";i:2;s:16:\"Parking Space(s)\";}s:13:\"wpl_field_308\";s:1544:\"*ACCEPTING 5% DEPOSIT! RARE INVESTMENT OPPORTUNITY!!! FULLY DEVELOPED 2 BEDROOM LEGAL BASEMENT SUITE WITH SEPARATE SIDE DOOR ENTRY IS INCLUDED!!! Welcome to The Aspen Collection by Decora Homes, located in the highly sought-after neighbourhood of Aspen Ridge. The Phoenix model is a Bi-Level home offering 1, 091 sq ft of open-concept living space with 3 bedrooms and 2 bathrooms on the main level, featuring luxury vinyl plank flooring throughout and quartz counter tops in the main kitchen. The primary bedroom includes a walk-in closet & 4-piece ensuite bathroom. This model includes a 2 bedroom, 1 bathroom legal basement suite with separate side entry — a great option for rental income or multi-generational living. Additional features include xeriscaped front landscaping, a concrete walkway from the sidewalk to the front door, and a 20x20 concrete parking pad with back alley access. Now available for Pre-Sale, with estimated completion roughly 6months from purchase. Buyers can choose from three thoughtfully curated colour palettes: Harmony, Tranquil, or Horizon. This lot also offers the option to add the \"Malibu Detached Garage, \" which features an additional ONE BEDROOM LEGAL RENTAL SUITE \"LOFT\" above the double detached garage. Add-on and upgrade options are available. These prices are based off of the buyers qualifying for their own construction mortgage. First time home buyer pricing starting at $478, 000, please inquire for more details! Contact your Realtor today for more information and add-on pricing! (id:62783)\";s:13:\"wpl_finalized\";s:1:\"1\";s:16:\"wpl_googlemap_ln\";s:11:\"-106.535868\";s:16:\"wpl_googlemap_lt\";s:9:\"52.176329\";s:21:\"wpl_list_agent_mls_id\";s:7:\"1934192\";s:22:\"wpl_list_office_mls_id\";s:5:\"48299\";s:11:\"wpl_listing\";s:8:\"For Sale\";s:18:\"wpl_listing_status\";s:6:\"Active\";s:15:\"wpl_living_area\";s:4:\"1091\";s:18:\"wpl_living_area_si\";s:4:\"1091\";s:20:\"wpl_living_area_unit\";s:1:\"1\";s:17:\"wpl_lot_area_unit\";s:1:\"3\";s:18:\"wpl_location1_name\";s:2:\"CA\";s:18:\"wpl_location2_name\";s:12:\"Saskatchewan\";s:18:\"wpl_location4_name\";s:9:\"Saskatoon\";s:16:\"wpl_lot_features\";a:2:{i:0;s:11:\"Rectangular\";i:1;s:9:\"Sump Pump\";}s:23:\"wpl_lot_size_dimensions\";s:8:\"30x127.9\";s:10:\"wpl_mls_id\";s:8:\"SK036182\";s:26:\"wpl_modification_timestamp\";s:20:\"2026-05-20T23:20:31Z\";s:27:\"wpl_originating_system_name\";s:35:\"Saskatchewan REALTORS® Association\";s:12:\"wpl_pic_numb\";s:2:\"11\";s:9:\"wpl_price\";s:6:\"499900\";s:12:\"wpl_price_si\";s:6:\"499900\";s:14:\"wpl_price_unit\";s:3:\"260\";s:21:\"wpl_property_sub_type\";s:13:\"Single Family\";s:17:\"wpl_property_type\";s:11:\"Residential\";s:10:\"wpl_ref_id\";s:8:\"29762572\";s:16:\"wpl_show_address\";s:1:\"1\";s:10:\"wpl_source\";s:2:\"RF\";s:27:\"wpl_status_change_timestamp\";s:20:\"2026-05-20T23:14:30Z\";s:17:\"wpl_location_text\";s:51:\"439 Stehwien STREET, Saskatoon, Saskatchewan S7W1M9\";s:12:\"wpl_zip_name\";s:6:\"S7W1M9\";s:14:\"wpl_office_key\";s:5:\"48299\";s:16:\"wpl_our_listings\";s:5:\"false\";s:20:\"realty_feed_raw_data\";O:91:\"Realtyna\\MlsOnTheFly\\Components\\CloudPost\\SubComponents\\RFClient\\SDK\\RF\\Entities\\RFProperty\":64:{s:7:\"post_id\";s:7:\"1429852\";s:11:\"post_author\";i:1;s:10:\"ListingKey\";s:8:\"29762572\";s:9:\"ListingId\";s:8:\"SK036182\";s:12:\"PropertyType\";s:11:\"Residential\";s:15:\"PropertySubType\";s:13:\"Single Family\";s:14:\"StandardStatus\";s:6:\"Active\";s:21:\"ModificationTimestamp\";s:20:\"2026-05-20T23:20:31Z\";s:23:\"RFModificationTimestamp\";s:20:\"2026-05-20T23:38:04Z\";s:9:\"ListPrice\";d:499900;s:21:\"BathroomsTotalInteger\";d:3;s:13:\"BathroomsHalf\";i:0;s:13:\"BedroomsTotal\";d:5;s:11:\"LotSizeArea\";i:0;s:10:\"LivingArea\";d:1091;s:17:\"BuildingAreaTotal\";i:0;s:4:\"City\";s:9:\"Saskatoon\";s:10:\"PostalCode\";s:6:\"S7W1M9\";s:15:\"UnparsedAddress\";s:51:\"439 Stehwien STREET, Saskatoon, Saskatchewan S7W1M9\";s:11:\"Coordinates\";a:2:{i:0;d:-106.535868;i:1;d:52.176329;}s:8:\"Latitude\";d:52.176329;s:9:\"Longitude\";d:-106.535868;s:9:\"YearBuilt\";i:2026;s:24:\"InternetAddressDisplayYN\";b:1;s:9:\"FeedTypes\";s:3:\"IDX\";s:21:\"OriginatingSystemName\";s:35:\"Saskatchewan REALTORS® Association\";s:13:\"PublicRemarks\";s:1541:\"*ACCEPTING 5% DEPOSIT! RARE INVESTMENT OPPORTUNITY!!! FULLY DEVELOPED 2 BEDROOM LEGAL BASEMENT SUITE WITH SEPARATE SIDE DOOR ENTRY IS INCLUDED!!! Welcome to The Aspen Collection by Decora Homes, located in the highly sought-after neighbourhood of Aspen Ridge. The Phoenix model is a Bi-Level home offering 1,091 sq ft of open-concept living space with 3 bedrooms and 2 bathrooms on the main level, featuring luxury vinyl plank flooring throughout and quartz counter tops in the main kitchen. The primary bedroom includes a walk-in closet & 4-piece ensuite bathroom. This model includes a 2 bedroom, 1 bathroom legal basement suite with separate side entry — a great option for rental income or multi-generational living. Additional features include xeriscaped front landscaping, a concrete walkway from the sidewalk to the front door, and a 20x20 concrete parking pad with back alley access. Now available for Pre-Sale, with estimated completion roughly 6months from purchase. Buyers can choose from three thoughtfully curated colour palettes: Harmony, Tranquil, or Horizon. This lot also offers the option to add the \"Malibu Detached Garage,\" which features an additional ONE BEDROOM LEGAL RENTAL SUITE \"LOFT\" above the double detached garage. Add-on and upgrade options are available. These prices are based off of the buyers qualifying for their own construction mortgage. First time home buyer pricing starting at $478,000, please inquire for more details! Contact your Realtor today for more information and add-on pricing! (id:62783)\";s:18:\"ArchitecturalStyle\";a:1:{i:0;s:8:\"Bi-level\";}s:8:\"Basement\";a:2:{i:0;s:18:\"Partially finished\";i:1;s:4:\"Full\";}s:7:\"Cooling\";a:1:{i:0;s:13:\"Air exchanger\";}s:12:\"CreationDate\";s:32:\"2026-05-16T01:16:44.003869+00:00\";s:7:\"Heating\";a:2:{i:0;s:10:\"Forced air\";i:1;s:11:\"Natural gas\";}s:30:\"InternetEntireListingDisplayYN\";b:1;s:12:\"ListAgentKey\";s:7:\"1934192\";s:13:\"ListOfficeKey\";s:5:\"48299\";s:15:\"LivingAreaUnits\";s:11:\"square feet\";s:11:\"LotFeatures\";a:2:{i:0;s:11:\"Rectangular\";i:1;s:9:\"Sump Pump\";}s:17:\"LotSizeDimensions\";s:8:\"30x127.9\";s:15:\"ParkingFeatures\";a:3:{i:0;s:11:\"Parking Pad\";i:1;s:4:\"None\";i:2;s:16:\"Parking Space(s)\";}s:21:\"PhotosChangeTimestamp\";s:20:\"2026-05-15T22:37:00Z\";s:11:\"PhotosCount\";i:11;s:15:\"StateOrProvince\";s:12:\"Saskatchewan\";s:21:\"StatusChangeTimestamp\";s:20:\"2026-05-20T23:14:30Z\";s:5:\"Rooms\";a:16:{i:0;a:11:{s:7:\"RoomKey\";s:10:\"1640121894\";s:8:\"RoomType\";s:5:\"Foyer\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:7.3;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:4;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.19Z\";}i:1;a:11:{s:7:\"RoomKey\";s:10:\"1640121895\";s:8:\"RoomType\";s:11:\"Living room\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:11.3;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:10;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.19Z\";}i:2;a:11:{s:7:\"RoomKey\";s:10:\"1640121896\";s:8:\"RoomType\";s:11:\"Dining room\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:9.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:8;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.19Z\";}i:3;a:11:{s:7:\"RoomKey\";s:10:\"1640121897\";s:8:\"RoomType\";s:7:\"Kitchen\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:7.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:13.9;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:4;a:11:{s:7:\"RoomKey\";s:10:\"1640121898\";s:8:\"RoomType\";s:12:\"4pc Bathroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";N;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";N;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";N;s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:5;a:11:{s:7:\"RoomKey\";s:10:\"1640121899\";s:8:\"RoomType\";s:15:\"Primary Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:9.8;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:11.6;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:6;a:11:{s:7:\"RoomKey\";s:10:\"1640121900\";s:8:\"RoomType\";s:16:\"4pc Ensuite bath\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";N;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";N;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";N;s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:7;a:11:{s:7:\"RoomKey\";s:10:\"1640121901\";s:8:\"RoomType\";s:7:\"Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:9.6;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:9;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:8;a:11:{s:7:\"RoomKey\";s:10:\"1640121902\";s:8:\"RoomType\";s:7:\"Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:10:\"Main level\";s:9:\"RoomWidth\";d:9.6;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:9;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:9;a:11:{s:7:\"RoomKey\";s:10:\"1640121903\";s:8:\"RoomType\";s:5:\"Other\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:10.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:13.2;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:10;a:11:{s:7:\"RoomKey\";s:10:\"1640121904\";s:8:\"RoomType\";s:12:\"Laundry room\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";N;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";N;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";N;s:21:\"ModificationTimestamp\";s:22:\"2026-05-20T23:14:30.2Z\";}i:11;a:11:{s:7:\"RoomKey\";s:10:\"1640121905\";s:8:\"RoomType\";s:7:\"Kitchen\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:7.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:9;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}i:12;a:11:{s:7:\"RoomKey\";s:10:\"1640121906\";s:8:\"RoomType\";s:11:\"Living room\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:12;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:15;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}i:13;a:11:{s:7:\"RoomKey\";s:10:\"1640121907\";s:8:\"RoomType\";s:12:\"4pc Bathroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";N;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";N;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";N;s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}i:14;a:11:{s:7:\"RoomKey\";s:10:\"1640121908\";s:8:\"RoomType\";s:7:\"Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:11.1;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:9.1;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}i:15;a:11:{s:7:\"RoomKey\";s:10:\"1640121909\";s:8:\"RoomType\";s:7:\"Bedroom\";s:9:\"ListingId\";s:8:\"SK036182\";s:9:\"RoomLevel\";s:8:\"Basement\";s:9:\"RoomWidth\";d:8.6;s:10:\"ListingKey\";s:8:\"29762572\";s:10:\"RoomLength\";d:8;s:14:\"RoomDimensions\";N;s:15:\"RoomDescription\";N;s:20:\"RoomLengthWidthUnits\";s:4:\"feet\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-20T23:14:30.21Z\";}}s:7:\"ListAOR\";s:12:\"Saskatchewan\";s:10:\"CityRegion\";s:11:\"Aspen Ridge\";s:10:\"ListAORKey\";s:2:\"27\";s:10:\"ListingURL\";s:77:\"www.realtor.ca/real-estate/29762572/439-stehwien-street-saskatoon-aspen-ridge\";s:13:\"StructureType\";a:1:{i:0;s:5:\"House\";}s:14:\"CoListAgentKey\";s:7:\"2178164\";s:14:\"CommonInterest\";s:8:\"Freehold\";s:15:\"CoListOfficeKey\";s:5:\"48299\";s:15:\"GeocodeManualYN\";b:1;s:21:\"FrontageLengthNumeric\";d:30;s:22:\"OriginalEntryTimestamp\";s:23:\"2026-05-15T22:37:00.76Z\";s:26:\"FrontageLengthNumericUnits\";s:4:\"feet\";s:30:\"ListAgentNationalAssociationId\";s:7:\"1233968\";s:31:\"ListOfficeNationalAssociationId\";s:7:\"1008841\";s:32:\"CoListAgentNationalAssociationId\";s:7:\"1428072\";s:33:\"CoListOfficeNationalAssociationId\";s:7:\"1008841\";s:5:\"Media\";a:11:{i:0;a:13:{s:5:\"Order\";i:1;s:8:\"MediaKey\";s:15:\"29762572_4890_1\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/5d099c9de0ab73db339ba9f0c84bf702.webp\";s:9:\"MediaSize\";i:238402;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-5d099c9de0ab73db339ba9f0c84bf702.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:1;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:1;a:13:{s:5:\"Order\";i:2;s:8:\"MediaKey\";s:15:\"29762572_4890_2\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/645860c25a8939b0becc3c9ae02b906a.webp\";s:9:\"MediaSize\";i:69047;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-645860c25a8939b0becc3c9ae02b906a.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:2;a:13:{s:5:\"Order\";i:3;s:8:\"MediaKey\";s:15:\"29762572_4890_3\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/4b66f164bf9c13159909d07ec858ea12.webp\";s:9:\"MediaSize\";i:69175;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-4b66f164bf9c13159909d07ec858ea12.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:3;a:13:{s:5:\"Order\";i:4;s:8:\"MediaKey\";s:15:\"29762572_4890_4\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/3c5d6674bf064407d90208a72161e6d3.webp\";s:9:\"MediaSize\";i:121512;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-3c5d6674bf064407d90208a72161e6d3.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:4;a:13:{s:5:\"Order\";i:5;s:8:\"MediaKey\";s:15:\"29762572_4890_5\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/cf960cff8ee8e62b70a87eb27c8bccd3.webp\";s:9:\"MediaSize\";i:167214;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-cf960cff8ee8e62b70a87eb27c8bccd3.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:5;a:13:{s:5:\"Order\";i:6;s:8:\"MediaKey\";s:15:\"29762572_4890_6\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/238156478aaec302485f3a903f1846db.webp\";s:9:\"MediaSize\";i:135760;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-238156478aaec302485f3a903f1846db.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:6;a:13:{s:5:\"Order\";i:7;s:8:\"MediaKey\";s:15:\"29762572_4890_7\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/50bbf2d45e50f5a43e05106d006d2ede.webp\";s:9:\"MediaSize\";i:174316;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-50bbf2d45e50f5a43e05106d006d2ede.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:7;a:13:{s:5:\"Order\";i:8;s:8:\"MediaKey\";s:15:\"29762572_4890_8\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/0c234466ab6679c61f64017491d4d63f.webp\";s:9:\"MediaSize\";i:195181;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-0c234466ab6679c61f64017491d4d63f.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:8;a:13:{s:5:\"Order\";i:9;s:8:\"MediaKey\";s:15:\"29762572_4890_9\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/02969e3d6f1de8fe358064ea1b9772aa.webp\";s:9:\"MediaSize\";i:131586;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-02969e3d6f1de8fe358064ea1b9772aa.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:9;a:13:{s:5:\"Order\";i:10;s:8:\"MediaKey\";s:16:\"29762572_4890_10\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/fc2d01f71ddeea49ea8d347c5e654889.webp\";s:9:\"MediaSize\";i:180335;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-fc2d01f71ddeea49ea8d347c5e654889.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}i:10;a:13:{s:5:\"Order\";i:11;s:8:\"MediaKey\";s:16:\"29762572_4890_11\";s:8:\"MediaURL\";s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/7de9ebb16f92b884a60b189b8d797ac3.webp\";s:9:\"MediaSize\";i:22662;s:9:\"MediaType\";s:4:\"webp\";s:9:\"Thumbnail\";s:90:\"https://cdn.realtyfeed.com/cdn/26/29762572/thumbnail-7de9ebb16f92b884a60b189b8d797ac3.webp\";s:12:\"ResourceName\";s:8:\"Property\";s:13:\"MediaCategory\";s:14:\"Property Photo\";s:15:\"LongDescription\";N;s:16:\"PreferredPhotoYN\";b:0;s:16:\"ResourceRecordId\";s:8:\"SK036182\";s:17:\"ResourceRecordKey\";s:8:\"29762572\";s:21:\"ModificationTimestamp\";s:23:\"2026-05-15T22:37:00.77Z\";}}s:12:\"DaysOnMarket\";i:28;s:9:\"@odata.id\";s:64:\"https://api.realtyfeed.com/realtyfeed/odata/Property(\'29762572\')\";s:2:\"ID\";s:7:\"1429852\";}s:8:\"add_date\";s:23:\"2026-05-15T22:37:00.76Z\";s:19:\"architectural_style\";i:1;s:27:\"architectural_style_options\";s:2:\"27\";s:9:\"bathrooms\";s:1:\"3\";s:8:\"bedrooms\";s:1:\"5\";s:10:\"build_year\";s:4:\"2026\";s:9:\"confirmed\";i:1;s:5:\"f_130\";i:1;s:13:\"f_130_options\";s:5:\"31,32\";s:5:\"f_134\";i:1;s:13:\"f_134_options\";s:2:\"28\";s:5:\"f_137\";i:1;s:13:\"f_137_options\";s:4:\"19,3\";s:5:\"f_150\";i:1;s:13:\"f_150_options\";s:8:\"30,19,87\";s:9:\"field_308\";s:1544:\"*ACCEPTING 5% DEPOSIT! RARE INVESTMENT OPPORTUNITY!!! FULLY DEVELOPED 2 BEDROOM LEGAL BASEMENT SUITE WITH SEPARATE SIDE DOOR ENTRY IS INCLUDED!!! Welcome to The Aspen Collection by Decora Homes, located in the highly sought-after neighbourhood of Aspen Ridge. The Phoenix model is a Bi-Level home offering 1, 091 sq ft of open-concept living space with 3 bedrooms and 2 bathrooms on the main level, featuring luxury vinyl plank flooring throughout and quartz counter tops in the main kitchen. The primary bedroom includes a walk-in closet & 4-piece ensuite bathroom. This model includes a 2 bedroom, 1 bathroom legal basement suite with separate side entry — a great option for rental income or multi-generational living. Additional features include xeriscaped front landscaping, a concrete walkway from the sidewalk to the front door, and a 20x20 concrete parking pad with back alley access. Now available for Pre-Sale, with estimated completion roughly 6months from purchase. Buyers can choose from three thoughtfully curated colour palettes: Harmony, Tranquil, or Horizon. This lot also offers the option to add the \"Malibu Detached Garage, \" which features an additional ONE BEDROOM LEGAL RENTAL SUITE \"LOFT\" above the double detached garage. Add-on and upgrade options are available. These prices are based off of the buyers qualifying for their own construction mortgage. First time home buyer pricing starting at $478, 000, please inquire for more details! Contact your Realtor today for more information and add-on pricing! (id:62783)\";s:9:\"finalized\";i:1;s:12:\"googlemap_ln\";s:11:\"-106.535868\";s:12:\"googlemap_lt\";s:9:\"52.176329\";s:17:\"list_agent_mls_id\";s:7:\"1934192\";s:18:\"list_office_mls_id\";s:5:\"48299\";s:7:\"listing\";s:1:\"9\";s:14:\"listing_status\";i:1;s:11:\"living_area\";s:4:\"1091\";s:14:\"living_area_si\";s:4:\"1091\";s:16:\"living_area_unit\";s:1:\"1\";s:13:\"lot_area_unit\";s:1:\"3\";s:14:\"location1_name\";s:2:\"CA\";s:14:\"location2_name\";s:12:\"Saskatchewan\";s:14:\"location4_name\";s:9:\"Saskatoon\";s:12:\"lot_features\";i:1;s:20:\"lot_features_options\";s:5:\"57,27\";s:19:\"lot_size_dimensions\";s:8:\"30x127.9\";s:6:\"mls_id\";s:8:\"SK036182\";s:22:\"modification_timestamp\";s:20:\"2026-05-20T23:20:31Z\";s:23:\"originating_system_name\";s:35:\"Saskatchewan REALTORS® Association\";s:8:\"pic_numb\";s:2:\"11\";s:5:\"price\";s:6:\"499900\";s:8:\"price_si\";s:6:\"499900\";s:10:\"price_unit\";s:3:\"260\";s:17:\"property_sub_type\";i:1;s:13:\"property_type\";s:2:\"15\";s:6:\"ref_id\";s:8:\"29762572\";s:12:\"show_address\";i:1;s:6:\"source\";s:2:\"RF\";s:23:\"status_change_timestamp\";s:20:\"2026-05-20T23:14:30Z\";s:13:\"location_text\";s:51:\"439 Stehwien STREET, Saskatoon, Saskatchewan S7W1M9\";s:8:\"zip_name\";s:6:\"S7W1M9\";s:10:\"office_key\";s:5:\"48299\";s:12:\"our_listings\";s:5:\"false\";s:6:\"zip_id\";N;s:12:\"sp_openhouse\";N;s:13:\"sp_forclosure\";N;s:11:\"sp_featured\";N;s:6:\"sp_hot\";N;s:13:\"meta_keywords\";s:0:\"\";s:13:\"show_internet\";i:1;s:4:\"kind\";i:0;s:7:\"deleted\";i:0;s:7:\"expired\";i:0;s:7:\"_wpl_id\";i:873553;s:2:\"id\";i:873553;s:16:\"fave_attachments\";a:0:{}s:20:\"fave_property_images\";a:11:{i:0;i:13429852000;i:1;i:13429852001;i:2;i:13429852002;i:3;i:13429852003;i:4;i:13429852004;i:5;i:13429852005;i:6;i:13429852006;i:7;i:13429852007;i:8;i:13429852008;i:9;i:13429852009;i:10;i:13429852010;}s:28:\"wpcf-property-featured-image\";a:11:{i:0;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/5d099c9de0ab73db339ba9f0c84bf702.webp\";i:1;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/645860c25a8939b0becc3c9ae02b906a.webp\";i:2;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/4b66f164bf9c13159909d07ec858ea12.webp\";i:3;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/3c5d6674bf064407d90208a72161e6d3.webp\";i:4;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/cf960cff8ee8e62b70a87eb27c8bccd3.webp\";i:5;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/238156478aaec302485f3a903f1846db.webp\";i:6;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/50bbf2d45e50f5a43e05106d006d2ede.webp\";i:7;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/0c234466ab6679c61f64017491d4d63f.webp\";i:8;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/02969e3d6f1de8fe358064ea1b9772aa.webp\";i:9;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/fc2d01f71ddeea49ea8d347c5e654889.webp\";i:10;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/7de9ebb16f92b884a60b189b8d797ac3.webp\";}s:20:\"wpcf-property-images\";a:11:{i:0;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/5d099c9de0ab73db339ba9f0c84bf702.webp\";i:1;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/645860c25a8939b0becc3c9ae02b906a.webp\";i:2;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/4b66f164bf9c13159909d07ec858ea12.webp\";i:3;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/3c5d6674bf064407d90208a72161e6d3.webp\";i:4;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/cf960cff8ee8e62b70a87eb27c8bccd3.webp\";i:5;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/238156478aaec302485f3a903f1846db.webp\";i:6;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/50bbf2d45e50f5a43e05106d006d2ede.webp\";i:7;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/0c234466ab6679c61f64017491d4d63f.webp\";i:8;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/02969e3d6f1de8fe358064ea1b9772aa.webp\";i:9;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/fc2d01f71ddeea49ea8d347c5e654889.webp\";i:10;s:80:\"https://cdn.realtyfeed.com/cdn/26/29762572/7de9ebb16f92b884a60b189b8d797ac3.webp\";}s:26:\"REAL_HOMES_property_images\";a:11:{i:0;i:13429852000;i:1;i:13429852001;i:2;i:13429852002;i:3;i:13429852003;i:4;i:13429852004;i:5;i:13429852005;i:6;i:13429852006;i:7;i:13429852007;i:8;i:13429852008;i:9;i:13429852009;i:10;i:13429852010;}s:13:\"_thumbnail_id\";i:13429852000;}}}', '2026-06-13 07:16:26', 'temporary', 1, '2026-06-13 07:11:26', '2026-06-13 07:11:26')

Residential For Sale - - 5 Bedrooms - 3 Bathrooms - Price $499,900 - SK036182
$499,900
Saskatchewan,Saskatoon 439 Stehwien STREET, Saskatoon, Saskatchewan S7W1M9
  • 5
  • 3
  • 1,091 Sqft
Basic Details
Property Type:
Residential
Listing Type:
For Sale
Listing ID:
SK036182
Price:
$499,900
Bedrooms:
5
Bathrooms:
3
Square Footage:
1,091 Sqft
Year Built:
2026
Office Key:
48299
Features
Heating System:
  • Forced air
  • Natural gas
Cooling System:
Air exchanger
Basement:
  • Full
  • Partially finished
Parking:
  • None
  • Parking Pad
  • Parking Space(s)
Architectural Style:
Bi-level
Address Map
Country:
CA
State:
Saskatchewan
City:
Saskatoon
Zipcode:
S7W1M9
1-877-888-3131 / 10807-124 Street Edmonton AB, T5M 0H4