Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
Array
(
[RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$filter=(PropertyType eq 'Land' or PropertyType eq 'Residential' or PropertyType eq 'Residential Income') and (Appliances eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR ArchitecturalStyle eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR CommunityFeatures eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR Cooling eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR CountyOrParish eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR ElementarySchool eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR ExteriorFeatures eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR Flooring eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR Heating eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR HighSchool eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR InteriorFeatures eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR ListingTerms eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR MiddleOrJuniorSchool eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR ParkingFeatures eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR PoolFeatures eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR PropertyType eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR Roof eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR SchoolDistrict eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR Sewer eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR Utilities eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened' OR WaterfrontFeatures eq 'Deck,Sprinkler,Gutters - Full,Back Porch - Screened') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true] => Array
(
[RF Response] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse Object
(
[items] => Array
(
[0] => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty Object
(
[post_id] => 135829
[post_author] => 1
[ListingKey] => 641215
[ListingId] => 641215
[PropertyType] => Residential
[PropertySubType] => Single Family
[StandardStatus] => Active
[ModificationTimestamp] => 2026-10-01T17:37:20Z
[RFModificationTimestamp] => 2026-10-01T17:45:34Z
[ListPrice] => 615000
[BathroomsTotalInteger] => 3
[BathroomsHalf] => 0
[BedroomsTotal] => 4
[LotSizeArea] => 0.16
[LivingArea] => 2900
[BuildingAreaTotal] => 2900
[City] => Blythewood
[PostalCode] => 29016
[UnparsedAddress] => 417 Bosque Circle, Blythewood, SC 29016
[Coordinates] => Array
(
[0] => -80.916565
[1] => 34.171925
)
[Latitude] => 34.171925
[Longitude] => -80.916565
[YearBuilt] => 2006
[InternetAddressDisplayYN] => 1
[FeedTypes] => IDX
[ListOfficeName] => BHHS Midlands Real Estate
[ListAgentMlsId] => 8599
[ListOfficeMlsId] => 682
[OriginatingSystemName] => columbiamls
[PublicRemarks] => Enjoy resort-style living in this beautiful four bedroom, three-bath home located in the gated community of Longcreek-The Greens! Ideally situated on a cul-de-sac and overlooking the scenic Windermere golf course, this home offers beautiful views and a peaceful setting. Located directly across from the prestigious Windermere Club, you'll enjoy convenient access to golf and club amenities. Just a short walk down the road is a beautiful equestrian center, adding to exceptional lifestyle this location provides. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
[Appliances] => Dishwasher,Disposal,Microwave Above Stove
[ArchitecturalStyle] => Traditional
[AssociationYN] => 1
[Basement] => Yes Basement
[BuildingAreaUnits] => Sqft
[ConstructionMaterials] => Brick-Partial-AbvFound,Fiber Cement-Hardy Plank
[Cooling] => Heat Pump 1st Lvl
[CountyOrParish] => Richland
[CreationDate] => 2026-08-20T14:18:20.264193+00:00
[Directions] => Longcreek entrance, right to The Greens across from Windermere Club. Right, then immediate left to end, left again, up hill on right.
[ExteriorFeatures] => Deck,Sprinkler,Gutters - Full,Back Porch - Screened
[FireplaceFeatures] => Gas Log-Natural
[Heating] => Gas 1st Lvl,Heat Pump 2nd Lvl
[InteriorFeatures] => Security System-Leased,Attic Access
[InternetEntireListingDisplayYN] => 1
[LaundryFeatures] => Closet
[ListAgentEmail] => gsevans@bhhsmidlands.com
[LivingAreaUnits] => Sqft
[LotSizeUnits] => Sqft
[MlsStatus] => ACTIVE
[OriginalEntryTimestamp] => 2026-08-20
[PhotosChangeTimestamp] => 2026-09-11T12:02:13Z
[PhotosCount] => 26
[RoadFrontageType] => Paved
[RoomKitchenFeatures] => Floors-Hardwood,Counter Tops-Granite,Cabinets-Stained,Backsplash-Other
[Sewer] => Public
[StateOrProvince] => SC
[StreetName] => Bosque
[StreetNumber] => 417
[StreetSuffix] => Circle
[SubdivisionName] => LONGCREEK THE GREENS
[WaterSource] => Public
[TMS] => 20406-01-43
[Baths] => 3
[Range] => Double Oven,Gas,Self Clean
[Garage] => Garage Attached, Front Entry
[Address] => 417 Bosque Circle
[AssnFee] => 110
[LVTDate] => 2026-08-20
[PowerOn] => Yes
[Location] => Cul-de-Sac,On Golf Course
[BathsFull] => 3
[#ofStories] => 2.5
[2ndBedroom] => Bath-Shared,Closet-Walk in,Whirlpool
[3rdBedroom] => Bath-Shared,Closet-Walk in,Tub-Shower
[4thBedroom] => Bath-Shared
[5thBedroom] => Bath-Shared,Tub-Shower
[BathsCombo] => 3 / 0
[HighSchool] => Blythewood
[IDXInclude] => Yes
[LivingRoom] => Fireplace,French Doors,Floors-Hardwood
[LowerLevel] => Finished
[New/Resale] => Resale
[OtherRooms] => Media Room
[class_name] => RE_1
[LA1UserCode] => SIOKOSG
[GarageSpaces] => 2
[MiddleSchool] => Blythewood
[PricePerSQFT] => 212.07
[ShortSaleY/N] => No
[StatusDetail] => 0
[AgentHitCount] => 66
[Level-Kitchen] => Main
[LockboxNumber] => 2459050
[MasterBedroom] => Double Vanity,Bath-Private,Ceilings-Tray
[Miscellaneous] => Golf Community,Gated Community
[FullBaths-Bsmt] => 1
[FullBaths-Main] => 2
[GeoSubdivision] => SC
[HalfBaths-Main] => 0
[Level-Bedroom2] => Basement
[Level-Bedroom3] => Basement
[Level-Bedroom4] => Second
[SchoolDistrict] => Richland Two
[IntSchoolChoice] => No
[LO1MainOfficeID] => 682
[OtherHeatedSqFt] => 0
[SeniorLivingY/N] => N
[AssocFeeIncludes] => Green Areas
[ElementarySchool] => Round Top
[FormalLivingRoom] => Bay Window,Floors-Hardwood
[HighSchoolChoice] => No
[LA1AgentLastName] => Siokos Evans
[Level-LivingRoom] => Main
[ListPriceTotSqFt] => 212.07
[RollbackTax(Y/N)] => No
[DetitledMobileY/N] => N
[LA1AgentFirstName] => Georgianna
[Level-WasherDryer] => Basement
[ForeclosedProperty] => No
[GeoUpdateTimestamp] => 2026-08-20T14:10:14.1
[MiddleSchoolChoice] => No
[AddressSearchNumber] => 417
[LO1OfficeIdentifier] => 682
[Level-MasterBedroom] => Main
[ListingTypeAgreement] => Exclusive Right to Sell
[PublishtoInternetY/N] => Yes
[Interior#ofFireplaces] => 1
[LO1OfficeAbbreviation] => PRUM01
[ElementarySchoolChoice] => No
[FirstPhotoAddTimestamp] => 2026-08-20T14:10:14.9
[MlsAreaMajor] => Columbia Northeast
[PrivatePoolYN] => No
[Media] => Array
(
[0] => Array
(
[Order] => 0
[MediaKey] => 6412150
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/1a22ef44f8b81e32848885fc42a159f3.webp
[ClassName] => Single Family
[MediaSize] => 491235
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-1a22ef44f8b81e32848885fc42a159f3.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[1] => Array
(
[Order] => 1
[MediaKey] => 6412151
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/e0ac2ca9efe1bc129de3e782c3452084.webp
[ClassName] => Single Family
[MediaSize] => 434318
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-e0ac2ca9efe1bc129de3e782c3452084.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[2] => Array
(
[Order] => 2
[MediaKey] => 6412152
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/eb8ead1b302ad6701d211daba2d1df7b.webp
[ClassName] => Single Family
[MediaSize] => 468533
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-eb8ead1b302ad6701d211daba2d1df7b.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[3] => Array
(
[Order] => 3
[MediaKey] => 6412153
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/6524213e75247a9c5640726c3dca0768.webp
[ClassName] => Single Family
[MediaSize] => 142793
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-6524213e75247a9c5640726c3dca0768.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[4] => Array
(
[Order] => 4
[MediaKey] => 6412154
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/af42a18e6b99e0b755bf85afc3f4e2e4.webp
[ClassName] => Single Family
[MediaSize] => 148698
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-af42a18e6b99e0b755bf85afc3f4e2e4.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[5] => Array
(
[Order] => 5
[MediaKey] => 6412155
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/435bcf9d64985a88d231a4fcb41db341.webp
[ClassName] => Single Family
[MediaSize] => 377867
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-435bcf9d64985a88d231a4fcb41db341.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[6] => Array
(
[Order] => 6
[MediaKey] => 6412156
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/07b859c22777518fe97eaab2add97640.webp
[ClassName] => Single Family
[MediaSize] => 120968
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-07b859c22777518fe97eaab2add97640.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[7] => Array
(
[Order] => 7
[MediaKey] => 6412157
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/e254c888e60cbe6d111dff6b249db177.webp
[ClassName] => Single Family
[MediaSize] => 142624
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-e254c888e60cbe6d111dff6b249db177.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[8] => Array
(
[Order] => 8
[MediaKey] => 6412158
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/667dea9fe9b540935fc51370e4fe871a.webp
[ClassName] => Single Family
[MediaSize] => 348824
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-667dea9fe9b540935fc51370e4fe871a.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[9] => Array
(
[Order] => 9
[MediaKey] => 6412159
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/4609b0637c3db5e01d14116aa533ad8f.webp
[ClassName] => Single Family
[MediaSize] => 121019
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-4609b0637c3db5e01d14116aa533ad8f.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[10] => Array
(
[Order] => 10
[MediaKey] => 64121510
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/2c1082a8fdc282bb818dfbc48d4ff2c4.webp
[ClassName] => Single Family
[MediaSize] => 247387
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-2c1082a8fdc282bb818dfbc48d4ff2c4.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[11] => Array
(
[Order] => 11
[MediaKey] => 64121511
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/3d5e0386cda5d01001ff19b18d36ac73.webp
[ClassName] => Single Family
[MediaSize] => 161175
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-3d5e0386cda5d01001ff19b18d36ac73.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[12] => Array
(
[Order] => 12
[MediaKey] => 64121512
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/8baae884956e6a4e6a6caa630dfdc66e.webp
[ClassName] => Single Family
[MediaSize] => 130971
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-8baae884956e6a4e6a6caa630dfdc66e.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[13] => Array
(
[Order] => 13
[MediaKey] => 64121513
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/8262c97205be2c434d5a875fa39f4980.webp
[ClassName] => Single Family
[MediaSize] => 172171
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-8262c97205be2c434d5a875fa39f4980.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[14] => Array
(
[Order] => 14
[MediaKey] => 64121514
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/04d72797fd3f4df5e1f4365b3bcc2a20.webp
[ClassName] => Single Family
[MediaSize] => 360594
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-04d72797fd3f4df5e1f4365b3bcc2a20.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[15] => Array
(
[Order] => 15
[MediaKey] => 64121515
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/5c5e6dce74113720caefaf7c61da866d.webp
[ClassName] => Single Family
[MediaSize] => 288215
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-5c5e6dce74113720caefaf7c61da866d.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[16] => Array
(
[Order] => 16
[MediaKey] => 64121516
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/52a28283b244f29bc11d4e3e451c3c5b.webp
[ClassName] => Single Family
[MediaSize] => 595332
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-52a28283b244f29bc11d4e3e451c3c5b.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[17] => Array
(
[Order] => 17
[MediaKey] => 64121517
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/91bd9b2ed26af0dac79611e4014108a1.webp
[ClassName] => Single Family
[MediaSize] => 578031
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-91bd9b2ed26af0dac79611e4014108a1.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[18] => Array
(
[Order] => 18
[MediaKey] => 64121518
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/57a2f74baa6d1b171b078a3da5f26ac6.webp
[ClassName] => Single Family
[MediaSize] => 684849
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-57a2f74baa6d1b171b078a3da5f26ac6.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[19] => Array
(
[Order] => 19
[MediaKey] => 64121519
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/86084b1b4ad24eff78468cca36eb63a5.webp
[ClassName] => Single Family
[MediaSize] => 406292
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-86084b1b4ad24eff78468cca36eb63a5.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[20] => Array
(
[Order] => 20
[MediaKey] => 64121520
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/9f8bce9f4645944e08d5360cda3791b9.webp
[ClassName] => Single Family
[MediaSize] => 592059
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-9f8bce9f4645944e08d5360cda3791b9.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[21] => Array
(
[Order] => 21
[MediaKey] => 64121521
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/22a268dccc2a698771d3197f206751f7.webp
[ClassName] => Single Family
[MediaSize] => 619036
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-22a268dccc2a698771d3197f206751f7.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[22] => Array
(
[Order] => 22
[MediaKey] => 64121522
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/0bb0f5fb11ec9b2a6163dbbb3c853f30.webp
[ClassName] => Single Family
[MediaSize] => 198079
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-0bb0f5fb11ec9b2a6163dbbb3c853f30.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[23] => Array
(
[Order] => 23
[MediaKey] => 64121523
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/ce4246565760b764b8e41671069b54d0.webp
[ClassName] => Single Family
[MediaSize] => 284907
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-ce4246565760b764b8e41671069b54d0.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[24] => Array
(
[Order] => 24
[MediaKey] => 64121524
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/60d2604605198dc66c5019d5040d5ecc.webp
[ClassName] => Single Family
[MediaSize] => 145217
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-60d2604605198dc66c5019d5040d5ecc.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
[25] => Array
(
[Order] => 25
[MediaKey] => 64121525
[MediaURL] => https://cdn.realtyfeed.com/cdn/121/641215/0d629e332104a8fb35fd1b76f8141ee5.webp
[ClassName] => Single Family
[MediaSize] => 211343
[MediaType] => webp
[Thumbnail] => https://cdn.realtyfeed.com/cdn/121/641215/thumbnail-0d629e332104a8fb35fd1b76f8141ee5.webp
[ResourceName] => Property
[MediaCategory] => Photo
[MediaObjectID] =>
[ResourceRecordKey] => 641215
)
)
[DaysOnMarket] => 72
[@odata.id] => https://api.realtyfeed.com/realtyfeed/odata/Property('641215')
[ID] => 135829
)
)
[success] => 1
[page_size] => 1
[page_count] => 1
[count] => 1
[after_key] =>
)
[RF Response Time] => 0.14 seconds
)
)