all styles
1-newer - 280
1-older - 210
1788 - 1840 (built) - 9
1840 - 1890 (built) - 36
1890 - 1915 (built) - 50
1915 - 1940 (built) - 85
1940 - 1960 (built) - 47
1960 - 1990 (built) - 92
1990 - 2006 (built) - 143
architect - 143
asian / middle eastern - 2
bohemian / eclectic / funky - 51
brick house - 44
bush living - 37
corrugated iron - 8
country living - 33
european - 52
industrial - 27
mediterranean - 7
modernised heritage - 23
pacific / balinese - 12
regular homes - 73
rustic / derelict - 25
stately sized - 72
suburban family - 184
usa - 34
waterside living - 75
weatherboard / whitewash stone - 53
more styles
1-newer - 280
1-older - 210
1788 - 1840 (built) - 9
1840 - 1890 (built) - 36
1890 - 1915 (built) - 50
1915 - 1940 (built) - 85
1940 - 1960 (built) - 47
1960 - 1990 (built) - 92
1990 - 2006 (built) - 143
architect - 143
asian / middle eastern - 2
bohemian / eclectic / funky - 51
brick house - 44
bush living - 37
corrugated iron - 8
country living - 33
european - 52
industrial - 27
mediterranean - 7
modernised heritage - 23
pacific / balinese - 12
regular homes - 73
rustic / derelict - 25
stately sized - 72
suburban family - 184
usa - 34
waterside living - 75
weatherboard / whitewash stone - 53
all spaces
attic - 2
backyard - 193
bar / entertainment - 16
bathrooms - 56
bedrooms with ensuite - 228
cellar - 6
childrens rooms - 91
courtyard - 44
exterior - 75
garage / shed - 51
gardens - 45
hallways, stairs & entrance - 83
home cinema - 20
home gym - 15
home office - 64
kitchen - 339
laundry - 20
library - 7
living / tv / dining room - 417
roof terrace - 6
snooker room / interior sports - 45
spa / sauna - 11
stables / kennels / holdings - 16
studio / workspace - 12
swimming pool - 189
tennis court / sports - 25
verandah / balconies / deck - 271
viewing space - 6
wardrobe - 8
all types
beach / river houses - 34
converted warehouses - 21
farmhouses & fields - 35
historic mansions - 20
houses - 380
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 - 449
1-3 hrs from sydney - 8
nsw - 4
upper northern suburbs - 2
keyword:
location code: