Difference between revisions of "Furniture/New Horizons/Construction site"

From Nookipedia, the Animal Crossing wiki
m (Text replacement - "|order by=nh_interior.category_sort,nh_interior.en_name" to "|order by=nh_interior.category_sort,nh_interior.catalog_num")
(Converting furniture query to module)
 
(5 intermediate revisions by 2 users not shown)
Line 6: Line 6:
 
{{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{{=}}'Construction site' OR theme2{{=}}'Construction site'}}
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._pageName=pagename,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='Construction Site' OR theme2='Construction Site'
 
|order by=nh_furniture.category_sort,nh_furniture.catalog_num
 
|format=template
 
|template=CargoDisplayNHFurniture
 
|named args=yes
 
|limit=600
 
}}
 
  
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
Line 27: 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='Construction Site' OR theme2='Construction Site'
+
|where=theme1='Construction site' OR theme2='Construction site'
 
|order by=nh_interior.category_sort,nh_interior.catalog_num
 
|order by=nh_interior.category_sort,nh_interior.catalog_num
 
|format=template
 
|format=template
Line 39: Line 28:
  
 
<br>
 
<br>
{{Furniture}}
+
{{Navbox Furniture}}
 
[[Category:Lists of furniture]]
 
[[Category:Lists of furniture]]

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

This is a list of construction site-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
188 Bulldozer bulldozer  39,000 Bells  9,750 Bells  Nook Shopping
 Paradise Planning office
Construction site - No 2.0×2.0
267 Cement mixer cement mixer  3,100 Bells  775 Bells  Nook's Cranny
 Paradise Planning office
Construction site - No 1.0×1.0
336 Cone cone  630 Bells  157 Bells  Nook's Cranny
Construction site / City life - No 1.0×1.0
337 Construction scaffolding construction scaffolding  5,800 Bells  1,450 Bells  Nook's Cranny
 Paradise Planning office
Construction site - No 2.0×1.0
338 Construction sign construction sign  1,000 Nook Miles  5,000 Bells  Nook Stop
Construction site / City life - No 1.0×1.0
511 Excavator excavator  69,000 Bells  17,250 Bells  Nook Shopping
 Paradise Planning office
Construction site - No 3.0×2.0
576 Floor sign floor sign  890 Bells  222 Bells  Nook's Cranny
Construction site / Facility - No 1.0×1.0
832 Iron frame iron frame Not for sale  15,000 Bells  Crafting
Workshop / Construction site - No 2.0×1.0
854 Jackhammer jackhammer  9,300 Bells  2,325 Bells  Nook's Cranny
 Paradise Planning office
Construction site / City life - No 1.0×1.0
970 Manhole cover manhole cover Not for sale  2,250 Bells  Crafting
City life / Construction site - No 1.0×1.0
1,020 Mining car mining car  3,800 Bells  950 Bells  Nook's Cranny
 Paradise Planning office
Construction site / Local - No 1.0×1.0
1,410 Robot arm robot arm  130,000 Bells  32,500 Bells  Nook's Cranny
 Paradise Planning office
Construction site / Sci-fi - No 2.0×1.0
1,442 Safety barrier safety barrier  1,400 Bells  350 Bells  Nook's Cranny
 Paradise Planning office
Construction site / City life - No 1.0×1.0
1,652 Steamroller steamroller  49,000 Bells  12,250 Bells  Nook Shopping
 Paradise Planning office
Construction site - No 3.0×2.0
1,655 Stepladder stepladder  1,100 Bells  275 Bells  Nook's Cranny
 Paradise Planning office
Supermarket / Construction site - No 1.0×1.0
1,805 Truck truck  120,000 Bells  30,000 Bells  Nook Shopping
 Paradise Planning office
Construction site / City life - No 3.0×2.0
1,941 Wooden box wooden box Not for sale  720 Bells  Crafting
Workshop / Construction site - No 1.0×1.0
270 Chainsaw chainsaw  3,100 Bells  775 Bells  Nook's Cranny
 Paradise Planning office
Construction site / Workshop - No 1.0×1.0
1,629 Stacked bags stacked bags  1,100 Bells  275 Bells  Nook's Cranny
 Paradise Planning office
Workshop / Construction site Seating No 1.0×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.

Interior[edit]

Interior in Animal Crossing: New Horizons

# Item Image Buy price Sell price Available from Colors HHA theme(s) Size
89 Blue shanty wall blue shanty wall  620 Bells  155 Bells  Nook's Cranny
Blue
Blue
Workshop / Construction site -
121 Brown shanty wall brown shanty wall  620 Bells  155 Bells  Nook's Cranny
Brown
Brown
Workshop / Construction site -
171 Construction-site wall construction-site wall  3,000 Bells  750 Bells  Saharah
Blue
Blue
Workshop / Construction site -
256 Gray shanty wall gray shanty wall  620 Bells  155 Bells  Nook's Cranny
Gray
Gray
Workshop / Construction site -
460 Pink shanty wall pink shanty wall  620 Bells  155 Bells  Nook's Cranny
Pink
Pink
Workshop / Construction site -
619 Steel-frame wall steel-frame wall Not for sale  6,000 Bells  Crafting
Red
Gray
Workshop / Construction site -
170 Construction-site flooring construction-site flooring  3,000 Bells  750 Bells  Saharah
Brown
White
Workshop / Construction site -
618 Steel flooring steel flooring Not for sale  5,250 Bells  Crafting
Gray
Gray
Workshop / Construction site -
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.