An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 9-30-2023 10:08:55

Array
(
    [_GET] => Array
        (
            [slug] => Casa-El-Encanto
        )

    [_POST] => Array
        (
        )

    [_COOKIE] => Array
        (
        )

    [_FILES] => Array
        (
        )

    [contact_email] => tgranzo@earthlink.net
    [debug] => 1
    [db] => mysqli Object
        (
            [affected_rows] => 0
            [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
            [client_version] => 50011
            [connect_errno] => 0
            [connect_error] => 
            [errno] => 0
            [error] => 
            [error_list] => Array
                (
                )

            [field_count] => 0
            [host_info] => p3plcpnl1131.prod.phx3.secureserver.net via TCP/IP
            [info] => 
            [insert_id] => 0
            [server_info] => 5.6.51-cll-lve
            [server_version] => 50651
            [stat] => Uptime: 209720  Threads: 4  Questions: 63906643  Slow queries: 10  Opens: 137153  Flush tables: 10  Open tables: 2873  Queries per second avg: 304.723
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 456360
            [warning_count] => 0
        )

    [_REQUEST] => Array
        (
            [slug] => Casa-El-Encanto
        )

    [todayMysql] => 20230930
    [today] => 9/30/2023
    [today0] => 09/30/2023
    [todayDB] => 20230930100855
    [sdbc] => mysqli Object
        (
            [affected_rows] => 0
            [client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
            [client_version] => 50011
            [connect_errno] => 0
            [connect_error] => 
            [errno] => 0
            [error] => 
            [error_list] => Array
                (
                )

            [field_count] => 1
            [host_info] => p3plcpnl1131.prod.phx3.secureserver.net via TCP/IP
            [info] => 
            [insert_id] => 0
            [server_info] => 5.6.51-cll-lve
            [server_version] => 50651
            [stat] => Uptime: 209720  Threads: 4  Questions: 63906644  Slow queries: 10  Opens: 137153  Flush tables: 10  Open tables: 2873  Queries per second avg: 304.723
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 456361
            [warning_count] => 0
        )

    [_SESSION] => Array
        (
        )

    [slug] => Yoga
    [pid] => 57
    [thisURL] => https://www.loscabosvacation.com/san-jose/detail.php?pid=57
    [showSlides] => 1
    [qry] => mysqli_result Object
        (
            [current_field] => 0
            [field_count] => 4
            [lengths] => Array
                (
                    [0] => 2
                    [1] => 4
                    [2] => 4
                    [3] => 0
                )

            [num_rows] => 15
            [type] => 0
        )

    [qry_total] => 15
    [rs] => Array
        (
            [id] => 30
            [name] => Yoga
            [slug] => Yoga
            [page_name] => 
        )

    [property_name] => Casa El Encanto
    [description] => 

 
In the exclusive gated community of La Caleta Palmilla, this 6,500 SF ocean front villa offers the ultimate in luxury accommodations. Upon entering the stunning villa, you are greeted with expansive ocean views. Located on the beach with it's own private cove, the grounds are lush and tropical. Enjoy a refreshing drink on one of the many terraces or decks as you take in scenic ocean views or cool off in the immense pool area, complete with 2 pools, a cascading waterfall, rock water slide and swim up palapa bar or relax in the private spa that overlooks the Sea of Cortez. 

The massive Main Room features a fully equipped gourmet kitchen complete with commercial grade oven and refrigerator, dining area and living room area complete with top of the line entertainment center inc. large screen plasma TV and ipod connector. There are 6 uniquely and impeccably appointed master bedrooms complete with it's own private bath, separately controlled a/c unit and ceiling fans. 

The services of our wonderful staff are included. Our own in-house private chef is available to cook your breakfasts and lunches. Our concierge is also onsite to make sure your every need is met whether it be setting up a tee time or dinner reservation or arranging spa services at the villa.

    [special_note] => 
Cook for breakfast & Lunch is included...
    [short_desc] => 
Casa El Encanto 6 Bedroom beach front Villa Located in La Caleta Palmilla
    [meta_title] => Casa El Encanto Palmilla La Caleta Beach Front Los Cabos Villa
    [meta_keys] => Casa El Encanto Palmilla La Caleta Beach Front Los Cabos Villa
    [meta_desc] => Casa El Encanto Palmilla La Caleta Beach Front Los Cabos Villa
    [show_avail] => 0
    [link] => 
    [calendar] => 0
    [no_beds] => 6
    [rating] => 4
    [sleeps] => 15
    [sqft_inside] => 6500
    [sqft_outside] => 0
    [low_rate] => 3300
    [high_rate] => 4200
    [rate_note] => 
1 – 4 guests:       $3,300/night
5 – 10 guests:     $3,850/night
11 – 14 guests:  $4,200/night
    [max_guests] => 
    [pageName] => detail.php
    [_SERVER] => Array
        (
            [LSPHP_ENABLE_USER_INI] => on
            [PATH] => /usr/local/bin:/usr/bin:/bin
            [TEMP] => /tmp
            [TMP] => /tmp
            [TMPDIR] => /tmp
            [PWD] => /
            [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
            [HTTP_ACCEPT_ENCODING] => br,gzip
            [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
            [HTTP_CONNECTION] => Keep-Alive
            [CONTENT_LENGTH] => 0
            [HTTP_HOST] => www.loscabosvacation.com
            [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
            [HTTP_X_HTTPS] => 1
            [REDIRECT_UNIQUE_ID] => ZRfzt8ldYMitNX7s95jIrAAAAIk
            [REDIRECT_SCRIPT_URL] => /san-jose/Casa-El-Encanto
            [REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Casa-El-Encanto
            [REDIRECT_USER_ID] => 7984084
            [REDIRECT_HTTPS] => on
            [REDIRECT_SSL_TLS_SNI] => www.loscabosvacation.com
            [REDIRECT_STATUS] => 200
            [UNIQUE_ID] => ZRfzt8ldYMitNX7s95jIrAAAAIk
            [SCRIPT_URL] => /san-jose/Casa-El-Encanto
            [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Casa-El-Encanto
            [USER_ID] => 7984084
            [HTTPS] => on
            [SSL_TLS_SNI] => www.loscabosvacation.com
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [SERVER_NAME] => www.loscabosvacation.com
            [SERVER_ADDR] => 50.63.7.156
            [SERVER_PORT] => 443
            [REMOTE_ADDR] => 44.197.111.121
            [DOCUMENT_ROOT] => /home/ald70w428ld7/public_html
            [REQUEST_SCHEME] => https
            [CONTEXT_PREFIX] => 
            [CONTEXT_DOCUMENT_ROOT] => /home/ald70w428ld7/public_html
            [SERVER_ADMIN] => webmaster@loscabosvacation.com
            [SCRIPT_FILENAME] => /home/ald70w428ld7/public_html/san-jose/detail.php
            [REMOTE_PORT] => 42628
            [REDIRECT_URL] => /san-jose/Casa-El-Encanto
            [REDIRECT_QUERY_STRING] => slug=Casa-El-Encanto
            [SERVER_PROTOCOL] => HTTP/1.1
            [REQUEST_METHOD] => GET
            [QUERY_STRING] => slug=Casa-El-Encanto
            [REQUEST_URI] => /san-jose/Casa-El-Encanto
            [SCRIPT_NAME] => /san-jose/detail.php
            [PHP_SELF] => /san-jose/detail.php
            [REQUEST_TIME_FLOAT] => 1696068535.12
            [REQUEST_TIME] => 1696068535
        )

    [myPath] => https://www.loscabosvacation.com/
    [feat_count] => 16
    [browser] => NA
    [i] => 15
    [cid] => 30
    [slides] => 
    [slidePath] => https://www.loscabosvacation.com/properties/slides/large/
    [thumbPath] => https://www.loscabosvacation.com/properties/slides/thumbs/
    [thumbs] => 
    [qryS] => mysqli_result Object
        (
            [current_field] => 0
            [field_count] => 3
            [lengths] => 
            [num_rows] => 42
            [type] => 0
        )

    [qryB_total] => 42
)

Casa El Encanto - 4