object(CI_DB_mysqli_result)#28 (8) { ["conn_id"]=> object(mysqli)#16 (19) { ["affected_rows"]=> int(1) ["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: 7076507 Threads: 1 Questions: 119749647 Slow queries: 0 Opens: 2210055 Flush tables: 1 Open tables: 2000 Queries per second avg: 16.922" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(4199729) ["warning_count"]=> int(0) } ["result_id"]=> object(mysqli_result)#27 (5) { ["current_field"]=> int(0) ["field_count"]=> int(50) ["lengths"]=> NULL ["num_rows"]=> int(1) ["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.

2 Listings match your search for Foxchase-On-Emerald-Lake neighborhood

Opelika, AL 36804

Neighborhood: Foxchase On Emerald Lake

School System: Northside Intermediate / Southview Primary

List Price: $644,999.00

Beds: 6 | Baths: 4

MLS #169132 | Residential Property For Sale