25-4540 – Ocean, Wind & Fire Residence B302

1 / 31

2 / 31

3 / 31

4 / 31

5 / 31

6 / 31

7 / 31

8 / 31

9 / 31

10 / 31

11 / 31

12 / 31

13 / 31

14 / 31

15 / 31

16 / 31

17 / 31

18 / 31

19 / 31

20 / 31

21 / 31

22 / 31

23 / 31

24 / 31

25 / 31

26 / 31

27 / 31

28 / 31

29 / 31

30 / 31

31 / 31

+22 photos

SJD Corr-Oceanside

Ocean, Wind & Fire Residence

$ 5,499,000 USD$ 104,481,000 MXN

3,236 sqft

REQUEST A TOUR

CONTACT AGENT

DESCRIPTION

Soar above it ALL in this forever Oceanview Residences in Querencia, offering panoramic Sea of Cortez views, exceptional sunrises, and a refined coastal lifestyle. Positioned on the third floor, one of the highest vantage points in the community, this residence delivers light-filled serenity, privacy with seamless indoor and outdoor living. This three-bedroom plus one bunkroom layout features floor-to-ceiling glass, a spacious terrace overlooking the vibrant Q Beach Club, built-in BBQ, upgraded lighting, two double-space parking spots, and a private owner’s lock-off. Footsteps from 3 dining options, Spa, Fitness facility and the warm golden sand, all is provided for. The home is offered fully furnished with a premium, high-quality decor package along with proven rental ROI potential.

LOCATION

Address:
Area: SJD Corr-Oceanside
ZIP:
Country: México
State:
City: San Jose Corridor

Open in Google Maps

General

Total sqft: 3,235.85sqft
Pet Friendly: Yes

Standard Fields

On market date: October 15, 2025 12:09 am
Property Name: Ocean, Wind & Fire Residence

Common Amenities

Beach Club: Yes
Gym: Yes
24 Hours Security: Yes

Development Information

Development Name: Section 28- Ocean Residences

Array
(
    [numberposts] => 3
    [post_type] => mexlife-properties
    [type] => Condos
    [meta_query] => Array
        (
            [relation] => AND
            [0] => Array
                (
                    [key] => listing_price
                    [value] => Array
                        (
                            [0] => 4399200
                            [1] => 6323850
                        )

                    [compare] => BETWEEN
                    [type] => NUMERIC
                )

            [1] => Array
                (
                    [key] => beds_total
                    [value] => 3
                    [compare] => >=
                )

        )

    [tax_query] => Array
        (
            [0] => Array
                (
                    [taxonomy] => area
                    [terms] => Array
                        (
                            [0] => 17834
                        )

                    [operator] => IN
                )

        )

)