all styles
1-newer - 243
1-older - 194
1788 - 1840 (built) - 7
1840 - 1890 (built) - 35
1890 - 1915 (built) - 46
1915 - 1940 (built) - 78
1940 - 1960 (built) - 44
1960 - 1990 (built) - 89
1990 - 2006 (built) - 117
architect - 123
asian / middle eastern - 2
bohemian / eclectic / funky - 47
brick house - 34
bush living - 31
corrugated iron - 7
country living - 30
european - 51
industrial - 27
mediterranean - 6
modernised heritage - 22
pacific / balinese - 9
regular homes - 52
rustic / derelict - 22
stately sized - 65
suburban family - 146
usa - 34
waterside living - 71
weatherboard / whitewash stone - 43
more styles
1-newer - 243
1-older - 194
1788 - 1840 (built) - 7
1840 - 1890 (built) - 35
1890 - 1915 (built) - 46
1915 - 1940 (built) - 78
1940 - 1960 (built) - 44
1960 - 1990 (built) - 89
1990 - 2006 (built) - 117
architect - 123
asian / middle eastern - 2
bohemian / eclectic / funky - 47
brick house - 34
bush living - 31
corrugated iron - 7
country living - 30
european - 51
industrial - 27
mediterranean - 6
modernised heritage - 22
pacific / balinese - 9
regular homes - 52
rustic / derelict - 22
stately sized - 65
suburban family - 146
usa - 34
waterside living - 71
weatherboard / whitewash stone - 43
all spaces
attic - 2
backyard - 161
bar / entertainment - 14
bathrooms - 40
bedrooms with ensuite - 195
cellar - 6
childrens rooms - 69
courtyard - 41
exterior - 70
garage / shed - 44
gardens - 43
hallways, stairs & entrance - 73
home cinema - 18
home gym - 14
home office - 59
kitchen - 300
laundry - 16
library - 5
living / tv / dining room - 378
roof terrace - 6
snooker room / interior sports - 39
spa / sauna - 11
stables / kennels / holdings - 16
studio / workspace - 10
swimming pool - 168
tennis court / sports - 24
verandah / balconies / deck - 236
viewing space - 6
wardrobe - 7
all types
beach / river houses - 30
converted warehouses - 21
farmhouses & fields - 32
historic mansions - 18
houses - 341
penthouses & apartments - 13
all proximities
SELECT COUNT(DISTINCT(tbllocation.locationID)) as total, tblproximity.proximityID,tblproximity.proximityName FROM tblproximity, tbllocation INNER JOIN tbl_loc_type ON tbl_loc_type.locationID = tbllocation. locationID INNER JOIN tbl_loc_style ON tbl_loc_style.locationID = tbllocation.locationID INNER JOIN tbl_loc_style1 ON tbl_loc_style1.locationID = tbllocation.locationID INNER JOIN tbl_loc_space ON tbl_loc_space.locationID = tbllocation.locationID INNER JOIN tbl_loc_prox ON tbl_loc_prox.locationID = tbllocation.locationID WHERE tbl_loc_style.styleID LIKE '%' AND tbl_loc_style1.styleID like '%' AND tbl_loc_type.typeID LIKE '%' AND tbl_loc_space.spaceID LIKE '%' AND tbl_loc_prox.proximityID = tblproximity.proximityID group by tblproximity.proximityID order by tblproximity.proximityID ASC
greater sydney - 410
1-3 hrs from sydney - 8
nsw - 4
upper northern suburbs - 2
keyword:
location code: