Difference between revisions of "Furniture/New Horizons/Bathroom"

From Nookipedia, the Animal Crossing wiki
(Converting furniture query to module)
 
(15 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{DISPLAYTITLE:List of bathroom-themed furniture in {{NH|short|nolink}}}}
 +
This is a list of '''bathroom-themed furniture''' in {{NH}}.
 +
__TOC__
 +
 
== Furniture ==
 
== Furniture ==
 
{{TableTop NH Furniture}}
 
{{TableTop NH Furniture}}
  
{{#cargo_query:
+
{{#invoke:NHFurnitureCargoQuery|main|limit=600|order by=nh_furniture.category_sort,nh_furniture.catalog_num|group by=nh_furniture.en_name|where=theme1{{=}}'Bathroom' OR theme2{{=}}'Bathroom'}}
table=nh_furniture,nh_furniture_variation
 
|join on=nh_furniture_variation.en_name = nh_furniture.en_name
 
|group by=nh_furniture.en_name
 
|fields=nh_furniture.en_name=name,nh_furniture_variation.image,nh_furniture.buy1_price=buy1-price,nh_furniture.buy1_wikitext=buy1,nh_furniture.sell,nh_furniture.availability1,nh_furniture.availability2,nh_furniture.theme1,nh_furniture.theme2,nh_furniture.function1,nh_furniture.function2,nh_furniture.customizable,nh_furniture.grid_size=gridsize
 
|where=theme1='Bathroom' OR theme2='Bathroom'
 
|order by=nh_furniture.en_name
 
|format=template
 
|template=BarLink
 
|named args=yes
 
|limit=600
 
}}
 
  
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
Line 23: Line 16:
 
table=nh_interior
 
table=nh_interior
 
|group by=nh_interior.en_name
 
|group by=nh_interior.en_name
|fields=en_name=name,image,buy1_price=buy1-price,buy1_wikitext=buy1,sell,availability1,availability2,color1,color2,theme1,theme2,grid_size=gridsize
+
|fields=en_name=name,catalog_num=catalog-num,image,buy1_price=buy1-price,buy1_wikitext=buy1,sell,availability1,availability2,color1,color2,theme1,theme2,grid_size=gridsize
 
|where=theme1='Bathroom' OR theme2='Bathroom'
 
|where=theme1='Bathroom' OR theme2='Bathroom'
|order by=nh_interior.en_name
+
|order by=nh_interior.category_sort,nh_interior.catalog_num
 
|format=template
 
|format=template
|template=BarLinkInterior
+
|template=CargoDisplayNHInterior
 
|named args=yes
 
|named args=yes
 
|limit=500
 
|limit=500
Line 35: Line 28:
  
 
<br>
 
<br>
{{Furniture}}
+
 
 +
== Former furniture/interior items ==
 +
The following furniture/interior items were formerly part of the Bathroom HHA theme.
 +
{{TableTop NH Furniture Themes|name=Furniture/interior items formerly classified as Bathroom|collapsed=yes}}
 +
{{#cargo_compound_query:
 +
tables=nh_furniture,nh_furniture_variation;
 +
join on=nh_furniture_variation.en_name = nh_furniture.en_name;
 +
group by=nh_furniture.en_name;
 +
fields=nh_furniture.en_name=name,nh_furniture._pageName=pagename,nh_furniture_variation.image,nh_furniture.theme1,nh_furniture.theme2,nh_furniture.former_theme1=former-theme1,nh_furniture.former_theme2=former-theme2;
 +
where=nh_furniture.former_theme1 IS NOT NULL AND (nh_furniture.former_theme1 = "Bathroom" OR nh_furniture.former_theme2 = "Bathroom");
 +
limit=600
 +
|tables=nh_interior;
 +
group by=nh_interior.en_name;
 +
fields=nh_interior.en_name=name,nh_interior._pageName=pagename,nh_interior.image,nh_interior.theme1,nh_interior.theme2,nh_interior.former_theme1=former-theme1,nh_interior.former_theme2=former-theme2;
 +
where=nh_interior.former_theme1 IS NOT NULL AND (nh_interior.former_theme1 = "Bathroom" OR nh_interior.former_theme2 = "Bathroom");
 +
limit=600
 +
|format=template
 +
|template=CargoDisplayNHHHAThemes
 +
|named args=yes
 +
}}
 +
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
 +
<br>
 +
 
 +
{{Navbox Furniture}}
 
[[Category:Lists of furniture]]
 
[[Category:Lists of furniture]]

Latest revision as of 20:03, February 26, 2024

This is a list of bathroom-themed furniture in Animal Crossing: New Horizons.

Furniture[edit]

Furniture in Animal Crossing: New Horizons

# Item Image Buy price Sell price Available from HHA theme(s) Interact Customizable Size
53 Aquarius urn Aquarius urn Not for sale  22,125 Bells  Crafting
Expensive / Bathroom - No 1.0×1.0
70 Automatic washer automatic washer  4,500 Bells  1,125 Bells  Nook's Cranny (upgraded)
Bathroom - No 1.0×1.0
114 Bath stool bath stool  810 Bells  202 Bells  Nook's Cranny
 Paradise Planning office
Public bath / Bathroom Seating No 1.0×1.0
115 Bathroom sink bathroom sink  3,300 Bells  825 Bells  Nook's Cranny
Bathroom - No 1.0×1.0
129 Bidet bidet  1,800 Bells  450 Bells  Nook's Cranny (upgraded)
Bathroom Seating No 1.0×1.0
308 Claw-foot tub claw-foot tub  63,000 Bells  15,750 Bells  Nook's Cranny (upgraded)
Bathroom / Expensive - No 2.0×1.0
358 Cosmos shower cosmos shower Not for sale  3,050 Bells  Crafting
Bathroom / Fancy - No 1.0×1.0
419 Deluxe washer deluxe washer  76,000 Bells  19,000 Bells  Nook's Cranny (upgraded)
Bathroom - No 1.0×1.0
434 Digital scale digital scale  930 Bells  232 Bells  Nook's Cranny
Bathroom / Public bath - No 1.0×1.0
481 Drying rack drying rack  2,700 Bells  675 Bells  Nook's Cranny
Garden / Bathroom - No 2.0×1.0
522 Fancy bathroom vanity fancy bathroom vanity  96,000 Bells  24,000 Bells  Nook's Cranny
 Paradise Planning office
Bathroom / Expensive - No 2.0×1.0
718 Golden toilet golden toilet Not for sale  60,000 Bells  Crafting
Bathroom / Expensive Toilet No 1.0×1.0
945 Long bathtub long bathtub  7,800 Bells  1,950 Bells  Nook's Cranny (upgraded)
Bathroom - No 2.0×1.0
1,269 Plain sink plain sink Not for sale  2,270 Bells  Crafting
Bathroom - No 1.0×1.0
1,275 Plastic clothing organizer plastic clothing organizer  2,400 Bells  600 Bells  Nook's Cranny
 Paradise Planning office
Bathroom / Living room Wardrobe No 1.0×1.0
1,322 Powder-room booth powder-room booth  3,800 Bells  950 Bells  Nook's Cranny
 Paradise Planning office
Bathroom / Facility Dresser No 1.0×1.0
1,460 Sauna heater sauna heater Not for sale  3,510 Bells  Crafting
Bathroom / Public bath - No 1.0×1.0
1,523 Shower booth shower booth  110,000 Bells  27,500 Bells  Nook's Cranny (upgraded)
Bathroom / Fitness - No 1.5×1.5
1,545 Simple vanity simple vanity  1,500 Bells  375 Bells  Nook's Cranny
 Paradise Planning office
Bathroom / Facility Dresser No 1.0×1.0
1,623 Squat toilet squat toilet  1,500 Bells  375 Bells  Nook's Cranny
Harmonious / Bathroom - No 1.0×1.0
1,647 Standing toilet standing toilet  1,900 Bells  475 Bells  Nook's Cranny
Bathroom / Facility - No 1.0×1.0
1,720 Tankless toilet tankless toilet  4,100 Bells  1,025 Bells  Nook's Cranny (upgraded)
Bathroom Toilet No 1.0×1.0
1,726 Taurus bathtub Taurus bathtub Not for sale  12,350 Bells  Crafting
Bathroom / Expensive - No 2.0×1.0
1,764 Toilet toilet  4,400 Bells  1,100 Bells  Nook's Cranny (upgraded)
Bathroom / Facility toilet No 1.0×1.0
1,765 Toilet-cleaning set toilet-cleaning set  670 Bells  167 Bells  Nook's Cranny
Bathroom / Facility - No 1.0×1.0
1,909 Whirlpool bath whirlpool bath  130,000 Bells  32,500 Bells  Nook's Cranny (upgraded)
Bathroom / Expensive - No 2.0×2.0
113 Bath bucket bath bucket  170 Bells  42 Bells  Nook's Cranny
 Paradise Planning office
Public bath / Bathroom - No 1.0×1.0
448 Dispenser dispenser  310 Bells  77 Bells  Nook's Cranny
 Paradise Planning office
Bathroom / Public bath - No 1.0×1.0
1,121 Nook Inc. toilet paper Nook Inc. toilet paper  10 Nook Points  130 Bells  NookLink
Bathroom - No 1.0×1.0
1,146 Old-fashioned washtub old-fashioned washtub Not for sale  360 Bells  Crafting
Bathroom / Retro - No 1.0×1.0
1,373 Rattan towel basket rattan towel basket  1,800 Bells  450 Bells  Nook's Cranny (upgraded)
Bathroom / Resort - No 1.0×1.0
1,628 Stack of clothes stack of clothes  1,100 Bells  275 Bells  Nook's Cranny
 Paradise Planning office
Apparel shop / Bathroom - No 1.0×1.0
1,775 Toothbrush-and-cup set toothbrush-and-cup set  420 Bells  105 Bells  Nook's Cranny
 Paradise Planning office
Bathroom - No 1.0×1.0
1,785 Toy duck toy duck  320 Bells  80 Bells  Nook's Cranny
 Paradise Planning office
Public bath / Bathroom - No 1.0×1.0
117 Bathroom towel rack bathroom towel rack  1,400 Bells  350 Bells  Nook's Cranny
Bathroom / Public bath - No 1.0×1.0
1,524 Shower set shower set  1,800 Bells  450 Bells  Nook's Cranny (upgraded)
Bathroom / Public bath - No 1.0×1.5
Includes data sourced from the Data Spreadsheet for Animal Crossing New Horizons, compiled and edited by 6480, noizhub, Ricky, chaiinchomp, saberslime, robotic_scarab, mollumisc, sunmarsh, kyrokey, obstinateRixatrix, jackiwi, Zalex, SuperHamster, kait, hyuum, Azarro, Czarcasm, cinnamon_swirlix, astronomyfortwo, Welcius, glowtopia, BriKun, Alyrei, dodocodes.com, StevieCoops, sneeze, Shiny190, TwistedPeach, LavaToaster, capstone, vmario, rocklamp, Alexis, Aeon, and PanchamBro.

Interior[edit]

Interior in Animal Crossing: New Horizons

# Item Image Buy price Sell price Available from Colors HHA theme(s) Size
11 Aqua tile wall aqua tile wall  1,420 Bells  355 Bells  Nook's Cranny
Aqua
Aqua
Bathroom / Public bath -
28 Bathhouse wall bathhouse wall  3,000 Bells  750 Bells  Saharah's Co-Op
Aqua
Aqua
Bathroom / Public bath -
33 Beige Moroccan wall beige Moroccan wall  2,440 Bells  610 Bells  Nook's Cranny
Beige
Beige
Bathroom / Facility -
47 Black two-toned tile wall black two-toned tile wall  1,850 Bells  462 Bells  Nook's Cranny
Black
Black
Bathroom / Public bath -
69 Blue honeycomb-tile wall blue honeycomb-tile wall  1,680 Bells  420 Bells  Nook's Cranny
Blue
Blue
Bathroom / Public bath -
78 Blue Moroccan wall blue Moroccan wall  2,440 Bells  610 Bells  Nook's Cranny
Blue
White
Bathroom / Facility -
95 Blue tile wall blue tile wall  1,420 Bells  355 Bells  Nook's Cranny
Blue
Blue
Bathroom / Public bath -
96 Blue two-toned tile wall blue two-toned tile wall  1,850 Bells  462 Bells  Nook's Cranny
Blue
Blue
Bathroom / Public bath -
163 Colorful-tile wall colorful-tile wall  1,420 Bells  355 Bells  Nook's Cranny
Colorful
Colorful
Bathroom / Public bath -
270 Green honeycomb-tile wall green honeycomb-tile wall  1,680 Bells  420 Bells  Nook's Cranny
Green
Green
Bathroom / Public bath -
298 Honeycomb-tile wall honeycomb-tile wall  1,680 Bells  420 Bells  Nook's Cranny
Brown
Brown
Bathroom / Public bath -
377 Monochromatic-tile wall monochromatic-tile wall  1,420 Bells  355 Bells  Nook's Cranny
Gray
White
Bathroom / Public bath -
382 Mosaic-tile wall mosaic-tile wall  1,450 Bells  362 Bells  Nook's Cranny
Black
White
Bathroom / Public bath -
410 Olive Moroccan wall olive Moroccan wall  2,440 Bells  610 Bells  Nook's Cranny
Yellow
Yellow
Bathroom / Facility -
441 Peach two-toned tile wall peach two-toned tile wall  1,850 Bells  462 Bells  Nook's Cranny
Pink
Pink
Bathroom / Public bath -
476 Purple Moroccan wall purple Moroccan wall  2,440 Bells  610 Bells  Nook's Cranny
Purple
Purple
Bathroom / Facility -
517 Red two-toned tile wall red two-toned tile wall  1,850 Bells  462 Bells  Nook's Cranny
Red
Red
Bathroom / Public bath -
668 White honeycomb-tile wall white honeycomb-tile wall  1,680 Bells  420 Bells  Nook's Cranny
White
White
Bathroom / Public bath -
10 Aqua tile flooring aqua tile flooring  900 Bells  225 Bells  Nook's Cranny
Aqua
Aqua
Bathroom / Public bath -
15 Argyle tile flooring argyle tile flooring  1,750 Bells  437 Bells  Nook's Cranny
White
Beige
Bathroom / Public bath -
32 Beige Moroccan flooring beige Moroccan flooring  2,100 Bells  525 Bells  Nook's Cranny
Beige
White
Bathroom / Facility -
68 Blue honeycomb tile blue honeycomb tile  1,420 Bells  355 Bells  Nook's Cranny
Blue
Blue
Bathroom / Public bath -
76 Blue Moroccan flooring blue Moroccan flooring  2,100 Bells  525 Bells  Nook's Cranny
Blue
White
Bathroom / Facility -
79 Blue mosaic-tile flooring blue mosaic-tile flooring  900 Bells  225 Bells  Nook's Cranny
Blue
Blue
Bathroom / Public bath -
117 Brown honeycomb tile brown honeycomb tile  1,420 Bells  355 Bells  Nook's Cranny
Brown
Brown
Bathroom / Public bath -
159 Colorful mosaic-tile flooring colorful mosaic-tile flooring  900 Bells  225 Bells  Nook's Cranny
Colorful
White
Bathroom / Public bath -
223 Floral mosaic-tile flooring floral mosaic-tile flooring  1,080 Bells  270 Bells  Nook's Cranny
White
White
Bathroom / Public bath -
269 Green honeycomb tile green honeycomb tile  1,420 Bells  355 Bells  Nook's Cranny
Green
Green
Bathroom / Public bath -
409 Olive Moroccan flooring olive Moroccan flooring  2,100 Bells  525 Bells  Nook's Cranny
Yellow
Brown
Bathroom / Facility -
435 Patchwork-tile flooring patchwork-tile flooring  2,100 Bells  525 Bells  Nook's Cranny
White
White
Bathroom / Public bath -
475 Purple Moroccan flooring purple Moroccan flooring  2,100 Bells  525 Bells  Nook's Cranny
Purple
White
Bathroom / Facility -
667 White honeycomb tile white honeycomb tile  1,420 Bells  355 Bells  Nook's Cranny
White
White
Bathroom / Public bath -
671 White mosaic-tile flooring white mosaic-tile flooring  900 Bells  225 Bells  Nook's Cranny
White
White
Bathroom / Public bath -
312 Ivory simple bath mat ivory simple bath mat  1,000 Bells  250 Bells  Saharah
Beige
Beige
Bathroom / Public bath 2.0 x 1.0
571 Simple green bath mat simple green bath mat  1,000 Bells  250 Bells  Saharah
Green
Green
Bathroom / Public bath 2.0 x 1.0
579 Simple navy bath mat simple navy bath mat  1,000 Bells  250 Bells  Saharah
Gray
Gray
Bathroom / Public bath 2.0 x 1.0
580 Simple pink bath mat simple pink bath mat  1,000 Bells  250 Bells  Saharah
Pink
Pink
Bathroom / Public bath 2.0 x 1.0
Includes data sourced from the Data Spreadsheet for Animal Crossing New Horizons, compiled and edited by 6480, noizhub, Ricky, chaiinchomp, saberslime, robotic_scarab, mollumisc, sunmarsh, kyrokey, obstinateRixatrix, jackiwi, Zalex, SuperHamster, kait, hyuum, Azarro, Czarcasm, cinnamon_swirlix, astronomyfortwo, Welcius, glowtopia, BriKun, Alyrei, dodocodes.com, StevieCoops, sneeze, Shiny190, TwistedPeach, LavaToaster, capstone, vmario, rocklamp, Alexis, Aeon, and PanchamBro.


Former furniture/interior items[edit]

The following furniture/interior items were formerly part of the Bathroom HHA theme.

Furniture/interior items formerly classified as Bathroom in Animal Crossing: New Horizons

Item Image Former HHA theme(s) Current HHA theme(s)
Clothesline pole clothesline pole Bathroom Garden / City life
Cypress bathtub cypress bathtub Bathroom Public bath / Resort
Kettle bathtub kettle bathtub Harmonious / Bathroom Outdoors / Retro
Oil-barrel bathtub oil-barrel bathtub Bathroom Outdoors / Local
Portable toilet portable toilet Bathroom / Facility City life / Local
Includes data sourced from the Data Spreadsheet for Animal Crossing New Horizons, compiled and edited by 6480, noizhub, Ricky, chaiinchomp, saberslime, robotic_scarab, mollumisc, sunmarsh, kyrokey, obstinateRixatrix, jackiwi, Zalex, SuperHamster, kait, hyuum, Azarro, Czarcasm, cinnamon_swirlix, astronomyfortwo, Welcius, glowtopia, BriKun, Alyrei, dodocodes.com, StevieCoops, sneeze, Shiny190, TwistedPeach, LavaToaster, capstone, vmario, rocklamp, Alexis, Aeon, and PanchamBro.