An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 4-18-2024 16:13:17

Array
(
    [_GET] => Array
        (
            [slug] => Casa-La-Laguna
        )

    [_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.5.5-10.6.16-MariaDB-cll-lve
            [server_version] => 50505
            [stat] => Uptime: 615049  Threads: 8  Questions: 1293382  Slow queries: 1  Opens: 586  Open tables: 107  Queries per second avg: 2.102
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 392403
            [warning_count] => 0
        )

    [_REQUEST] => Array
        (
            [slug] => Casa-La-Laguna
        )

    [todayMysql] => 20240418
    [today] => 4/18/2024
    [today0] => 04/18/2024
    [todayDB] => 20240418161317
    [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.5.5-10.6.16-MariaDB-cll-lve
            [server_version] => 50505
            [stat] => Uptime: 615049  Threads: 8  Questions: 1293382  Slow queries: 1  Opens: 586  Open tables: 107  Queries per second avg: 2.102
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 392404
            [warning_count] => 0
        )

    [_SESSION] => Array
        (
        )

    [slug] => Yoga
    [pid] => 12
    [thisURL] => https://www.loscabosvacation.com/san-jose/detail.php?pid=12
    [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 La Laguna
    [description] => 
Casa La Laguna sits on a quiet, pristine, semi-private beach, next to the Puerto Los Cabos Marina. This newly built, private compound commands expansive, unobstructed views from Punta Palmilla to Punta Gorda. It is wonderful for large family reunions, corporate retreats and couples gatherings. It features four levels with ocean view from every room in the house.

With an exquisite blend of Hacienda style and custom Balinese furnishings, this vacation home includes, 6 ocean view bedrooms, 6 full bathrooms and 2 half baths. There is over 10,000 square feet of living area, 8,000 square feet of which is air-conditioned. There is 16,000 square feet of outdoor space.

This indoor/outdoor design opens to the large outdoor deck area, perfect for entertaining and relaxing. Here you will enjoy the palapa bar and barbeque, with a two level heated infinity pool. The top level of the pool is walk-in "beach style", with a 12-foot slide to the ocean level pool, large enough for lap swimming. The 10 person Jacuzzi is also nestled in this scenic terrace directly above the beach.

The main living area includes a spacious living room, formal bar, spectacular kitchen, formal dining room with a spectacular, round table for 12, and three other dining areas, one of which is on a massive, partially covered, outdoor terrace. There is seating for eight, with dramatic beach and ocean views from here, complete with a unique fire bowl. There are several televisions throughout the home, including the 120-inch rear projection screen, in a comfortable media room. For the fitness enthusiasts, there is also a state of the art gym.
    [special_note] => 
•    Daily breakfast and lunch preparation by amazing gourmet Chef Angel (food is extra); valid through January 2, 2016: See attached menu
•    Dinner chef and in-villa butler (Butler from 2:00-10:00): $200 per day; valid through January 2, 2016: See attached menu
•    In-villa concierge services; valid through January 2, 2016
•    Access to In-Villa Spa: See attached Spa services

 
    [short_desc] => 
Casa La Laguna is a 6 bedroom villa that sits on a quiet, pristine, semi-private beach, north of the Puerto Los Cabos Marina.
    [meta_title] => Casa La Luguna Los Cabos Villas - San Jose Vacation Rental - 6 Bedrooms
    [meta_keys] => los cabos villa beach front vacation rental, san jose vacation rental, vacation rental, vacation house, 6 bedrooms
    [meta_desc] => Los Cabos Villas Casa La Laguna Vacation Rental
    [show_avail] => 0
    [link] => 
    [calendar] => 0
    [no_beds] => 6
    [rating] => 4
    [sleeps] => 0
    [sqft_inside] => 10000
    [sqft_outside] => 16000
    [low_rate] => 3600
    [high_rate] => 4400
    [rate_note] => 
·        •    1/3/15   - 6/1/15: $4,400/night
•    6/1/15   - 10/1/15: $3,600/night
•    10/1/15 – 11/23/15: $4,400/night
•    11/23/15 – 11/30/15 (Thanksgiving): $4,800/night (5 night minimum)
•    11/30/15 – 12/19/15: $4,400/night
•    
4 night minimum for all above periods, except: 11/23/15-11/30/15 (Thanksgiving: 5 night minimum) 
Event rates: available upon request


    [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] => */*
            [CONTENT_LENGTH] => 0
            [HTTP_HOST] => www.loscabosvacation.com
            [HTTP_REFERER] => http://www.loscabosvacation.com/san-jose/Casa-La-Laguna
            [HTTP_USER_AGENT] => claudebot
            [HTTP_X_HTTPS] => 1
            [REDIRECT_UNIQUE_ID] => ZiFGnfrkScOocB7lloRCywAA6gQ
            [REDIRECT_SCRIPT_URL] => /san-jose/Casa-La-Laguna
            [REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Casa-La-Laguna
            [REDIRECT_USER_ID] => 7984084
            [REDIRECT_HTTPS] => on
            [REDIRECT_SSL_TLS_SNI] => www.loscabosvacation.com
            [REDIRECT_HTTP2] => on
            [REDIRECT_H2PUSH] => off
            [REDIRECT_H2_PUSH] => off
            [REDIRECT_H2_PUSHED] => 
            [REDIRECT_H2_PUSHED_ON] => 
            [REDIRECT_H2_STREAM_ID] => 3
            [REDIRECT_H2_STREAM_TAG] => 527365-340-3
            [REDIRECT_STATUS] => 200
            [UNIQUE_ID] => ZiFGnfrkScOocB7lloRCywAA6gQ
            [SCRIPT_URL] => /san-jose/Casa-La-Laguna
            [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Casa-La-Laguna
            [USER_ID] => 7984084
            [HTTPS] => on
            [SSL_TLS_SNI] => www.loscabosvacation.com
            [HTTP2] => on
            [H2PUSH] => off
            [H2_PUSH] => off
            [H2_PUSHED] => 
            [H2_PUSHED_ON] => 
            [H2_STREAM_ID] => 3
            [H2_STREAM_TAG] => 527365-340-3
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [SERVER_NAME] => www.loscabosvacation.com
            [SERVER_ADDR] => 50.63.7.156
            [SERVER_PORT] => 443
            [REMOTE_ADDR] => 18.191.132.194
            [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] => 35357
            [REDIRECT_URL] => /san-jose/Casa-La-Laguna
            [REDIRECT_QUERY_STRING] => slug=Casa-La-Laguna
            [SERVER_PROTOCOL] => HTTP/2.0
            [REQUEST_METHOD] => GET
            [QUERY_STRING] => slug=Casa-La-Laguna
            [REQUEST_URI] => /san-jose/Casa-La-Laguna
            [SCRIPT_NAME] => /san-jose/detail.php
            [PHP_SELF] => /san-jose/detail.php
            [REQUEST_TIME_FLOAT] => 1713456797.61
            [REQUEST_TIME] => 1713456797
        )

    [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] => 30
            [type] => 0
        )

    [qryB_total] => 30
)

Casa La Laguna - 4

Casa La Laguna sits on a quiet, pristine, semi-private beach, next to the Puerto Los Cabos Marina. This newly built, private compound commands expansive, unobstructed views from Punta Palmilla to Punta Gorda. It is wonderful for large family reunions, corporate retreats and couples gatherings. It features four levels with ocean view from every room in the house.

With an exquisite blend of Hacienda style and custom Balinese furnishings, this vacation home includes, 6 ocean view bedrooms, 6 full bathrooms and 2 half baths. There is over 10,000 square feet of living area, 8,000 square feet of which is air-conditioned. There is 16,000 square feet of outdoor space.

This indoor/outdoor design opens to the large outdoor deck area, perfect for entertaining and relaxing. Here you will enjoy the palapa bar and barbeque, with a two level heated infinity pool. The top level of the pool is walk-in "beach style", with a 12-foot slide to the ocean level pool, large enough for lap swimming. The 10 person Jacuzzi is also nestled in this scenic terrace directly above the beach.

The main living area includes a spacious living room, formal bar, spectacular kitchen, formal dining room with a spectacular, round table for 12, and three other dining areas, one of which is on a massive, partially covered, outdoor terrace. There is seating for eight, with dramatic beach and ocean views from here, complete with a unique fire bowl. There are several televisions throughout the home, including the 120-inch rear projection screen, in a comfortable media room. For the fitness enthusiasts, there is also a state of the art gym.