Back to Properties
Interested in this property?
CONTACT US

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: 4/06/2026

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.

More Information MLS# 26-1316

Address

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

General Description

Construction: Completed Current Price: $7,195,000 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: 1 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

Status Change Info

Status: Active

Amenities

Fireplaces: 1

Appliances

Clothes Dryer: Electric Oven: Electric Range: Electric

Devices

Air Conditioning: Mini Splits Water Heater: Tank

Title

Fideicomiso: Scotia

Connectivity

Internet: Satellite TV: Satellite

HOA Info

Dues Period: Year

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: April - 06 - 2026
25 Las Colinas, Casa Esteban, San Jose Corridor,- MLS# 26-1316
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.

Interested in this property?
CONTACT US

Contact agent

Upload Your Property

Contact
Listing

Upload Your Property

Contact
Listing