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:44:18

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.6.51-cll-lve
            [server_version] => 50651
            [stat] => Uptime: 211843  Threads: 4  Questions: 64135447  Slow queries: 10  Opens: 137182  Flush tables: 10  Open tables: 2890  Queries per second avg: 302.749
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 460653
            [warning_count] => 0
        )

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

    [todayMysql] => 20230930
    [today] => 9/30/2023
    [today0] => 09/30/2023
    [todayDB] => 20230930104418
    [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: 211843  Threads: 4  Questions: 64135448  Slow queries: 10  Opens: 137182  Flush tables: 10  Open tables: 2890  Queries per second avg: 302.749
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 460654
            [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] => 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] => ZRf8AsnitHb-neEw8NIdqAAAAMw [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_STATUS] => 200 [UNIQUE_ID] => ZRf8AsnitHb-neEw8NIdqAAAAMw [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 [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] => 37598 [REDIRECT_URL] => /san-jose/Casa-de-Las-Piedras [REDIRECT_QUERY_STRING] => slug=Casa-de-Las-Piedras [SERVER_PROTOCOL] => HTTP/1.1 [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] => 1696070658.46 [REQUEST_TIME] => 1696070658 ) [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.

Rates

$750 - $1250 / night

7th night free!

$750 a night July 1 - October 1

*All Prices Subject to Change. Holiday Prices are Higher. Prices do not include Mexican taxes

Amenities

  • Air Conditioning
  • All bedrooms have flat screen TVís and phones
  • CD Player
  • Ceiling Fans
  • Fireplace (Gas)
  • Fundadores Beach Club is less than a 5 minute walk away
  • Gas BBQ
  • Gourmet Kitchen
  • Granite/Marble Countertops
  • Outdoor Bar (with granite countertops)
  • Satellite TV
  • Spa
  • Stereo
  • Swimming Pool (Outdoor)
  • View
  • Washer and Dryer
  • Wireless Internet

Sleeping Accomodations!

5 bedrooms.

  • 1 - King Suite (adjoing bathroom with jacuzzi)
  • 1 - King Suite (adjoing bathroom with jacuzzi tub)
  • 1 - Queen (adjoing bathroom)
  • 1 - Two Singles (adjoing bathroom)
  • 1 - Single Bed (adjoing bathroom)

Additional Information

Maximum # of guests: 10

Interior square footage: 5000
Exterior square footage: 3000
Total square footage: 8000