$7,195,000
San Jose Corridor,
MLS# 26-1316
6 beds | 13011.21 sqft
1 / 16
Property 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.
Details
Maps
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: 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.