25 Las Colinas, Casa Esteban, San Jose Corridor,
New Listing
$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.