An error occurred in script '/home/ald70w428ld7/public_html/includes/detail_body2.php' on line 14:
Undefined variable: qryS_total
Date/Time: 3-28-2024 09:47:07

Array
(
    [_GET] => Array
        (
            [slug] => Villa-Stella-Maris
        )

    [_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: 1268318  Threads: 100  Questions: 155175913  Slow queries: 12  Opens: 380576  Open tables: 2534  Queries per second avg: 122.347
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 3462323
            [warning_count] => 0
        )

    [_REQUEST] => Array
        (
            [slug] => Villa-Stella-Maris
        )

    [todayMysql] => 20240328
    [today] => 3/28/2024
    [today0] => 03/28/2024
    [todayDB] => 20240328094707
    [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: 1268318  Threads: 100  Questions: 155175913  Slow queries: 12  Opens: 380576  Open tables: 2534  Queries per second avg: 122.347
            [sqlstate] => 00000
            [protocol_version] => 10
            [thread_id] => 3462324
            [warning_count] => 0
        )

    [_SESSION] => Array
        (
        )

    [slug] => Yoga
    [pid] => 31
    [thisURL] => https://www.loscabosvacation.com/san-jose/detail.php?pid=31
    [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] => Villa Stella Maris
    [description] => 

Villa Stella Maris sits high up in Palmilla Norte and overlooks the beautiful Sea of Cortez. This classically designed villa with pool and spa has 4 bedrooms with ocean views. This property is right next door to Villa Los Amigos and then Villa Amanecer so all 3 properties can make up a total of 13 bedrooms.

[special_note] =>

Special Discounts on Palmilla Golf are Avaiable!

Google Map Link Click Here!

[short_desc] =>

Villa Stela Maris is 6,000 feet of polished comfort, and steps from the beach and world-class golf. Stela Maris exemplifies what the good living of the exclusive Palmilla area is all about.

[meta_title] => Villa Stela Maris - Los Cabos Palmilla Villa - 4 bedrooms [meta_keys] => los cabos villas palmilla villas san jose del cabo vacation rental [meta_desc] => Los Cabos Palmilla Villa Stella Maris [show_avail] => 1 [link] => [calendar] => 1 [no_beds] => 4 [rating] => 3 [sleeps] => 12 [sqft_inside] => 0 [sqft_outside] => 0 [low_rate] => 880 [high_rate] => 1100 [rate_note] =>

Google Map Link Click Here!

[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/Villa-Stella-Maris [HTTP_USER_AGENT] => claudebot [HTTP_X_HTTPS] => 1 [REDIRECT_UNIQUE_ID] => ZgU8m7Csxs7fqfcdKkqx8QAA5xE [REDIRECT_SCRIPT_URL] => /san-jose/Villa-Stella-Maris [REDIRECT_SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Villa-Stella-Maris [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] => 3220910-298-3 [REDIRECT_STATUS] => 200 [UNIQUE_ID] => ZgU8m7Csxs7fqfcdKkqx8QAA5xE [SCRIPT_URL] => /san-jose/Villa-Stella-Maris [SCRIPT_URI] => https://www.loscabosvacation.com/san-jose/Villa-Stella-Maris [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] => 3220910-298-3 [SERVER_SIGNATURE] => [SERVER_SOFTWARE] => Apache [SERVER_NAME] => www.loscabosvacation.com [SERVER_ADDR] => 50.63.7.156 [SERVER_PORT] => 443 [REMOTE_ADDR] => 3.87.133.69 [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] => 36624 [REDIRECT_URL] => /san-jose/Villa-Stella-Maris [REDIRECT_QUERY_STRING] => slug=Villa-Stella-Maris [SERVER_PROTOCOL] => HTTP/2.0 [REQUEST_METHOD] => GET [QUERY_STRING] => slug=Villa-Stella-Maris [REQUEST_URI] => /san-jose/Villa-Stella-Maris [SCRIPT_NAME] => /san-jose/detail.php [PHP_SELF] => /san-jose/detail.php [REQUEST_TIME_FLOAT] => 1711619227.8 [REQUEST_TIME] => 1711619227 ) [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] => 28 [type] => 0 ) [qryB_total] => 28 )

Villa Stella Maris - 3

Villa Stella Maris sits high up in Palmilla Norte and overlooks the beautiful Sea of Cortez. This classically designed villa with pool and spa has 4 bedrooms with ocean views. This property is right next door to Villa Los Amigos and then Villa Amanecer so all 3 properties can make up a total of 13 bedrooms.

Rates

$880 - $1100 / night

Google Map Link Click Here!

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

Special Discounts on Palmilla Golf are Avaiable!

Google Map Link Click Here!

Amenities

  • 3 Levels
  • Air Conditioning
  • CD Player
  • Ceiling Fans
  • DVD Player
  • Gas BBQ
  • Jacuzzi (outdoor)
  • Ocean View
  • Satellite TV
  • Stereo
  • Swimming Pool (Outdoor)
  • Washer and Dryer
  • Wireless Internet

Sleeping Accomodations!

4 bedrooms.

  • King Suite (upstairs master)
  • 2 singles (upstairs)
  • 2 doubles
  • Double & Single
  • Queen (in foyer)

Additional Information

Maximum # of guests: 12