Rooms & Layout

These attributes describe the interior layout, room counts, and floor plan characteristics of a property.

Bedrooms

bedrooms_total

• Type: INT
• Description: Total number of bedrooms
• Example: 3
• Required: No
• Indexed: Yes
• Use Case: Primary filter for property searches

bedrooms_above_grade

• Type: INT
• Description: Number of bedrooms above ground level
• Example: 3
• Required: No

bedrooms_below_grade

• Type: INT
• Description: Number of bedrooms below ground level (basement bedrooms)
• Example: 0
• Required: No

Bathrooms

bathrooms_total

• Type: DOUBLE
• Description: Total number of bathrooms (can include half baths)
• Example: 2.5 (2 full + 1 half)
• Required: No
• Indexed: Yes
• Use Case: Primary filter for property searches

bathrooms_full

• Type: INT
• Description: Number of full bathrooms (toilet, sink, shower/tub)
• Example: 2
• Required: No

bathrooms_three_quarter

• Type: INT
• Description: Number of three-quarter bathrooms (toilet, sink, shower)
• Example: 1
• Required: No

bathrooms_half

• Type: INT
• Description: Number of half bathrooms/powder rooms (toilet, sink)
• Example: 1
• Required: No

bathrooms_one_quarter

• Type: INT
• Description: Number of quarter bathrooms (toilet only)
• Example: 0
• Required: No

Common Rooms

living_rooms

• Type: INT
• Description: Number of living rooms
• Example: 1
• Required: No

dining_rooms

• Type: INT
• Description: Number of formal dining rooms
• Example: 1
• Required: No

family_rooms

• Type: INT
• Description: Number of family rooms
• Example: 1
• Required: No

great_rooms

• Type: INT
• Description: Number of great rooms (combined living/dining)
• Example: 1
• Required: No

kitchens

• Type: INT
• Description: Number of kitchens
• Example: 1
• Required: No

Utility Rooms

pantries

• Type: INT
• Description: Number of pantries
• Example: 1
• Required: No

laundry_rooms

• Type: INT
• Description: Number of laundry rooms
• Example: 1
• Required: No

mudrooms

• Type: INT
• Description: Number of mudrooms
• Example: 1
• Required: No

Work & Study Spaces

offices

• Type: INT
• Description: Number of offices
• Example: 1
• Required: No

studies

• Type: INT
• Description: Number of studies
• Example: 1
• Required: No

libraries

• Type: INT
• Description: Number of libraries
• Example: 1
• Required: No

Recreation & Entertainment

bonus_rooms

• Type: INT
• Description: Number of bonus/flex rooms
• Example: 1
• Required: No

recreation_rooms

• Type: INT
• Description: Number of recreation rooms
• Example: 1
• Required: No

media_rooms

• Type: INT
• Description: Number of media/theater rooms
• Example: 1
• Required: No

home_theaters

• Type: INT
• Description: Number of dedicated home theaters
• Example: 1
• Required: No

exercise_rooms

• Type: INT
• Description: Number of exercise/fitness rooms
• Example: 1
• Required: No

game_rooms

• Type: INT
• Description: Number of game rooms
• Example: 1
• Required: No

workshops

• Type: INT
• Description: Number of workshops
• Example: 1
• Required: No

craft_rooms

• Type: INT
• Description: Number of craft rooms
• Example: 1
• Required: No

wine_cellars

• Type: INT
• Description: Number of wine cellars
• Example: 1
• Required: No

storage_rooms

• Type: INT
• Description: Number of storage rooms
• Example: 2
• Required: No

closets_walk_in

• Type: INT
• Description: Number of walk-in closets
• Example: 2
• Required: No

Structure

stories

• Type: DOUBLE
• Description: Number of stories/floors
• Example: 2.0, 1.5 (split-level)
• Required: No

levels_total

• Type: INT
• Description: Total number of levels
• Example: 2
• Required: No

levels_above_grade

• Type: INT
• Description: Number of levels above ground
• Example: 2
• Required: No

levels_below_grade

• Type: INT
• Description: Number of levels below ground
• Example: 1
• Required: No

basement_type

• Type: VARCHAR(50)
• Description: Type of basement
• Values: "full", "partial", "finished", "unfinished", "none"
• Example: "finished"
• Required: No

attic_type

• Type: VARCHAR(50)
• Description: Type of attic
• Values: "finished", "unfinished", "none", "loft"
• Example: "unfinished"
• Required: No

Usage Examples

Filter by Bedrooms and Bathrooms

SELECT * FROM properties
WHERE bedrooms_total >= 3
AND bathrooms_total >= 2
AND status = 'active'
ORDER BY price_current;

Find Properties with Home Offices

SELECT * FROM properties
WHERE offices > 0
OR studies > 0
ORDER BY offices DESC, studies DESC;

Count Total Rooms

SELECT
  id,
  bedrooms_total +
  bathrooms_total +
  living_rooms +
  dining_rooms +
  kitchens AS total_rooms
FROM properties
WHERE bedrooms_total IS NOT NULL;

Find Multi-Level Properties

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

Properties with Finished Basements

SELECT * FROM properties
WHERE basement_type = 'finished'
AND bedrooms_below_grade > 0;

Best Practices

1. Always set bedrooms_total and bathrooms_total: Primary search filters
2. Use decimal for bathrooms: Include half baths (e.g., 2.5)
3. Distinguish above/below grade: Important for basement bedrooms
4. Count all room types: Provides comprehensive property description
5. Set basement_type and attic_type: Helps buyers understand space

Related Attributes

• Dimensions - Area measurements for rooms
• Interior Features - Room finishes and features
• Construction Attributes - Building structure affecting layout