Outdoor & Landscaping

These attributes describe parking, outdoor amenities, pools, and landscaping features.

Parking

parking_total_spaces

• Type: INT
• Description: Total number of parking spaces
• Example: 2
• Required: No
• Indexed: Yes
• Use Case: Primary filter for parking requirements

garage_spaces

• Type: INT
• Description: Number of garage parking spaces
• Example: 2
• Required: No

garage_type

• Type: VARCHAR(50)
• Description: Type of garage
• Values: "attached", "detached", "carport", "none"
• Example: "attached"
• Required: No

garage_door_type

• Type: VARCHAR(50)
• Description: Type of garage door
• Values: "automatic", "manual", "roll_up"
• Example: "automatic"
• Required: No

has_automatic_garage_doors

• Type: BOOLEAN
• Description: Whether garage has automatic door openers
• Example: true
• Required: No

has_heated_garage

• Type: BOOLEAN
• Description: Whether garage is heated
• Example: true
• Required: No

has_workshop_space

• Type: BOOLEAN
• Description: Whether garage includes workshop space
• Example: true
• Required: No

driveway_spaces

• Type: INT
• Description: Number of driveway parking spaces
• Example: 2
• Required: No

driveway_material

• Type: VARCHAR(50)
• Description: Driveway surface material
• Values: "concrete", "asphalt", "gravel", "pavers"
• Example: "concrete"
• Required: No

has_circular_driveway

• Type: BOOLEAN
• Description: Whether property has circular driveway
• Example: false
• Required: No

has_gated_entry

• Type: BOOLEAN
• Description: Whether property has gated entry
• Example: true
• Required: No

Pools & Spas

has_pool

• Type: BOOLEAN
• Description: Whether property has a pool
• Example: true
• Required: No
• Indexed: Yes

pool_type

• Type: VARCHAR(50)
• Description: Type of pool
• Values: "in_ground", "above_ground", "indoor", "lap_pool"
• Example: "in_ground"
• Required: No

pool_size

• Type: VARCHAR(50)
• Description: Pool size description
• Example: "large", "olympic", "plunge"
• Required: No

has_spa

• Type: BOOLEAN
• Description: Whether property has spa/hot tub
• Example: true
• Required: No

has_hot_tub

• Type: BOOLEAN
• Description: Whether property has hot tub (separate from spa)
• Example: false
• Required: No

Outdoor Living Spaces

has_outdoor_kitchen

• Type: BOOLEAN
• Description: Whether property has outdoor kitchen
• Example: true
• Required: No

has_outdoor_fireplace

• Type: BOOLEAN
• Description: Whether property has outdoor fireplace
• Example: true
• Required: No

has_fire_pit

• Type: BOOLEAN
• Description: Whether property has fire pit
• Example: true
• Required: No

has_deck

• Type: BOOLEAN
• Description: Whether property has deck
• Example: true
• Required: No

has_patio

• Type: BOOLEAN
• Description: Whether property has patio
• Example: true
• Required: No

has_balcony

• Type: BOOLEAN
• Description: Whether property has balcony
• Example: true
• Required: No

has_porch

• Type: BOOLEAN
• Description: Whether property has porch
• Example: true
• Required: No

has_gazebo

• Type: BOOLEAN
• Description: Whether property has gazebo
• Example: false
• Required: No

has_pergola

• Type: BOOLEAN
• Description: Whether property has pergola
• Example: true
• Required: No

has_outdoor_shower

• Type: BOOLEAN
• Description: Whether property has outdoor shower
• Example: true
• Required: No

Landscaping

landscaping_level

• Type: VARCHAR(50)
• Description: Level of landscaping
• Values: "minimal", "moderate", "extensive", "professional"
• Example: "extensive"
• Required: No

has_irrigation_system

• Type: BOOLEAN
• Description: Whether property has irrigation/sprinkler system
• Example: true
• Required: No

has_sprinkler_system

• Type: BOOLEAN
• Description: Whether property has sprinkler system (may overlap with irrigation)
• Example: true
• Required: No

has_outdoor_lighting

• Type: BOOLEAN
• Description: Whether property has outdoor lighting
• Example: true
• Required: No

has_garden

• Type: BOOLEAN
• Description: Whether property has garden
• Example: true
• Required: No

has_vegetable_garden

• Type: BOOLEAN
• Description: Whether property has vegetable garden
• Example: true
• Required: No

has_fruit_trees

• Type: BOOLEAN
• Description: Whether property has fruit trees
• Example: true
• Required: No

has_mature_trees

• Type: BOOLEAN
• Description: Whether property has mature trees
• Example: true
• Required: No

has_privacy_fencing

• Type: BOOLEAN
• Description: Whether property has privacy fencing
• Example: true
• Required: No

fence_material

• Type: VARCHAR(50)
• Description: Fence material
• Values: "wood", "vinyl", "metal", "chain_link", "stone"
• Example: "wood"
• Required: No

Usage Examples

Find Properties with Pools

SELECT * FROM properties
WHERE has_pool = true
AND status = 'active'
ORDER BY price_current;

Properties with 2+ Parking Spaces

SELECT * FROM properties
WHERE parking_total_spaces >= 2
ORDER BY parking_total_spaces DESC;

Find Properties with Outdoor Kitchens

SELECT * FROM properties
WHERE has_outdoor_kitchen = true
OR has_outdoor_fireplace = true
OR has_fire_pit = true;

Properties with Extensive Landscaping

SELECT * FROM properties
WHERE landscaping_level = 'extensive'
AND has_irrigation_system = true;

Find Properties with Garages

SELECT * FROM properties
WHERE garage_spaces > 0
AND garage_type = 'attached'
ORDER BY garage_spaces DESC;

Best Practices

1. Always set parking_total_spaces: Critical filter for buyers
2. Distinguish garage vs driveway: Helps buyers understand parking options
3. Document outdoor features: Pools and outdoor spaces add significant value
4. Note landscaping level: Affects maintenance requirements
5. Track pool type: In-ground vs above-ground affects value differently

Related Attributes

• Dimensions - Lot size affecting outdoor space
• Waterfront & Views - Waterfront properties
• Luxury Features - High-end outdoor amenities