Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5345
+post_id: "251837"
+post_author: 1
+"ListingKey": "RTC6058837"
+"ListingId": "2988123"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family Residence"
+"StandardStatus": "Coming Soon"
+"ModificationTimestamp": "2025-09-03T04:35:00Z"
+"RFModificationTimestamp": "2025-09-03T04:38:01Z"
+"ListPrice": 1645000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.15
+"LivingArea": 3705.0
+"BuildingAreaTotal": 3705.0
+"City": "Chattanooga"
+"PostalCode": "37405"
+"UnparsedAddress": "607 Colville Street, Chattanooga, Tennessee 37405"
+"Coordinates": array:2 [
0 => -85.300336
1 => 35.069777
]
+"Latitude": 35.069777
+"Longitude": -85.300336
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Becky Cope English"
+"ListOfficeName": "The Agency Chattanooga"
+"ListAgentMlsId": "495527"
+"ListOfficeMlsId": "56115"
+"OriginatingSystemName": "RealTracs"
+"PublicRemarks": "Welcome to 607 Colville Street, a brand-new North Chattanooga cottage-inspired home by Waters-Holland, where timeless design meets thoughtful functionality. Just a few days from being complete, this enchanting home will be available for showings on September 9th. Nestled on a deep lot providing a rare, alley-accessible three car garage, this charming home blends seamlessly into its neighborhood with a modern French Farmhouse true round front door, metal accent roof, natural stone details, and gas lantern. Step inside to a light-filled entry foyer with wide plank oak hardwood floors and soothing neutral color palette. The Waters-Holland signature shines through in the use of wood trim, tall baseboards and crown moldings, with distinctive touches like chamfered edge cased openings and vertical wood paneling in the living room. A cast concrete fireplace with a herringbone interior anchors the living room while the open dining room flows effortlessly into a kitchen showcasing a fluted range hood with brass trim, Fisher-Paykel appliances, and a spacious work island for casual dining. The main level feels boasts cozy yet open living spaces. A powder room with deep blue walls features a marble topped vanity with wall-mounted brass faucet. A mudroom bench and double-door storage closet greet you at the owner's entry from the garage, while a walk-in pantry is just a few steps away from the range wall. The kitchen has an exterior door leading to a partially covered patio pre-wired for outdoor entertainment. Upstairs, the Primary Suite is a serene retreat with a private hallway, vaulted ceiling, decorative wall trim, and custom closet. The primary bath features an oversized double-sink vanity, polished nickel fixtures, and a fully tiled shower with dual heads. A light-filled hallway connects three additional bedrooms (one ensuite), two full baths, a lavish laundry room, and a versatile family room."
+"AboveGradeFinishedAreaSource": "Other"
+"AboveGradeFinishedAreaUnits": "Square Feet"
+"Appliances": array:6 [
0 => "Stainless Steel Appliance(s)"
1 => "Microwave"
2 => "Gas Range"
3 => "Disposal"
4 => "Dishwasher"
5 => "Refrigerator"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"AssociationAmenities": "Playground,Sidewalks"
+"AttributionContact": "4233646298"
+"BathroomsFull": 3
+"BelowGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaUnits": "Square Feet"
+"BuildingAreaSource": "Other"
+"BuildingAreaUnits": "Square Feet"
+"BuyerFinancing": array:3 [
0 => "Other"
1 => "Conventional"
2 => "VA"
]
+"ConstructionMaterials": array:3 [
0 => "Fiber Cement"
1 => "Other"
2 => "Brick"
]
+"Cooling": array:3 [
0 => "Ceiling Fan(s)"
1 => "Central Air"
2 => "Electric"
]
+"CoolingYN": true
+"Country": "US"
+"CountyOrParish": "Hamilton County, TN"
+"CoveredSpaces": "3"
+"CreationDate": "2025-09-03T04:06:37.084389+00:00"
+"Directions": "From Downtown, North on Market Street, right on Frazier Ave, left on Forest Ave, right on Colville, property on left."
+"DocumentsChangeTimestamp": "2025-09-03T04:35:00Z"
+"DocumentsCount": 3
+"ElementarySchool": "Normal Park Museum Magnet School"
+"ExteriorFeatures": array:1 [
0 => "Smart Irrigation"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"GarageSpaces": "3"
+"GarageYN": true
+"HighSchool": "Red Bank High School"
+"InteriorFeatures": array:1 [
0 => "Ceiling Fan(s)"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"Levels": array:1 [
0 => "Three Or More"
]
+"ListAgentEmail": "becky.english@theagencyre.com"
+"ListAgentFirstName": "Becky"
+"ListAgentKey": "495527"
+"ListAgentLastName": "Cope English"
+"ListAgentMobilePhone": "4233646298"
+"ListAgentOfficePhone": "4235412800"
+"ListAgentPreferredPhone": "4233646298"
+"ListAgentStateLicense": "277820"
+"ListAgentURL": "https://www.theagencyre.com/"
+"ListOfficeEmail": "chattanooga@theagencyre.com"
+"ListOfficeKey": "56115"
+"ListOfficePhone": "4235412800"
+"ListOfficeURL": "https://www.theagencyre.com/"
+"ListingAgreement": "Exclusive Right To Sell"
+"ListingContractDate": "2025-09-02"
+"LivingAreaSource": "Other"
+"LotSizeAcres": 0.15
+"LotSizeDimensions": "40x151"
+"LotSizeSource": "Agent Calculated"
+"MajorChangeTimestamp": "2025-09-03T04:02:40Z"
+"MajorChangeType": "Coming Soon"
+"MiddleOrJuniorSchool": "Normal Park Museum Magnet School"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Coming Soon / Hold"
+"NewConstructionYN": true
+"OffMarketDate": "2025-09-02"
+"OffMarketTimestamp": "2025-09-03T04:01:53Z"
+"OriginalEntryTimestamp": "2025-09-03T04:02:24Z"
+"OriginalListPrice": 1645000
+"OriginatingSystemModificationTimestamp": "2025-09-03T04:15:07Z"
+"ParcelNumber": "135D K 039"
+"ParkingFeatures": array:5 [
0 => "Garage Door Opener"
1 => "Detached"
2 => "Concrete"
3 => "Driveway"
4 => "On Street"
]
+"ParkingTotal": "3"
+"PhotosChangeTimestamp": "2025-09-03T04:04:00Z"
+"PhotosCount": 17
+"PreviousListPrice": 1645000
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"SpecialListingConditions": array:1 [
0 => "Standard"
]
+"StateOrProvince": "TN"
+"StatusChangeTimestamp": "2025-09-03T04:02:40Z"
+"StreetName": "Colville Street"
+"StreetNumber": "607"
+"StreetNumberNumeric": "607"
+"SubdivisionName": "Colvilles Addn"
+"TaxAnnualAmount": "1683"
+"Utilities": array:2 [
0 => "Electricity Available"
1 => "Water Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"YearBuiltDetails": "New"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('RTC6058837')"
+"provider_name": "Real Tracs"
+"PropertyTimeZoneName": "America/New_York"
+"Media": array:17 [
0 => array:13 [
"Order" => 0
"MediaKey" => "68b7bdf67d5cf33e5def3647"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/915a0ef726836851e32b46c8ed9507eb.webp"
"MediaSize" => 1048576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-915a0ef726836851e32b46c8ed9507eb.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => true
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.222Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "68b7bdf67d5cf33e5def364e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/a8bc3871a7d48f7ad7e9da23f29dfb89.webp"
"MediaSize" => 1048576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-a8bc3871a7d48f7ad7e9da23f29dfb89.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.245Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "68b7bdf67d5cf33e5def3641"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/6ac07598348f1d8c0657162fe322d346.webp"
"MediaSize" => 1048576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-6ac07598348f1d8c0657162fe322d346.webp"
"ImageWidth" => 1333
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2000
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "1333x2000"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.211Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "68b7bdf67d5cf33e5def3643"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/8bb350724912a457c80e5186662541d1.webp"
"MediaSize" => 1048576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-8bb350724912a457c80e5186662541d1.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.133Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "68b7bdf67d5cf33e5def363e"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/2519ad8d422ff14bbec3769828212c0f.webp"
"MediaSize" => 262144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-2519ad8d422ff14bbec3769828212c0f.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.174Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "68b7bdf67d5cf33e5def3648"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/d68ce67006b1878f105acc994ba90334.webp"
"MediaSize" => 262144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-d68ce67006b1878f105acc994ba90334.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.090Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "68b7bdf67d5cf33e5def364c"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/8e03a5f14c37f17ee6a7f88d4a2db8ad.webp"
"MediaSize" => 262144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-8e03a5f14c37f17ee6a7f88d4a2db8ad.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.119Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "68b7bdf67d5cf33e5def364b"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/1275c9190ec7007987a3f80611a9dce0.webp"
"MediaSize" => 524288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-1275c9190ec7007987a3f80611a9dce0.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.151Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "68b7bdf67d5cf33e5def3645"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/78d052981e04e3f11fe1e794f99ab82d.webp"
"MediaSize" => 524288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-78d052981e04e3f11fe1e794f99ab82d.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.119Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "68b7bdf67d5cf33e5def3646"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/c80886d12406ed53002561105fd57cfd.webp"
"MediaSize" => 262144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-c80886d12406ed53002561105fd57cfd.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.112Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "68b7bdf67d5cf33e5def3640"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/f3405d403be68342a62be84a8cabee6e.webp"
"MediaSize" => 262144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-f3405d403be68342a62be84a8cabee6e.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.119Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "68b7bdf67d5cf33e5def3642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/ab2ebd3eb884b9f32c30f5e183db77c8.webp"
"MediaSize" => 262144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-ab2ebd3eb884b9f32c30f5e183db77c8.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.119Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "68b7bdf67d5cf33e5def3649"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/bb79be6ec6923b354b3cced765046896.webp"
"MediaSize" => 524288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-bb79be6ec6923b354b3cced765046896.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.276Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "68b7bdf67d5cf33e5def363f"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/43e83c4fecdd3e23bbe08878201ebc7b.webp"
"MediaSize" => 262144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-43e83c4fecdd3e23bbe08878201ebc7b.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.119Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "68b7bdf67d5cf33e5def364d"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/33d586ee46172c31bcf041a2a755430d.webp"
"MediaSize" => 262144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-33d586ee46172c31bcf041a2a755430d.webp"
"ImageWidth" => 1333
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2000
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "1333x2000"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.119Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "68b7bdf67d5cf33e5def3644"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/c1f7e561c13a9bf017f637c575e6e63c.webp"
"MediaSize" => 262144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-c1f7e561c13a9bf017f637c575e6e63c.webp"
"ImageWidth" => 1333
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 2000
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "1333x2000"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.119Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "68b7bdf67d5cf33e5def364a"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/69f72557ca10a020622a3d298fb71793.webp"
"MediaSize" => 524288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/31/RTC6058837/thumbnail-69f72557ca10a020622a3d298fb71793.webp"
"ImageWidth" => 2000
"Permission" => array:1 [
0 => "Public"
]
"ImageHeight" => 1333
"PreferredPhotoYN" => false
"ResourceRecordKey" => "RTC6058837"
"ImageSizeDescription" => "2000x1333"
"MediaModificationTimestamp" => "2025-09-03T04:03:02.151Z"
]
]
+"ID": "251837"
}