HERON POINTE
24 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:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=20&$filter=SubdivisionName eq 'HERON POINTE'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=20&$filter=SubdivisionName eq 'HERON POINTE'&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=20&$filter=SubdivisionName eq 'HERON POINTE'/Property?$select=ALL&$orderby=ModificationTimestamp desc&$top=10&$skip=20&$filter=SubdivisionName eq 'HERON POINTE'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3219 +items: array:4 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3218 +post_id: "105562" +post_author: 1 +"ListingKey": "609114" +"ListingId": "609114" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-24T19:15:05Z" +"RFModificationTimestamp": "2025-06-27T09:08:25Z" +"ListPrice": 254999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.28 +"LivingArea": 1755.0 +"BuildingAreaTotal": 1755.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "243 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.143517 1 => 33.85668 ] +"Latitude": 33.85668 +"Longitude": -81.143517 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "August 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-05-21T20:36:04.712924+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-05-21" +"PhotosChangeTimestamp": "2025-06-24T19:15:05Z" +"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": "243" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/558/modelhome/2926/virtualtour/2933" +"WaterSource": "Well" +"Baths Full": "2" +"2nd Bedroom": "Double Vanity,Bath-Shared,Closet-Walk in,Floors - Carpet" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Address": "243 Hazel Rain Road" +"Assn Fee": "411" +"Great Room": "Floors-Luxury Vinyl Plank" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"New/Resale": "New" +"# of Stories": "2.5" +"Baths": "3" +"LO1Office Identifier": "1577" +"Power On": "No" +"LO1Main Office ID": "1577" +"Level-Kitchen": "Main" +"Half Baths-Main": "1" +"Full Baths-Main": "0" +"Price Per SQFT": "145.3" +"LO1Office Abbreviation": "LENC01" +"Range": "Gas" +"High School": "Airport" +"Agent Hit Count": "75" +"Garage Spaces": "2" +"Level-Washer Dryer": "Main" +"LA1User Code": "JGOULD" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"LA1Agent First Name": "Jeremy" +"Baths Combo": "2 / 1" +"Garage Level": "Main" +"Half Baths-2nd": "0" +"Address Search Number": "243" +"Lot Number": "35" +"Level-Master Bedroom": "Second" +"School District": "Lexington Two" +"LVT Date": "2025-05-21" +"Middle School": "Pine Ridge" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Interior # of Fireplaces": "0" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Energy": "Thermopane" +"Other Heated SqFt": "0" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "RE_1" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Level-Bedroom 3": "Second" +"Level-Great Room": "Main" +"Level-Bedroom 4": "Second" +"Rollback Tax (Y/N)": "No" +"IDX Include": "Yes" +"Level-Bedroom 2": "Second" +"List Price Tot SqFt": "145.3" +"LA1Agent Middle Initial": "M" +"Full Baths-2nd": "2" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-05-21T20:26:41.8" +"Garage": "Garage Attached, Front Entry" +"LA1Agent Last Name": "Gould" +"Assn/Regime Fee Per": "6 Months" +"Full Baths- Lower": "0" +"TMS": "008902-01-035" +"Geo Update Timestamp": "2025-05-21T20:26:40.8" +"Other Rooms": "Loft" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6091140" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/4cdb0a6fb72fa5b8aa069cb9af063a51.webp" "MediaSize" => 476661 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-4cdb0a6fb72fa5b8aa069cb9af063a51.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6091141" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/5fa3c5072192470bb8140b5b20f3eae6.webp" "MediaSize" => 99568 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-5fa3c5072192470bb8140b5b20f3eae6.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6091142" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/caed92d9bc39bf73761f98346b961aca.webp" "MediaSize" => 117957 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-caed92d9bc39bf73761f98346b961aca.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6091143" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/4bad2662d8fdf9eaf65fe76a0a88b750.webp" "MediaSize" => 46032 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-4bad2662d8fdf9eaf65fe76a0a88b750.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6091144" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/6617dea89daa2c1ff26008090b7209ec.webp" "MediaSize" => 302786 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-6617dea89daa2c1ff26008090b7209ec.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6091145" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/b7232ff7a7105721bc74b2a4143bcbf8.webp" "MediaSize" => 371921 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-b7232ff7a7105721bc74b2a4143bcbf8.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6091146" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/98e76ef3f0500202cb43cd3645897d4e.webp" "MediaSize" => 327530 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-98e76ef3f0500202cb43cd3645897d4e.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6091147" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/9b281d34e5f16a60d9b765c6c040a8ea.webp" "MediaSize" => 305892 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-9b281d34e5f16a60d9b765c6c040a8ea.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6091148" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/0c3cff3c182dacde591db09331cee299.webp" "MediaSize" => 377569 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-0c3cff3c182dacde591db09331cee299.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6091149" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/0d8c3f2ba598451676bb2f47ece144a6.webp" "MediaSize" => 302655 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-0d8c3f2ba598451676bb2f47ece144a6.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "60911410" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/cd139b2fefa2d56453db7e937b1d4c85.webp" "MediaSize" => 337276 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-cd139b2fefa2d56453db7e937b1d4c85.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "60911411" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/eef209cb4b0a0d1424a91ec9c0341784.webp" "MediaSize" => 368552 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-eef209cb4b0a0d1424a91ec9c0341784.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "60911412" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/889e91d113f5659678537c40efe4d317.webp" "MediaSize" => 291549 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-889e91d113f5659678537c40efe4d317.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "60911413" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/e2f0fa71dad93acc0a41adf0cf208fb5.webp" "MediaSize" => 304455 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-e2f0fa71dad93acc0a41adf0cf208fb5.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "60911414" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/921de4c7baeb2e209fda522543340c80.webp" "MediaSize" => 348880 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-921de4c7baeb2e209fda522543340c80.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "60911415" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/7baae0f6fed588b827cc4a018f6833a0.webp" "MediaSize" => 300815 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-7baae0f6fed588b827cc4a018f6833a0.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "60911416" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/faff27e518c09600a5aa374101b63f66.webp" "MediaSize" => 231951 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-faff27e518c09600a5aa374101b63f66.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "60911417" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/01ab837fb06cc229cb86761eda8f54fc.webp" "MediaSize" => 278304 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-01ab837fb06cc229cb86761eda8f54fc.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "60911418" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/742a0227086c9dbf2b98c4193bb54df7.webp" "MediaSize" => 350340 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-742a0227086c9dbf2b98c4193bb54df7.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "60911419" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/c44f3011ece36fa34d6ae8b568c1b87a.webp" "MediaSize" => 371021 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-c44f3011ece36fa34d6ae8b568c1b87a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "60911420" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/30aada9110ffa75e56d5aabc4dc5a80b.webp" "MediaSize" => 222835 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-30aada9110ffa75e56d5aabc4dc5a80b.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "60911421" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/e96cca42889295bb29eaf79f7b7003b1.webp" "MediaSize" => 262906 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-e96cca42889295bb29eaf79f7b7003b1.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "60911422" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/2311e4caccd7193016293e0e44c7fd29.webp" "MediaSize" => 992881 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-2311e4caccd7193016293e0e44c7fd29.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "60911423" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609114/7ea44cfc6536a16b51b407a026c22e3a.webp" "MediaSize" => 61212 "ResourceRecordKey" => "609114" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609114/thumbnail-7ea44cfc6536a16b51b407a026c22e3a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('609114')" +"ID": "105562" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3220 +post_id: "103463" +post_author: 1 +"ListingKey": "606899" +"ListingId": "606899" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-06-16T15:14:02Z" +"RFModificationTimestamp": "2025-06-16T15:20:03Z" +"ListPrice": 272999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.28 +"LivingArea": 1955.0 +"BuildingAreaTotal": 1955.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "235 Hazel Rain Road, Gaston, Sc 29053" +"Coordinates": array:2 [ 0 => -81.143283 1 => 33.856488 ] +"Latitude": 33.856488 +"Longitude": -81.143283 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "July 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-04-21T17:43:55.351540+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-04-21" +"PhotosChangeTimestamp": "2025-06-16T15:14: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": "235" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"Baths Full": "2" +"2nd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Address": "235 Hazel Rain Road" +"Assn Fee": "411" +"Great Room": "Floors-Luxury Vinyl Plank" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"New/Resale": "New" +"# of Stories": "2" +"Baths": "3" +"LO1Office Identifier": "1577" +"Power On": "No" +"LO1Main Office ID": "1577" +"Level-Kitchen": "Main" +"Half Baths-Main": "1" +"Full Baths-Main": "0" +"Price Per SQFT": "139.64" +"LO1Office Abbreviation": "LENC01" +"Range": "Gas" +"High School": "Airport" +"Agent Hit Count": "121" +"Garage Spaces": "2" +"Level-Washer Dryer": "Main" +"LA1User Code": "JGOULD" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"LA1Agent First Name": "Jeremy" +"Baths Combo": "2 / 1" +"Garage Level": "Main" +"Half Baths-2nd": "0" +"Address Search Number": "235" +"Lot Number": "33" +"Level-Master Bedroom": "Second" +"School District": "Lexington Two" +"LVT Date": "2025-04-21" +"Middle School": "Pine Ridge" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Interior # of Fireplaces": "0" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Energy": "Thermopane" +"Other Heated SqFt": "0" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "RE_1" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Level-Bedroom 3": "Second" +"Level-Great Room": "Main" +"Level-Bedroom 4": "Second" +"Rollback Tax (Y/N)": "No" +"IDX Include": "Yes" +"Level-Bedroom 2": "Second" +"List Price Tot SqFt": "139.64" +"LA1Agent Middle Initial": "M" +"Full Baths-2nd": "2" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-04-21T17:32:20.8" +"Garage": "Garage Attached, Front Entry" +"LA1Agent Last Name": "Gould" +"Assn/Regime Fee Per": "6 Months" +"Full Baths- Lower": "0" +"TMS": "008902-01-033" +"Geo Update Timestamp": "2025-04-21T17:32:19.8" +"Other Rooms": "Loft" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6068990" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/3141d5c84ceabbc569df28ae0166afc1.webp" "MediaSize" => 354947 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-3141d5c84ceabbc569df28ae0166afc1.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6068991" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/8356bf159b7718f33e168b2546d85dfc.webp" "MediaSize" => 99568 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-8356bf159b7718f33e168b2546d85dfc.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6068992" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/7f29c656ca30ba371a26c2679ef9becb.webp" "MediaSize" => 117957 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-7f29c656ca30ba371a26c2679ef9becb.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6068993" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/eff2278266cd595371e06be22f1bad39.webp" "MediaSize" => 45109 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-eff2278266cd595371e06be22f1bad39.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6068994" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/9bb61300c8282d99c5bae8e8f1ffa2f4.webp" "MediaSize" => 302786 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-9bb61300c8282d99c5bae8e8f1ffa2f4.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6068995" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/987b437dffe7da249bde1de19af352c7.webp" "MediaSize" => 371921 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-987b437dffe7da249bde1de19af352c7.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6068996" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/9c5523e0e40c753208b7d880b85448ce.webp" "MediaSize" => 327530 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-9c5523e0e40c753208b7d880b85448ce.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6068997" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/0f0e2cd4763ff471dc631ace9f1119bb.webp" "MediaSize" => 305892 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-0f0e2cd4763ff471dc631ace9f1119bb.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6068998" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/d8b3ee4fa485e4ba77d8dbc88ba5a750.webp" "MediaSize" => 377569 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-d8b3ee4fa485e4ba77d8dbc88ba5a750.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6068999" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/79706a736622a813d37b111b972214aa.webp" "MediaSize" => 302655 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-79706a736622a813d37b111b972214aa.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "60689910" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/61f53378be30c80914e3c336cd3338f9.webp" "MediaSize" => 337276 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-61f53378be30c80914e3c336cd3338f9.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "60689911" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/e1d7d6912d3be8ef5f688b2834453671.webp" "MediaSize" => 368552 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-e1d7d6912d3be8ef5f688b2834453671.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "60689912" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/bad1af2915e789b8a8162e907d644f4c.webp" "MediaSize" => 291549 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-bad1af2915e789b8a8162e907d644f4c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "60689913" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/e8f8fa11962b1cdf0168fc02cd1bdb77.webp" "MediaSize" => 304455 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-e8f8fa11962b1cdf0168fc02cd1bdb77.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "60689914" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/3d5f5ef1518ec9d952b044d7cc6ef228.webp" "MediaSize" => 348880 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-3d5f5ef1518ec9d952b044d7cc6ef228.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "60689915" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/2f0a0d4038584fa7a6dacaf1fc0884e5.webp" "MediaSize" => 300815 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-2f0a0d4038584fa7a6dacaf1fc0884e5.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "60689916" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/5de2651d8c98f6dcbb1fb690b43752b5.webp" "MediaSize" => 231951 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-5de2651d8c98f6dcbb1fb690b43752b5.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "60689917" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/40592874bf542853cabaf1d0384c4f86.webp" "MediaSize" => 278304 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-40592874bf542853cabaf1d0384c4f86.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "60689918" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/eb1a907bda6c4e5c0afcc8bb1b84d889.webp" "MediaSize" => 350340 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-eb1a907bda6c4e5c0afcc8bb1b84d889.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "60689919" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/904f6211362ce3d0983515ae26830fde.webp" "MediaSize" => 371021 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-904f6211362ce3d0983515ae26830fde.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "60689920" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/980bdd60943b3a410a6b443bd4fc8214.webp" "MediaSize" => 222835 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-980bdd60943b3a410a6b443bd4fc8214.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "60689921" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/441978cc3f2340d3e28e20c7e78aca88.webp" "MediaSize" => 262906 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-441978cc3f2340d3e28e20c7e78aca88.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "60689922" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/863ed1a2b1ca447a4619751a006b78ea.webp" "MediaSize" => 992881 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-863ed1a2b1ca447a4619751a006b78ea.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "60689923" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/606899/6ca86c56e87a7f275b958d6d88576673.webp" "MediaSize" => 61212 "ResourceRecordKey" => "606899" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/606899/thumbnail-6ca86c56e87a7f275b958d6d88576673.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('606899')" +"ID": "103463" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3217 +post_id: "106218" +post_author: 1 +"ListingKey": "609727" +"ListingId": "609727" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-05-30T16:31:14Z" +"RFModificationTimestamp": "2025-06-28T02:11:50Z" +"ListPrice": 289999.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0.26 +"LivingArea": 2306.0 +"BuildingAreaTotal": 2306.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "230 Hazel Rain Road, Gaston, SC 29053" +"Coordinates": array:2 [ 0 => -81.142417 1 => 33.856872 ] +"Latitude": 33.856872 +"Longitude": -81.142417 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "Sold before listed for comp purposes only! Find main level living in your NEW 5-bedroom, 2.5-bath Emerson 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, and tile backsplash in the kitchen, wood-inspired vinyl plank flooring throughout the first floor, and a seamless transition from the living space to the backyard. Overlooking the Family Room, the open kitchen has extra storage and large pantry, spacious counters, an expansive island, and modern stainless-steel appliances, including a gas stove, microwave, and dishwasher. Your first- floor owner’s suite includes a full walk in closet and double vanity bathroom as well as a large, enclosed shower. An added elegant stained oak rail and iron balusters are located at the first floor staircase.On the second floor a full bathroom is conveniently located near 4 additional bedrooms; ideal for privacy from main floor living, hosting overnight guests, or creating a home office. An additional open Loft area serves the second floor for boundless opportunities such as an additional living area to entertain or even an exercise room- you choose! 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" +"ArchitecturalStyle": "Traditional" +"AssociationYN": true +"Basement": "No Basement" +"BuildingAreaUnits": "Sqft" +"ConstructionMaterials": "Vinyl" +"Cooling": "Central" +"CountyOrParish": "Lexington" +"CreationDate": "2025-05-30T16:37:27.366015+00:00" +"Directions": "l-26 E to exit 115. Turn right on to Hwy 321 then turn right onto Fish Hatchery RD. Follow Fish Hatchery to Heron Pointe entrance at Hazel Rain Rd. From l-77 turn left onto HWY 321 then go to Fish Hatchery RD and turn right and continue on Fish Hatchery rd to Heron Point entrance" +"ExteriorFeatures": "Sprinkler,Gutters - Full" +"Heating": "Gas 1st Lvl,Gas 2nd Lvl" +"ListAgentEmail": "lennarcharlotte@lennar.com" +"LivingAreaUnits": "Sqft" +"LotSizeUnits": "Sqft" +"MlsStatus": "PENDING" +"OriginalEntryTimestamp": "2025-05-30" +"PhotosChangeTimestamp": "2025-05-30T16:31:14Z" +"PhotosCount": "30" +"RoadFrontageType": "Paved" +"RoomKitchenFeatures": "Eat In,Backsplash-Tiled,Cabinets-Painted,Recessed Lights,Counter Tops-Quartz,Floors-Luxury Vinyl Plank" +"Sewer": "Septic" +"StateOrProvince": "SC" +"StreetName": "Hazel Rain" +"StreetNumber": "230" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/925/virtualtour/932" +"WaterSource": "Well" +"Baths Full": "2" +"2nd Bedroom": "Closet-Walk in" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Address": "230 Hazel Rain Road" +"Assn Fee": "411" +"Great Room": "Floors-Luxury Vinyl Plank" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance,Green Areas" +"New/Resale": "New" +"# of Stories": "2" +"Baths": "3" +"LO1Office Identifier": "1577" +"Power On": "No" +"LO1Main Office ID": "1577" +"Level-Kitchen": "Main" +"Half Baths-Main": "1" +"Full Baths-Main": "1" +"Price Per SQFT": "125.76" +"LO1Office Abbreviation": "LENC01" +"Range": "Gas" +"High School": "Airport" +"Garage Spaces": "2" +"Level-Washer Dryer": "Main" +"LA1User Code": "JGOULD" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA" +"LA1Agent First Name": "Jeremy" +"Baths Combo": "2 / 1" +"Address Search Number": "230" +"Lot Number": "55" +"Level-Master Bedroom": "Main" +"School District": "Lexington Two" +"LVT Date": "2025-05-30" +"Middle School": "Pine Ridge" +"Interior # of Fireplaces": "0" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Closet-Walk in" +"Energy": "Thermopane" +"Other Heated SqFt": "0" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "RE_1" +"4th Bedroom": "Closet-Walk in" +"Level-Bedroom 3": "Second" +"Level-Great Room": "Main" +"Level-Bedroom 4": "Second" +"Rollback Tax (Y/N)": "No" +"IDX Include": "Yes" +"Level-Bedroom 2": "Second" +"List Price Tot SqFt": "125.76" +"LA1Agent Middle Initial": "M" +"Full Baths-2nd": "1" +"Elementary School": "Congaree" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-05-30T16:30:47.7" +"Level-Bedroom 5": "Second" +"Garage": "Garage Attached, Front Entry" +"LA1Agent Last Name": "Gould" +"Assn/Regime Fee Per": "6 Months" +"TMS": "008902-01-055" +"5th Bedroom": "Closet-Walk in" +"Geo Update Timestamp": "2025-05-30T16:30:46.5" +"Other Rooms": "Loft" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:30 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6097270" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/23d742f752ca29e148c6bcea7cea56fa.webp" "MediaSize" => 961992 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-23d742f752ca29e148c6bcea7cea56fa.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6097271" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/099adb900e964f23852db483777d6b9b.webp" "MediaSize" => 108911 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-099adb900e964f23852db483777d6b9b.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6097272" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/8cf077c275b50bec93e73afb2e8d15a2.webp" "MediaSize" => 102969 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-8cf077c275b50bec93e73afb2e8d15a2.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6097273" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/ad1379c9aad0b3109a133cc334dec3e7.webp" "MediaSize" => 47023 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-ad1379c9aad0b3109a133cc334dec3e7.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6097274" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/c5220d0f6ce8c0e2c1e043d6f2c64c1a.webp" "MediaSize" => 282362 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-c5220d0f6ce8c0e2c1e043d6f2c64c1a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6097275" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/5b833398edd3774b68cc12f583063734.webp" "MediaSize" => 237646 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-5b833398edd3774b68cc12f583063734.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6097276" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/a30da93b8ca854061af95db0cbffdeea.webp" "MediaSize" => 395353 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-a30da93b8ca854061af95db0cbffdeea.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6097277" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/d55285f389ebb8f8a1a00dfa412b4a62.webp" "MediaSize" => 452443 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-d55285f389ebb8f8a1a00dfa412b4a62.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6097278" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/ce50dba01dc88edd795bd7537c7fd0ae.webp" "MediaSize" => 301480 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-ce50dba01dc88edd795bd7537c7fd0ae.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6097279" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/9313616f7f84ec730bfd0093730a8038.webp" "MediaSize" => 484199 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-9313616f7f84ec730bfd0093730a8038.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "60972710" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/c335995b4887c3621d8b395340804d00.webp" "MediaSize" => 395353 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-c335995b4887c3621d8b395340804d00.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "60972711" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/649b496f83c8ffb91471d7fb2d261bdf.webp" "MediaSize" => 484199 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-649b496f83c8ffb91471d7fb2d261bdf.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "60972712" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/00fa02ae3fbb65788044e163b3dacb7b.webp" "MediaSize" => 183217 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-00fa02ae3fbb65788044e163b3dacb7b.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "60972713" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/492be434c9450ce7f0802fd074dc3358.webp" "MediaSize" => 194909 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-492be434c9450ce7f0802fd074dc3358.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "60972714" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/2fdf46867d1395cd8e955cfbee0a2b53.webp" "MediaSize" => 366444 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-2fdf46867d1395cd8e955cfbee0a2b53.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "60972715" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/1a00a454171738122b8fc26339448ba8.webp" "MediaSize" => 390968 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-1a00a454171738122b8fc26339448ba8.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "60972716" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/e1e325f61b05a588cc319957219117ff.webp" "MediaSize" => 168082 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-e1e325f61b05a588cc319957219117ff.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "60972717" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/b740ece31ce943e63e983e5ece92987f.webp" "MediaSize" => 455974 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-b740ece31ce943e63e983e5ece92987f.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "60972718" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/fcf1f1dae2629c137638040680ea249e.webp" "MediaSize" => 260153 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-fcf1f1dae2629c137638040680ea249e.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "60972719" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/985bf0552a4a98d3bcb315aca236e9f7.webp" "MediaSize" => 412959 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-985bf0552a4a98d3bcb315aca236e9f7.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "60972720" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/22b361a3620d084b6d7a1e8e26e56eb1.webp" "MediaSize" => 321428 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-22b361a3620d084b6d7a1e8e26e56eb1.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "60972721" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/9c058bad12ba808a1855c347ee836a9b.webp" "MediaSize" => 194900 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-9c058bad12ba808a1855c347ee836a9b.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "60972722" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/3652ea61606918778a522a2fa11fedd6.webp" "MediaSize" => 415978 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-3652ea61606918778a522a2fa11fedd6.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "60972723" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/e3c3b413788ce83c2d050739320f63f8.webp" "MediaSize" => 455974 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-e3c3b413788ce83c2d050739320f63f8.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 24 => array:11 [ "Order" => 24 "MediaKey" => "60972724" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/c81bfbf5ae2ffd07a44b4b7d7fe0913a.webp" "MediaSize" => 376432 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-c81bfbf5ae2ffd07a44b4b7d7fe0913a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 25 => array:11 [ "Order" => 25 "MediaKey" => "60972725" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/73b0e514b106843d99620721a976cd73.webp" "MediaSize" => 444316 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-73b0e514b106843d99620721a976cd73.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 26 => array:11 [ "Order" => 26 "MediaKey" => "60972726" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/da22648e342c482c76ef04e13a7cd377.webp" "MediaSize" => 223045 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-da22648e342c482c76ef04e13a7cd377.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 27 => array:11 [ "Order" => 27 "MediaKey" => "60972727" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/f06a94027f721679dd37c73e2d5bcfca.webp" "MediaSize" => 194900 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-f06a94027f721679dd37c73e2d5bcfca.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 28 => array:11 [ "Order" => 28 "MediaKey" => "60972728" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/bfb4da2bec718591cbf0a6a7b23a5465.webp" "MediaSize" => 992881 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-bfb4da2bec718591cbf0a6a7b23a5465.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 29 => array:11 [ "Order" => 29 "MediaKey" => "60972729" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/609727/a8b22ec37d3e74596b35ec5bc9950081.webp" "MediaSize" => 91583 "ResourceRecordKey" => "609727" "ResourceName" => "Property" "ClassName" => "RESIDENTIAL" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/609727/thumbnail-a8b22ec37d3e74596b35ec5bc9950081.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('609727')" +"ID": "106218" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3221 +post_id: "102048" +post_author: 1 +"ListingKey": "605499" +"ListingId": "605499" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Pending" +"ModificationTimestamp": "2025-05-02T13:02:01Z" +"RFModificationTimestamp": "2025-05-02T13:07:24Z" +"ListPrice": 292249.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.26 +"LivingArea": 1955.0 +"BuildingAreaTotal": 1955.0 +"City": "Gaston" +"PostalCode": "29053" +"UnparsedAddress": "226 Hazel Rain Road, Gaston, Sc 29053" +"Coordinates": array:2 [ 0 => -81.142299 1 => 33.856772 ] +"Latitude": 33.856772 +"Longitude": -81.142299 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Lennar Carolinas LLC" +"ListAgentMlsId": "8866" +"ListOfficeMlsId": "1577" +"OriginatingSystemName": "columbiamls" +"PublicRemarks": "June 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 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-04-02T20:00:55.734362+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-04-01" +"PhotosChangeTimestamp": "2025-05-02T13:02:01Z" +"PhotosCount": "24" +"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": "226" +"StreetSuffix": "Road" +"SubdivisionName": "HERON POINTE" +"VirtualTourURLUnbranded": "https://www.modsy.com/homejourney/embed/lennar/community/221/modelhome/926/virtualtour/933" +"WaterSource": "Well" +"Baths Full": "2" +"2nd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Miscellaneous": "Cable TV Available,Warranty (New Const) Bldr" +"Address": "226 Hazel Rain Road" +"Assn Fee": "411" +"Great Room": "Floors-Luxury Vinyl Plank" +"Assoc Fee Includes": "Cable TV,Common Area Maintenance" +"New/Resale": "New" +"# of Stories": "2" +"Baths": "3" +"LO1Office Identifier": "1577" +"Power On": "No" +"LO1Main Office ID": "1577" +"Level-Kitchen": "Main" +"Half Baths-Main": "1" +"Full Baths-Main": "0" +"Price Per SQFT": "149.49" +"LO1Office Abbreviation": "LENC01" +"Range": "Gas" +"High School": "Airport" +"Agent Hit Count": "82" +"Garage Spaces": "2" +"Level-Washer Dryer": "Main" +"LA1User Code": "JGOULD" +"Avail Financing": "Cash,Conventional,Rural Housing Eligible,FHA,VA" +"Full Baths-Bsmt": "0" +"LA1Agent First Name": "Jeremy" +"Baths Combo": "2 / 1" +"Garage Level": "Main" +"Half Baths-2nd": "0" +"Address Search Number": "226" +"Lot Number": "56" +"Level-Master Bedroom": "Second" +"School District": "Lexington Two" +"LVT Date": "2025-04-02" +"Middle School": "Pine Ridge" +"3rd Bedroom": "Bath-Shared,Closet-Walk in,Floors - Carpet" +"Interior # of Fireplaces": "0" +"Status Detail": "0" +"Master Bedroom": "Double Vanity,Bath-Private,Separate Shower,Closet-Walk in,Floors - Carpet,Floors-Luxury Vinyl Plank" +"Energy": "Thermopane" +"Other Heated SqFt": "0" +"Listing Type Agreement": "Exclusive Right to Sell" +"Geo Subdivision": "SC" +"class_name": "RE_1" +"4th Bedroom": "Closet-Walk in,Floors - Carpet" +"Level-Bedroom 3": "Second" +"Level-Great Room": "Main" +"Level-Bedroom 4": "Second" +"Rollback Tax (Y/N)": "No" +"IDX Include": "Yes" +"Level-Bedroom 2": "Second" +"List Price Tot SqFt": "149.49" +"LA1Agent Middle Initial": "M" +"Full Baths-2nd": "2" +"Level-Other Room": "Second" +"Elementary School": "Congaree" +"Publish to Internet Y/N": "Yes" +"First Photo Add Timestamp": "2025-04-02T19:28:22.3" +"Garage": "Garage Attached, Front Entry" +"LA1Agent Last Name": "Gould" +"Assn/Regime Fee Per": "6 Months" +"Full Baths- Lower": "0" +"TMS": "008902-01-056" +"Geo Update Timestamp": "2025-04-02T19:28:20.9" +"Other Rooms": "Loft" +"MlsAreaMajor": "Cayce/West Cola/Airport/S. Congaree" +"Media": array:24 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6054990" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/ed3e30d4286a4f1e0c2ef7677c1c0316.webp" "MediaSize" => 354947 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-ed3e30d4286a4f1e0c2ef7677c1c0316.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "6054991" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/2ed1ef690a38f1cf4437ebcba16bf078.webp" "MediaSize" => 99568 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-2ed1ef690a38f1cf4437ebcba16bf078.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "6054992" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/b5b2d275ec78d7e601157ce4806eaa04.webp" "MediaSize" => 117957 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-b5b2d275ec78d7e601157ce4806eaa04.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "6054993" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/5a8441a19ed2622d3d357abce181324f.webp" "MediaSize" => 51737 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-5a8441a19ed2622d3d357abce181324f.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "6054994" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/7c636d2de0261f0da2dccd3d4b02d732.webp" "MediaSize" => 302786 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-7c636d2de0261f0da2dccd3d4b02d732.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "6054995" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/ad6a5d6bf1b8dee46d9ae6378f4e415a.webp" "MediaSize" => 371921 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-ad6a5d6bf1b8dee46d9ae6378f4e415a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "6054996" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/d58cf37ad875867954ea1a6db11639fe.webp" "MediaSize" => 327530 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-d58cf37ad875867954ea1a6db11639fe.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "6054997" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/7b56a2ea1e9429dfed1099efbd5bd000.webp" "MediaSize" => 305892 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-7b56a2ea1e9429dfed1099efbd5bd000.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "6054998" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/98273a3d4060c57b32c07e1bdbaaa56e.webp" "MediaSize" => 377569 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-98273a3d4060c57b32c07e1bdbaaa56e.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "6054999" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/5d580ba93b404e7dd7842b3b62010245.webp" "MediaSize" => 302655 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-5d580ba93b404e7dd7842b3b62010245.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "60549910" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/aecc1dcc905addd0f14491c6053f8a5a.webp" "MediaSize" => 337276 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-aecc1dcc905addd0f14491c6053f8a5a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "60549911" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/3a2422917c629c4b71e0131aa703f4ab.webp" "MediaSize" => 368552 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-3a2422917c629c4b71e0131aa703f4ab.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "60549912" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/5da1ae2bc2112af29578e746dd1e7b0a.webp" "MediaSize" => 291549 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-5da1ae2bc2112af29578e746dd1e7b0a.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "60549913" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/678028bb94a3655c03b5d7d345963713.webp" "MediaSize" => 304455 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-678028bb94a3655c03b5d7d345963713.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "60549914" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/ce5a8ab52dfaeb8d3e3b8074ee079c18.webp" "MediaSize" => 348880 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-ce5a8ab52dfaeb8d3e3b8074ee079c18.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "60549915" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/1b078781f1dfd64a31c6881ef97af87f.webp" "MediaSize" => 300815 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-1b078781f1dfd64a31c6881ef97af87f.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "60549916" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/aec2edc6dcc33a6ef2ddb14af7f46437.webp" "MediaSize" => 231951 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-aec2edc6dcc33a6ef2ddb14af7f46437.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "60549917" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/4d1233c07b444128ac89c6186940a78c.webp" "MediaSize" => 278304 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-4d1233c07b444128ac89c6186940a78c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "60549918" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/cc0e71fc49c369f0e78a10a59d334522.webp" "MediaSize" => 350340 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-cc0e71fc49c369f0e78a10a59d334522.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "60549919" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/a1a2be89cd39a873f16c821a1f021465.webp" "MediaSize" => 371021 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-a1a2be89cd39a873f16c821a1f021465.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 20 => array:11 [ "Order" => 20 "MediaKey" => "60549920" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/45872e8ecf3b021a733ff4a4e38e4299.webp" "MediaSize" => 222835 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-45872e8ecf3b021a733ff4a4e38e4299.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 21 => array:11 [ "Order" => 21 "MediaKey" => "60549921" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/a12f4172eca3e4478e1db23ef2b3dd72.webp" "MediaSize" => 262906 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-a12f4172eca3e4478e1db23ef2b3dd72.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 22 => array:11 [ "Order" => 22 "MediaKey" => "60549922" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/4bbaa11cade8d3bf0922c612bf57b4bb.webp" "MediaSize" => 992881 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-4bbaa11cade8d3bf0922c612bf57b4bb.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] 23 => array:11 [ "Order" => 23 "MediaKey" => "60549923" "MediaURL" => "https://cdn.realtyfeed.com/cdn/121/605499/9776106a409e0d8aef7fbcee862ac24c.webp" "MediaSize" => 61212 "ResourceRecordKey" => "605499" "ResourceName" => "Property" "ClassName" => "Single Family" "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/121/605499/thumbnail-9776106a409e0d8aef7fbcee862ac24c.webp" "MediaCategory" => "Photo" "MediaObjectID" => "" ] ] +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('605499')" +"ID": "102048" } ] +success: true +page_size: 10 +page_count: 3 +count: 24 +after_key: "" } "RF Response Time" => "0.24 seconds" ] "RF Cache Key: f2d0057e22033ec2242883ebb91ea76003af925fd04899ed31b9cfa169d71c23" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3208 +items: array:4 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3218} 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3220} 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3217} 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3221} ] +success: true +page_size: 10 +page_count: 3 +count: 24 +after_key: "" } ] ]
