Welcome to this stunning and pristine custom-built 4-bedroom, 2-bathroom home perfectly nestled in a peaceful country setting. Located less than 5 minutes to Hampton and 25 minutes to Rothesay/Quispamsis this beautiful home could be yours! Thoughtfully designed with timeless craftsmanship and modern comfort, this ho
Get expert tips, market trends, and exclusive real estate insights—right to your inbox!
By signing up, you agree to our Privacy Policy and Terms & Conditions.
Commission-Free Real Estate with ComFree
The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA.
* Only when the buyer comes direct, otherwise the seller may choose to negotiate a commission with the buyer’s agent.
© 2024 ComFree Realty Inc. All rights reserved.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with PassGo Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with PassGo Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with PassGo Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with PassGo Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:5 [ "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 28828217/Property?$select=ALL&$top=20&$filter=ListingKey eq 28828217&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 28828217/Property?$select=ALL&$top=20&$filter=ListingKey eq 28828217&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#22948 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#22950 +post_id: "149983" +post_author: 1 +"ListingKey": "28828217" +"ListingId": "NB126242" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-09-08T17:56:03Z" +"RFModificationTimestamp": "2025-09-08T22:52:11Z" +"ListPrice": 649900.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 1.83 +"LivingArea": 2668.0 +"BuildingAreaTotal": 0 +"City": "Hampton" +"PostalCode": "E5N7T6" +"UnparsedAddress": "97 845 Route, Hampton, New Brunswick E5N7T6" +"Coordinates": array:2 [ 0 => -65.8737259 1 => 45.5482407 ] +"Latitude": 45.5482407 +"Longitude": -65.8737259 +"YearBuilt": 2016 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "New Brunswick Real Estate Board" +"PublicRemarks": "Welcome to this stunning and pristine custom-built 4-bedroom, 2-bathroom home perfectly nestled in a peaceful country setting. Located less than 5 minutes to Hampton and 25 minutes to Rothesay/Quispamsis this beautiful home could be yours! Thoughtfully designed with timeless craftsmanship and modern comfort, this home offers the best of both worlds. The heart of the home is the chefs kitchen, featuring a large island, quartz countertops, glass backsplash, and modern stainless steel appliances. The open dining area easily accommodates a very large table, making it perfect for hosting family and friends. Custom details shine throughout with crown moulding, wainscoting, heated tile floors on the main level, and hardwood floors upstairs. The striking flared staircase with wrought iron railings leads to spacious bedrooms, including an oversized primary suite. The luxurious main bath boasts a soaker tub and walk-in shower. The large finished two-car garage includes built-in drawers and is prepped for in-floor heat. Outside, enjoy just under 2 acres with a babbling brook at the back, fenced yard-perfect for pets and kids, 16x10 shed, paved driveway with turnaround, covered patio, and a second-level deck with glass railing. This home has been extremely well cared for and is waiting for new owners. Call your REALTOR® today to book a private viewing! (id:62650)" +"ArchitecturalStyle": array:1 [ 0 => "2 Level" ] +"CreationDate": "2025-09-08T22:51:42.465932+00:00" +"Directions": "Route 845" +"ExteriorFeatures": array:1 [ 0 => "Vinyl" ] +"Flooring": array:2 [ 0 => "Hardwood" 1 => "Ceramic" ] +"FoundationDetails": array:1 [ 0 => "Concrete Slab" ] +"Heating": array:3 [ 0 => "Baseboard heaters" 1 => "Radiant heat" 2 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2016855" +"ListOfficeKey": "269605" +"LivingAreaUnits": "square feet" +"LotSizeDimensions": "1.83" +"ParcelNumber": "30325617" +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Garage" ] +"PhotosChangeTimestamp": "2025-09-08T14:15:41Z" +"PhotosCount": 43 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "New Brunswick" +"StatusChangeTimestamp": "2025-09-08T17:45:20Z" +"TaxAnnualAmount": "5301" +"WaterSource": array:2 [ 0 => "Drilled Well" 1 => "Well" ] +"Rooms": array:9 [ 0 => array:11 [ "RoomKey" => "1490384219" "RoomType" => "Bedroom" "ListingId" => "NB126242" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28828217" "RoomLength" => null "RoomDimensions" => "9'3'' x 16'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-09-08T17:45:20.71Z" ] 1 => array:11 [ "RoomKey" => "1490384220" "RoomType" => "Bedroom" "ListingId" => "NB126242" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28828217" "RoomLength" => null "RoomDimensions" => "9'7'' x 14'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-09-08T17:45:20.71Z" ] 2 => array:11 [ "RoomKey" => "1490384221" "RoomType" => "Bedroom" "ListingId" => "NB126242" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28828217" "RoomLength" => null "RoomDimensions" => "9'7'' x 15'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-09-08T17:45:20.71Z" ] 3 => array:11 [ "RoomKey" => "1490384222" "RoomType" => "Primary Bedroom" "ListingId" => "NB126242" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28828217" "RoomLength" => null "RoomDimensions" => "16'4'' x 19'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-09-08T17:45:20.71Z" ] 4 => array:11 [ "RoomKey" => "1490384223" "RoomType" => "Bath (# pieces 1-6)" "ListingId" => "NB126242" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28828217" "RoomLength" => null "RoomDimensions" => "9'7'' x 16'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-09-08T17:45:20.71Z" ] 5 => array:11 [ "RoomKey" => "1490384224" "RoomType" => "Bath (# pieces 1-6)" "ListingId" => "NB126242" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28828217" "RoomLength" => null "RoomDimensions" => "5'6'' x 12'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-09-08T17:45:20.71Z" ] 6 => array:11 [ "RoomKey" => "1490384225" "RoomType" => "Living room" "ListingId" => "NB126242" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28828217" "RoomLength" => null "RoomDimensions" => "16' x 23'" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-09-08T17:45:20.71Z" ] 7 => array:11 [ "RoomKey" => "1490384226" "RoomType" => "Dining room" "ListingId" => "NB126242" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28828217" "RoomLength" => null "RoomDimensions" => "16' x 18'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-09-08T17:45:20.71Z" ] 8 => array:11 [ "RoomKey" => "1490384227" "RoomType" => "Kitchen" "ListingId" => "NB126242" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28828217" "RoomLength" => null "RoomDimensions" => "9' x 16'" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2025-09-08T17:45:20.71Z" ] ] +"ListAOR": "New Brunswick" +"ListAORKey": "84" +"ListingURL": "www.realtor.ca/real-estate/28828217/97-845-route-hampton" +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2145994" +"CommonInterest": "Freehold" +"CoListOfficeKey": "269605" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"AboveGradeFinishedArea": 2668 +"OriginalEntryTimestamp": "2025-09-08T14:15:41.14Z" +"MapCoordinateVerifiedYN": false +"AboveGradeFinishedAreaUnits": "square feet" +"Media": array:43 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6161408860" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/aced30c39ff800cc15a25c8eee4f68c5.webp" "MediaSize" => 133247 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-aced30c39ff800cc15a25c8eee4f68c5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6161408868" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/1c347436b528105ac9472146af3a43bd.webp" "MediaSize" => 144748 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-1c347436b528105ac9472146af3a43bd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6161408937" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/b2b6b9e8667739996d3898455ba6bef7.webp" "MediaSize" => 93810 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-b2b6b9e8667739996d3898455ba6bef7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6161409020" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/eb990dbd7b64efda0abdfedb51522c5c.webp" "MediaSize" => 75445 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-eb990dbd7b64efda0abdfedb51522c5c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6161409145" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/1dc6cfe5dbed13b30319d5d97fe58bd4.webp" "MediaSize" => 77262 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-1dc6cfe5dbed13b30319d5d97fe58bd4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6161409184" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/dd18847fb7162d4a92d25b5dcdc365b5.webp" "MediaSize" => 56386 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-dd18847fb7162d4a92d25b5dcdc365b5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6161409219" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/40ffe21401d4c069680f91200b149916.webp" "MediaSize" => 61900 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-40ffe21401d4c069680f91200b149916.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6161409276" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/bf1108a2d00edf58a7c223488b33dcda.webp" "MediaSize" => 69528 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-bf1108a2d00edf58a7c223488b33dcda.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6161409329" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/518b9d76d4d767f42bbe1823f4f37c46.webp" "MediaSize" => 77021 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-518b9d76d4d767f42bbe1823f4f37c46.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6161409358" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/679ca6e6e728673611a27b5f5c8023ed.webp" "MediaSize" => 54878 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-679ca6e6e728673611a27b5f5c8023ed.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6161409391" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/33df4f0d49cc7b8cb374cacfe2b262c5.webp" "MediaSize" => 90074 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-33df4f0d49cc7b8cb374cacfe2b262c5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6161409435" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/4eaa272a8935a40188d490603a6413bc.webp" "MediaSize" => 79266 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-4eaa272a8935a40188d490603a6413bc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6161409551" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/0eb22d309bc79fddbe9bdd05d992a1aa.webp" "MediaSize" => 83269 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-0eb22d309bc79fddbe9bdd05d992a1aa.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6161409588" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/bb5e6c12cb7be863cff68a8db8333eeb.webp" "MediaSize" => 104865 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-bb5e6c12cb7be863cff68a8db8333eeb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6161409642" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/084fd0a178f961b77907f9b07c3f9eff.webp" "MediaSize" => 58167 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-084fd0a178f961b77907f9b07c3f9eff.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6161409712" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/07e7da7cff3f410e9a361be229eb5dd7.webp" "MediaSize" => 56832 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-07e7da7cff3f410e9a361be229eb5dd7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6161409750" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/fd6724963bdfd1ea1e21ce5f174f81d4.webp" "MediaSize" => 43818 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-fd6724963bdfd1ea1e21ce5f174f81d4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 17 => array:13 [ "Order" => 17 "MediaKey" => "6161409808" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/af311042aa9774a6caa718bb321f9391.webp" "MediaSize" => 113315 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-af311042aa9774a6caa718bb321f9391.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 18 => array:13 [ "Order" => 18 "MediaKey" => "6161409870" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/78ac9bd3056fb8b680b6ac0593af7ff3.webp" "MediaSize" => 85982 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-78ac9bd3056fb8b680b6ac0593af7ff3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 19 => array:13 [ "Order" => 19 "MediaKey" => "6161409933" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/79f0deeeefa37ca2bb7293c820b95fc5.webp" "MediaSize" => 71576 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-79f0deeeefa37ca2bb7293c820b95fc5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 20 => array:13 [ "Order" => 20 "MediaKey" => "6161409992" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/62a43791c023244f9d1167672a483197.webp" "MediaSize" => 58331 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-62a43791c023244f9d1167672a483197.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 21 => array:13 [ "Order" => 21 "MediaKey" => "6161410000" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/efaf4b3ba90c77f587d6b47ad67ec3e2.webp" "MediaSize" => 60088 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-efaf4b3ba90c77f587d6b47ad67ec3e2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 22 => array:13 [ "Order" => 22 "MediaKey" => "6161410046" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/c941284f4b0e872191f5aee201fb5682.webp" "MediaSize" => 64448 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-c941284f4b0e872191f5aee201fb5682.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 23 => array:13 [ "Order" => 23 "MediaKey" => "6161410058" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/4d870b83d82fb51a19655456a31bfee3.webp" "MediaSize" => 52885 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-4d870b83d82fb51a19655456a31bfee3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 24 => array:13 [ "Order" => 24 "MediaKey" => "6161410136" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/9a41a8b7ff4ff40f688086c1d90c8b6a.webp" "MediaSize" => 53359 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-9a41a8b7ff4ff40f688086c1d90c8b6a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 25 => array:13 [ "Order" => 25 "MediaKey" => "6161410166" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/2bb8795e2df11cc1b109c735c4229fe0.webp" "MediaSize" => 65085 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-2bb8795e2df11cc1b109c735c4229fe0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 26 => array:13 [ "Order" => 26 "MediaKey" => "6161410275" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/12b11936d52ccb0a09e63c70afdf5002.webp" "MediaSize" => 62663 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-12b11936d52ccb0a09e63c70afdf5002.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 27 => array:13 [ "Order" => 27 "MediaKey" => "6161410320" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/09870d2e66e95e0a1424f3156bfaf398.webp" "MediaSize" => 157474 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-09870d2e66e95e0a1424f3156bfaf398.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 28 => array:13 [ "Order" => 28 "MediaKey" => "6161410364" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/0697918bb98ef8bdcb2addbd960a00d8.webp" "MediaSize" => 118462 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-0697918bb98ef8bdcb2addbd960a00d8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 29 => array:13 [ "Order" => 29 "MediaKey" => "6161410480" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/c9c6a0add1f10cbcad507f9c4ac99b3f.webp" "MediaSize" => 124766 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-c9c6a0add1f10cbcad507f9c4ac99b3f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 30 => array:13 [ "Order" => 30 "MediaKey" => "6161410525" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/7286ec3947b3d9523d8f7590c5d673ee.webp" "MediaSize" => 164941 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-7286ec3947b3d9523d8f7590c5d673ee.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 31 => array:13 [ "Order" => 31 "MediaKey" => "6161410556" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/62d9e1be523f10685377a96a2ad33238.webp" "MediaSize" => 145648 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-62d9e1be523f10685377a96a2ad33238.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 32 => array:13 [ "Order" => 32 "MediaKey" => "6161410607" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/c71573d33aea8683ce21bd290e27cc80.webp" "MediaSize" => 187817 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-c71573d33aea8683ce21bd290e27cc80.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 33 => array:13 [ "Order" => 33 "MediaKey" => "6161410689" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/a639b352cd713af81ac6154f99d3d236.webp" "MediaSize" => 147963 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-a639b352cd713af81ac6154f99d3d236.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 34 => array:13 [ "Order" => 34 "MediaKey" => "6161410765" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/f55e3f8ab83b990091c1a04fe8df1ebb.webp" "MediaSize" => 110927 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-f55e3f8ab83b990091c1a04fe8df1ebb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 35 => array:13 [ "Order" => 35 "MediaKey" => "6161410798" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/907e7350ffa50277fa43cc489e920b4a.webp" "MediaSize" => 164133 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-907e7350ffa50277fa43cc489e920b4a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 36 => array:13 [ "Order" => 36 "MediaKey" => "6161410845" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/96d60a56e9bf43d5201eb05b15799c63.webp" "MediaSize" => 139879 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-96d60a56e9bf43d5201eb05b15799c63.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 37 => array:13 [ "Order" => 37 "MediaKey" => "6161410876" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/108fa771ddc55b6a030a7e54a9eed119.webp" "MediaSize" => 152435 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-108fa771ddc55b6a030a7e54a9eed119.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 38 => array:13 [ "Order" => 38 "MediaKey" => "6161410905" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/1b54d807451ceb01625816f2fd4517d6.webp" "MediaSize" => 135356 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-1b54d807451ceb01625816f2fd4517d6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 39 => array:13 [ "Order" => 39 "MediaKey" => "6161410944" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/4160df4f08d27c7f716748578d5e5565.webp" "MediaSize" => 154091 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-4160df4f08d27c7f716748578d5e5565.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 40 => array:13 [ "Order" => 40 "MediaKey" => "6161410984" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/b204538ec1ee16a6797e52a76006d499.webp" "MediaSize" => 146418 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-b204538ec1ee16a6797e52a76006d499.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 41 => array:13 [ "Order" => 41 "MediaKey" => "6161411023" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/b03eb732eef35b4b829faf772d708e4b.webp" "MediaSize" => 144556 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-b03eb732eef35b4b829faf772d708e4b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] 42 => array:13 [ "Order" => 42 "MediaKey" => "6161411060" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28828217/dc0284857a90363ff4828e493a19127a.webp" "MediaSize" => 141393 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28828217/thumbnail-dc0284857a90363ff4828e493a19127a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "NB126242" "ResourceRecordKey" => "28828217" "ModificationTimestamp" => "2025-09-08T14:15:41.15Z" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28828217')" +"ID": "149983" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.3 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 269605/Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 269605&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 269605/Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 269605&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24824 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.28 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2016855/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2016855&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2016855/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2016855&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24822 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.14 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 28828217" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24410 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.28 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=6&$filter=ListingKey ne 28828217 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-65.8737259 45.5482407)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=6&$filter=ListingKey ne 28828217 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-65.8737259 45.5482407)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=6&$filter=ListingKey ne 28828217 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-65.8737259 45.5482407)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=6&$filter=ListingKey ne 28828217 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-65.8737259 45.5482407)) le 2000m&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24842 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.21 seconds" ] ]