array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29953493 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1563097"
+post_author: 1
+"ListingKey": "29953493"
+"ListingId": "40842924"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:40:16Z"
+"RFModificationTimestamp": "2026-06-25T21:14:57Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1488.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3G1"
+"UnparsedAddress": "255 CAMELOT Court Unit# 2, Waterloo, Ontario N2K3G1"
+"Coordinates": array:2 [
0 => -80.5079629
1 => 43.4921833
]
+"Latitude": 43.4921833
+"Longitude": -80.5079629
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 2-255 Camelot Court, a charming 2-storey freehold townhome in Waterloo’s sought-after Lincoln Village. Offering 3 bedrooms and 1full bathroom, this home is an excellent opportunity for first-time buyers, young families, or investors looking to get into a well-established neighbourhood. The main floor features a bright, functional layout with spacious living areas and plenty of natural light, creating a warm and inviting atmosphere. Upstairs, you’ll find three comfortable bedrooms and a full bathroom—perfect for everyday family living. One of the standout features of this home is the backyard setting. Backing directly onto Sandowne Public School, you’ll enjoy added privacy with no rear neighbours. A deck off the living room provides the perfect space to relax or entertain outdoors. Additional highlights include an attached garage and private driveway with parking for two vehicles. Ideally located close to shopping, parks, schools, and with quick access to Highway 7/8, thishome offers both convenience and community. A great opportunity to own a freehold townhome in a desirable Waterloo neighbourhood. (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 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:14:49.632234+00:00"
+"Directions": "Hwy 8 E/ON-7, Take the University Ave East exit, Turn left onto Braemore Ave, Turn left onto Sandowne Dr, Turn right onto Dunvegan Dr, Turn left onto Bairstow Crescent, Turn left onto Camelot Ct, Property will be on the left"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099819"
+"ListOfficeKey": "292918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:33:04Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:33:04Z"
+"Stories": "2.0"
+"StreetName": "CAMELOT"
+"StreetNumber": "255"
+"StreetSuffix": "Court"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3186.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/255_camelot_ct_2_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1667909650"
"RoomType" => "Other"
"ListingId" => "40842924"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.07Z"
]
1 => array:11 [
"RoomKey" => "1667909651"
"RoomType" => "Laundry room"
"ListingId" => "40842924"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.07Z"
]
2 => array:11 [
"RoomKey" => "1667909652"
"RoomType" => "Utility room"
"ListingId" => "40842924"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 5'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.07Z"
]
3 => array:11 [
"RoomKey" => "1667909653"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842924"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.07Z"
]
4 => array:11 [
"RoomKey" => "1667909654"
"RoomType" => "Bedroom"
"ListingId" => "40842924"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.07Z"
]
5 => array:11 [
"RoomKey" => "1667909655"
"RoomType" => "Bedroom"
"ListingId" => "40842924"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.07Z"
]
6 => array:11 [
"RoomKey" => "1667909656"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842924"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.07Z"
]
7 => array:11 [
"RoomKey" => "1667909657"
"RoomType" => "Family room"
"ListingId" => "40842924"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "19'1'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.07Z"
]
8 => array:11 [
"RoomKey" => "1667909658"
"RoomType" => "Dining room"
"ListingId" => "40842924"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 5'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.08Z"
]
9 => array:11 [
"RoomKey" => "1667909659"
"RoomType" => "Kitchen"
"ListingId" => "40842924"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.08Z"
]
10 => array:11 [
"RoomKey" => "1667909660"
"RoomType" => "Foyer"
"ListingId" => "40842924"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953493"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:04.08Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29953493/255-camelot-court-unit-2-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1138
+"BelowGradeFinishedArea": 350
+"OriginalEntryTimestamp": "2026-06-25T18:33:04.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1369903"
+"ListOfficeNationalAssociationId": "1419429"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29953493_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/1768804572af44c9ba134b886d6e9988.webp"
"MediaSize" => 125898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-1768804572af44c9ba134b886d6e9988.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Townhome exterior featuring vertical wood-finish siding, white-frame windows, and a brick facade"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29953493_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/dfede04008ba556a1b4eb0ccf64b841b.webp"
"MediaSize" => 127679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-dfede04008ba556a1b4eb0ccf64b841b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Townhouse exterior featuring vertical siding, a dedicated entrance with an overhang, and an integrated garage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29953493_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/b5d9cd88c39c6f6f72df2c3d6390efa9.webp"
"MediaSize" => 147577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-b5d9cd88c39c6f6f72df2c3d6390efa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29953493_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/3485d146edcfb5edc1e16cbdc282feff.webp"
"MediaSize" => 121051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-3485d146edcfb5edc1e16cbdc282feff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior entrance featuring a white panel door with an arched window, light-colored brick siding, and vertical wood paneling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29953493_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/462ed250923aa3393007d359edec06fd.webp"
"MediaSize" => 87658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-462ed250923aa3393007d359edec06fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a white paneled door with an arched glass insert, black hardware, and an adjacent full-length mirror with a dark frame"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29953493_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/1c805531cfa22a55a5434c839b48d575.webp"
"MediaSize" => 64579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-1c805531cfa22a55a5434c839b48d575.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, dark countertops, white refrigerator, and a white oven with an overhead microwave"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29953493_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/af1810194b1991b0d5fd75ea09c2eb31.webp"
"MediaSize" => 88513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-af1810194b1991b0d5fd75ea09c2eb31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring light-toned carpeting and neutral wall colors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29953493_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/002eed2fa835bfd98c43aca0ab7cf6ba.webp"
"MediaSize" => 92474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-002eed2fa835bfd98c43aca0ab7cf6ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living space with neutral wall color and carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29953493_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/9c215360498f7a3ccf9dbccf221dcd23.webp"
"MediaSize" => 92640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-9c215360498f7a3ccf9dbccf221dcd23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring neutral wall tones and light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29953493_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/18aabbe99d25a99a354acc86f40137d4.webp"
"MediaSize" => 83852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-18aabbe99d25a99a354acc86f40137d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area with neutral wall tones and light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29953493_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/210c4865fac29394c5429f417833ba55.webp"
"MediaSize" => 74224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-210c4865fac29394c5429f417833ba55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring neutral wall tones and light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29953493_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/5f27fc8e86e3873855c0f3ff2c6cfa52.webp"
"MediaSize" => 77886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-5f27fc8e86e3873855c0f3ff2c6cfa52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with a textured ceiling, painted walls, and an entryway to another room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29953493_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/f04c7c733d58eefaf67c6c18d9f0d16d.webp"
"MediaSize" => 80238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-f04c7c733d58eefaf67c6c18d9f0d16d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted dining area featuring a light wood-finish table and dark wood-finish chairs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29953493_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/f6e8ba3d0c845112b35baffd3ec5eaed.webp"
"MediaSize" => 70842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-f6e8ba3d0c845112b35baffd3ec5eaed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, a double basin stainless steel sink, a window with horizontal blinds, a built-in microwave, and a white electric range"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29953493_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/2b46007e8c21ad8eb315646d694adab9.webp"
"MediaSize" => 78014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-2b46007e8c21ad8eb315646d694adab9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, a double basin stainless steel sink, a built-in microwave, white electric range, and a breakfast bar with dark wood-finish countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29953493_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/f6a5a13c89981c28571bc04446832582.webp"
"MediaSize" => 72870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-f6a5a13c89981c28571bc04446832582.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, a double basin stainless steel sink, a dishwasher, and an electric range"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29953493_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/6812d37322eb7ead41466d6325c39790.webp"
"MediaSize" => 75688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-6812d37322eb7ead41466d6325c39790.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29953493_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/76b58e0c8e241ebaeba379d42b8c39e7.webp"
"MediaSize" => 96546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-76b58e0c8e241ebaeba379d42b8c39e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29953493_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/402bc611448dd2c46948ef32dd86c6af.webp"
"MediaSize" => 62645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-402bc611448dd2c46948ef32dd86c6af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted staircase featuring a white handrail, leading to an upper level"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29953493_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/086cddbaf757b30fe43ff2eec49e48cb.webp"
"MediaSize" => 47376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-086cddbaf757b30fe43ff2eec49e48cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29953493_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/2d21d5c5f0c04e2a0f7a9bb45ea6140d.webp"
"MediaSize" => 40822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-2d21d5c5f0c04e2a0f7a9bb45ea6140d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted hallway featuring a built-in closet with bi-fold paneled doors and a flush-mount ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29953493_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/2c8738d668a3d22afad56bb881511cd2.webp"
"MediaSize" => 80617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-2c8738d668a3d22afad56bb881511cd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring neutral-toned walls, white trim, and light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29953493_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/c5b9fe7c63036924a8ed8932987f2270.webp"
"MediaSize" => 61866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-c5b9fe7c63036924a8ed8932987f2270.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned wall finishes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29953493_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/0fe92c0a7b3a73c4e3e94dfe96fbceaa.webp"
"MediaSize" => 50024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-0fe92c0a7b3a73c4e3e94dfe96fbceaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with integrated sink, chrome faucet, and mirrored medicine cabinet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29953493_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/cf02bd466a31b5e97f26f2285b4184f4.webp"
"MediaSize" => 77007
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-cf02bd466a31b5e97f26f2285b4184f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with light blue walls and a white textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29953493_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/88f9144695b940c90787fb7bf81e8b6a.webp"
"MediaSize" => 78606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-88f9144695b940c90787fb7bf81e8b6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29953493_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/aa0d3fda5f79504aa5d638b137e7febb.webp"
"MediaSize" => 78251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-aa0d3fda5f79504aa5d638b137e7febb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned walls complement the light-colored carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29953493_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/47c8b5d935701ce916164477aa0845b1.webp"
"MediaSize" => 69937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-47c8b5d935701ce916164477aa0845b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom with neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29953493_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/07aebd34887b37fdbf16c8673b365025.webp"
"MediaSize" => 65753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-07aebd34887b37fdbf16c8673b365025.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29953493_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/23e8a544f4982b32fff1994e15de3c6d.webp"
"MediaSize" => 79520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-23e8a544f4982b32fff1994e15de3c6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished room featuring neutral carpeting, white walls, and a drop ceiling with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29953493_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/03be4823ff5df50a1d8b349ce8aa5fb0.webp"
"MediaSize" => 80509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-03be4823ff5df50a1d8b349ce8aa5fb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned walls complement the light carpet flooring in this versatile room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29953493_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/26fcd6a9c973141c089fb3a03f3d4f71.webp"
"MediaSize" => 72743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-26fcd6a9c973141c089fb3a03f3d4f71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29953493_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/d572a0dd58f9b06f2d98136cc77bb5af.webp"
"MediaSize" => 96924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-d572a0dd58f9b06f2d98136cc77bb5af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a white top-load washing machine and a white front-load dryer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29953493_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/526c52c4d1e5e0faeab2485cddc20246.webp"
"MediaSize" => 158788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-526c52c4d1e5e0faeab2485cddc20246.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious wooden deck with slatted railing and a brick exterior wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29953493_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/3ff9893a91ece9b40fe523f9a61b0c08.webp"
"MediaSize" => 169359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-3ff9893a91ece9b40fe523f9a61b0c08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level wooden deck featuring a railing system and steps"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29953493_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/27a41affa52d430e9be2df58b7b8d0cf.webp"
"MediaSize" => 134217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-27a41affa52d430e9be2df58b7b8d0cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior brick facade with vertical siding accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29953493_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/be1f94ce185a0e8056dcbf59b8e55878.webp"
"MediaSize" => 157385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-be1f94ce185a0e8056dcbf59b8e55878.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Tiered wooden deck with steps to a grassy area, brick exterior, and partial fencing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29953493_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/51ec11bd2c10eea41f4b338da994b93c.webp"
"MediaSize" => 150557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-51ec11bd2c10eea41f4b338da994b93c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring multiple elevated wood decks, brick and siding facade, and a ground-level grass lawn with established perimeter landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29953493_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/6499c12352ffa7fea0b35d50fd257153.webp"
"MediaSize" => 167731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-6499c12352ffa7fea0b35d50fd257153.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Townhome exterior featuring individual garage access and covered front entries"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29953493_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/e763fd9fcaee09148272646afae9f5bd.webp"
"MediaSize" => 152107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-e763fd9fcaee09148272646afae9f5bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a residential area with varied housing styles, mature trees, and a spacious green field featuring a baseball diamond"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29953493_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/7366cab35d5d0028b035fbe4681927a5.webp"
"MediaSize" => 163466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-7366cab35d5d0028b035fbe4681927a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Residential neighborhood featuring rows of townhomes and detached properties, bordered by a multi-lane highway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29953493_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/e8f1a0632ed6cdbc7fef472c83233af3.webp"
"MediaSize" => 133482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-e8f1a0632ed6cdbc7fef472c83233af3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a residential area with multiple row houses, a multi-lane highway, and a distant city skyline"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29953493_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/70f70f94b148825971183e6a8ddf6011.webp"
"MediaSize" => 41971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-70f70f94b148825971183e6a8ddf6011.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29953493_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/70822029559e971a0e4f7c243638e7bd.webp"
"MediaSize" => 48514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-70822029559e971a0e4f7c243638e7bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29953493_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953493/07575cb77de1a0f33477f0e9b5ebfc32.webp"
"MediaSize" => 40592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953493/thumbnail-07575cb77de1a0f33477f0e9b5ebfc32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842924"
"ResourceRecordKey" => "29953493"
"ModificationTimestamp" => "2026-06-25T18:33:04.03Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953493')"
+"ID": "1563097"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 292918" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24842
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2099819" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24841
+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 '29953493'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25244
+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 '29953493'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25260
+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 '29953493' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5079629 43.4921833)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25333
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25327
+post_id: "1562594"
+post_author: 1
+"ListingKey": "29951014"
+"ListingId": "X13487184"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T03:25:01Z"
+"RFModificationTimestamp": "2026-06-26T04:38:16Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3S6"
+"UnparsedAddress": "217 MAYFIELD AVENUE, Waterloo, Ontario N2J3S6"
+"Coordinates": array:2 [
0 => -80.510872
1 => 43.480402
]
+"Latitude": 43.480402
+"Longitude": -80.510872
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare Find! Highly auspicious North-facing VASTU-compliant home; Fully Renovated LEGAL DUPLEX - Turnkey & Positive Cash Flow. Minutes from 3 universities 3+2 Bedrooms 2 Full Baths, 2 Kitchens. Detached bungalow on a large lot in a quiet, family-friendly avenue in the desirable Lincoln Heights / Glenridge neighbourhood - within the boundary of top-rated schools. MAIN FLOOR: Spacious layout with a Large primary bedroom and walk-out to a private deck overlooking the backyard, plus two additional regular bedrooms. LEGAL BASEMENT: 2 Large bedrooms + Office room. Highlights: Over 2,000 sq ft of finished living space; Detached oversized garage + long driveway with ample parking; Currently rented to respectful, responsible university students who pay on time and care for the property; POSITIVE CASH FLOW from day one; Bonus upside - BUILD BIG LATER: This large lot qualifies as-of-right for up to a 4-unit, 4-storey building under Waterloo's December 2024 "FOUR Units, FOUR Storeys" bylaw - no rezoning, no variances. A complete conceptual fourplex design (3D model + floor plans) is available for serious buyers. A standout opportunity for homeowners & investors alike. No gimmicks. NO offer date. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Range"
4 => "Dryer"
5 => "Microwave"
6 => "Furniture"
7 => "Water Heater"
8 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:21:57.875346+00:00"
+"Directions": "Cross Streets: University Ave / Conestoga Pkwy. ** Directions: University Ave To Mayfield Ave."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Vinyl"
2 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2019588"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "60.1 x 120.7 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T13:13:58Z"
+"PhotosCount": 19
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T03:17:35Z"
+"Stories": "1.0"
+"StreetName": "Mayfield"
+"StreetNumber": "217"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4451.61"
+"View": "View"
+"VirtualTourURLUnbranded": "https://video-api.supreme.one/48PjWV?branded=true"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1668295410"
"RoomType" => "Bedroom 2"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29951014"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
1 => array:11 [
"RoomKey" => "1668295411"
"RoomType" => "Office"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29951014"
"RoomLength" => 4.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
2 => array:11 [
"RoomKey" => "1668295412"
"RoomType" => "Living room"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5
"ListingKey" => "29951014"
"RoomLength" => 6.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
3 => array:11 [
"RoomKey" => "1668295413"
"RoomType" => "Bathroom"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 1.4
"ListingKey" => "29951014"
"RoomLength" => 1.75
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
4 => array:11 [
"RoomKey" => "1668295414"
"RoomType" => "Living room"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 4.0
"ListingKey" => "29951014"
"RoomLength" => 4.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
5 => array:11 [
"RoomKey" => "1668295415"
"RoomType" => "Dining room"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5
"ListingKey" => "29951014"
"RoomLength" => 6.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
6 => array:11 [
"RoomKey" => "1668295416"
"RoomType" => "Kitchen"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29951014"
"RoomLength" => 5.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
7 => array:11 [
"RoomKey" => "1668295417"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 3.97
"ListingKey" => "29951014"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
8 => array:11 [
"RoomKey" => "1668295418"
"RoomType" => "Bedroom 2"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29951014"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
9 => array:11 [
"RoomKey" => "1668295419"
"RoomType" => "Bedroom 3"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 2.9
"ListingKey" => "29951014"
"RoomLength" => 4.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
10 => array:11 [
"RoomKey" => "1668295420"
"RoomType" => "Bathroom"
"ListingId" => "X13487184"
"RoomLevel" => "Main level"
"RoomWidth" => 1.5
"ListingKey" => "29951014"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
11 => array:11 [
"RoomKey" => "1668295421"
"RoomType" => "Kitchen"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 4.0
"ListingKey" => "29951014"
"RoomLength" => 4.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.68Z"
]
12 => array:11 [
"RoomKey" => "1668295422"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13487184"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29951014"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-26T03:17:35.69Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29951014/217-mayfield-avenue-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.1
+"OriginalEntryTimestamp": "2026-06-25T13:13:58.05Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1299556"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:19 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29951014_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/b0f18832d6aea2a94358417abd4246e3.webp"
"MediaSize" => 147646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-b0f18832d6aea2a94358417abd4246e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13487184"
"ResourceRecordKey" => "29951014"
"ModificationTimestamp" => "2026-06-25T13:13:58.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29951014_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951014/613ddab0d7bfb304922811a680d05c61.webp"
"MediaSize" => 470853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951014/thumbnail-613ddab0d7bfb304922811a680d05c61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951014')"
+"ID": "1562594"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25329
+post_id: "1562014"
+post_author: 1
+"ListingKey": "29953652"
+"ListingId": "X13489360"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:05:24Z"
+"RFModificationTimestamp": "2026-06-25T20:30:46Z"
+"ListPrice": 414999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4J1"
+"UnparsedAddress": "32 - 121 UNIVERSITY AVENUE E, Waterloo, Ontario N2J4J1"
+"Coordinates": array:2 [
0 => -80.515579
1 => 43.477294
]
+"Latitude": 43.477294
+"Longitude": -80.515579
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Calling all INVESTORS , FIRST TIME HOME BUYERS AND FAMILIES ALIKE ! This exceptional 5 bedroom townhouse has the potential of $3,500 to$4,000 per month rent !, For families and first time home buyers the square footage offers incredible value. The spacious layout seamlessly flows from room to room, creating an inviting atmosphere for both relaxation and entertainment. Enjoy preparing meals with ease as there is noshortage of counter space in the kitchen. Morning coffee or barbecues with friends on your patio. Each bedroom offering plenty of space, natural light, and closet storage. The master bedroom features an ensuite bath & walk in closet . Downstairs, is a rec room for movie nights and entertaining. There is an abundance of storage in the basement for all of your extra belongings. Take advantage of the proximity to excellent schools, Wilfred Laurier University, Waterloo University as well as the Conestoga College campus, Miles of scenic walking trails for outdoor enthusiasts to explore the natural beauty of the surrounding area. For those who enjoy shopping and dining, you're in luck! This property is conveniently located within walking distance to great shopping destinations and local eateries, providing endless opportunities for leisure! No scraping your car this upcoming winter as there is a underground parking space included. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "766"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:27:11.755530+00:00"
+"Directions": "Cross Streets: Marsland. ** Directions: University Ave East to Marsland drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2193931"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:48Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:58:48Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "University"
+"StreetNumber": "121"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3304"
+"VirtualTourURLUnbranded": "https://youriguide.com/32_121_university_ave_e_waterloo_on/"
+"Rooms": array:15 [
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]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953652/32-121-university-avenue-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2247230"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "ONYX"
+"CoListOfficeKey": "286835"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-25T18:36:48.32Z"
+"ListAgentNationalAssociationId": "1443150"
+"ListOfficeNationalAssociationId": "1364242"
+"CoListAgentNationalAssociationId": "1486102"
+"CoListOfficeNationalAssociationId": "1364242"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953652')"
+"ID": "1562014"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: "1561308"
+post_author: 1
+"ListingKey": "29952188"
+"ListingId": "40842768"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T17:00:12Z"
+"RFModificationTimestamp": "2026-06-25T19:26:50Z"
+"ListPrice": 414999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1886.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4J1"
+"UnparsedAddress": "121 UNIVERSITY Avenue E Unit# 32, Waterloo, Ontario N2J4J1"
+"Coordinates": array:2 [
0 => -80.5156713
1 => 43.4772121
]
+"Latitude": 43.4772121
+"Longitude": -80.5156713
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Calling all INVESTORS , FIRST TIME HOME BUYERS AND FAMILIES ALIKE ! This exceptional 5 bedroom townhouse has the potential of $3,500 to $4,000 per month rent !, For families and first time home buyers the square footage offers incredible value. The spacious layout seamlessly flows from room to room, creating an inviting atmosphere for both relaxation and entertainment. Enjoy preparing meals with ease as there is no shortage of counter space in the kitchen. Morning coffee or barbecues with friends on your patio. Each bedroom offering plenty of space, natural light, and closet storage. The master bedroom features an ensuite bath & walk in closet . Downstairs, is a rec room for movie nights and entertaining. There is an abundance of storage in the basement for all of your extra belongings. Take advantage of the proximity to excellent schools, Wilfred Laurier University, Waterloo University as well as the Conestoga College campus, Miles of scenic walking trails for outdoor enthusiasts to explore the natural beauty of the surrounding area. For those who enjoy shopping and dining, you're in luck! This property is conveniently located within walking distance to great shopping destinations and local eateries, providing endless opportunities for leisure! No scraping your car this upcoming winter as there is a underground parking space included. (id:62650)"
+"AssociationFee": "766"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T19:26:41.683405+00:00"
+"Directions": "University Ave East to Marsland drive"
+"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": "2034139"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-25T16:50:25Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T16:50:25Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "UNIVERSITY"
+"StreetNumber": "121"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3304"
+"VirtualTourURLUnbranded": "https://youriguide.com/32_121_university_ave_e_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29952188/121-university-avenue-e-unit-32-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1800304"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289848"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1568
+"BelowGradeFinishedArea": 318
+"OriginalEntryTimestamp": "2026-06-25T16:50:25.59Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1310837"
+"ListOfficeNationalAssociationId": "1381908"
+"CoListAgentNationalAssociationId": "1190449"
+"CoListOfficeNationalAssociationId": "1381908"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29952188')"
+"ID": "1561308"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+post_id: "1557351"
+post_author: 1
+"ListingKey": "29941712"
+"ListingId": "40842211"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T02:00:27Z"
+"RFModificationTimestamp": "2026-06-26T04:47:25Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3520.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3J1"
+"UnparsedAddress": "391 TIMLOCK Place, Waterloo, Ontario N2K3J1"
+"Coordinates": array:2 [
0 => -80.5005194
1 => 43.4981893
]
+"Latitude": 43.4981893
+"Longitude": -80.5005194
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful family home tucked away on a quiet court in Waterloo's sought-after Lexington neighbourhood. Surrounded by mature trees, parks, trails, schools and a strong sense of community, this is the kind of neighbourhood where families put down roots and stay for years. Offering generous above-grade living space plus a finished basement, this 4-bedroom, 4-bathroom home blends comfort, functionality and timeless style. Freshly painted in neutral tones with recent basement updates, it has been well maintained with a new roof (2020), furnace (2014), air conditioner (2025) and many updated windows. The spacious kitchen is the heart of the home, with plenty of room for family and friends to gather. Multiple living areas on the main floor provide flexibility for everyday living and entertaining, including a welcoming family room, dining room and separate sitting room. Main floor laundry adds convenience. Upstairs, four generous bedrooms include a relaxing primary retreat with a beautifully updated ensuite bath. The finished basement adds valuable living space with a large recreation and games area, perfect for movie nights, gaming, ping pong, board games or simply spending time together. A separate bonus room works equally well as a home office, fitness room, guest space or hobby room. A two-piece bathroom and ample storage complete the lower level. Outside, the large private backyard offers plenty of room for children and pets to play, gardens to grow, or future outdoor living plans. A double garage and parking for four vehicles provide plenty of room for family and guests. Located minutes from Rim Park, recreation facilities, transit, shopping and everyday amenities, this home offers the perfect balance of peaceful suburban living and convenient city access. Beautifully maintained, thoughtfully updated and ideally located, this is a rare opportunity to own a home in one of Waterloo's most desirable family neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:50:07.259543+00:00"
+"Directions": "Bridge to Dansbury to Forestlawn to Timlock Pl"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1830254"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:22:31Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T01:50:53Z"
+"Stories": "2.0"
+"StreetName": "TIMLOCK"
+"StreetNumber": "391"
+"StreetSuffix": "Place"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "7963.37"
+"VirtualTourURLUnbranded": "https://youriguide.com/391_timlock_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29941712/391-timlock-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 2400
+"BelowGradeFinishedArea": 1120
+"OriginalEntryTimestamp": "2026-06-23T16:11:30.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1195645"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941712')"
+"ID": "1557351"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25328
+post_id: "1555612"
+post_author: 1
+"ListingKey": "29938343"
+"ListingId": "40842043"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T14:20:12Z"
+"RFModificationTimestamp": "2026-06-25T21:04:14Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1090.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3T1"
+"UnparsedAddress": "207 B AUBURN Drive, Waterloo, Ontario N2K3T1"
+"Coordinates": array:2 [
0 => -80.4866626
1 => 43.4874765
]
+"Latitude": 43.4874765
+"Longitude": -80.4866626
+"YearBuilt": 1992
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in Waterloo's highly sought-after University Downs neighbourhood, this beautifully updated family home offers the perfect combination of modern updates, functional living space, and an unbeatable location. The bright open-concept main floor is designed for both everyday living and entertaining, featuring laminate flooring, a charming kitchen, and a spacious dining area overlooking the family room. Patio doors lead to a large, fully fenced backyard, creating the perfect setting for summer barbecues, outdoor play, and gatherings with family and friends. Upstairs, you'll find three spacious bedrooms and a beautifully updated bathroom, providing plenty of room for a growing family. The finished basement adds valuable living space and is ideal for a rec room, playroom, home office, or gym. A bathroom and laundry room complete the lower level. Thoughtful updates throughout make this home truly move-in ready. Outside, the large driveway offers ample parking for multiple vehicles, making everyday life and entertaining guests easy and convenient. Ideally located close to excellent schools, parks, walking trails, Conestoga Mall, the LRT, universities, shopping, restaurants, and major commuter routes, families will appreciate the mature tree-lined streets, strong sense of community, and proximity to all the amenities that make University Downs one of Waterloo's most desirable neighbourhoods. Beautifully updated, family-friendly, and ready to enjoy—this is a place you'll be proud to call home. Some photos virtually staged. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T22:10:36.777923+00:00"
+"Directions": "Auburn and University"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600661"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T20:32:10Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T14:11:17Z"
+"Stories": "2.0"
+"StreetName": "AUBURN"
+"StreetNumber": "207"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3637.94"
+"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/29938343/207-b-auburn-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1090
+"OriginalEntryTimestamp": "2026-06-22T20:32:10.46Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1155649"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938343')"
+"ID": "1555612"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1538278"
+post_author: 1
+"ListingKey": "29914287"
+"ListingId": "40839253"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T18:00:17Z"
+"RFModificationTimestamp": "2026-06-23T19:54:52Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.094
+"LivingArea": 2571.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Z8"
+"UnparsedAddress": "212 SLEAFORD Street, Waterloo, Ontario N2J4Z8"
+"Coordinates": array:2 [
0 => -80.5224041
1 => 43.4908368
]
+"Latitude": 43.4908368
+"Longitude": -80.5224041
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**Welcome to 212 Sleaford Street, Waterloo!** LOCATION LOCATION LOCATION!! This inviting detached house with a double-car garage locates in one of the most desirable area in the City of Waterloo. It offers an exceptional combination of space, versatility, and convenience. The upper level features 3 comfortable bedrooms and a generously sized family room filled with natural light, make it an ideal space for relaxing, entertaining, or spending quality time with family members together. The finished basement expands the home’s possibilities with an additional bedroom, a 3-piece bathroom, and spacious recreation space. With its own separate entrance, the lower level offers excellent flexibility for extended family, guests, a private home office, or potential future rental use. Ideally situated just minutes from Conestoga Mall and HWY 85, provides convenient access to shopping, restaurants, public transit, major routes throughout Waterloo Region. It is also within easy reach of the University of Waterloo, Wilfrid Laurier University, and Conestoga College by public transit or a 10 mins drive, making it an attractive opportunity for first-time buyers, growing families, and investors alike. RIM Park Sportsplex is also nearby, provides family with easy access to various sports throughout the season (hockey, skating, indoor/outdoor soccer fields, basketball, badminton and more). Recent improvements include a new hot water tank installed in 2026 (owned), and a new water softener (owned, 2025). As an added bonus, ALL FURNITURE currently in the home can be INCLUDED, offering a truly convenient and move-in-ready opportunity. With its generous living space, versatile finished basement, double garage, and highly desirable Waterloo location, this is a home you will not want to miss!!! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:57:09.434616+00:00"
+"Directions": "Dearborn Blvd / Tealby Crt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2168724"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.094"
+"PhotosChangeTimestamp": "2026-06-19T21:41:14Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T17:52:05Z"
+"Stories": "2.0"
+"StreetName": "SLEAFORD"
+"StreetNumber": "212"
+"StreetSuffix": "Street"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "5421.13"
+"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/29914287/212-sleaford-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "50-R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1818
+"BelowGradeFinishedArea": 753
+"OriginalEntryTimestamp": "2026-06-17T11:50:23.7Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1419405"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914287')"
+"ID": "1538278"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1531330"
+post_author: 1
+"ListingKey": "29906169"
+"ListingId": "X13447076"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:45:10Z"
+"RFModificationTimestamp": "2026-06-25T19:00:19Z"
+"ListPrice": 625000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3K9"
+"UnparsedAddress": "209 DIXIE CRESCENT, Waterloo, Ontario N2J3K9"
+"Coordinates": array:2 [
0 => -80.513059
1 => 43.477575
]
+"Latitude": 43.477575
+"Longitude": -80.513059
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 209 Dixie Crescent, a lovingly maintained bungalow that has been cherished by the same family for over 60 years and is now ready for its next chapter. Nestled on a quiet, tree-lined crescent in one of Waterloo's most established and family-friendly neighbourhoods, this home offers over 2,000 square feet of finished living space and endless potential. Featuring 3 bedrooms, 2 bathrooms, and a solid, well-built structure, this home provides the perfect opportunity to move in and enjoy or renovate and create the home of your dreams. Many of the major updates have already been completed, including windows, roof (2015), furnace (2022), and central air conditioning (2022), allowing you to focus on personalizing the interior to suit your style and needs. Inside, a bright and welcoming living room is filled with natural light from a large picture window. The adjoining dining area offers a comfortable space for everyday meals and family gatherings, with sliding patio doors leading to a covered deck-an ideal setting for morning coffee or entertaining. The finished basement with a separate entrance adds exceptional versatility, offering excellent potential for multi-generational living, rental possibilities, or simply additional space for recreation, hobbies, and family enjoyment. One of the standout features of this property is the mature backyard. Rarely found in newer developments, the expansive outdoor space provides privacy, room to play, and endless possibilities for gardening, entertaining, or future enhancements. Beyond the existing fence line, you'll discover approximately 20 additional feet of usable space, further expanding the potential of this remarkable lot. Conveniently located close to excellent schools, both universities, parks, trails, shopping, transit, and the expressway, this is more than just a home-it's an opportunity to establish roots in a sought-after Waterloo neighbourhood and create lasting memories for years to come. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:55:49.379184+00:00"
+"Directions": "Cross Streets: Marshall. ** Directions: Willowdale to Dixie."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:1 [
0 => "Free Standing Metal"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2133582"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "52 x 125 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:02:48Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:35:33Z"
+"Stories": "1.0"
+"StreetName": "Dixie"
+"StreetNumber": "209"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4397.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/209_dixie_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906169/209-dixie-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 52.0
+"OriginalEntryTimestamp": "2026-06-15T20:02:48.53Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1386021"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906169')"
+"ID": "1531330"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "1531566"
+post_author: 1
+"ListingKey": "29904482"
+"ListingId": "40839889"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T17:00:15Z"
+"RFModificationTimestamp": "2026-06-15T20:08:57Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2573.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3S9"
+"UnparsedAddress": "225 DARTMOOR Crescent, Waterloo, Ontario N2K3S9"
+"Coordinates": array:2 [
0 => -80.4878773
1 => 43.4871065
]
+"Latitude": 43.4871065
+"Longitude": -80.4878773
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 225 Dartmoor Crescent in Waterloo, a spacious and well-maintained two-storey home offering over 2,500 sq. ft. of total living space in a sought-after family-friendly neighbourhood. This 3 bedroom, 4 bathroom home features a functional layout designed for both everyday living and entertaining. The main floor offers a large, inviting living room complete with a cozy fireplace, engineered hardwood floors, and extra large windows that fill the space with natural light. The living area flows seamlessly into the dining room, creating the perfect setting for family gatherings and hosting guests. The kitchen offers plenty of cabinet space, room for a breakfast table, and sliding glass doors leading to a private fully fenced backyard with patio, ideal for summer BBQs, outdoor dining, or relaxing evenings. Upstairs, you’ll find three generously sized bedrooms with plush carpeting, including a spacious primary suite featuring its own private ensuite bathroom. The finished basement adds even more living space with a large rec room complete with a built-in bar, making it the perfect spot for entertaining, movie nights, or a games area. Additional highlights include a double car garage and ample storage throughout. Conveniently located close to Bechtel Park, Bridgeport Public School, shopping, amenities, and with easy access to Highway 85 for commuters, this home offers the perfect combination of comfort, space, and location. (id:62783)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T20:08:46.315278+00:00"
+"Directions": "DARTMOOR CRES AND BRIDLE TRAIL"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897572"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T16:51:48Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T16:51:48Z"
+"Stories": "2.0"
+"StreetName": "DARTMOOR"
+"StreetNumber": "225"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "5480"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29904482/225-dartmoor-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 56.0
+"AboveGradeFinishedArea": 1699
+"BelowGradeFinishedArea": 874
+"OriginalEntryTimestamp": "2026-06-15T16:51:48Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1215332"
+"ListOfficeNationalAssociationId": "1438749"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904482')"
+"ID": "1531566"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+post_id: "1530988"
+post_author: 1
+"ListingKey": "29903648"
+"ListingId": "40839800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T18:40:14Z"
+"RFModificationTimestamp": "2026-06-22T18:42:57Z"
+"ListPrice": 735000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2287.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G8"
+"UnparsedAddress": "460 WOOLWICH Street Unit# 24, Waterloo, Ontario N2K4G8"
+"Coordinates": array:2 [
0 => -80.4939516
1 => 43.5014803
]
+"Latitude": 43.5014803
+"Longitude": -80.4939516
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to Riverstone Estates. Beautiful bright 3 bedroom, 3 bathroom multi level townhome located in highly desirable East Waterloo. Main floor has large open concept living/dining/kitchen area. Second floor features 2 bedrooms + 4 pc bath. Master suite located on upper level with full ensuite and walk in closet. Living room features a gas fireplace. All appliances included. Lower level finished, with full walkout basement and access to single garage. Patio door walk out from dining room to private deck area. Parking for 2 cars. Prime location to Walter Bean Trail, the Grand River, Kiwanis Park, Grey Silo Golf Course, Rim Park and expressway. Ample Visitor parking in front of unit. Seller can be flexible on closing. Low Condo Fee. Come Check out. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "235"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:21:53.555087+00:00"
+"Directions": "Off Woolwich"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564596"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:31:12Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T18:32:42Z"
+"Stories": "2.0"
+"StreetName": "WOOLWICH"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4712.14"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29903648/460-woolwich-street-unit-24-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1950017"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2287
+"OriginalEntryTimestamp": "2026-06-15T15:31:11.85Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1095797"
+"ListOfficeNationalAssociationId": "1004391"
+"CoListAgentNationalAssociationId": "1244287"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903648')"
+"ID": "1530988"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 92
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]