An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 4-20-2024 01:55:55

Array
(
    [_GET] => Array
        (
            [slug] => Casa-de-Las-Piedras
        )

    [_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: 736407  Threads: 6  Questions: 1465919  Slow queries: 1  Opens: 588  Open tables: 107  Queries per second avg: 1.990
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 451754
            [warning_count] => 0
        )

    [_REQUEST] => Array
        (
            [slug] => Casa-de-Las-Piedras
        )

    [todayMysql] => 20240420
    [today] => 4/20/2024
    [today0] => 04/20/2024
    [todayDB] => 20240420015555
    [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: 736407  Threads: 6  Questions: 1465919  Slow queries: 1  Opens: 588  Open tables: 107  Queries per second avg: 1.990
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 451755
            [warning_count] => 0
        )

    [_SESSION] => Array
        (
        )

    [slug] => Yoga
    [pid] => 2
    [thisURL] => https://www.loscabosvacation.com/san-jose/detail.php?pid=2
    [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 de Las Piedras
    [description] => 
This brand new 5 bedroom 5 1/2 bath 5000 sq. ft. villa with pool and spa is located just a few lots from the beach in the Fundadores section of Puerto Los Cabos. There are 4 master suites with adjoining bathrooms and a 5th small bedroom with adjoing bathroom for single adult or child. All master suite bedrooms have flat screen TV’s and phones. A spectacular stereo system with IPod docking stations plays differant music throughout the property. Kitchen boasts all granite counter tops GE Monogram Refrigerator, Freezer and Stove. The Fundadores Beach Club is just a short walk from this beautiful villa. There are 2 beautiful Golf Courses in the Puerto Los Cabos development with Greg Norman and Jack Nicklaus designs. this beautiful home is just 5-10 minutes from San Jose del Cabo.
    [special_note] => 
Please Click Here for Google Map


Click Here for You Tube Video!
    [short_desc] => 
This beautiful 5 bedroom 5 1/2 bath 5000 sq. ft. villa with pool and spa is located just a few lots from the beach and beach club in the Fundadores section of Puerto Los Cabos. 5 flat screen TV's, 3 bars, awesome stereo, great ocean, golf course views.
    [meta_title] => Casa de Las Piedras - Los Cabos Villas - Puerto Los Cabos - 5 Bedrooms
    [meta_keys] => los cabos villa, puerto los cabos vacation rental, san jose, 5 bedrooms
    [meta_desc] => Puerto Los Cabos Villa 5 bedroom 5-1/2 bath 5000 sq. ft. pool and spa
    [show_avail] => 1
    [link] => 
    [calendar] => 1
    [no_beds] => 5
    [rating] => 0
    [sleeps] => 10
    [sqft_inside] => 5000
    [sqft_outside] => 3000
    [low_rate] => 750
    [high_rate] => 1250
    [rate_note] => 
7th night free!
$750 a night July 1 - October 1
    [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_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
            [HTTP_X_HTTPS] => 1
            [REDIRECT_UNIQUE_ID] => ZiMgq_c7pUNGhgPJFq_AcAAAAig
            [REDIRECT_SCRIPT_URL] => /san-jose/Casa-de-Las-Piedras
            [REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Casa-de-Las-Piedras
            [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] => 2598221-556-3
            [REDIRECT_STATUS] => 200
            [UNIQUE_ID] => ZiMgq_c7pUNGhgPJFq_AcAAAAig
            [SCRIPT_URL] => /san-jose/Casa-de-Las-Piedras
            [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Casa-de-Las-Piedras
            [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] => 2598221-556-3
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [SERVER_NAME] => www.loscabosvacation.com
            [SERVER_ADDR] => 50.63.7.156
            [SERVER_PORT] => 443
            [REMOTE_ADDR] => 3.133.141.6
            [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] => 38570
            [REDIRECT_URL] => /san-jose/Casa-de-Las-Piedras
            [REDIRECT_QUERY_STRING] => slug=Casa-de-Las-Piedras
            [SERVER_PROTOCOL] => HTTP/2.0
            [REQUEST_METHOD] => GET
            [QUERY_STRING] => slug=Casa-de-Las-Piedras
            [REQUEST_URI] => /san-jose/Casa-de-Las-Piedras
            [SCRIPT_NAME] => /san-jose/detail.php
            [PHP_SELF] => /san-jose/detail.php
            [REQUEST_TIME_FLOAT] => 1713578155.84
            [REQUEST_TIME] => 1713578155
        )

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

    [qryB_total] => 31
)

Casa de Las Piedras

This brand new 5 bedroom 5 1/2 bath 5000 sq. ft. villa with pool and spa is located just a few lots from the beach in the Fundadores section of Puerto Los Cabos. There are 4 master suites with adjoining bathrooms and a 5th small bedroom with adjoing bathroom for single adult or child. All master suite bedrooms have flat screen TV’s and phones. A spectacular stereo system with IPod docking stations plays differant music throughout the property. Kitchen boasts all granite counter tops GE Monogram Refrigerator, Freezer and Stove. The Fundadores Beach Club is just a short walk from this beautiful villa. There are 2 beautiful Golf Courses in the Puerto Los Cabos development with Greg Norman and Jack Nicklaus designs. this beautiful home is just 5-10 minutes from San Jose del Cabo.