25 Las Colinas, Casa Esteban, San Jose Corridor, (MLS# 26-1316)

25 Las Colinas, Casa Esteban, San Jose Corridor,

$7,195,000

Property Type: Houses Bedrooms: 6 Square Footage: 13,011 Status: Active

Current Price: $7,195,000 List Date: 3/16/2026 Last Modified: 3/17/2026

Overview

Description

Las Colinas 25 is an exceptional six-bedroom estate with unobstructed views of the San Jose coastline stretching to Punta Gorda. Designed to embrace seamless indoor-outdoor living within Querencia, the home features expansive living areas that open onto a generous pool terrace--ideal for enjoying panoramic ocean views and year-round entertaining. In the main house, the living areas and the primary bedroom offer breathtaking views to the Sea of Cortez. Four spacious guest suites are privately situated in their own wing, offering comfort and independence, while a separate ground-level studio serves as the sixth bedroom, ideal for guests or staff. The property also includes three parking spaces and is just a short walk to the Querencia Beach Club.

Listing Details MLS# 26-1316

Address

Property Name: Casa Esteban
Street Number: 25
Street Name: Las Colinas

General Description

Construction: Completed
Price (USD): 7195000
Seller Financing Offered?: No
Financing: Cash/Efectivo
Total M2: 1209.22
Total SqFt: 13011.21
AC M2: 650.33
AC SqFt: 6997.55
Zone: San Jose Corridor
Decks/Patios M2: 88.54
Decks/Patios SqFt: 952.69
Area: SJD Corr-Inland
Lot M2: 2123.25
Community: Querencia-Inland
Subdivision: Section 1- Las Colinas
Total Bedrooms: 6
Full Baths: 6
1/2 Bath: Yes
Year Built: 2011
Furnished: Furnished
Primary View: Ocean
Secondary View: Ocean
Garage Stalls: 2
Mstr Plan Community: Yes

Location Taxes Legal

Tax ID Number: 401-024-001-001-025-001

Contract Data

Begin Date: 2026-03-14

Amenities

Fireplaces: Yes
Bar: Yes
BBQ Area: Yes
Deck: Yes
Fountain: Yes
Hot Tub/Jacuzzi: Yes
Maids Quarters: Yes
Patio: Yes
Pool: Yes
Pool Heater: Yes
Second Kitchen: Yes
Storage Area: Yes
Terrace: Yes
Water Feature: Yes

More Information

Appliances

Clothes Dryer: Electric
Oven: Electric
Range: Electric
Clothes Washer: Yes
Dishwasher: Yes
Disposal: Yes
Freezer: Yes
Microwave: Yes
Refrigerator: Yes
Cook Top: Yes
Ice Maker: Yes
Warming Drawer: Yes
Wine Fridge: Yes

Devices

Air Conditioning: Mini Splits
Water Heater: Tank
Water Purification: Yes

Title

Fideicomiso: Scotia

Connectivity

Internet: Satellite
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

Const.

Construction Type: Concrete / Cinder Block
Flooring Types: Marble

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; Fountain; Hot Tub/Jacuzzi; Maids Quarters; Patio; Pool; Pool Heater; Second Kitchen; 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; Dishwasher; Disposal; Freezer; Microwave; Refrigerator; Cook Top; Ice Maker; Warming Drawer; Wine Fridge Devices: Water Purification Road Type: Paved Electricity: CFE Water: Muni Sewage: Muni How To Show: Agent To Accompany; By Appointment Only

Last Updated: March - 17 - 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.

25 Las Colinas, Casa Esteban, San Jose Corridor, (MLS# 26-1316)