object(CI_DB_mysqli_result)#28 (8) { ["conn_id"]=> object(mysqli)#16 (19) { ["affected_rows"]=> int(3) ["client_info"]=> string(79) "mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $" ["client_version"]=> int(50011) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(50) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(6) "5.7.44" ["server_version"]=> int(50744) ["stat"]=> string(150) "Uptime: 7319431 Threads: 1 Questions: 128431607 Slow queries: 0 Opens: 2281493 Flush tables: 1 Open tables: 2000 Queries per second avg: 17.546" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(4410261) ["warning_count"]=> int(0) } ["result_id"]=> object(mysqli_result)#27 (5) { ["current_field"]=> int(0) ["field_count"]=> int(50) ["lengths"]=> NULL ["num_rows"]=> int(3) ["type"]=> int(0) } ["result_array"]=> array(0) { } ["result_object"]=> array(0) { } ["custom_result_object"]=> array(0) { } ["current_row"]=> int(0) ["num_rows"]=> NULL ["row_data"]=> NULL } Berkshire Hathaway HomeServices Preferred Real Estate Auburn
filter_list map

We are currently experiencing technical difficulties with our MLS connection, which may impact search functionality. We apologize for any inconvenience and encourage you to check back later.

4 Listings match your search for The-Estates neighborhood

Opelika, AL 36804

Neighborhood: Southern Ridge Estates

School System: Beauregard Elementary

List Price: $545,000.00

Beds: 4 | Baths: 3

MLS #171303 | Residential Property For Sale

Opelika, AL 36801

Neighborhood: The Estates

School System: West Forest Intermediate / Carver Primary

List Price: $350,000.00

Beds: 3 | Baths: 2

MLS #169752 | Residential Property For Sale

Opelika, AL 36801

Neighborhood: The Estates

School System: West Forest Intermediate / Carver Primary

List Price: $375,000.00

Beds: 4 | Baths: 3

MLS #172473 | Residential Property For Sale