array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29987150 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: "1591137"
+post_author: 1
+"ListingKey": "29987150"
+"ListingId": "40844520"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:35:12Z"
+"RFModificationTimestamp": "2026-07-03T23:19:32Z"
+"ListPrice": 1247000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3235.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G5"
+"UnparsedAddress": "517 STARBOARD Crescent, Waterloo, Ontario N2K4G5"
+"Coordinates": array:2 [
0 => -80.5062174
1 => 43.5105961
]
+"Latitude": 43.5105961
+"Longitude": -80.5062174
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 517 Starboard Crescent, Waterloo, a beautifully maintained bungalow offering 3 bedrooms, 3 bathrooms, and a spacious open-concept layout designed for comfortable everyday living and entertaining. Step inside to the welcoming foyer where you're greeted by an airy floor plan. To the right, the formal living room features a cozy gas fireplace and skylight, creating a bright and inviting space. The living room flows seamlessly into the dining area and spacious kitchen, complete with granite countertops, stainless steel appliances, abundant cabinetry, generous prep space, and a large centre island with breakfast bar seating. A convenient door off the kitchen provides easy access to the backyard. The main floor also features updated hardwood flooring throughout, a convenient mudroom/laundry room with direct access to the double garage, and a 3-piece bathroom. Two bedrooms are located on this level, including the spacious primary suite with a walk-in closet and a luxurious 5-piece ensuite. The finished basement expands your living space with a large recreation room highlighted by a stylish gas fireplace, an additional bedroom, and a 3-piece bathroom—ideal for guests, extended family, or a home office. Step outside to your private backyard retreat featuring an inground saltwater pool and patio area, perfect for relaxing or entertaining all summer long. Complete with a double car garage and parking for up to six vehicles in the driveway, this exceptional home offers the perfect combination of space, comfort, and lifestyle in a sought-after Waterloo neighbourhood. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T23:19:24.529023+00:00"
+"Directions": "Chesapeake Drive to Starboard Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T20:33:15Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:33:15Z"
+"Stories": "1.0"
+"StreetName": "STARBOARD"
+"StreetNumber": "517"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "7992.01"
+"VirtualTourURLUnbranded": "https://youriguide.com/517_starboard_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1674395024"
"RoomType" => "Utility room"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "31'4'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.98Z"
]
1 => array:11 [
"RoomKey" => "1674395025"
"RoomType" => "Recreation room"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "31'4'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.98Z"
]
2 => array:11 [
"RoomKey" => "1674395026"
"RoomType" => "Cold room"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.98Z"
]
3 => array:11 [
"RoomKey" => "1674395027"
"RoomType" => "Bedroom"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
4 => array:11 [
"RoomKey" => "1674395028"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
5 => array:11 [
"RoomKey" => "1674395029"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
6 => array:11 [
"RoomKey" => "1674395030"
"RoomType" => "Living room"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "19'7'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
7 => array:11 [
"RoomKey" => "1674395031"
"RoomType" => "Laundry room"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
8 => array:11 [
"RoomKey" => "1674395032"
"RoomType" => "Kitchen"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
9 => array:11 [
"RoomKey" => "1674395033"
"RoomType" => "Foyer"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
10 => array:11 [
"RoomKey" => "1674395034"
"RoomType" => "Dining room"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
11 => array:11 [
"RoomKey" => "1674395035"
"RoomType" => "Bedroom"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
12 => array:11 [
"RoomKey" => "1674395036"
"RoomType" => "Full bathroom"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
13 => array:11 [
"RoomKey" => "1674395037"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29987150"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T20:29:14.99Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29987150/517-starboard-crescent-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 64.0
+"AboveGradeFinishedArea": 1623
+"BelowGradeFinishedArea": 1613
+"OriginalEntryTimestamp": "2026-07-03T20:29:14.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29987150_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/c5dfba95e4ba0907ab3ea1e524896930.webp"
"MediaSize" => 120105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-c5dfba95e4ba0907ab3ea1e524896930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29987150_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/8dc368700c4a90a60f5609dec9117a75.webp"
"MediaSize" => 121050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-8dc368700c4a90a60f5609dec9117a75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29987150_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/3745765af2223e7a3ccb9ebc5bf434b2.webp"
"MediaSize" => 106236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-3745765af2223e7a3ccb9ebc5bf434b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.19Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29987150_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/d7282e03111268c7f81e7d4b8a6de682.webp"
"MediaSize" => 127876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-d7282e03111268c7f81e7d4b8a6de682.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29987150_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/2dbce625577091e7fe94ff622b710b65.webp"
"MediaSize" => 116463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-2dbce625577091e7fe94ff622b710b65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:08.96Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29987150_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/bd127d809b8c9beea9346ef0b1bcccbf.webp"
"MediaSize" => 66838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-bd127d809b8c9beea9346ef0b1bcccbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.28Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29987150_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/3239edd8f5931bb904d6c69f97336404.webp"
"MediaSize" => 71849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-3239edd8f5931bb904d6c69f97336404.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.3Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29987150_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/411292fca1c61369beab260c338c80ed.webp"
"MediaSize" => 92479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-411292fca1c61369beab260c338c80ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.86Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29987150_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/85711576dc521f2aa49a69c60e218e39.webp"
"MediaSize" => 93383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-85711576dc521f2aa49a69c60e218e39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:08.96Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29987150_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/518f51ba95e52b35506f60da3b2d0573.webp"
"MediaSize" => 57864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-518f51ba95e52b35506f60da3b2d0573.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:08.9Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29987150_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/46104cfb33b421a278db9a2a3387f4d9.webp"
"MediaSize" => 76487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-46104cfb33b421a278db9a2a3387f4d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29987150_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/06ab24702822dd0803822e2df2fe407c.webp"
"MediaSize" => 93107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-06ab24702822dd0803822e2df2fe407c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.08Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29987150_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/6dc917564b99d529d6f75e52b2d864fb.webp"
"MediaSize" => 85665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-6dc917564b99d529d6f75e52b2d864fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.73Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29987150_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/08d2085e0b6c9d26aa6f870d2bdc2f26.webp"
"MediaSize" => 74454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-08d2085e0b6c9d26aa6f870d2bdc2f26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.14Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29987150_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/93afa28d29901124c4d76bf2fd02201d.webp"
"MediaSize" => 82419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-93afa28d29901124c4d76bf2fd02201d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:08.96Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29987150_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/9d6f37f35bb340838d1ad042755150de.webp"
"MediaSize" => 70929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-9d6f37f35bb340838d1ad042755150de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.95Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29987150_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/f392546fe5b4fd2ab9c268b474445e5d.webp"
"MediaSize" => 77655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-f392546fe5b4fd2ab9c268b474445e5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.07Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29987150_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/43f76e7015878786e15d8fd52bc7bfba.webp"
"MediaSize" => 76410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-43f76e7015878786e15d8fd52bc7bfba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.72Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29987150_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/33933856c747e0db6c1e49b80a2ec671.webp"
"MediaSize" => 69717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-33933856c747e0db6c1e49b80a2ec671.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29987150_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/5ccc1a39c7fb73e8843bac1bc67930f4.webp"
"MediaSize" => 69751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-5ccc1a39c7fb73e8843bac1bc67930f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.23Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29987150_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ffd3ccd1e9a4167c2d0b4cd92bb7b1ad.webp"
"MediaSize" => 42190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ffd3ccd1e9a4167c2d0b4cd92bb7b1ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.46Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29987150_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/75fe56c0f040da43aa755e8ad174b13d.webp"
"MediaSize" => 63886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-75fe56c0f040da43aa755e8ad174b13d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.27Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29987150_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/0d1a79b693785f5b26581a88504eddbd.webp"
"MediaSize" => 30799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-0d1a79b693785f5b26581a88504eddbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.24Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29987150_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/134de0468f0a391f1a4b8c16c7ece89e.webp"
"MediaSize" => 71927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-134de0468f0a391f1a4b8c16c7ece89e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29987150_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/679ba2a6231953f9106364ec1da9d63f.webp"
"MediaSize" => 62430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-679ba2a6231953f9106364ec1da9d63f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29987150_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/18e89d51661cf84333d90a7666c71868.webp"
"MediaSize" => 87505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-18e89d51661cf84333d90a7666c71868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29987150_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/335188d50fbb0ffec8d63c0ba43a545e.webp"
"MediaSize" => 100715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-335188d50fbb0ffec8d63c0ba43a545e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:14.4Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29987150_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/c93227a3891c5a165a01cd1d7f82948d.webp"
"MediaSize" => 82680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-c93227a3891c5a165a01cd1d7f82948d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:14.4Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29987150_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/97b79fdc68b7d907836927754ee24cc4.webp"
"MediaSize" => 68621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-97b79fdc68b7d907836927754ee24cc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.87Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29987150_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/3d389ad3c156e152a09c5ac807635750.webp"
"MediaSize" => 54240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-3d389ad3c156e152a09c5ac807635750.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.96Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29987150_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/dd8d8c08cd408df56dba00de42c267d1.webp"
"MediaSize" => 59529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-dd8d8c08cd408df56dba00de42c267d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:09.98Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29987150_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/989e14a03ce054960e9ed37342c9cb69.webp"
"MediaSize" => 94399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-989e14a03ce054960e9ed37342c9cb69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.13Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29987150_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ab603b1669540446c64c9dfb87940322.webp"
"MediaSize" => 81085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ab603b1669540446c64c9dfb87940322.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.47Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29987150_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/312df54dab6faab41ebcddae069014ff.webp"
"MediaSize" => 79731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-312df54dab6faab41ebcddae069014ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.46Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29987150_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/6b3d25b577dbdc6b407d06c78e347998.webp"
"MediaSize" => 74505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-6b3d25b577dbdc6b407d06c78e347998.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:15.31Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29987150_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/deebf00efea75142466d46289b6d10e6.webp"
"MediaSize" => 77365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-deebf00efea75142466d46289b6d10e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.02Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29987150_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/e4ec21e41e1ed66dcae5f031ccdab5c9.webp"
"MediaSize" => 73877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-e4ec21e41e1ed66dcae5f031ccdab5c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:15.4Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29987150_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ef9f836d890e623836d8b69568ef102e.webp"
"MediaSize" => 87975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ef9f836d890e623836d8b69568ef102e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.19Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29987150_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/582c8a333a414e6210c62dcbf03bf169.webp"
"MediaSize" => 86072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-582c8a333a414e6210c62dcbf03bf169.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:14.46Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29987150_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/8b79de4d1b5567aa0c3c52be9d2a400f.webp"
"MediaSize" => 172687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-8b79de4d1b5567aa0c3c52be9d2a400f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.72Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29987150_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ecf2330455472288bc742d025d40ac51.webp"
"MediaSize" => 133274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ecf2330455472288bc742d025d40ac51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.26Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29987150_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/615e10e3aa427318bef228f0e3ba17e2.webp"
"MediaSize" => 156602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-615e10e3aa427318bef228f0e3ba17e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.16Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29987150_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/7cfda36a4e2eb04d0a41bc04f1237ff5.webp"
"MediaSize" => 151137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-7cfda36a4e2eb04d0a41bc04f1237ff5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:11.67Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29987150_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/6a401c32c52b2221afe771f4564614d5.webp"
"MediaSize" => 144408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-6a401c32c52b2221afe771f4564614d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:13.02Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29987150_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/ceded095b1a54b7218d4a1b7b2ed3405.webp"
"MediaSize" => 171318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-ceded095b1a54b7218d4a1b7b2ed3405.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:12.43Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29987150_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/8616eda1caf0305182b9bc9ada9cbaef.webp"
"MediaSize" => 163509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-8616eda1caf0305182b9bc9ada9cbaef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.19Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29987150_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/03a0c78114b0fbb8c2b6fe0a0b6766be.webp"
"MediaSize" => 50532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-03a0c78114b0fbb8c2b6fe0a0b6766be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:10.19Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29987150_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29987150/71a3f1906192f269ff7389721aa90cde.webp"
"MediaSize" => 42696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29987150/thumbnail-71a3f1906192f269ff7389721aa90cde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844520"
"ResourceRecordKey" => "29987150"
"ModificationTimestamp" => "2026-07-03T20:33:15.33Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987150')"
+"ID": "1591137"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24921
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1908292" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24879
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29987150'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25284
+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 '29987150'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25300
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29987150' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5062174 43.5105961)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25373
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+post_id: "1590600"
+post_author: 1
+"ListingKey": "29986048"
+"ListingId": "40843697"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:25:13Z"
+"RFModificationTimestamp": "2026-07-03T19:51:49Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 7.26
+"LivingArea": 801.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "255 NORTHFIELD Drive E Unit# 505, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.5214326
1 => 43.5107434
]
+"Latitude": 43.5107434
+"Longitude": -80.5214326
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone Condominiums, one of Waterloo's most sought-after communities, where modern design, exceptional amenities, and an unbeatable location come together. This beautifully maintained 2-bedroom, 2-bathroom suite offers over 800 sq. ft. of stylish living space with contemporary finishes throughout. The bright open-concept layout is designed for everyday living and entertaining, featuring a modern kitchen with quartz countertops, stainless steel appliances, a white subway tile backsplash, ample cabinetry, and a spacious island overlooking the living and dining area. Expansive windows fill the home with natural light, while the generous balcony provides the perfect place to enjoy your morning coffee. At the end of the day, retreat to the spacious primary bedroom featuring a private ensuite. The second bedroom and additional full bathroom offer flexible space for guests, family, or a dedicated home office. In-suite laundry and an exclusive surface parking space add everyday convenience. Residents of Blackstone enjoy an exceptional collection of amenities, including a fully equipped fitness centre, co-working/business lounge, an impressive party room, games and media room, rooftop terrace, landscaped gardens, bike storage, pet wash station, and BBQ areas. Even better, the condo fees include heat, high-speed internet, building insurance, building and grounds maintenance, common elements, snow removal, private garbage collection, roof maintenance, property management, and parking, providing outstanding value and predictable monthly expenses. Perfectly located just minutes from Conestoga Mall, the ION LRT, RIM Park, Walter Bean Trail, Grey Silo Golf Club, St. Jacobs Farmers' Market, the University of Waterloo, Wilfrid Laurier University, and an excellent selection of shopping, cafés, and restaurants right at your doorstep, this home is ideal for professionals, first-time buyers, downsizers, and investors alike. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:51:46.539329+00:00"
+"Directions": "NORTHFIELD TO BRIDGE ST"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"LotSizeDimensions": "7.26"
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-03T18:18:33Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:18:33Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3752.53"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1674297532"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.21Z"
]
1 => array:11 [
"RoomKey" => "1674297533"
"RoomType" => "Full bathroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
2 => array:11 [
"RoomKey" => "1674297534"
"RoomType" => "Bedroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
3 => array:11 [
"RoomKey" => "1674297535"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
4 => array:11 [
"RoomKey" => "1674297536"
"RoomType" => "Living room"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
5 => array:11 [
"RoomKey" => "1674297537"
"RoomType" => "Kitchen"
"ListingId" => "40843697"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986048"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:33.22Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986048/255-northfield-drive-e-unit-505-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2059475"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292003"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 158.0
+"AboveGradeFinishedArea": 801
+"OriginalEntryTimestamp": "2026-07-03T18:18:33.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"CoListAgentNationalAssociationId": "1334623"
+"CoListOfficeNationalAssociationId": "1407357"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986048_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/a455392c75fffdd9e494d033914cb72d.webp"
"MediaSize" => 53177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-a455392c75fffdd9e494d033914cb72d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986048_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/e25770c11d666d2b4f3073002318c2e7.webp"
"MediaSize" => 56207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-e25770c11d666d2b4f3073002318c2e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986048_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/74c2bf188f8b64fd271b95408206166e.webp"
"MediaSize" => 80547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-74c2bf188f8b64fd271b95408206166e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986048_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/1b60f67966064961b32684bbcbd89e9c.webp"
"MediaSize" => 48842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-1b60f67966064961b32684bbcbd89e9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986048_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/f0b6df7db15b5b6b99bb96c889185565.webp"
"MediaSize" => 46887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-f0b6df7db15b5b6b99bb96c889185565.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986048_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/70f541a0b017c0b10ebc5cd61c888761.webp"
"MediaSize" => 56129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-70f541a0b017c0b10ebc5cd61c888761.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986048_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/7a5eb6523874431a96da7ad431aa8813.webp"
"MediaSize" => 45602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-7a5eb6523874431a96da7ad431aa8813.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
"ModificationTimestamp" => "2026-07-03T18:18:33.18Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986048_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986048/5de9898eb6125a7035c48be6e2c9aaee.webp"
"MediaSize" => 72288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986048/thumbnail-5de9898eb6125a7035c48be6e2c9aaee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843697"
"ResourceRecordKey" => "29986048"
…1
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986048')"
+"ID": "1590600"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25369
+post_id: "1590601"
+post_author: 1
+"ListingKey": "29986089"
+"ListingId": "X13519890"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:35:15Z"
+"RFModificationTimestamp": "2026-07-03T19:48:02Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "505 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.521297
1 => 43.510381
]
+"Latitude": 43.510381
+"Longitude": -80.521297
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums, one of Waterloo's most sought-after communities, where modern design, exceptional amenities, and an unbeatable location come together. This beautifully maintained 2-bedroom, 2-bathroom suite offers over 800 sq. ft. of stylish living space with contemporary finishes throughout. The bright open-concept layout is designed for everyday living and entertaining, featuring a modern kitchen with quartz countertops, stainless steel appliances, a white subway tile backsplash, ample cabinetry, and a spacious island overlooking the living and dining area. Expansive windows fill the home with natural light, while the generous balcony provides the perfect place to enjoy your morning coffee. At the end of the day, retreat to the spacious primary bedroom featuring a private ensuite. The second bedroom and additional full bathroom offer flexible space for guests, family, or a dedicated home office. In-suite laundry and an exclusive surface parking space add everyday convenience. Residents of Blackstone enjoy an exceptional collection of amenities, including a fully equipped fitness centre, co-working/business lounge, an impressive party room, games and media room, rooftop terrace, landscaped gardens, bike storage, pet wash station, and BBQ areas. Even better, the condo fees include heat, high-speed internet, building insurance, building and grounds maintenance, common elements, snow removal, private garbage collection, roof maintenance, property management, and parking, providing outstanding value and predictable monthly expenses. Perfectly located just minutes from Conestoga Mall, the ION LRT, RIM Park, Walter Bean Trail, Grey Silo Golf Club, St. Jacobs Farmers' Market, the University of Waterloo, Wilfrid Laurier University, and an excellent selection of shopping, cafés, and restaurants right at your doorstep, this home is ideal for professionals, first-time buyers, downsizers, and investors alike. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:47:55.686450+00:00"
+"Directions": "Cross Streets: NORTHFIELD/BRIDGE. ** Directions: NORTHFIELD TO BRIDGE ST."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1899457"
+"ListOfficeKey": "292096"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Elevator"
3 => "Balcony"
4 => "Dry"
5 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:25:30Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:25:30Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3752.53"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29986089/505-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2059475"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five River Prop Mgrs"
+"CoListAgentKey2": "1834162"
+"CoListOfficeKey": "292096"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Security/Concierge"
3 => "Visitor Parking"
]
+"CoListOfficeKey2": "293196"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-03T18:25:30.01Z"
+"ListAgentNationalAssociationId": "1216506"
+"ListOfficeNationalAssociationId": "1408169"
+"CoListAgentNationalAssociationId": "1334623"
+"CoListAgentNationalAssociationId2": "1196633"
+"CoListOfficeNationalAssociationId": "1408169"
+"CoListOfficeNationalAssociationId2": "1423680"
+"Media": array:8 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986089')"
+"ID": "1590601"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1589769"
+post_author: 1
+"ListingKey": "29984026"
+"ListingId": "40844904"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:05:17Z"
+"RFModificationTimestamp": "2026-07-03T19:06:07Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1753.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E8"
+"UnparsedAddress": "532 WISMER Street, Waterloo, Ontario N2K0E8"
+"Coordinates": array:2 [
0 => -80.4878425
1 => 43.4990626
]
+"Latitude": 43.4990626
+"Longitude": -80.4878425
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Freehold End-Unit Townhome with No Condo Fees! Welcome to this beautifully updated freehold end-unit townhome, where extra windows, added privacy, and a larger fenced yard create the feel of a semi-detached home—all with no condo fees. The welcoming ground level features a versatile flex space, ideal as a home office, guest room, gym, or playroom, adapting effortlessly to your lifestyle. Upstairs, the bright and airy open-concept main living area is designed for both everyday living and entertaining. The stylish kitchen boasts quartz countertops, stainless steel appliances, and a spacious eat-in area, while still offering room for a separate dining space. The inviting living room opens through sliding doors to an elevated deck with stairs leading down to the fully fenced backyard—perfect for summer barbecues, children, or pets. A convenient two-piece powder room completes this level.The upper floor offers a spacious primary retreat featuring a walk-in closet and private ensuite bathroom. Two additional generously sized bedrooms and a second full bathroom provide comfortable space for family or guests. Situated in a fantastic Waterloo location close to parks, schools, shopping, universities, transit, and everyday amenities, this move-in-ready home is an exceptional opportunity for first-time buyers, young families, professionals, or investors looking for a low-maintenance property in a highly desirable neighbourhood. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:12:14.864059+00:00"
+"Directions": "University/Woolwich"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563569"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T14:18:21Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:59:24Z"
+"Stories": "3.0"
+"StreetName": "WISMER"
+"StreetNumber": "532"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "5302"
+"VirtualTourURLUnbranded": "https://youriguide.com/532_wismer_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29984026/532-wismer-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1600603"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2246706"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "76826"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1753
+"BelowGradeFinishedArea": 0
+"OriginalEntryTimestamp": "2026-07-03T14:18:21.44Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1109914"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1145016"
+"CoListAgentNationalAssociationId2": "1485557"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1004387"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984026')"
+"ID": "1589769"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "1590387"
+post_author: 1
+"ListingKey": "29984547"
+"ListingId": "X13518412"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:30:04Z"
+"RFModificationTimestamp": "2026-07-03T17:08:31Z"
+"ListPrice": 999999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Prince Edward County (Sophiasburg Ward)"
+"PostalCode": "K0K1W0"
+"UnparsedAddress": "213 GOMORRAH ROAD, Prince Edward County (Sophiasburg Ward), Ontario K0K1W0"
+"Coordinates": array:2 [
0 => -80.499587
1 => 43.507364
]
+"Latitude": 43.507364
+"Longitude": -80.499587
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Central Lakes Association of REALTORS®"
+"PublicRemarks": "Nestled in a serene historical hamlet of Prince Edward County, this magnificent two-storey country home sits on a picturesque 2.6-acre parcel, featuring Smith's Creek gently meandering through the property behind a beautifully restored multi-level Dutch barn. Cross the creek via a quaint bridge to discover a spacious garden area perfect for quiet enjoyment of outdoor gatherings. Meticulous care has been taken to preserve the original character of this century home. The main floor welcomes you with grand 8-ft double library doors leading to both the formal living room and the cozy family room. Each space is enhanced by original pine flooring, elegant trim, soaring ceilings, and the inviting glow of propane fireplaces. The living room also boasts an intricately designed tin ceiling, adding a touch of period charm. The newly installed kitchen (2022) was thoughtfully crafted to harmonize with the home's historic aesthetic. It offers abundant cabinetry, a central island, and opens into the bright dining area, which leads to a large deck overlooking the grounds. This deck connects seamlessly with the inviting wraparound covered porch - ideal for enjoying peaceful country views. Upstairs, the second level features four comfortable bedrooms, a spacious 4-piece bathroom, and a large walk-in storage closet. Original hardwood floors and woodwork continue throughout, preserving the timeless warmth and character of the home. The impressive multi-level barn, dating back to the late 1800's, has undergone significant structural improvements, including foundation reinforcement and interior refinishing with rustic pine planks. Currently used for dry storage, its versatile design and unique atmosphere make it a perfect venue for festive events or creative ventures. Surrounded by farmland and forest teeming with local wildlife and bird species, this one-of-a-kind property offers a rare opportunity to own a piece of County heritage, with all the tranquility and beauty of rural living. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Water Treatment"
11 => "Window Coverings"
12 => "Water Heater"
]
+"Basement": array:5 [
0 => "Unfinished"
1 => "Partial"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:08:24.679771+00:00"
+"Directions": "Cross Streets: County Road 14 & County Road 15. ** Directions: Follow County Roads 14 or 15 to Gomorrah, just outside of Demorestville."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1433818"
+"ListOfficeKey": "211195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Sloping"
2 => "Open space"
3 => "Level"
]
+"LotSizeDimensions": "293.5 x 500 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:20:58Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:20:58Z"
+"Stories": "2.0"
+"StreetName": "Gomorrah"
+"StreetNumber": "213"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2824.93"
+"Utilities": array:4 [
0 => "Electricity"
1 => "Telephone"
2 => "Wireless"
3 => "Electricity Connected"
]
+"View": "View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/213_gommorah_rd_prince_edward_on/"
+"WaterSource": array:1 [
0 => "Dug Well"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Central Lakes"
+"CityRegion": "Sophiasburg Ward"
+"ListAORKey": "88"
+"ListingURL": "www.realtor.ca/real-estate/29984547/213-gomorrah-road-prince-edward-county-sophiasburg-ward-sophiasburg-ward"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RR1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 293.6
+"OriginalEntryTimestamp": "2026-07-03T15:20:58.7Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1117495"
+"ListOfficeNationalAssociationId": "1193887"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984547')"
+"ID": "1590387"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+post_id: "1587688"
+post_author: 1
+"ListingKey": "29982473"
+"ListingId": "40843934"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:55:14Z"
+"RFModificationTimestamp": "2026-07-03T17:09:22Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2845.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3P2"
+"UnparsedAddress": "570 HALLMARK Drive, Waterloo, Ontario N2K3P2"
+"Coordinates": array:2 [
0 => -80.5232066
1 => 43.5004294
]
+"Latitude": 43.5004294
+"Longitude": -80.5232066
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Location, Location, Location. Lovely 2 storey home in sought after 'Colonial Acres', backing onto trees and the privacy of Anndale Park with no neighbours behind. This home features two 2 Bedrooms up with new flooring and both with 4pc Ensuites. The main floor has a spacious Living room, formal Dining room, TV room with hardwood floor, 2pc Powder room and a walk-out to a deck with a retractable awning.The bright basement has a finished Recreation room with walk-out leading to a fenced yard, a 3pc Bath, an additional 3rd Bedroom, laundry and storage. This home has been well maintained throughout, with additional insulation added to the attic. This home is ideally located providing ameneties for the whole family, being steps from Conestoga Mall, LRT Transit Hub, Grey Silo Golf course, RIM Park recreation centre, walking trails, St. Jacob’s Farmers market, great schools and offering convenient access to the Expressway. A great place to call Home. (id:62650)"
+"Appliances": array:10 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T00:59:43.127043+00:00"
+"Directions": "Davenport Rd to Hallmark Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563939"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T23:10:26Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:48:31Z"
+"Stories": "2.0"
+"StreetName": "HALLMARK"
+"StreetNumber": "570"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6316.27"
+"VirtualTourURLUnbranded": "https://youriguide.com/570_hallmark_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29982473/570-hallmark-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1775
+"BelowGradeFinishedArea": 1070
+"OriginalEntryTimestamp": "2026-07-02T23:10:26.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070118"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982473')"
+"ID": "1587688"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: "1585240"
+post_author: 1
+"ListingKey": "29980078"
+"ListingId": "X13514038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T18:40:18Z"
+"RFModificationTimestamp": "2026-07-02T19:13:12Z"
+"ListPrice": 724900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4L7"
+"UnparsedAddress": "765 ANGLER WAY, Waterloo, Ontario N2K4L7"
+"Coordinates": array:2 [
0 => -80.5001427
1 => 43.5145232
]
+"Latitude": 43.5145232
+"Longitude": -80.5001427
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "765 Angler Way, Waterloo is a spacious 3-bedroom, 2.5-bathroom home offering 1,437 sq ft above grade plus a finished basement. Located in one of north Waterloo's most highly sought-after family neighbourhoods on a quiet dead-end street, this property offers privacy, safety for children, and a true sense of community. The main floor includes a convenient 2-piece powder room, while the second level features three good-sized bedrooms and a 4-piece bathroom. The finished basement provides flexible living space with a basic rec room and 3-piece bathroom. Outside, enjoy the large back patio ideal for BBQs and relaxing in the private yard. With excellent access to top schools, parks, and amenities, this home is perfect for families looking to put down roots in a desirable location. (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:13:10.994697+00:00"
+"Directions": "Cross Streets: University. ** Directions: University to New Hampshire."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154832"
+"ListOfficeKey": "285194"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "28 x 98.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T18:32:27Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T18:32:27Z"
+"Stories": "2.0"
+"StreetName": "Angler"
+"StreetNumber": "765"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "4452"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/o6z5m_765_angler_way_waterloo_on/"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29980078/765-angler-way-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2026-07-02T18:32:27.6Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406273"
+"ListOfficeNationalAssociationId": "1348537"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980078')"
+"ID": "1585240"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1587452"
+post_author: 1
+"ListingKey": "29978817"
+"ListingId": "40844546"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T17:00:11Z"
+"RFModificationTimestamp": "2026-07-02T17:08:43Z"
+"ListPrice": 724900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1923.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4L7"
+"UnparsedAddress": "765 ANGLER Way, Waterloo, Ontario N2K4L7"
+"Coordinates": array:2 [
0 => -80.5004055
1 => 43.5144025
]
+"Latitude": 43.5144025
+"Longitude": -80.5004055
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "765 Angler Way, Waterloo is a spacious 3-bedroom, 2.5-bathroom home offering 1,437 sq ft above grade plus a finished basement. Located in one of north Waterloo’s most highly sought-after family neighbourhoods on a quiet dead-end street, this property offers privacy, safety for children, and a true sense of community. The main floor includes a convenient 2-piece powder room, while the second level features three good-sized bedrooms and a 4-piece bathroom. The finished basement provides flexible living space with a basic rec room and 3-piece bathroom. Outside, enjoy the large back patio ideal for BBQs and relaxing in the private yard. With excellent access to top schools, parks, and amenities, this home is perfect for families looking to put down roots in a desirable location. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:08:31.519059+00:00"
+"Directions": "NEW HAMPSHIRE STREET"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1920294"
+"ListOfficeKey": "285135"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T16:33:12Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T16:50:33Z"
+"Stories": "2.0"
+"StreetName": "ANGLER"
+"StreetNumber": "765"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4452"
+"VirtualTourURLUnbranded": "https://youriguide.com/o6z5m_765_angler_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978817/765-angler-way-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1437
+"BelowGradeFinishedArea": 486
+"OriginalEntryTimestamp": "2026-07-02T16:33:07.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1226483"
+"ListOfficeNationalAssociationId": "1347769"
+"Media": array:25 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978817')"
+"ID": "1587452"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+post_id: "1576427"
+post_author: 1
+"ListingKey": "29964980"
+"ListingId": "X13499606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:35:17Z"
+"RFModificationTimestamp": "2026-06-29T19:41:06Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N9"
+"UnparsedAddress": "488 COLT STREET, Waterloo, Ontario N2K4N9"
+"Coordinates": array:2 [
0 => -80.490937
1 => 43.499333
]
+"Latitude": 43.499333
+"Longitude": -80.490937
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright, impeccably maintained freehold townhouse nestled in Waterloo's highly desirable Lexington neighbourhood. Designed for modern living, the open-concept main floor offers a spacious kitchen complete with stainless steel appliances, a well-appointed dining area, and an inviting great room that seamlessly connects to the outdoors. Step out to the expansive deck, perfect for summer entertaining, morning coffee, or simply relaxing in your private backyard setting, backing onto only one neighbouring property. The carpet-free main floor adds both style and practicality. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and the convenience of second-floor laundry. Ideally located close to shopping, schools, parks, public transit, and everyday amenities, this move-in-ready home offers the perfect blend of comfort, privacy, and convenience. Some photos virtually staged. Roof '23, AC '22 (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T14:43:10.232271+00:00"
+"Directions": "Cross Streets: University/Woolwich. ** Directions: University to Colt."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982520"
+"ListOfficeKey": "286883"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "22.9 x 102 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:08Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T19:28:30Z"
+"Stories": "2.0"
+"StreetName": "Colt"
+"StreetNumber": "488"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4354"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29964980/488-colt-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 22.1
+"OriginalEntryTimestamp": "2026-06-29T13:50:08.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267654"
+"ListOfficeNationalAssociationId": "1364605"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964980')"
+"ID": "1576427"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+post_id: "1575738"
+post_author: 1
+"ListingKey": "29964993"
+"ListingId": "40839771"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:00:07Z"
+"RFModificationTimestamp": "2026-06-29T19:03:37Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.05
+"LivingArea": 1440.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N9"
+"UnparsedAddress": "488 COLT Street, Waterloo, Ontario N2K4N9"
+"Coordinates": array:2 [
0 => -80.4908096
1 => 43.4991897
]
+"Latitude": 43.4991897
+"Longitude": -80.4908096
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright, impeccably maintained freehold townhouse nestled in Waterloo's highly desirable Lexington neighbourhood. Designed for modern living, the open-concept main floor offers a spacious kitchen complete with stainless steel appliances, a well-appointed dining area, and an inviting great room that seamlessly connects to the outdoors. Step out to the expansive deck, perfect for summer entertaining, morning coffee, or simply relaxing in your private backyard setting, backing onto only one neighbouring property.The carpet-free main floor adds both style and practicality. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and the convenience of second-floor laundry. Ideally located close to shopping, schools, parks, public transit, and everyday amenities, this move-in-ready home offers the perfect blend of comfort, privacy, and convenience. Some photos virtually staged. Roof '23 AC ' 22 (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T14:32:02.394661+00:00"
+"Directions": "University to Colt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982520"
+"ListOfficeKey": "294000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0.05"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:41Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:51:28Z"
+"Stories": "2.0"
+"StreetName": "COLT"
+"StreetNumber": "488"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4354"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964993/488-colt-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 1440
+"OriginalEntryTimestamp": "2026-06-29T13:50:41.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267654"
+"ListOfficeNationalAssociationId": "1434122"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964993')"
+"ID": "1575738"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 54
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]