array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29951785 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23442
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23444
+post_id: "1561837"
+post_author: 1
+"ListingKey": "29951785"
+"ListingId": "40842536"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T16:00:15Z"
+"RFModificationTimestamp": "2026-06-25T20:03:47Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1279.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 12, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.5890984
1 => 43.4499345
]
+"Latitude": 43.4499345
+"Longitude": -80.5890984
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this meticulously maintained, turn-key stacked townhouse in Waterloo’s highly sought-after Vista Hills community! Built by Activa, this Viola layout has been lovingly cared for by its original and sole owner, showing true pride of ownership. Step inside to discover a bright, open-concept layout elevated by a complete premium interior renovation upon move-in. The main floor boasts 9-foot ceilings and features a stunning, fully upgraded modern kitchen with high-end countertops, custom cabinetry, and a seamless flow into the great room. The space is beautifully accented with sophisticated crown moldings and elegant large-format wall tiles that exude a custom, luxury feel. True Carpet-Free living throughout with contemporary, wide-plank flooring. Enjoy private outdoor living with TWO balconies—one off the main great room and a second off the primary bedroom. The upper level offers two spacious bedrooms, a 4-piece main bathroom, upper-floor laundry, and a generous linen/storage closet. The primary suite serves as a true retreat, complete with a 3-piece ensuite and a walk-in closet. Phenomenal location designated for top-rated schools, including Vista Hills Public School and Laurel Heights Secondary School. Unbeatable convenience with Costco just a short drive away, alongside the nearby Boardwalk shopping district for all your retail and dining needs. Enjoy scenic walking trails, community parks, public transit, and quick access to the University of Waterloo and Wilfrid Laurier University. This pristine, upgraded home offers the perfect blend of comfort, style, and a lifestyle of ultimate convenience—ideal for professionals, growing families, or investors! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"AssociationFee": "359.56"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Property Management"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:03:37.713365+00:00"
+"Directions": "COLUMBIA ST TO LADYSLIPPER DR TO FOAMFLOWER PLACE"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180828"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-25T15:50:49Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T15:50:49Z"
+"Stories": "2.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3315"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1667769675"
"RoomType" => "Laundry room"
"ListingId" => "40842536"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.25Z"
]
1 => array:11 [
"RoomKey" => "1667769676"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842536"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.25Z"
]
2 => array:11 [
"RoomKey" => "1667769677"
"RoomType" => "Bedroom"
"ListingId" => "40842536"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.26Z"
]
3 => array:11 [
"RoomKey" => "1667769678"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842536"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.26Z"
]
4 => array:11 [
"RoomKey" => "1667769679"
"RoomType" => "Full bathroom"
"ListingId" => "40842536"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.26Z"
]
5 => array:11 [
"RoomKey" => "1667769680"
"RoomType" => "Utility room"
"ListingId" => "40842536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.26Z"
]
6 => array:11 [
"RoomKey" => "1667769681"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => "2'10'' x 5'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.26Z"
]
7 => array:11 [
"RoomKey" => "1667769682"
"RoomType" => "Kitchen"
"ListingId" => "40842536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 17'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.26Z"
]
8 => array:11 [
"RoomKey" => "1667769683"
"RoomType" => "Great room"
"ListingId" => "40842536"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 17'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.26Z"
]
9 => array:11 [
"RoomKey" => "1667769684"
"RoomType" => "Foyer"
"ListingId" => "40842536"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29951785"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T15:50:49.26Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29951785/142-foamflower-place-unit-12-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1279
+"OriginalEntryTimestamp": "2026-06-25T15:50:49.21Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430684"
+"ListOfficeNationalAssociationId": "1394395"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29951785_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/b2ac277177421e076d3aea67d1f9cce9.webp"
"MediaSize" => 67873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-b2ac277177421e076d3aea67d1f9cce9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern multi-story building featuring varied paneling, large windows, and multiple balconies with glass railings"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29951785_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/1a03610d532bb0c4137b8e061374aea9.webp"
"MediaSize" => 68065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-1a03610d532bb0c4137b8e061374aea9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern multi-level exterior featuring light-toned siding, grey brick accents, and dark trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29951785_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/b5d096855061edef4e7fc300c20d0ab2.webp"
"MediaSize" => 66461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-b5d096855061edef4e7fc300c20d0ab2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area with light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29951785_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/34c62d661cdc4fbb34fbfe5b2891f565.webp"
"MediaSize" => 65794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-34c62d661cdc4fbb34fbfe5b2891f565.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring light wood-finish flooring, a contemporary kitchen with dark cabinetry, stainless steel appliances, and a white subway tile backsplash, a kitchen island with seatin"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29951785_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/ea278a1b629e3c8d14c1b99fc2156118.webp"
"MediaSize" => 59987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-ea278a1b629e3c8d14c1b99fc2156118.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29951785_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/7ef7f8ee0f9106c58feccf5cc93f3e8d.webp"
"MediaSize" => 55469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-7ef7f8ee0f9106c58feccf5cc93f3e8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29951785_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/3b224cd0c14876ca02a27cb8ee0e7e25.webp"
"MediaSize" => 63245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-3b224cd0c14876ca02a27cb8ee0e7e25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring light wood-finish flooring, a kitchen with dark cabinetry and stainless steel appliances, a white subway tile backsplash, and a breakfast bar island"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29951785_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/7f84c08ce013e2f195e1b0df5f83e277.webp"
"MediaSize" => 64955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-7f84c08ce013e2f195e1b0df5f83e277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29951785_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/3913519bfc3a6d2f7b6a8d3ad575bf8b.webp"
"MediaSize" => 59009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-3913519bfc3a6d2f7b6a8d3ad575bf8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29951785_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/dc3d7d556f65629d3d3fcdd3a6fed1f7.webp"
"MediaSize" => 52855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-dc3d7d556f65629d3d3fcdd3a6fed1f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring shaker-style cabinetry, a stainless steel range hood, white subway tile backsplash, and light-toned countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29951785_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/fab119b814e9d2ebfd2df20d26324b81.webp"
"MediaSize" => 60903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-fab119b814e9d2ebfd2df20d26324b81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark grey shaker-style cabinetry, white subway tile backsplash, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29951785_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/92e411dc669de9768d20250ed2bda7d1.webp"
"MediaSize" => 62613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-92e411dc669de9768d20250ed2bda7d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring a spacious island with a built-in sink, dark cabinetry, stainless steel appliances, white subway tile backsplash, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29951785_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/d4e290ec03bdf2d9602bbc844df1ea31.webp"
"MediaSize" => 54297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-d4e290ec03bdf2d9602bbc844df1ea31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring a dual-basin stainless steel sink with a high-arc faucet, white countertops, dark cabinetry, and a white subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29951785_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/7f0c189872a3108981f5dac68c252577.webp"
"MediaSize" => 54907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-7f0c189872a3108981f5dac68c252577.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring sleek gray cabinetry, white countertops, a white subway tile backsplash, and stainless steel appliances including a range and range hood"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29951785_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/3744b0b220a7214ef8e77ca224ae4139.webp"
"MediaSize" => 63116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-3744b0b220a7214ef8e77ca224ae4139.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark grey cabinetry, light countertops, stainless steel appliances, and a white subway tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29951785_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/7c3215602631da53a43117c37cb0c038.webp"
"MediaSize" => 62233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-7c3215602631da53a43117c37cb0c038.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring a dual-basin stainless steel sink with a gooseneck faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29951785_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/aa80d94baf7fb960a1c114ccf6222548.webp"
"MediaSize" => 63630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-aa80d94baf7fb960a1c114ccf6222548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring dark cabinetry, light countertops, stainless steel appliances, a tile backsplash, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29951785_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/1321b31b9912b4e17de9eb2ef072631b.webp"
"MediaSize" => 45096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-1321b31b9912b4e17de9eb2ef072631b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29951785_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/50184f37adaa5b02efec906d0de1a30f.webp"
"MediaSize" => 43320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-50184f37adaa5b02efec906d0de1a30f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pedestal sink with chrome faucet, wall-mounted mirror, and frosted window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29951785_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/b5f005f0b0a648d0b261b9e29a62dde9.webp"
"MediaSize" => 24972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-b5f005f0b0a648d0b261b9e29a62dde9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Compact water closet featuring a white ceramic toilet, light-toned tile flooring, and chrome fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29951785_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/9ca70274e585f93e0eb5336327cb3903.webp"
"MediaSize" => 41968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-9ca70274e585f93e0eb5336327cb3903.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29951785_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/cf9b070828a8f80abea60eb3068159e6.webp"
"MediaSize" => 53252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-cf9b070828a8f80abea60eb3068159e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29951785_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/33932e9a64e4d4909b1fcf00313bc67f.webp"
"MediaSize" => 58821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-33932e9a64e4d4909b1fcf00313bc67f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior with light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29951785_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/83ad58283916f98d5607318c21e04874.webp"
"MediaSize" => 60709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-83ad58283916f98d5607318c21e04874.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring throughout, framed by white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29951785_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/3dc0eccdd3f42bc43fb6c902aed69f27.webp"
"MediaSize" => 57807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-3dc0eccdd3f42bc43fb6c902aed69f27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light wood-finish flooring, white walls, and a window with sheer and blackout curtains"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29951785_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/70dc7690a08724822ac2ac3b7456a637.webp"
"MediaSize" => 54678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-70dc7690a08724822ac2ac3b7456a637.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29951785_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/a1093dbf4f1f2a100094519547f57c05.webp"
"MediaSize" => 56941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-a1093dbf4f1f2a100094519547f57c05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-finish flooring and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29951785_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/4720f66777fe92335f74a510d73b9327.webp"
"MediaSize" => 46389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-4720f66777fe92335f74a510d73b9327.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior room featuring light-toned wood-finish flooring and crisp white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29951785_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/2d2114b4e5f322dd91039a7367655a5d.webp"
"MediaSize" => 45280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-2d2114b4e5f322dd91039a7367655a5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a frameless glass shower enclosure with white marble-style subway tile surround, a built-in shower niche, and a shower head with handheld sprayer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29951785_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/ca86d2a0067049376d4a3297a6319c8b.webp"
"MediaSize" => 37894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-ca86d2a0067049376d4a3297a6319c8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a spacious glass-enclosed shower, large format marble-look tile, and a floating vanity with a white countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29951785_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/4438f8031cc7dae7ec3d77e0b97c6bff.webp"
"MediaSize" => 42298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-4438f8031cc7dae7ec3d77e0b97c6bff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern bathroom featuring a single vanity with an undermount sink, a polished chrome faucet, and a large wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29951785_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/face96398a9f0ff52c7e46a9588ff1eb.webp"
"MediaSize" => 43365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-face96398a9f0ff52c7e46a9588ff1eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in shower featuring glass enclosure, white marble-look tile surround, dual shower heads, and chrome fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29951785_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/c6cace5b11a7be29c0a073d92d9b6b74.webp"
"MediaSize" => 42072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-c6cace5b11a7be29c0a073d92d9b6b74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern bathroom featuring a white floating vanity with a light countertop, a glass-enclosed shower with white tiled walls, and coordinating floor tiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29951785_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/8965b0f2cfa62f339690386db2bcb0c7.webp"
"MediaSize" => 60258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-8965b0f2cfa62f339690386db2bcb0c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring complements the bright interior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29951785_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/38056ebd70d983c5981542ecfa804b79.webp"
"MediaSize" => 61975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-38056ebd70d983c5981542ecfa804b79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring a window with sheer and blackout curtains, a white six-drawer dresser, and decorative wall molding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29951785_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/1158f6f7ed59b4b7ac8fb20a3c05f246.webp"
"MediaSize" => 61704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-1158f6f7ed59b4b7ac8fb20a3c05f246.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive window with floor-to-ceiling sheer and solid curtains"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29951785_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/2da82bcd3ff3d66dfb8b293fb30e9df0.webp"
"MediaSize" => 44362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-2da82bcd3ff3d66dfb8b293fb30e9df0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Clean bedroom space with light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29951785_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/05db64d806efaf2cab7e8830214956f5.webp"
"MediaSize" => 46603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-05db64d806efaf2cab7e8830214956f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring complements the neutral wall color"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29951785_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/1a0250a9ff6d77416965611422574be3.webp"
"MediaSize" => 53337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-1a0250a9ff6d77416965611422574be3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light-tone wood-finish flooring, white walls, and a large window with privacy sheers and opaque drapes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29951785_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/ce6439a6717496e586260d05c2808ddc.webp"
"MediaSize" => 59562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-ce6439a6717496e586260d05c2808ddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White wall paneling details complement the light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29951785_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/bd3d8aa18c5352e09a1bb44e5adc0333.webp"
"MediaSize" => 47620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-bd3d8aa18c5352e09a1bb44e5adc0333.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light-filled room featuring neutral wall tones and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29951785_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/70344da4f7539d6e0f10e413a82a8fbb.webp"
"MediaSize" => 57838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-70344da4f7539d6e0f10e413a82a8fbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring complements the neutral wall color"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29951785_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/1e1d9eff2df5a5052730db18d3765f2a.webp"
"MediaSize" => 58444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-1e1d9eff2df5a5052730db18d3765f2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light wood-finish flooring, white painted walls, and a window dressed with sheer and solid curtains"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29951785_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/7e712edd3f28a0b9885386c65804470f.webp"
"MediaSize" => 52586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-7e712edd3f28a0b9885386c65804470f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral wall paint in a bedroom with light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29951785_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/6158e1c54b8ddbd7f64c01656ca81288.webp"
"MediaSize" => 52558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-6158e1c54b8ddbd7f64c01656ca81288.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring light-colored walls and flooring, accented by wainscoting detailing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29951785_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/e02799d1fefdd29efd07586be7473fe5.webp"
"MediaSize" => 44763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-e02799d1fefdd29efd07586be7473fe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white bathtub with a tile surround, a built-in toilet, a single vanity with a white countertop, an undermount sink, and a chrome faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29951785_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/8b2d93a0249b2f57d807fa6a8fd539b5.webp"
"MediaSize" => 40220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-8b2d93a0249b2f57d807fa6a8fd539b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gray vanity with an integrated sink and light-toned countertop, featuring a chrome faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29951785_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/f79b2e2c8a0eb86b3272a85e2775cdb2.webp"
"MediaSize" => 47595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-f79b2e2c8a0eb86b3272a85e2775cdb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a rectangular undermount sink, a white countertop, and a mirrored medicine cabinet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29951785_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/c9ae04183077794a1071f36dea71d24b.webp"
"MediaSize" => 54659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29951785/thumbnail-c9ae04183077794a1071f36dea71d24b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Integrated laundry closet featuring a stacked white washer and dryer unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842536"
"ResourceRecordKey" => "29951785"
"ModificationTimestamp" => "2026-06-25T15:50:49.21Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "29951785_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29951785/24d983b3fd6d2e49c8f36e3415314293.webp"
"MediaSize" => 111416
…9
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951785')"
+"ID": "1561837"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290853" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24924
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2180828" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24893
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29951785'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25294
+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 '29951785'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25310
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29951785' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5890984 43.4499345)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25400
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25377
+post_id: "1574016"
+post_author: 1
+"ListingKey": "29963363"
+"ListingId": "X13498204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T00:30:35Z"
+"RFModificationTimestamp": "2026-06-28T00:33:22Z"
+"ListPrice": 537888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2K7"
+"UnparsedAddress": "3 - 601 COLUMBIA FOREST BOULEVARD, Waterloo, Ontario N2V2K7"
+"Coordinates": array:2 [
0 => -80.5844243
1 => 43.4647062
]
+"Latitude": 43.4647062
+"Longitude": -80.5844243
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exclusive Columbia Forest Estates enclave of Waterloo! This premium, turn-key townhome offers the perfect blend of modern styling, functional space, & unbeatable location convenience. Step inside to discover a freshly updated, open-concept main level featuring brand-new luxury flooring, modern trim, and an abundance of natural light. The seamlessly connected kitchen/dining area, & inviting living room complete with a cozy gas fireplace creates the ultimate hub for entertaining or everyday family living. The kitchen comes fully equipped with a suite of appliances, including a brand-new refrigerator and over-the-range microwave along with the already existing stainless dishwasher and stove. Upstairs and down, an intelligently designed layout delivers a rare 4-bedroom setup that offers privacy & flexibility. It is perfectly configured with two full 4-piece bathrooms plus a convenient main-floor powder room. The lower level adds immense value, boasting a versatile recreation or home office space, or a separate guest room, and space for dedicated laundry. Step outside to your private backyard with a natural gas hookup for seamless summer BBQs, backing directly onto the scenic Geo-Time Trail network. On top of the premium interior finishes, you will enjoy complete peace of mind with a newer, fully owned furnace and A/C system installed in 2024. Location is everything: you are steps from the region's top-rated elementary and secondary schools, and only minutes from the University Corridor-offering incredible long-term value/appreciation and high-end student occupancy in a premium location. Enjoy rapid access to major highways, the Waterloo Memorial Recreation Complex, RIM Park, Costco, and the vibrant Boardwalk shopping district. Whether you are a growing family or an astute investor looking for a premium asset, this home truly embodies the epitome of convenient modern living. Don't let this rare opportunity pass you by-schedule your private viewing today! (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Range"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"AssociationFee": "646"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T22:24:30.467157+00:00"
+"Directions": "Cross Streets: Columbia Forest Blvd & Erbsville Rd. ** Directions: Head north on Erbsville Road past Columbia Street West. The complex is located on the left-hand side, immediately at the corner intersection of Erbsville Road and Columbia Forest Boulevard."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2209347"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-27T23:18:05Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T00:18:54Z"
+"Stories": "3.0"
+"StreetName": "Columbia Forest"
+"StreetNumber": "601"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "3699"
+"VirtualTourURLUnbranded": "https://youtu.be/pXbuepXb0Zc"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29963363/3-601-columbia-forest-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Management Inc."
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-27T21:47:19.54Z"
+"ListAgentNationalAssociationId": "1456335"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963363')"
+"ID": "1574016"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+post_id: "1571992"
+post_author: 1
+"ListingKey": "29960557"
+"ListingId": "X13495788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:55:03Z"
+"RFModificationTimestamp": "2026-06-26T23:03:08Z"
+"ListPrice": 975000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "597 SUNDEW DRIVE, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.597865
1 => 43.459722
]
+"Latitude": 43.459722
+"Longitude": -80.597865
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Vista Hills-one of Waterloo's most sought-after family communities! Set on a premium 58-foot lot with beautifully curated perennial landscaping, this stunning "White Cherry" model offers the perfect balance of upscale finishes, functional family living, and outdoor enjoyment. The fully fenced backyard feels like your own private retreat, featuring a stamped concrete patio, sleek modern pergola, and lush gardens-an ideal setting for kids to play, summer entertaining, or quiet evenings outdoors. Step inside to a bright, thoughtfully designed main floor where durable 12x24 porcelain tile and hand-scraped hardwood create a warm and timeless feel throughout. At the heart of the home is a beautifully appointed chef-inspired kitchen with granite countertops, a large island perfect for gathering, ceiling-height custom cabinetry, pantry storage, and a newer smart stove. The open-concept layout flows seamlessly into the living and dining areas, creating a welcoming space for everyday life and hosting family and friends. Upstairs, you'll find 4 spacious bedrooms along with the convenience of second-floor laundry. The primary suite offers a peaceful escape with a spa-inspired 5-piece ensuite complete with a glass shower and relaxing soaker tub. The fully finished basement adds incredible versatility with a stylish wet bar, custom entertainment feature wall, additional bedroom, and full bathroom-perfect for guests, movie nights, or multi-generational living. Additional updates include smart switches, modern lighting, owned water softener and water heater, plus a newer furnace and air conditioner (2022). With 4+1 bedrooms, 4 bathrooms, and highly rated schools including Vista Hills Public School just minutes away, this is the kind of home where families can truly settle in and grow for years to come. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:02:57.139170+00:00"
+"Directions": "Cross Streets: Columbia Street & Sundew Drive. ** Directions: Columbia Street West to Sundew Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138804"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "57.8 x 110 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:48:02Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:48:02Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "597"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7645"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/597_sundew_dr_waterloo_on/"
+"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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29960557/597-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 57.9
+"OriginalEntryTimestamp": "2026-06-26T20:48:02.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1390596"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960557')"
+"ID": "1571992"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "1571993"
+post_author: 1
+"ListingKey": "29960298"
+"ListingId": "40843054"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:20:09Z"
+"RFModificationTimestamp": "2026-06-26T21:08:38Z"
+"ListPrice": 975000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3312.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "597 SUNDEW Drive, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.5978545
1 => 43.4597552
]
+"Latitude": 43.4597552
+"Longitude": -80.5978545
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Vista Hills—one of Waterloo’s most sought-after family communities! Set on a premium 58-foot lot with beautifully curated perennial landscaping, this stunning “White Cherry” model offers the perfect balance of upscale finishes, functional family living, and outdoor enjoyment. The fully fenced backyard feels like your own private retreat, featuring a stamped concrete patio, sleek modern pergola, and lush gardens—an ideal setting for kids to play, summer entertaining, or quiet evenings outdoors. Step inside to a bright, thoughtfully designed main floor where durable 12x24 porcelain tile and hand-scraped hardwood create a warm and timeless feel throughout. At the heart of the home is a beautifully appointed chef-inspired kitchen with granite countertops, a large island perfect for gathering, ceiling-height custom cabinetry, pantry storage, and a newer smart stove. The open-concept layout flows seamlessly into the living and dining areas, creating a welcoming space for everyday life and hosting family and friends. Upstairs, you’ll find 4 spacious bedrooms along with the convenience of second-floor laundry. The primary suite offers a peaceful escape with a spa-inspired 5-piece ensuite complete with a glass shower and relaxing soaker tub. The fully finished basement adds incredible versatility with a stylish wet bar, custom entertainment feature wall, additional bedroom, and full bathroom—perfect for guests, movie nights, or multi-generational living. Additional updates include smart switches, modern lighting, owned water softener and water heater, plus a newer furnace and air conditioner (2022). With 4+1 bedrooms, 4 bathrooms, and highly rated schools including Vista Hills Public School just minutes away, this is the kind of home where families can truly settle in and grow for years to come. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Wet Bar"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T21:08:29.368025+00:00"
+"Directions": "Columbia Street West to Sundew Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1944030"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wet bar"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:11:08Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:11:08Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "597"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7645"
+"VirtualTourURLUnbranded": "https://youriguide.com/597_sundew_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29960298/597-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 2345
+"BelowGradeFinishedArea": 967
+"OriginalEntryTimestamp": "2026-06-26T20:11:08.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1239929"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29960298')"
+"ID": "1571993"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+post_id: "1568039"
+post_author: 1
+"ListingKey": "29956203"
+"ListingId": "40843022"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T01:45:02Z"
+"RFModificationTimestamp": "2026-06-26T04:50:46Z"
+"ListPrice": 1130000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2774.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "745 WOOD LILY Street, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.5998881
1 => 43.4612882
]
+"Latitude": 43.4612882
+"Longitude": -80.5998881
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Here is the 40ft Model, not 36ft. Nestled in the highly sought-after Vista Hills community, this stunning executive home offers modern living in one of Waterloo’s most desirable neighbourhoods. Conveniently located near Costco, The Boardwalk, Boardwalk Medical Centre, shopping plazas, restaurants, and everyday amenities, this home is also within the top-ranked school boundaries of Vista Hills Public School and Laurel Heights Secondary School. Offering nearly 2,800 sq. ft. of thoughtfully designed living space, this home features a double-car garage and a bright openconcept layout. The modern kitchen flows seamlessly into the spacious living room with hardwood floors and a cozy fireplace, creating the perfect space for entertaining and family living. Sliding doors from the breakfast area lead to a private backyard retreat, while the separate dining room can also serve as a home office. Upstairs, each bedroom features its own private ensuite bathroom, providing comfort and privacy for the whole family. A versatile loft area offers additional space for a family lounge, study, or reading nook. Surrounded by scenic greenbelt and nature trails, this exceptional property perfectly blends luxury, convenience, and tranquility. A rare opportunity to own in one of Vista Hills’ most prestigious enclaves. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
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-26T04:49:23.213409+00:00"
+"Directions": "Rock Elm St. /Wood Lily"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T01:39:29Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T01:39:29Z"
+"Stories": "2.0"
+"StreetName": "WOOD LILY"
+"StreetNumber": "745"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8766.67"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=kx_UbYopPFU"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29956203/745-wood-lily-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 2774
+"OriginalEntryTimestamp": "2026-06-26T01:39:29.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956203')"
+"ID": "1568039"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1564289"
+post_author: 1
+"ListingKey": "29949076"
+"ListingId": "40841876"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T21:20:13Z"
+"RFModificationTimestamp": "2026-06-25T23:48:22Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1983.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG Drive, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864421
1 => 43.462059
]
+"Latitude": 43.462059
+"Longitude": -80.5864421
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PRICELESS VIEW! The Holy Grail of Retirement Bungalows. Modern-build, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo’s coveted Clair Hills community! This rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. It is freshly painted and updated with new carpet, and is completely move-in ready. With 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The sun-filled open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings where you’ll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and features a walk-in closet and private 4-piece ensuite. The second bedroom delights with a built-in Murphy bed that easily converts the space from home office to ready-made guest room. The bright walkout basement includes oversized windows, a cozy gas fireplace, and direct yard access with a covered deck that's perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privilege, along with a spacious utility/storage room complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered light switches, and modern mechanical systems. Add the double garage, quiet low-traffic location, and a peaceful pond-side setting, and you have effortless living at its finest! Homes offering this combination of location, quality, and accessibility are seldom available, and perfect for those looking to downsize. Don’t miss your opportunity to call Rosewood Estates home! Book your private showing today!! (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:48:02.127003+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:11:25Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T21:11:25Z"
+"Stories": "1.0"
+"StreetName": "SALZBURG"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5446"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"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/29949076/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2026-06-24T21:11:25.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949076')"
+"ID": "1564289"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+post_id: "1563698"
+post_author: 1
+"ListingKey": "29949612"
+"ListingId": "X13486026"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T22:55:14Z"
+"RFModificationTimestamp": "2026-06-25T23:10:34Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.586439
1 => 43.462061
]
+"Latitude": 43.462061
+"Longitude": -80.586439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "PRICELESS VIEW! The Holy Grail of Retirement Bungalows! Modern-build, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo's coveted Clair Hills community! This rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. It is freshly painted and updated with new carpet, and is completely move-in ready. With 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The sun-filled open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings where you'll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and features a walk-in closet and private 4-piece ensuite. The second bedroom delights with a built-in Murphy bed that easily converts the space from home office to ready-made guest room. The bright walkout basement includes oversized windows, a cozy gas fireplace, and direct yard access with a covered deck that's perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privilege, along with a spacious utility/storage room complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered light switches, and modern mechanical systems. Add the double garage, quiet low-traffic location, and a peaceful pond-side setting, and you have effortless living at its finest! Homes offering this combination of location, quality, and accessibility are seldom available, and perfect for those looking to downsize. Don't miss your opportunity to call Rosewood Estates home! (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:09:20.683398+00:00"
+"Directions": "Cross Streets: Columbia St W. ** Directions: Columbia to Salzburg Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T22:17:44Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T22:48:20Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5446"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29949612/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-24T22:17:44.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949612')"
+"ID": "1563698"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23456
+post_id: "1562598"
+post_author: 1
+"ListingKey": "29953614"
+"ListingId": "X13488898"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:45:13Z"
+"RFModificationTimestamp": "2026-06-25T21:05:35Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "12 - 142 FOAMFLOWER PLACE, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.589814
1 => 43.4496898
]
+"Latitude": 43.4496898
+"Longitude": -80.589814
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this meticulously maintained, turn-key stacked townhouse in Waterloo's highly sought-after Vista Hills community! Built by Activa, this "Viola" layout has been lovingly cared for by its original and sole owner, showing true pride of ownership. Step inside to discover a bright,open-concept layout elevated by a complete premium interior renovation upon move-in. The main floor boasts 9-foot ceilings and features a stunning, fully upgraded modern kitchen with high-end countertops, custom cabinetry, and a seamless flow into the great room. The space is beautifully accented with sophisticated crown moldings and elegant, large-format wall tiles that exude a custom, luxury feel. True Carpet-Freeliving throughout with contemporary, wide-plank flooring. Enjoy private outdoor living with TWO balconies-one off the main great room and a second off the primary bedroom. The upper level offers two spacious bedrooms, a 4-piece main bathroom, upper-floor laundry, and a generous linen/storage closet. The primary suite serves as a true retreat, complete with a 3-piece ensuite and a walk-in closet. Phenomenal location, designated for top-rated schools, including Vista Hills Public School and Laurel Heights Secondary School. Unbeatable convenience with Costco, just a short drive away, alongside the nearby Boardwalk shopping district for all your retail and dining needs. Enjoy scenic walking trails, community parks, public transit, and quick access to the University of Waterloo and Wilfrid Laurier University. This pristine, upgraded home offers the perfect blend of comfort, style, and a lifestyle of ultimate convenience-ideal for professionals, growing families, or investors! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "359.56"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:05:30.909378+00:00"
+"Directions": "Cross Streets: Columbia St & Platinum Dr. ** Directions: COLUMBIA ST TO LADYSLIPPER DR TO FOAMFLOWER PLACE."
+"ExteriorFeatures": array:2 [
0 => "Brick Facing"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188755"
+"ListOfficeKey": "291409"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:37Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:36:37Z"
+"StreetName": "Foamflower"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3315"
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953614/12-142-foamflower-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1418255"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"CoListOfficeKey": "90198"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-25T18:36:37.03Z"
+"ListAgentNationalAssociationId": "1437820"
+"ListOfficeNationalAssociationId": "1397659"
+"CoListAgentNationalAssociationId": "1105101"
+"CoListOfficeNationalAssociationId": "1153615"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953614')"
+"ID": "1562598"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25381
+post_id: "1560177"
+post_author: 1
+"ListingKey": "29944974"
+"ListingId": "X13481758"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T00:20:15Z"
+"RFModificationTimestamp": "2026-06-24T00:39:42Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "736 WOOD LILY STREET, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.599137
1 => 43.461038
]
+"Latitude": 43.461038
+"Longitude": -80.599137
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 736 Wood Lily Street, a contemporary masterpiece in the prestigious Vista Hillscommunity, offering over 3,400 sq. ft. of finished living space (2,469 sq. ft. above grade).This executive residence impresses with its modern architectural design and a spacious layoutperfect for both family living and high-end entertaining.The main level invites you into a bright, open-concept floor plan defined by 9ft ceilings, wideoak stairs, and over $85k in premium upgrades. The gourmet kitchen is a chef's dream, featuringcustom white cabinetry, a high-end upgraded range hood, and sleek built-in oven and microwave.Transition effortlessly to your private backyard oasis, complete with a recently finishedinterlocking stone patio, an outdoor storage shed, and full fencing.The second floor is intelligently designed for family comfort, boasting a sprawling family roomand a dedicated office space. The primary suite serves as a true sanctuary with a privatecovered balcony, a large walk-in closet, and a spa-like 5-piece ensuite. This level alsofeatures two additional generously sized bedrooms and a modern 4-piece main bath. The fullyfinished basement is an entertainer's paradise, featuring a massive open recreation area with acustom accent wall designed for a home theater. The space is anchored by a luxury wet bar withquartz countertops and designer cabinetry, and is perfectly complemented by a sophisticated3-piece luxury bathroom. With multiple storage rooms, parking for four and a prime location,this home is a must-see!The Vista Hills Lifestyle: This vibrant community is surrounded by environmentally protectedlands and over 25km of scenic trails, including the nearby Geo-Time Trail. Families will lovebeing steps away from the top-rated Vista Hills Public School and various local playgrounds.For ultimate convenience, you are just a 5-minute drive from Costco and The Boardwalk at IraNeedles, which offers premier shopping, dining, and Landmark Cinemas. (id:62783)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener remote(s)"
13 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:3 [
0 => "Central air conditioning"
1 => "Air exchanger"
2 => "Ventilation system"
]
+"CreationDate": "2026-06-24T00:39:39.336420+00:00"
+"Directions": "Cross Streets: Sundew Dr and Mayapple St. ** Directions: Take Columbia St W, turn onto Sundew Dr, turnonto Mayapple St, turn onto Wood Lily St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Carpeted"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2076953"
+"ListOfficeKey": "275137"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved yard"
2 => "Sump Pump"
]
+"LotSizeDimensions": "36.1 x 99.3 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-24T00:13:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T00:13:23Z"
+"Stories": "2.0"
+"StreetName": "Wood Lily"
+"StreetNumber": "736"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7305.56"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/736_wood_lily_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29944974/736-wood-lily-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 36.1
+"OriginalEntryTimestamp": "2026-06-24T00:13:23.67Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1352099"
+"ListOfficeNationalAssociationId": "1262136"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29944974')"
+"ID": "1560177"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25399
+post_id: "1560178"
+post_author: 1
+"ListingKey": "29944899"
+"ListingId": "40842511"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T00:00:09Z"
+"RFModificationTimestamp": "2026-06-24T00:25:06Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3426.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "736 WOOD LILY Street, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.5995752
1 => 43.4611724
]
+"Latitude": 43.4611724
+"Longitude": -80.5995752
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 736 Wood Lily Street, a contemporary masterpiece in the prestigious Vista Hills community, offering over 3,400 sq. ft. of finished living space (2,469 sq. ft. above grade). This executive residence impresses with its modern architectural design and a spacious layout perfect for both family living and high-end entertaining.The main level invites you into a bright, open-concept floor plan defined by 9ft ceilings, wid oak stairs, and over $85k in premium upgrades. The gourmet kitchen is a chef’s dream, featuring custom white cabinetry, a high-end upgraded range hood, and sleek built-in oven and microwave. Transition effortlessly to your private backyard oasis, complete with a recently finished interlocking stone patio, an outdoor storage shed, and full fencing. The second floor is intelligently designed for family comfort, boasting a sprawling family room and a dedicated office space. The primary suite serves as a true sanctuary with a private covered balcony, a large walk-in closet, and a spa-like 5-piece ensuite. This level also features two additional generously sized bedrooms and a modern 4-piece main bath. The fully finished basement is an entertainer’s paradise, featuring a massive open recreation area with a custom accent wall designed for a home theater. The space is anchored by a luxury wet bar with quartz countertops and designer cabinetry, and is perfectly complemented by a sophisticated 3-piece luxury bathroom. With multiple storage rooms, parking for four and a prime location, this home is a must-see! The Vista Hills Lifestyle: This vibrant community is surrounded by environmentally protected lands and over 25km of scenic trails, including the nearby Geo-Time Trail. Families will love being steps away from the top-rated Vista Hills Public School and various local playgrounds. For ultimate convenience, you are just a 5-minute drive from Costco and The Boardwalk at Ira Needles, which offers shopping, dining, and Landmark Cinemas. (id:62783)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Oven - Built-In"
9 => "Wet Bar"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
13 => "Microwave Built-in"
]
+"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-24T00:25:02.267747+00:00"
+"Directions": "Take Columbia St W, turn onto Sundew Dr, turn onto Mayapple St, turn onto Wood Lily St"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2217869"
+"ListOfficeKey": "284587"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Wet bar"
2 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-23T23:50:33Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T23:50:33Z"
+"Stories": "2.0"
+"StreetName": "WOOD LILY"
+"StreetNumber": "736"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7305.56"
+"VirtualTourURLUnbranded": "https://youriguide.com/736_wood_lily_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29944899/736-wood-lily-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2469
+"BelowGradeFinishedArea": 957
+"OriginalEntryTimestamp": "2026-06-23T23:50:33.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1463522"
+"ListOfficeNationalAssociationId": "1343174"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29944899')"
+"ID": "1560178"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 76
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]