Mexico Luxury Real Estate

Las Colinas 42, Casa Celi, San Jose Corridor,

New Listing
$5,200,000
Property Type: Houses Bedrooms: 5 Square Footage: 4,953 Status: Active
Current Price: $5,200,000 List Date: 11/13/2026 Last Modified: 11/13/2026

Overview

Description

Situated along the hillside of Las Colinas, Casa Celi enjoys some of Querencia's most captivating views of the Sea of Cortez, overlooking the natural desert landscape, San José del Cabo Bay, and the city lights that illuminate the coastline. This five-bedroom, five-and-a-half-bathroom residence features traditional Mexican architecture with natural stone accents, wood-beamed ceilings and inviting indoor and outdoor living spaces. Expansive terraces, shaded seating areas, and an infinity-edge pool create the ideal setting to relax, entertain, and take in the panoramic ocean views. With approximately 4,600 square feet of air-conditioned living space, Casa Celi offers a comfortable retreat in one of Querencia's established hillside neighborhoods.

Listing Details MLS# 26-4827

Address

Property Name
Casa Celi
Street Name
Las Colinas 42

General Description

Construction
Completed
Price (USD)
5200000
Seller Financing Offered?
No
Financing
Cash/Efectivo
Total M2
460.29
Total SqFt
4952.72
AC M2
385.57
AC SqFt
4148.73
Zone
San Jose Corridor
Decks/Patios M2
176.76
Decks/Patios SqFt
1901.94
Area
SJD Corr-Inland
Lot M2
1409
Community
Querencia-Inland
Subdivision
Section 1- Las Colinas
Total Bedrooms
5
Full Baths
5
1/2 Bath
Yes
Year Built
2007
Furnished
Furnished
Primary View
Ocean
Secondary View
Ocean
Style
Two Story
Garage Stalls
3
Carport
Yes
Mstr Plan Community
Yes

Location Taxes Legal

Tax ID Number
401024001001-FII042

Contract Data

Begin Date
2026-11-13

Amenities

Fireplaces
Yes
Bar
Yes
BBQ Area
Yes
Deck
Yes
Fence / Wall
Yes
Fire Pit
Yes
Fountain
Yes
Hot Tub/Jacuzzi
Yes
Kitchen Nook
Yes
Palapa
Yes
Patio
Yes
Pergola
Yes
Pool
Yes
Pool Heater
Yes
Storage Area
Yes
Terrace
Yes
Water Feature
Yes

More Information

Appliances

Clothes Dryer
Gas
Oven
Gas
Range
Gas
Clothes Washer
Yes
Compactor
Yes
Dishwasher
Yes
Disposal
Yes
Freezer
Yes
Microwave
Yes
Refrigerator
Yes
Cook Top
Yes
Ice Maker
Yes
Wine Fridge
Yes

Devices

Air Conditioning
Central
Water Heater
Gas
Water Purification
Yes

Connectivity

Internet
Satellite
Telephone
1 line
TV
Satellite

HOA Info

Dues Period
Year

Road Type

Paved
Yes

Common Amenities

Tennis Court
Yes
Beach Club
Yes
Gym
Yes
Gated
Yes
Golf
Yes
Guarded
Yes
Handball/Paddleball
Yes
Kiddy Park
Yes
Picnic Area
Yes
Pool
Yes
Putting/Pitching
Yes
Restaurants/Bars
Yes
Spa
Yes

Title

Escritura
Yes

Const.

Construction Type
Concrete / Cinder Block
Flooring Types
Travertine

Electricity

CFE
Yes

Water

Muni
Yes

Sewage

Muni
Yes

How To Show

Agent To Accompany
Yes
By Appointment Only
Yes

Property Features

Amenities: Bar; BBQ Area; Deck; Fence / Wall; Fire Pit; Fountain; Hot Tub/Jacuzzi; Kitchen Nook; Palapa; Patio; Pergola; Pool; Pool Heater; Storage Area; Terrace; Water Feature Common Amenities: Beach Club; Gated; Golf; Guarded; Gym; Handball/Paddleball; Kiddy Park; Picnic Area; Pool; Putting/Pitching; Restaurants/Bars; Spa; Tennis Court Appliances: Clothes Washer; Compactor; Dishwasher; Disposal; Freezer; Microwave; Refrigerator; Cook Top; Ice Maker; Wine Fridge Devices: Water Purification Road Type: Paved Title: Escritura Electricity: CFE Water: Muni Sewage: Muni How To Show: Agent To Accompany; By Appointment Only
IDX
Source MLS Verified
Last Updated: November - 13 - 2026
All information is deemed reliable but not guaranteed. The listings on this site are displayed courtesy of the IDX program of MLS BCS and may not be the listings of the site owner.