multi-table lookup

TESTING VERSION 25 — PRODUCTION DEPLOY COMPLETE

Selected Models Data:
Array
(
)

multi-table lookup

October 25, 2026, 7:09 pm

NEW MT_MASTER_MODEL Lookup

Exact Matches

Brand	Model #	MODELID	MODELIDNEW	Lifecycle
Turbosound	NuQ152	P0B34	0312-ABW	Sales
Turbosound	NuQ152-AN	P0B3C	0312-ACE	Sales
Turbosound	NuQ152-AN-WH	P0B6T	0312-ADS	Sales
Turbosound	NuQ152-WH	P0B6U	0312-ADT	Sales
Turbosound	NuQ152-FY	P0BKT		Sales
Turbosound	NUQ152-AN-AL	NUQ152-A	NUQ152-A

Filter parts:

Parts Found for Version: P0B34

Master Num	Brand	Model	Search Item	Description	Qty	Web Price
10176	Turbosound	NuQ152	A05-B5V01-00102		0	$0.00
57969	Turbosound	NuQ152	-		0	$0.00
58569	Turbosound	NuQ152	FG38-00005-000	Pole Cups; 0312-AAW; Punching; Aluminium, ADC12; Black <hr> A65-00001-70370 - FG38-00005-000 <b><hr><b>Vendor Update 2026-05-02</b><br>	6	$28.00
66879	Turbosound	NuQ152	H76-00001-30403	Transducer Assemblies; Transducers, High Frequency; 1 in; 6 ohm; 160 W H76-00001-30403 - AA04-00090-000 66879	0	$121.99
71423	Turbosound	NuQ152	-		0	$0.00
79062	Turbosound	NuQ152	-	Plastic; Logos; 0302-ACK; Injection Molding; ABS; Natural G58-00001-46147 - FJ24-00048-000	1	$5.60
79681	Turbosound	NuQ152	-	Plastic; Handles; 0308-ABT; Injection Molding; ABS; Blue G53-00000-90220 - FJ15-00005-000	1	$5.60
81399	Turbosound	NuQ152	-		0	$0.00
84253	Turbosound	NuQ152	-		0	$0.00
97411	Turbosound	NuQ152	-		0	$20.97
98957	Turbosound	NuQ152	-	Metal; Brackets; 0308-AAA; Punching; Steel, SECC; Natural A65-00000-20078 - FG04-00341-000Metal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets; 0308-AAA; Punching; Steel, SECC; NaturalMetal; Brackets<hr><b>Vendor Update 2026-05-02</b><br>	0	$5.60
99014	Turbosound	NuQ152	-		0	$0.00
99018	Turbosound	NuQ152	-		0	$0.00
99041	Turbosound	NuQ152	-		0	$0.00
99042	Turbosound	NuQ152	-		0	$0.00
99043	Turbosound	NuQ152	-		0	$0.00
101762	Turbosound	NuQ152	-		0	$0.00
101763	Turbosound	NuQ152	-		0	$0.00