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: 8e9cd7c0d8f0b43ccd8f0627cc452f7416b54eb6cf2894a19fe2cb9e4a7cfc5b" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3757 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3210 +post_id: ? mixed +post_author: ? mixed +"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')" } ] +success: true +page_size: 10 +page_count: 4 +count: 31 +after_key: "" } ] ]
