Sprinkler,Gutters - Partial,Front Porch - Covered
26 Properties
Sort by:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:1 [ "RF Cache Key: 2a66f81eabb5f8a08a847537f22019b49391aaace448a24ca765b0c51a116833" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3991 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "614094" +"ListingId": "614094" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-14T20:42:24Z" +"RFModificationTimestamp": "2025-08-14T20:46:58Z" +"ListPrice": 244999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1532.0 +"BuildingAreaTotal": 1532.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "271 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.144327 1 => 33.857366 ] +"Latitude": 33.857366 +"Longitude": -81.144327 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "3696" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "September 2025 Move in! Welcome to your stunning NEW 3-bedroom, 2-bath Shelley plan in Lexington County, perfectly situated for easy commuting in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertop in the kitchen and baths, wood-inspired vinyl plank flooring throughout the first floor. Set on .28 acres, this home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, subway tile backsplash, and modern stainless-steel appliances, including a gas stove, microwave, and dishwasher. The largest first-floor owner’s suite includes a full walk in closet and double vanity bathroom. An additional full bathroom is conveniently located near 2 bedrooms, ideal for main floor living, hosting overnight guests, or creating a home office. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-07-28T20:41:47.033537+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77 turn left onto Hwy 321 then go to Fish Hatchery Road and turn right and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "Tina.horne@Lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-07-24" +"PhotosChangeTimestamp": "2025-08-14T20:42:24Z" +"PhotosCount": "20" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "271" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/646/modelhome/3602/virtualtour/3614" +"WaterSource": "Well" +"TMS": "008092-01-042" +"Baths": "2" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "271 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-07-28" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "42" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Floors - Carpet" +"3rd Bedroom": "Floors - Carpet" +"Baths Combo": "2 / 0" +"High School": "Airport" +"IDX Include": "Yes" +"# of Stories": "1" +"Garage Level": "Main" +"LA1User Code": "HORNET" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "159.92" +"Short Sale Y/N": "No" +"Agent Hit Count": "89" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Main": "2" +"Geo Subdivision": "SC" +"Half Baths-Main": "0" +"Level-Bedroom 2": "Main" +"Level-Bedroom 3": "Main" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Elementary School": "Congaree" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance,Green Areas" +"Formal Dining Room": "Area" +"LA1Agent Last Name": "Horne" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"Foreclosed Property": "No" +"LA1Agent First Name": "Tina" +"List Price Tot SqFt": "159.92" +"Geo Update Timestamp": "2025-07-28T20:35:59.6" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Main" +"Address Search Number": "271" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"LA1Agent Middle Initial": "J" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-07-28T20:36:00.5" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:20 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6140940" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/87cbd21fc148cdd784d4f287304c3ed3.webp" "ClassName" => "Single Family" "MediaSize" => 384035 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-87cbd21fc148cdd784d4f287304c3ed3.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6140941" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/f035faffca3757ce3480932b74ad7dcc.webp" "ClassName" => "Single Family" "MediaSize" => 119118 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-f035faffca3757ce3480932b74ad7dcc.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6140942" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/bec989bb533cc6ddd267b9d2a38fcbbe.webp" "ClassName" => "Single Family" "MediaSize" => 46293 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-bec989bb533cc6ddd267b9d2a38fcbbe.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6140943" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/a2faaf1223236918a2aa5251191f5292.webp" "ClassName" => "Single Family" "MediaSize" => 219466 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-a2faaf1223236918a2aa5251191f5292.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6140944" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/6feb8eccd19df22aa93e3621e488e360.webp" "ClassName" => "Single Family" "MediaSize" => 254102 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-6feb8eccd19df22aa93e3621e488e360.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6140945" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/fb8e493a92aa59f32914ce7337c04cfb.webp" "ClassName" => "Single Family" "MediaSize" => 244096 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-fb8e493a92aa59f32914ce7337c04cfb.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6140946" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/4c384332cf32bae98640a23e8edc8f0f.webp" "ClassName" => "Single Family" "MediaSize" => 355856 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-4c384332cf32bae98640a23e8edc8f0f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6140947" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/12f51eda3db9e760851331778cd97e3a.webp" "ClassName" => "Single Family" "MediaSize" => 380294 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-12f51eda3db9e760851331778cd97e3a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6140948" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/153963b57ab14b107eb30446f6ff460d.webp" "ClassName" => "Single Family" "MediaSize" => 370443 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-153963b57ab14b107eb30446f6ff460d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6140949" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/b7b77da833a92dcce6cc5215e6bad7e2.webp" "ClassName" => "Single Family" "MediaSize" => 355327 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-b7b77da833a92dcce6cc5215e6bad7e2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61409410" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/a1cd9a80f822c6017a020dd3625a5202.webp" "ClassName" => "Single Family" "MediaSize" => 413175 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-a1cd9a80f822c6017a020dd3625a5202.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61409411" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/3b515666676ffda779db8de751b3107e.webp" "ClassName" => "Single Family" "MediaSize" => 372318 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-3b515666676ffda779db8de751b3107e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61409412" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/9cd8c2bfffbec31a016dfd75df0b5f8e.webp" "ClassName" => "Single Family" "MediaSize" => 303990 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-9cd8c2bfffbec31a016dfd75df0b5f8e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61409413" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/a8aff4b258b15ba54650483011a05036.webp" "ClassName" => "Single Family" "MediaSize" => 280247 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-a8aff4b258b15ba54650483011a05036.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61409414" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/255fc03da58f1f306797a7f863912a94.webp" "ClassName" => "Single Family" "MediaSize" => 181721 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-255fc03da58f1f306797a7f863912a94.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "61409415" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/f8aa4e540d90822ccc8770b4a1767e01.webp" "ClassName" => "Single Family" "MediaSize" => 181942 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-f8aa4e540d90822ccc8770b4a1767e01.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "61409416" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/91be4ad7e50ac80ef0ffeb5d3c01c651.webp" "ClassName" => "Single Family" "MediaSize" => 304825 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-91be4ad7e50ac80ef0ffeb5d3c01c651.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "61409417" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/5ef6fc07809e76bfa344fce6e7740752.webp" "ClassName" => "Single Family" "MediaSize" => 327884 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-5ef6fc07809e76bfa344fce6e7740752.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "61409418" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/1394d437e9db32766a62dd108c31403e.webp" "ClassName" => "Single Family" "MediaSize" => 992881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-1394d437e9db32766a62dd108c31403e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "61409419" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/614094/4590590c202b05cb31533bbcc367ec8b.webp" "ClassName" => "Single Family" "MediaSize" => 91583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/614094/thumbnail-4590590c202b05cb31533bbcc367ec8b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "614094" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('614094')" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3209 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "606906" +"ListingId": "606906" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-14T18:10:27Z" +"RFModificationTimestamp": "2025-08-14T18:18:56Z" +"ListPrice": 289999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.28 +"LivingArea": 2577.0 +"BuildingAreaTotal": 2577.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "242 Hazel Rain Road, Gaston, Sc 29053" +"Coordinates": array:2 [ 0 => -81.142755 1 => 33.857164 ] +"Latitude": 33.857164 +"Longitude": -81.142755 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "October 2025 Move In! Welcome to your stunning NEW 5-bedroom, 3-bath Frost plan in Lexington County, SC, perfectly situated for easy commuting in Gaston, SC. Featuring a first-floor private suite, this home has all the features a homeowner wants in a new home! Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertops in the kitchen, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard.The open kitchen has spacious counters, tiled backsplash, an expansive island, large walk-in pantry, and modern stainless-steel appliances, including a gas stove, microwave and dishwasher. Located on the first floor is a full bedroom/suite, perfect for overnight guests or family members. The second- floor owner’s suite includes 2 full walk-in closets and double vanity bathroom. On the second floor a third full bathroom is conveniently located near 3 additional bedrooms as well as a versatile entertainment room, ideal for privacy from main floor living, hosting overnight guests, or creating a home office. Added elegance of a first floor oak rail and iron balusters are also included on this homesite. Don't miss the amazing community features of large homesites, gutters, coach lights (per plan), garage door opener, tankless water heater and zoned irrigation. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20,Gas Water Heater" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-04-21T18:14:19.341664+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77 turn left onto Hwy 321 then go to Fish Hatchery Road and turn right and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access,Attic Access" +"LaundryFeatures": "Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OpenParkingSpaces": "2" +"OriginalEntryTimestamp": "2025-04-21" +"PhotosChangeTimestamp": "2025-08-14T18:10:27Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "242" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/656/modelhome/3208/virtualtour/3219" +"WaterSource": "Well" +"TMS": "008902-01-032" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "242 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-04-21" +"Power On": "No" +"Baths Full": "3" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "52" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Bath-Shared,Closet-Private,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Closet-Private,Floors - Carpet" +"4th Bedroom": "Bath-Shared,Closet-Walk in,Closet-Private,Floors - Carpet" +"5th Bedroom": "Bath-Shared,Closet-Walk in,Closet-Private,Floors-Luxury Vinyl Plank" +"Baths Combo": "3 / 0" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Media Room" +"# of Stories": "2" +"Garage Level": "Main" +"LA1User Code": "JGOULD" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Full Baths-2nd": "2" +"Master Bedroom": "Double Vanity,Closet-His & Her,Bath-Private,Separate Shower,Closet-Walk in,Closet-Private,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "112.53" +"Agent Hit Count": "146" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Main": "1" +"Geo Subdivision": "SC" +"Half Baths-Main": "0" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"Level-Bedroom 5": "Main" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"Formal Dining Room": "Area,Floors-Luxury Vinyl Plank" +"LA1Agent Last Name": "Gould" +"Level-Washer Dryer": "Second" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "112.53" +"Geo Update Timestamp": "2025-04-21T18:05:30.1" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "242" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"LA1Agent Middle Initial": "M" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-04-21T18:05:30.9" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6069060" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/9e762cd1b2cbdc12661fd55db482b95b.webp" "ClassName" => "Single Family" "MediaSize" => 509536 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-9e762cd1b2cbdc12661fd55db482b95b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6069061" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/b86ef27f5f0e16b589d7d8613cebc022.webp" "ClassName" => "Single Family" "MediaSize" => 119515 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-b86ef27f5f0e16b589d7d8613cebc022.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6069062" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/5dfb434ab657ef1f9c37c9d7122ed6da.webp" "ClassName" => "Single Family" "MediaSize" => 121506 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-5dfb434ab657ef1f9c37c9d7122ed6da.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6069063" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/2d452206dadffeb97ae716f479e155b4.webp" "ClassName" => "Single Family" "MediaSize" => 44959 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-2d452206dadffeb97ae716f479e155b4.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6069064" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/7675a23078e081c0bd989c118c530e1d.webp" "ClassName" => "Single Family" "MediaSize" => 218687 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-7675a23078e081c0bd989c118c530e1d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6069065" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/227db3f4c7fa01c4d7e6849c3898b1c6.webp" "ClassName" => "Single Family" "MediaSize" => 312332 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-227db3f4c7fa01c4d7e6849c3898b1c6.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6069066" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/7383b85b3c2aec5376877bdf089715fe.webp" "ClassName" => "Single Family" "MediaSize" => 341367 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-7383b85b3c2aec5376877bdf089715fe.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6069067" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/0e7e398f5dbf03191e330220c237a3be.webp" "ClassName" => "Single Family" "MediaSize" => 291907 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-0e7e398f5dbf03191e330220c237a3be.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6069068" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/a035623d7c336d126d204251ae9c5ed2.webp" "ClassName" => "Single Family" "MediaSize" => 178774 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-a035623d7c336d126d204251ae9c5ed2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6069069" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/345b34453b19f49bb57bb08f072aa968.webp" "ClassName" => "Single Family" "MediaSize" => 297244 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-345b34453b19f49bb57bb08f072aa968.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "60690610" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/f771158143ef126b9d939f59436f24dc.webp" "ClassName" => "Single Family" "MediaSize" => 358620 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-f771158143ef126b9d939f59436f24dc.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "60690611" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/2a845af17ef0cdb2838ff2f3b0215c3c.webp" "ClassName" => "Single Family" "MediaSize" => 175692 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-2a845af17ef0cdb2838ff2f3b0215c3c.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "60690612" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/0d4e4987694767359519728f5b2dfd31.webp" "ClassName" => "Single Family" "MediaSize" => 330846 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-0d4e4987694767359519728f5b2dfd31.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "60690613" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/37ad95dd59eb6772262a25e8db32258b.webp" "ClassName" => "Single Family" "MediaSize" => 335326 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-37ad95dd59eb6772262a25e8db32258b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "60690614" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/bbad09cbf2afd164e1e33452efad5e74.webp" "ClassName" => "Single Family" "MediaSize" => 263922 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-bbad09cbf2afd164e1e33452efad5e74.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "60690615" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/435c2710f04127a8280d3a0aa9f46401.webp" "ClassName" => "Single Family" "MediaSize" => 283427 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-435c2710f04127a8280d3a0aa9f46401.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "60690616" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/953f65bab1410a4bd35034b1a1741ffd.webp" "ClassName" => "Single Family" "MediaSize" => 296864 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-953f65bab1410a4bd35034b1a1741ffd.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "60690617" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/3a80e09a5428a798107dab94fbda4bb1.webp" "ClassName" => "Single Family" "MediaSize" => 271189 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-3a80e09a5428a798107dab94fbda4bb1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "60690618" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/96d7f2d98324197e8c8bf54a792c808d.webp" "ClassName" => "Single Family" "MediaSize" => 174790 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-96d7f2d98324197e8c8bf54a792c808d.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "60690619" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/eec431c211d14edff2677edd9aaf5508.webp" "ClassName" => "Single Family" "MediaSize" => 302534 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-eec431c211d14edff2677edd9aaf5508.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "60690620" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/d5e27df8894f70ed6220e4a60f8b5f26.webp" "ClassName" => "Single Family" "MediaSize" => 286901 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-d5e27df8894f70ed6220e4a60f8b5f26.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "60690621" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/4938be19ec6bd246bb774547241cf223.webp" "ClassName" => "Single Family" "MediaSize" => 217276 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-4938be19ec6bd246bb774547241cf223.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "60690622" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/28a15fb8db1c0e62806c9a58e8ea0ffa.webp" "ClassName" => "Single Family" "MediaSize" => 992881 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-28a15fb8db1c0e62806c9a58e8ea0ffa.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "60690623" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606906/2ee916bbc99a34c7223d84f8827ab055.webp" "ClassName" => "Single Family" "MediaSize" => 91583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606906/thumbnail-2ee916bbc99a34c7223d84f8827ab055.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "606906" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('606906')" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3207 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "610884" +"ListingId": "610884" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-13T14:24:01Z" +"RFModificationTimestamp": "2025-08-13T14:30:12Z" +"ListPrice": 281649.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.12 +"LivingArea": 1772.0 +"BuildingAreaTotal": 1772.0 +"City": "Elgin" +"PostalCode": "29045-0000" +"UnparsedAddress": "3051 Hallsdale Drive, Elgin, SC 29045-0000" +"Coordinates": array:2 [ 0 => -80.7922274811 1 => 34.1247082145 ] +"Latitude": 34.1247082145 +"Longitude": -80.7922274811 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Clayton Properties Group Inc" +"ListAgentMlsId": "17674" +"ListOfficeMlsId": "1694" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Featuring resort style amenities with cabana, pool with wading area, lazy river and sidewalks on each side of the street. Up to $15,000 with partner lender Silverton Mortgage and preferred attorney. The Guilford plan is a four bedroom, two-and one-half bathroom home. From the stone accent on the front porch, enter the home to find a formal office with French doors. Luxury vinyl plank flooring flows throughout the entire main level. A pet pad has been added to this home for your animals to enjoy! The kitchen includes pendant lighting over the peninsula, luna pearl granite countertops, stone gray cabinetry, and stainless-steel electric cooktop! An extended patio on the back porch is perfect for enjoying your yard! Upstairs, three secondary bedrooms share a bathroom with dual sinks. A loft connects your loved ones together, and the laundry room is conveniently located upstairs. The primary suite features a vaulted ceiling, dual sinks, a tile shower, and spacious walk-in closet. The Guilford is one you don't want to miss at Ellington! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"CoListAgentEmail": "pmcmahan@mungo.com" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central,Zoned" +"CountyOrParish": "Richland" +"CreationDate": "2025-06-13T19:39:18.471048+00:00" +"Directions": "Community Directions From I-20 E: Take exit 82 for Spears Creek Church Rd. Turn right onto Spears Creek Church Rd. Travel .2 miles and turn left onto Percival Rd. Travel 1.8 miles and turn left onto Sandy Oaks Rd. Ellington will be on the right in .5 miles. Model Address: 2223 County Line Trl.,Elgin" +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Zoned" +"InteriorFeatures": "Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Heated Space" +"ListAgentEmail": "lweber@mungo.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OriginalEntryTimestamp": "2025-06-13" +"PhotosChangeTimestamp": "2025-06-15T13:06:23Z" +"PhotosCount": "15" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Pantry,Counter Tops-Granite,Recessed Lights,Floors-Luxury Vinyl Plank" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Hallsdale" +"StreetNumber": "3051" +"StreetSuffix": "Drive" +"SubdivisionName": "ELLINGTON" +"WaterSource": "Public" +"TMS": "31700-01-04" +"Baths": "3" +"Range": "Self Clean,Smooth Surface" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "3051 Hallsdale Drive" +"Assn Fee": "525" +"LVT Date": "2025-06-13" +"Lot Size": "5375" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "3115" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Bath-Shared,Tub-Shower" +"3rd Bedroom": "Bath-Shared,Tub-Shower" +"4th Bedroom": "Bath-Shared,Tub-Shower" +"Baths Combo": "2 / 1" +"High School": "Spring Valley" +"IDX Include": "Yes" +"Other Rooms": "Other,Loft" +"# of Stories": "2" +"LA1User Code": "WEBERL" +"Co-List Agent": "18143" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Summit" +"Miscellaneous": "Community Pool,Warranty (New Const) Bldr,Sidewalk Community" +"Status Detail": "0" +"Co-List Office": "1694" +"Full Baths-2nd": "2" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Ceilings-Vaulted" +"Price Per SQFT": "158.94" +"Agent Hit Count": "108" +"Avail Financing": "Cash,Conventional,FHA,VA" +"Full Baths-Main": "0" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"School District": "Richland Two" +"Level-Great Room": "Main" +"Level-Other Room": "Second" +"Elementary School": "Pontiac" +"LO1Main Office ID": "1694" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Common Area Maintenance,Pool,Sidewalk Maintenance,Street Light Maintenance,Green Areas" +"Formal Dining Room": "Floors-Luxury Vinyl Plank" +"LA1Agent Last Name": "Weber" +"Level-Other Room 2": "Main" +"Level-Washer Dryer": "Second" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "Yearly" +"LA1Agent First Name": "Lorraine" +"List Price Tot SqFt": "158.94" +"Geo Update Timestamp": "2025-06-13T19:33:52.5" +"LO1Office Identifier": "1694" +"Level-Master Bedroom": "Second" +"Address Search Number": "3051" +"LO1Office Abbreviation": "MUNH01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"Level-Formal Dining Room": "Main" +"First Photo Add Timestamp": "2025-06-13T19:33:53.6" +"MlsAreaMajor": "Columbia Northeast" +"Media": array:15 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6108840" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/25cf2f308977bf93e7b348488f784906.webp" "ClassName" => "Single Family" "MediaSize" => 377571 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-25cf2f308977bf93e7b348488f784906.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6108841" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/e0e080244678967dd7ffe06756778565.webp" "ClassName" => "Single Family" "MediaSize" => 193234 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-e0e080244678967dd7ffe06756778565.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6108842" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/c5f013a919eb0c142ed7a1bf88da4e8e.webp" "ClassName" => "Single Family" "MediaSize" => 235703 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-c5f013a919eb0c142ed7a1bf88da4e8e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6108843" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/ee0b15e0cffaf83bff1d7d3833f4fab7.webp" "ClassName" => "Single Family" "MediaSize" => 200269 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-ee0b15e0cffaf83bff1d7d3833f4fab7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6108844" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/58ba8633a268d1a778e01ec01efa3826.webp" "ClassName" => "Single Family" "MediaSize" => 168720 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-58ba8633a268d1a778e01ec01efa3826.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6108845" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/c56bb5966f9385c836d5427eaf0845d6.webp" "ClassName" => "Single Family" "MediaSize" => 196610 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-c56bb5966f9385c836d5427eaf0845d6.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6108846" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/c2ecfb4b686ded5df0560e2581fd545f.webp" "ClassName" => "Single Family" "MediaSize" => 207154 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-c2ecfb4b686ded5df0560e2581fd545f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6108847" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/2e5c696c28458d22abbc30e7d79fc22a.webp" "ClassName" => "Single Family" "MediaSize" => 44430 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-2e5c696c28458d22abbc30e7d79fc22a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6108848" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/e199ff9a15339de74972d0c698d49192.webp" "ClassName" => "Single Family" "MediaSize" => 66759 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-e199ff9a15339de74972d0c698d49192.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6108849" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/9206dcffdcfd0e7cf4ac2a9aa3d2eed9.webp" "ClassName" => "Single Family" "MediaSize" => 351945 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-9206dcffdcfd0e7cf4ac2a9aa3d2eed9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "61088410" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/1e59d8f41e02aa160034b6c1f2a3e5a9.webp" "ClassName" => "Single Family" "MediaSize" => 339909 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-1e59d8f41e02aa160034b6c1f2a3e5a9.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "61088411" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/ce9e622676546faf6c3ac7efa3ffcaa8.webp" "ClassName" => "Single Family" "MediaSize" => 310000 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-ce9e622676546faf6c3ac7efa3ffcaa8.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "61088412" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/31bb0ccaaf97a5998f90f4e298079243.webp" "ClassName" => "Single Family" "MediaSize" => 336467 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-31bb0ccaaf97a5998f90f4e298079243.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "61088413" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/2554731df829417dcbad591e83b5e393.webp" "ClassName" => "Single Family" "MediaSize" => 373246 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-2554731df829417dcbad591e83b5e393.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "61088414" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/610884/b76035b7e2afdf5be5964e0d2a4ac988.webp" "ClassName" => "Single Family" "MediaSize" => 303788 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/610884/thumbnail-b76035b7e2afdf5be5964e0d2a4ac988.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "610884" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('610884')" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3214 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "599503" +"ListingId": "599503" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-07T23:18:03Z" +"RFModificationTimestamp": "2025-08-07T23:24:19Z" +"ListPrice": 224999.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.29 +"LivingArea": 1532.0 +"BuildingAreaTotal": 1532.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "197 Hazel Rain Road, Gaston, Sc 29053" +"Coordinates": array:2 [ 0 => -81.0931 1 => 33.8303 ] +"Latitude": 33.8303 +"Longitude": -81.0931 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "1766" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Move-In Ready! Welcome to your stunning NEW 3-bedroom, 2-bath Shelley plan in Lexington County, perfectly situated for easy commuting in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertop in the kitchen and baths, wood-inspired vinyl plank flooring throughout the first floor. Set on .29 acres, this home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, subway tile backsplash, and modern stainless-steel appliances, including a stove, microwave, Refrigerator, and dishwasher. The largest first-floor owner’s suite includes a full walk in closet and double vanity bathroom. An additional full bathroom is conveniently located near 2 bedrooms, ideal for main floor living, hosting overnight guests, or creating a home office. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-03-19T09:20:17.318774+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77 turn left onto Hwy 321 then go to Fish Hatchery Road and turn right and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "sharee.hairston@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-01-05" +"PhotosChangeTimestamp": "2025-08-07T23:18:03Z" +"PhotosCount": "33" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "197" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/646/modelhome/3602/virtualtour/3614" +"WaterSource": "Well" +"TMS": "008902-01-024" +"Baths": "2" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "197 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-01-06" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "24" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Floors - Carpet" +"3rd Bedroom": "Floors - Carpet" +"Baths Combo": "2 / 0" +"High School": "Airport" +"IDX Include": "Yes" +"# of Stories": "1" +"Garage Level": "Main" +"LA1User Code": "HAIRSTS" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "146.87" +"Agent Hit Count": "176" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Main": "2" +"Geo Subdivision": "SC" +"Half Baths-Main": "0" +"Level-Bedroom 2": "Main" +"Level-Bedroom 3": "Main" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Elementary School": "Congaree" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance,Green Areas" +"Formal Dining Room": "Area" +"LA1Agent Last Name": "Hairston" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Sharee" +"List Price Tot SqFt": "146.87" +"Geo Update Timestamp": "2025-04-25T18:59:19.8" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Main" +"Address Search Number": "197" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-01-06T15:17:19.2" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:33 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "5995030" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/d0e4c1f436f1b36effa5bae97f1e7270.webp" "ClassName" => "Single Family" "MediaSize" => 1008988 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-d0e4c1f436f1b36effa5bae97f1e7270.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "5995031" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/0335996f9f24d722ce4311fb7a225e6a.webp" "ClassName" => "Single Family" "MediaSize" => 978186 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-0335996f9f24d722ce4311fb7a225e6a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "5995032" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/4441bc858d668770e770e1105db1815a.webp" "ClassName" => "Single Family" "MediaSize" => 863342 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-4441bc858d668770e770e1105db1815a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "5995033" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/e41197d69b470a9dd0d379558c2a5d78.webp" "ClassName" => "Single Family" "MediaSize" => 119118 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-e41197d69b470a9dd0d379558c2a5d78.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "5995034" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/5890cbc8b5ecac75d3e9d036da166c3f.webp" "ClassName" => "Single Family" "MediaSize" => 46018 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-5890cbc8b5ecac75d3e9d036da166c3f.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "5995035" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/558672977c8388f7b70bcdf61e912e11.webp" "ClassName" => "Single Family" "MediaSize" => 724910 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-558672977c8388f7b70bcdf61e912e11.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "5995036" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/7ae5b264c711367a2659d96f49f78f6a.webp" "ClassName" => "Single Family" "MediaSize" => 670504 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-7ae5b264c711367a2659d96f49f78f6a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "5995037" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/f180654d156caa85896c079c8c9d01d1.webp" "ClassName" => "Single Family" "MediaSize" => 711969 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-f180654d156caa85896c079c8c9d01d1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "5995038" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/9bfa4856672dd0930cf4abb1f59b1373.webp" "ClassName" => "Single Family" "MediaSize" => 731661 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-9bfa4856672dd0930cf4abb1f59b1373.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "5995039" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/5b6002c40da98c6dcb4f060d65251d07.webp" "ClassName" => "Single Family" "MediaSize" => 740039 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-5b6002c40da98c6dcb4f060d65251d07.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "59950310" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/2a763890c7a71d3cec3273bee1a2f33b.webp" "ClassName" => "Single Family" "MediaSize" => 693418 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-2a763890c7a71d3cec3273bee1a2f33b.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "59950311" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/920269ce4d605a6898bb30a62e0f11fc.webp" "ClassName" => "Single Family" "MediaSize" => 690268 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-920269ce4d605a6898bb30a62e0f11fc.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "59950312" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/157c2643acfc0af4ae70ed93131c9edd.webp" "ClassName" => "Single Family" "MediaSize" => 694982 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-157c2643acfc0af4ae70ed93131c9edd.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "59950313" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/e18911bfb2cf889eb91eac026412bfd7.webp" "ClassName" => "Single Family" "MediaSize" => 739180 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-e18911bfb2cf889eb91eac026412bfd7.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "59950314" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/2fe205a99199107fb7c964e982c28e5e.webp" "ClassName" => "Single Family" "MediaSize" => 685312 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-2fe205a99199107fb7c964e982c28e5e.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "59950315" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/b994a9699cb4ff814589aeb6e8a8a104.webp" "ClassName" => "Single Family" "MediaSize" => 726323 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-b994a9699cb4ff814589aeb6e8a8a104.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "59950316" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/e3b7e569f4d009ca8f5d6c710ae78215.webp" "ClassName" => "Single Family" "MediaSize" => 732742 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-e3b7e569f4d009ca8f5d6c710ae78215.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "59950317" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/a72be34f4a2081f67b5c500906f89268.webp" "ClassName" => "Single Family" "MediaSize" => 712528 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-a72be34f4a2081f67b5c500906f89268.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "59950318" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/709dfdbcae5a4b4362ca951cb50974a1.webp" "ClassName" => "Single Family" "MediaSize" => 746286 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-709dfdbcae5a4b4362ca951cb50974a1.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "59950319" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/4ef7739cc11caea9a8002b699ed83359.webp" "ClassName" => "Single Family" "MediaSize" => 678649 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-4ef7739cc11caea9a8002b699ed83359.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "59950320" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/9bc487966a1d1cdc8464b8ab2e6ff580.webp" "ClassName" => "Single Family" "MediaSize" => 601976 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-9bc487966a1d1cdc8464b8ab2e6ff580.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "59950321" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/55f5eb78832621313142431389a3cb6a.webp" "ClassName" => "Single Family" "MediaSize" => 631023 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-55f5eb78832621313142431389a3cb6a.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "59950322" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/00a438c745a2af1d0fa085d2c173c748.webp" "ClassName" => "Single Family" "MediaSize" => 762713 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-00a438c745a2af1d0fa085d2c173c748.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "59950323" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/f2016ffcce6a78b08650d9be8c3f0d00.webp" "ClassName" => "Single Family" "MediaSize" => 713485 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-f2016ffcce6a78b08650d9be8c3f0d00.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 24 => array:11 [ "Order" => 24 "MediaKey" => "59950324" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/f54f693aa93dd185bf1159cf960729b2.webp" "ClassName" => "Single Family" "MediaSize" => 703583 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/599503/thumbnail-f54f693aa93dd185bf1159cf960729b2.webp" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "" "ResourceRecordKey" => "599503" ] 25 => array:11 [ "Order" => 25 "MediaKey" => "59950325" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/599503/d46f8f34c3ca2ab37f45485b223df8a9.webp" "ClassName" => "Single Family" "MediaSize" => 680201 …6 ] 26 => array:11 [ …11] 27 => array:11 [ …11] 28 => array:11 [ …11] 29 => array:11 [ …11] 30 => array:11 [ …11] 31 => array:11 [ …11] 32 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('599503')" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3216 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "614088" +"ListingId": "614088" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-01T18:42:19Z" +"RFModificationTimestamp": "2025-08-01T18:49:43Z" +"ListPrice": 249999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1928.0 +"BuildingAreaTotal": 1928.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "267 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.144214 1 => 33.857269 ] +"Latitude": 33.857269 +"Longitude": -81.144214 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "September 2025 Move-In! Just in time for Summer gatherings! Welcome to your stunning NEW 3-bedroom, 2.5-bath Anderson plan in Lexington County,, perfectly situated for easy commuting in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertops in the kitchen and baths, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. An amazing iron baluster 1st floor oak stair rail greets you in this large open foyer. This home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, tiled backsplash, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes 2 full walk-in closets and double vanity bathroom. An additional full bathroom is conveniently located near 2 bedrooms, ideal for privacy from main floor living, hosting overnight guests, or creating a home office. Enjoy the exceptional included features that include 9 foot ceilings on the main level, white square cabinets in 36” and 42” heights with crown moulding, garage coach lights (per plan), large outside patios, gutters and more! Schedule your tour today! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-07-28T20:15:36.484099+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-07-28" +"PhotosChangeTimestamp": "2025-08-01T18:42:19Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "267" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-041" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "267 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-07-28" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "41" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Double Vanity,Bath-Shared,Closet-Walk in,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Loft" +"# of Stories": "2" +"Garage Level": "Main" +"LA1User Code": "JGOULD" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Full Baths-2nd": "2" +"Half Baths-2nd": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "129.67" +"Agent Hit Count": "54" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Elementary School": "Congaree" +"Full Baths- Lower": "0" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"LA1Agent Last Name": "Gould" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "129.67" +"Geo Update Timestamp": "2025-07-28T20:14:35.5" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "267" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"LA1Agent Middle Initial": "M" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-07-28T20:14:36" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] 22 => array:11 [ …11] 23 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('614088')" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3217 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "614446" +"ListingId": "614446" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-08-01T18:38:43Z" +"RFModificationTimestamp": "2025-08-01T18:42:57Z" +"ListPrice": 264999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.26 +"LivingArea": 1955.0 +"BuildingAreaTotal": 1955.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "266 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.1438392154 1 => 33.8575196248 ] +"Latitude": 33.8575196248 +"Longitude": -81.1438392154 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "SOLD Before listed for comps only. Welcome to your open concept NEW 4-bedroom, 2.5-bath Crane plan in Lexington County, perfectly situated in Heron Pointe; a location great for easy commuting located in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant granite countertops in the kitchen, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. This home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes a full walk in closet and double vanity bathroom. An additional full bathroom is also located near the 3 quaint bedrooms. You will also love your new versatile loft space, ideal for another living area while hosting overnight guests with a pull out couch, or creating a home office or an exercise room. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-08-01T18:42:34.805554+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-07-31" +"PhotosChangeTimestamp": "2025-08-01T18:38:43Z" +"PhotosCount": "22" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Counter Tops-Granite,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "266" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-046" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "266 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-08-01" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "46" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Loft" +"# of Stories": "2" +"Garage Level": "Main" +"LA1User Code": "JGOULD" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Full Baths-2nd": "2" +"Half Baths-2nd": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "135.55" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Full Baths- Lower": "0" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"LA1Agent Last Name": "Gould" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "135.55" +"Geo Update Timestamp": "2025-08-01T18:37:27.2" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "266" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"LA1Agent Middle Initial": "M" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-08-01T18:37:29.2" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:22 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('614446')" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3218 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "613794" +"ListingId": "613794" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-07-29T15:00:02Z" +"RFModificationTimestamp": "2025-07-29T15:07:04Z" +"ListPrice": 234999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1755.0 +"BuildingAreaTotal": 1755.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "263 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.144093 1 => 33.857164 ] +"Latitude": 33.857164 +"Longitude": -81.144093 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "September 2025 Move In! Welcome to your open concept NEW 4-bedroom, 2.5-bath Crane plan in Lexington County, perfectly situated in Heron Pointe; a location great for easy commuting located in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertops in the kitchen, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. This home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes a full walk in closet and double vanity bathroom. An additional full bathroom is also located near the 3 quaint bedrooms. You will also love your new versatile loft space, ideal for another living area while hosting overnight guests with a pull out couch, or creating a home office or an exercise room. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-07-24T12:47:06.397536+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-07-23" +"PhotosChangeTimestamp": "2025-07-29T15:00:02Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "263" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/558/modelhome/2926/virtualtour/2933" +"WaterSource": "Well" +"TMS": "008902-01-040" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "263 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-07-24" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "40" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Double Vanity,Bath-Shared,Closet-Walk in,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Loft" +"# of Stories": "2.5" +"Garage Level": "Main" +"LA1User Code": "JGOULD" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Full Baths-2nd": "2" +"Half Baths-2nd": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "133.9" +"Agent Hit Count": "56" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Full Baths- Lower": "0" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"LA1Agent Last Name": "Gould" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Jeremy" +"List Price Tot SqFt": "133.9" +"Geo Update Timestamp": "2025-07-24T12:42:17.5" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "263" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"LA1Agent Middle Initial": "M" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-07-24T12:42:18.1" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] 22 => array:11 [ …11] 23 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('613794')" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3219 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "613121" +"ListingId": "613121" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-28T16:25:39Z" +"RFModificationTimestamp": "2025-07-28T16:33:48Z" +"ListPrice": 289900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.12 +"LivingArea": 1726.0 +"BuildingAreaTotal": 1726.0 +"City": "Blythewood" +"PostalCode": "29016" +"UnparsedAddress": "1117 Turtle Stone Road, Blythewood, SC 29016" +"Coordinates": array:2 [ 0 => -80.90306 1 => 34.1768495788 ] +"Latitude": 34.1768495788 +"Longitude": -80.90306 +"YearBuilt": 2022 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Mac's Real Estate Services Inc" +"ListAgentMlsId": "12213" +"ListOfficeMlsId": "1091" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Welcome to 1117 Turtle Stone Road in Blythewood, SC – just minutes from the future home of Scout Motors! This beautifully maintained 4-bedroom, 2.5-bathroom home was built in 2022 and offers modern comfort and convenience throughout. Step inside to discover a spacious open-concept layout featuring high ceilings, vaulted ceilings in the great room, and high-end blinds throughout the home. The kitchen is perfect for entertaining with its gas range, granite countertops, bar seating, pantry, and abundant cabinet space. The great room boasts a ceiling fan and tons of natural light, creating a welcoming space for family and friends. The owner’s suite is located on the main level, complete with a large walk-in closet, double vanity, garden tub, and separate shower. A convenient half bath downstairs is perfect for guests, while the additional bedrooms are located upstairs for added privacy. Enjoy extras like a spacious laundry room, tankless gas water heater, 2-car garage with opener, covered front porch, and a fully fenced backyard. The sprinkler system helps keep your curb appeal looking sharp year-round. Located in a community with a pool, this home offers both lifestyle and location. Don’t miss your chance to own in one of Blythewood’s most desirable areas! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Tankless H20,Gas Water Heater" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Richland" +"CreationDate": "2025-07-15T17:31:57.149896+00:00" +"Directions": "From I-77 take Exit 24. Right on Wilson Blvd. Continue 1.6 miles and turn right on Rimer Pond Rd. Continue 4 miles and turn right on Hard Scrabble Rd. Continue 1 mile and turn right into The Falls. Turn left on South Sage Drop Rd. Road will turn into Turtle Stone at Curve. Home will be on left." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Fencing": "Privacy Fence,Rear Only Wood" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl,Split System" +"InteriorFeatures": "Attic Storage,Ceiling Fan,Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "benbrysonmcc@gmail.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "ACTIVE" +"OpenParkingSpaces": "3" +"OriginalEntryTimestamp": "2025-07-15" +"PhotosChangeTimestamp": "2025-07-15T17:23:25Z" +"PhotosCount": "30" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Bar,Pantry,Counter Tops-Granite,Cabinets-Stained,Floors-Luxury Vinyl Plank" +"Sewer": "Public" +"StateOrProvince": "SC" +"StreetName": "Turtle Stone" +"StreetNumber": "1117" +"StreetSuffix": "Road" +"SubdivisionName": "The Falls" +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/1117_turtle_stone_rd_blythewood_sc/" +"WaterSource": "Public" +"TMS": "20415-04-10" +"Baths": "3" +"Range": "Free-standing,Gas,Self Clean" +"Garage": "Garage Attached, Front Entry" +"Address": "1117 Turtle Stone Road" +"Assn Fee": "425" +"LVT Date": "2025-07-15" +"Power On": "Yes" +"Baths Full": "2" +"Great Room": "Ceiling-Vaulted,Ceiling Fan,Floors-Luxury Vinyl Plank" +"New/Resale": "Resale" +"class_name": "RE_1" +"2nd Bedroom": "Bath-Shared,Tub-Shower,Closet-Private,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Tub-Shower,Floors - Carpet" +"4th Bedroom": "Bath-Shared,Closet-Walk in,Tub-Shower,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Blythewood" +"House Faces": "Northwest" +"IDX Include": "Yes" +"# of Stories": "2" +"Garage Level": "Main" +"LA1User Code": "MCCARB" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Blythewood" +"Miscellaneous": "Cable TV Available,Community Pool" +"Status Detail": "0" +"Full Baths-2nd": "1" +"Half Baths-2nd": "0" +"Lockbox Number": "32796839" +"Master Bedroom": "Double Vanity,Tub-Garden,Bath-Private,Separate Shower,Closet-Walk in,Ceilings-High (over 9 Ft),Floors - Carpet" +"Price Per SQFT": "167.96" +"Short Sale Y/N": "No" +"Agent Hit Count": "71" +"Avail Financing": "Cash,Conventional,FHA,VA" +"Full Baths-Main": "1" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"School District": "Richland Two" +"Level-Great Room": "Main" +"Elementary School": "Lake Carolina" +"Int School Choice": "No" +"LO1Main Office ID": "1091" +"Other Heated SqFt": "0" +"Senior Living Y/N": "N" +"Assoc Fee Includes": "Common Area Maintenance,Pool,Green Areas" +"Formal Dining Room": "Area,Ceilings-High (over 9 Ft),Floors-Luxury Vinyl Plank" +"High School Choice": "No" +"LA1Agent Last Name": "McCarter" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "Yearly" +"Detitled Mobile Y/N": "N" +"Foreclosed Property": "No" +"LA1Agent First Name": "Ben" +"List Price Tot SqFt": "167.96" +"Geo Update Timestamp": "2025-07-15T17:23:23.6" +"LO1Office Identifier": "1091" +"Level-Master Bedroom": "Main" +"Middle School Choice": "No" +"Address Search Number": "1117" +"LO1Office Abbreviation": "MACS01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Other Elementary School": "Lake Carolina" +"Publish to Internet Y/N": "Yes" +"Elementary School Choice": "No" +"Interior # of Fireplaces": "0" +"Level-Formal Dining Room": "Main" +"First Photo Add Timestamp": "2025-07-15T17:23:25" +"MlsAreaMajor": "Columbia Northeast" +"Media": array:30 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] 22 => array:11 [ …11] 23 => array:11 [ …11] 24 => array:11 [ …11] 25 => array:11 [ …11] 26 => array:11 [ …11] 27 => array:11 [ …11] 28 => array:11 [ …11] 29 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('613121')" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3220 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "602501" +"ListingId": "602501" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-07-28T14:11:57Z" +"RFModificationTimestamp": "2025-07-28T14:19:21Z" +"ListPrice": 268000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.26 +"LivingArea": 1955.0 +"BuildingAreaTotal": 1955.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "218 Hazel Rain Road, Gaston, Sc 29053" +"Coordinates": array:2 [ 0 => -81.142062 1 => 33.856589 ] +"Latitude": 33.856589 +"Longitude": -81.142062 +"YearBuilt": 2024 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "1766" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Sold before listed for comp purposes only! Welcome to your open concept NEW 4-bedroom, 2.5-bath Crane plan in Lexington County, perfectly situated in Heron Pointe; a location great for easy commuting located in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertops in the kitchen, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. This home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes a full walk in closet and double vanity bathroom. An additional full bathroom is also located near the 3 quaint bedrooms. You will also love your new versatile loft space, ideal for another living area while hosting overnight guests with a pull out couch, or creating a home office or an exercise room. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Stone,Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-03-18T12:55:12.920309+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "sharee.hairston@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-02-20" +"PhotosChangeTimestamp": "2025-07-28T14:11:57Z" +"PhotosCount": "24" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "218" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-058" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "218 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-02-21" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "58" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Closet-Walk in,Floors - Carpet" +"3rd Bedroom": "Closet-Walk in,Floors - Carpet" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Loft" +"# of Stories": "2" +"Garage Level": "Main" +"LA1User Code": "HAIRSTS" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Full Baths-2nd": "2" +"Half Baths-2nd": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "137.08" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"Level-Bedroom 4": "Second" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Full Baths- Lower": "0" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"LA1Agent Last Name": "Hairston" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Sharee" +"List Price Tot SqFt": "137.08" +"Geo Update Timestamp": "2025-02-21T15:10:22.2" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "218" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-02-21T15:10:23" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] 22 => array:11 [ …11] 23 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('602501')" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3221 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "609201" +"ListingId": "609201" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-07-23T13:39:21Z" +"RFModificationTimestamp": "2025-07-23T13:43:07Z" +"ListPrice": 239999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1928.0 +"BuildingAreaTotal": 1928.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "247 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.143638 1 => 33.856772 ] +"Latitude": 33.856772 +"Longitude": -81.143638 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "1766" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "August 2025 Move-In! Just in time for Summer gatherings! Welcome to your stunning NEW 3-bedroom, 2.5-bath Anderson plan in Lexington County,, perfectly situated for easy commuting in Gaston, SC. Enjoy the convenience of nearby shopping, Lake Murray, top-rated schools, and just a 26-minute drive to downtown Columbia. This home features elegant quartz countertops in the kitchen and baths, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. An amazing iron baluster 1st floor oak stair rail greets you in this large open foyer. This home also offers exceptional indoor and outdoor spaces, perfect for entertaining and relaxation. The open kitchen has spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, tiled backsplash, microwave and dishwasher. All bedrooms are located on the second floor for privacy from the main level. The second-floor owner’s suite includes 2 full walk-in closets and double vanity bathroom. An additional full bathroom is conveniently located near 2 bedrooms, ideal for privacy from main floor living, hosting overnight guests, or creating a home office. Enjoy the exceptional included features that include 9 foot ceilings on the main level, white square cabinets in 36” and 42” heights with crown moulding, garage coach lights (per plan), large outside patios, gutters and more! Schedule your tour today! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings." +"Appliances": "Dishwasher,Disposal,Microwave Above Stove,Stove Exhaust Vented Exte,Tankless H20" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-05-22T18:53:55.569082+00:00" +"Directions": "I-26 E to exit 115. Turn right onto Hwy 321 then turn right onto Fish Hatchery Road. Follow Fish Hatchery Road to Heron Pointe entrance at Hazel Rain Road. From I-77. Exit straight to Fish Hatchery Road and continue on Fish Hatchery Road to Heron Pointe entrance." +"ExteriorFeatures": "Sprinkler,Gutters - Partial,Front Porch - Covered" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"InteriorFeatures": "Garage Opener,Smoke Detector,Attic Pull-Down Access" +"LaundryFeatures": "Electric,Heated Space,Utility Room" +"ListAgentEmail": "sharee.hairston@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-05-22" +"PhotosChangeTimestamp": "2025-07-23T13:39:21Z" +"PhotosCount": "32" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Island,Pantry,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "247" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"TMS": "008902-01-036" +"Baths": "3" +"Range": "Gas" +"Energy": "Thermopane" +"Garage": "Garage Attached, Front Entry" +"Address": "247 Hazel Rain Road" +"Assn Fee": "411" +"LVT Date": "2025-05-22" +"Power On": "No" +"Baths Full": "2" +"Great Room": "Floors-Luxury Vinyl Plank" +"Lot Number": "36" +"New/Resale": "New" +"class_name": "RE_1" +"2nd Bedroom": "Double Vanity,Bath-Shared,Closet-Walk in,Floors - Carpet" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Baths Combo": "2 / 1" +"High School": "Airport" +"IDX Include": "Yes" +"Other Rooms": "Loft" +"# of Stories": "2" +"Garage Level": "Main" +"LA1User Code": "HAIRSTS" +"Garage Spaces": "2" +"Level-Kitchen": "Main" +"Middle School": "Pine Ridge" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Status Detail": "0" +"Full Baths-2nd": "2" +"Half Baths-2nd": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Price Per SQFT": "124.48" +"Agent Hit Count": "103" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"Full Baths-Main": "0" +"Geo Subdivision": "SC" +"Half Baths-Main": "1" +"Level-Bedroom 2": "Second" +"Level-Bedroom 3": "Second" +"School District": "Lexington Two" +"Level-Great Room": "Main" +"Elementary School": "Congaree" +"Full Baths- Lower": "0" +"LO1Main Office ID": "1577" +"Other Heated SqFt": "0" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"LA1Agent Last Name": "Hairston" +"Level-Washer Dryer": "Main" +"Rollback Tax (Y/N)": "No" +"Assn/Regime Fee Per": "6 Months" +"LA1Agent First Name": "Sharee" +"List Price Tot SqFt": "124.48" +"Geo Update Timestamp": "2025-05-22T18:47:33.7" +"LO1Office Identifier": "1577" +"Level-Master Bedroom": "Second" +"Address Search Number": "247" +"LO1Office Abbreviation": "LENC01" +"Listing Type Agreement": "Exclusive Right to Sell" +"Publish to Internet Y/N": "Yes" +"Interior # of Fireplaces": "0" +"First Photo Add Timestamp": "2025-05-22T18:47:34.8" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:32 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] 19 => array:11 [ …11] 20 => array:11 [ …11] 21 => array:11 [ …11] 22 => array:11 [ …11] 23 => array:11 [ …11] 24 => array:11 [ …11] 25 => array:11 [ …11] 26 => array:11 [ …11] 27 => array:11 [ …11] 28 => array:11 [ …11] 29 => array:11 [ …11] 30 => array:11 [ …11] 31 => array:11 [ …11] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('609201')" } ] +success: true +page_size: 10 +page_count: 3 +count: 26 +after_key: "" } ] ]
