Sorting oddly named cells in Visual Basic. 4

[tjtindal]

I had to think for a minute as to what I was trying to say when I was writing the subject line, but hopefully this'll clear it up:

What's the easiest way to force sorting in a particular order when you have odd entries like this?

111ss
112ss
113ss
11ss <- this should be above 111ss
121ss
122ss
123ss
12ss <- this should be above 121ss

I know the quick answer: put a "0" zero in front of all the smaller numbers to equalize it. Unfortunately, that's just not an option because it's "11ss", not "011ss".

My only idea is to create another field in the db for sorting, a numerical field like 1, 2, 3, 4, etc. so it'll be forced to sort in that order, but the tricky part is not having to rewrite the entire table everytime sorting is changed for all the entries under the changed number. Like, if there's 500 entries, and I change number 5, I don't want to have to rewrite all the fields for 6-500. Know what I mean?

Does anyone have any thoughts as to another method of sorting?

 

[johnwm]

You could add another field that is padded with zeroes....

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[gmmastros]

In most popular databases, there are string manipulation functions that can be used to order data, and they don't always have to be returned. For example, if you are using Microsoft SQL Server, you could order your recordset like this....

Order By Right('0000000000' + Field, 10)

This will put 10 zero's in front of the field, take the right 10 characters, and then sort by that. The actual data will be unaffected, and you will get your correct sort order.

If you are using an Access database, this may or may not work. Someone with more experience in that database will correct me if I am wrong (and I won't get offended ).

Let us know if this works for you.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[BobRodes]

Interesting trick, George.

 

[gmmastros]

I'm glad you like it.

If you want to test this, pop open a query analyzer window and toss in this code.

Declare @Temp Table(Data VarChar(10))

Insert Into @Temp Values('111ss')
Insert Into @Temp Values('112ss')
Insert Into @Temp Values('113ss')
Insert Into @Temp Values('11ss')
Insert Into @Temp Values('121ss')
Insert Into @Temp Values('122ss')
Insert Into @Temp Values('123ss')
Insert Into @Temp Values('12ss')

Select 'Wrong Sort', * From @Temp ORder By Data

Select 'Right Sort', * From @Temp Order BY Right('0000000000' + Data, 10)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[BobRodes]

No, it makes complete sense. I just never thought of it before!

 

[tjtindal]

So this is my recordsource I'm using to call the Microsoft Access database:

.RecordSource = "SELECT * FROM Lots ORDER BY Lot"

...and based on the above information, I changed it to:

.RecordSource = "SELECT * FROM Lots ORDER BY Right('0000000000' + Lot,10)"

However, when I actually run the code, it returns an error stating that my SQL statement is invalid. Got any thoughts on how I can fix this problem?

 

[gmmastros]

Hmmm.... I have a similar sorting issue in an Access Database. I changed the table name and the field name (to correspond with my database), and ran the query directly in Access without any problems.

I've never used data bound controls, so unfortunately, I won't be able to help. I'm sure there are others around here that may be able to help a little better. Sorry.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Golom]

or an alternative

.RecordSource = "SELECT * FROM Lots ORDER BY Val(Lot), Lot"

 

[tjtindal]

.RecordSource = "SELECT * FROM Lots ORDER BY Val(Lot), Lot"

What is the Val(Lot) part supposed to do?

 

[bjd4jc]

You will want to change your query to use the ampersand and not the plus for Access. Could change the outcome of your order (but probably wont' fix your error).

SELECT * FROM Lots ORDER BY Right('0000000000' + Lot,10)

 

[tjtindal]

SELECT * FROM Lots ORDER BY Right('0000000000' & Lot,10)

The ampersand as opposed to the + sign works great, however, now my non-lot items aren't showing properly.

Like:

Lot 60 Quail Run
$100,000 Loan
Bemis Tree Farm

^ See, those are completely out of order.

12cp
13cp
112cp
113cp

^ However those are in perfect order.

...It'll just take me tweaking it a bit to get it right, but thanks for all of your help!

 

[Golom]

Val(Lot) just converts the string to a numeric, thus
[tt]
Lot Val(Lot)
111ss 111
112ss 112
113ss 113
11ss 11
[/tt]
evaluation stops when it hits a non-numeric character. Sorting is handled properly because it is done on the value of the numeric ... not on the left-to-right valuation of the digits in the number as it is in a string.

 

[SBerthold]

tjtindal, your sorting order seems to have changed:

111ss
112ss
113ss
11ss <- this should be above 111ss
121ss
122ss
123ss
12ss <- this should be above 121ss

which in this context meant to me:
11ss
111ss
112ss
113ss
12ss
121ss
122ss
123ss

but in your last post you would want:
11ss
12ss
111ss
112ss
113ss
121ss
122ss
123ss

so, is the last way correct?

 

[tjtindal]

Yes, the last way is correct. It's totally numerical.

 

[SBerthold]

Ok.

Just to mention, because I've seen it used in other recent threads:

You shouldn't really use the VAL() function on anything but strings which contain only numeric data, which is what it was intended for: For "properly" calculating numeric strings with-out having to worry what numeric type it needs to be converted to.

In the example above, considering the possible amount and types of Lots and how the names may be made, in all possible manners, if the condition(s) are right then the VAL() function would lead to items being not properly sorted, even if all names begin with digits and it is to be sorted numerically.

Just thought I'd mention this.

 

[Golom]

SammyB

Don't know that I can agree with that.

I'm not aware of any proclamation about what "VAL is intended for." I am however aware of how it works and that is that it converts strings to numeric values until it finds a non-numeric character.

Certainly it is true that "ABC123" wouldn't return anything useful from VAL (zero actually) but situations like this one where the numeric part always appears at the start of the string are quite legitimate places to use VAL.

Do you have a reference to a thread or threads that caution against using VAL in cases like these?

 

[strongm]

I'm with Golom

 

[tjtindal]

Okay, this is gonna be kinda long, but when I sort my database with this code:

SELECT * FROM Lots ORDER BY Right('0000000000' & Lot,10)

It returns data in this order. This is the "Lot" field values below in the order that they sort with the above code:

$100,000 Loan
$300,000 Loan
Shop < notice starting here it's ALL out of order
Dingo
Church
SS Ph1
SS Ph2
SS Ph3
Kamatsu
SS Land
Suite A
Suite B
Suite C
Suite D
Suite G
Suite H
Rock Vac
The Farm
Timeshare
Direct Buy
Ford 1 Ton
House Boat
Phase 7 CP
6708 Foxrun
Rayco Dozer
Rayco Dozer
Suite E & F
Hensley Land
Motel 6-Plex
Lot 2 Block 6
1999 Dodge Ram
2001 Dodge Ram
3 School Buses
3810 Snow Lane
7 Calais Court
Fusakawa Dozer
Kubota Backhoe
Kubota Tractor
Paron 50 Acres
14624 Robinwood
211 Cornerstone
4508 Pine Drive
5515 "G" Street
5520 "G" Street
FORCE Racetrack
1515 Aspen Acres
17498 Oak Forest
3515 Grable Lane
603 School Drive
Equipment (Misc)
Guns And Jewelry
Kobelco Trackhoe
Lot 60 Quail Run
1985 Phel Trailer
1996 Lexus ES 300
2615 Leslie Drive
2726 Leslie Drive
3121 Hilltop Road
3202 Hilltop Road
324 Hogcreek Road
3301 Hilltop Road
507 Prickett Road
6263 Cynamid Road
6325 Cynamid Road
Polaris 4-Wheeler
Quail Ridge Sewer
1000 Foxhunt Trail
1099 Foxhunt Trail
1999 Toyota Tacoma
2001 Jeep Cherokee
300 Richwood Drive
78 Pinedale Circle
Airport - 40 Acres
Lot 47 Oak Meadows
Proscapes Building
15203 Springer Road
1986 Mack Tow Truck
2001 Porsche Boxter
3014 Oakbrook Drive
3100 Oakbrook Drive
3100 Oakbrook Drive
3x Cabins (Choctaw)
Guard Shack Trailer
Vermeer Tub Grinder
12600 Southfork Road
1984 Mack Dump Truck
1998 Ford Expedition
234 Glenn Hills Road
3x Trailers - 16 ft.
4606 North Lake Road
Caterpillar D3 Dozer
CP Loan - Bob Fewell
CP Loan Phase 6 & 3B
Lake Norrell 7 Acres
Vimy Ridge 2.5 Acres
15620 Vimy Woods Road
221 Glenn Hills Drive
2496 Holly Ridge Cove
3024 Scott Salem Road
Doug and Cindys House
Mahindra Tractor 3510
Mahindra Tractor 4110
Nagano Mini Excavator
Nagano Mini Excavator
130 Indian Valley Cove
2002 Cadillac Escalade
GNB Complex (Complete)
Silver Springs Phase 1
12701 Hunters Hill Road
Cornerstone Development
Lazer and Manhole Tools
Farm: 20006 Undersprings
Hometex Development Loan
John Deere 310 E Backhoe
John Deere E 450 G Dozer
SSS Super Storage Senter
01 Cornerstone Development
02 Cornerstone Development
03 Cornerstone Development
04 Cornerstone Development
05 Cornerstone Development
06 Cornerstone Development
07 Cornerstone Development
7620 Ferndale Cutoff Road
08 Cornerstone Development
09 Cornerstone Development
A & W Loan - CTS Building
Cornerstone - Vacant Land
10 Cornerstone Development
11 Cornerstone Development
12 Cornerstone Development
13 Cornerstone Development
14 Cornerstone Development
165 Crooked Lane (Choctaw)
2x Kawasaki 220 4-Wheelers
Loftin Homes Workmans Comp
Silver Springs Subdivision
Choctaw Bay Resort (Duplex)
Cornerstone 5 Acres Tract 1
Cornerstone 5 Acres Tract 2
Silver Springs Country Club
GL Rental Property Insurance
Sewer Pumps for Alexander Mtn
Loftin Homes General Liability
1993 Riviera Cruise Party Barge
1998 Chevrolet Corvette (Black)
1999 Aztec 22 ft. Crow Ski Boat
Benton Equipment BEC (Property)
CP Skyline Phase & Aqu. of Land
Lowboy Trailer & 2 Box Trailers
Mini X - Mini Excavator - ME 15
2004 Chevrolet Suburban (Silver)
Silver Springs Phase 4, 5, 7 & 8
1982 Ford Rescue Unit (Ambulance)
Benton Equipment BEC (Equipment) [Key]
Emerald Mountain Land Development Loan
Benton Equipment BEC (Equipment) [US-1]
Benton Equipment BEC (Equipment) [US-2]
Benton Equipment BEC (Equipment) [CIT-1]
Benton Equipment BEC (Equipment) [CIT-2]
Benton Equipment BEC (Equipment) [CIT-3]
Benton Equipment BEC (Equipment) [GE Capital]
Benton Equipment BEC (Equipment) [Regions]
Benton Equipment BEC (Equipment) [Western-1]
Benton Equipment BEC (Equipment) [Western-2]
Farn Project Multipurpose Property Owners Improvement District No 12
Hurricane Lake Block 5-31 Lots - Land Loan
Hurricane Lake Block 5 - Development Loan
Benton Equipment BEC (Equipment) [Citicapital]
AHW 14 < and now it's in perfect order
AHW 19
BO 06
BO 09
BO 23
BO 26
BO 28
BO 33
BO 36
BO 37
BO 39
BO 40
02cp
03cp
04cp
05cp
06cp
07cp
08cp
09cp
10cp
11cp
13cp
14cp
15cp
16cp
17cp
19cp
20cp
21cp
22cp
24cp
26cp
27cp
28cp
31cp
32cp
33cp
34cp
35cp
37cp
38cp
39cp
40cp
41cp
42cp
45cp
46cp
47cp
48cp
49cp
50cp
51cp
52cp
53cp
54cp
55cp
56cp
58cp
59cp
60cp
61cp
62cp
63cp
64cp
65cp
66cp
67cp
73cp
74cp
75cp
76cp
77cp
78cp
79cp
80cp
81cp
82cp
83cp
84cp
95cp
96cp
111cp
112cp
113cp
114cp
115cp
116cp
119cp
120cp
121cp
122cp
123cp
124cp
125cp
126cp
127cp
128cp
129cp
130cp
131cp
132cp
133cp
134cp
135cp
136cp
137cp
138cp
139cp
140cp
141cp
142cp
143cp
144cp
145cp
146cp
147cp
148cp
149cp
150cp
151cp
152cp
153cp
154cp
155cp
156cp
157cp
158cp
159cp
160cp
161cp
162cp
163cp
164cp
165cp
166cp
167cp
168cp
169cp
170cp
171cp
173cp
174cp
175cp
180cp
181cp
182cp
183cp
184cp
185cp
186cp
187cp
DW 01
DW 03
DW 08
DW 09
DW 10
DW 12
DW 15
DW 16
DW 17
DW 19
DW 23
DW 44
DW 50
EW 13
EW 14
EW 17
EW 24
EW 28
EW 30
EW 31
02em
03em
04em
05em
06em
18em
19em
20em
22em
24em
30em
31em
32em
35em
37em
42em
43em
44em
45em
46em
Lot 06 (The Farm)
Lot 14 (The Farm)
Lot 18 (The Farm)
Lot 35 (The Farm)
01-04hl
01-11hl
01-19hl
02-04hl
02-19hl
02-24hl
03-14hl
03-19hl
04-03hl
04-12hl
04-14hl
04-19hl
04-21hl
04-23hl
05-12hl
05-14hl
06-09hl
6-13hl
07-02hl
07-03hl
07-10hl
07-18hl
08-03hl
08-07hl
8-13hl
08-18hl
09-03hl
09-18hl
12-12hl
12-15hl
12-16hl
13-05hl
14-05hl
15-05hl
15-12hl
16-02hl
16-05hl
17-02hl
17-05hl
22-02hl
PO 16
PO 17
PO 18
PO 19
PO 20
PO 22
PO 24
PO 25
PO 27
PO 28
PO 29
PO 30
PO 32
PO 38
PO 47
PO 48
QR 02
QR 03
QR 04
QR 05
QR 12
QR 18
QR 19
QR 23
QR 25
QR 26
QR 29
QR 30
QR 35
QR 36
QR 39
QR 45
QR 46
RT 03
RT 13
RT 23
RT 24
RT 31
RT 35
RT 39
RT 41
RT 42
RT 53
RT 56
RT 62
RT 64
RT 68
RT 69
RT 73
RT 74
RT 79
RT 81
RT 82
RT 87
RT 89
49ss
50ss
53ss
54ss
55ss
59ss
60ss
61ss
62ss
63ss
64ss
65ss
66ss
67ss
68ss
69ss
70ss
71ss
72ss
73ss
74ss
75ss
76ss
77ss
80ss
81ss
82ss
83ss
118ss
119ss
120ss
121ss
122ss
123ss
124ss
125ss
126ss
127ss
128ss
129ss
130ss
131ss
132ss
133ss
134ss
135ss
136ss
137ss
138ss
139ss
140ss
141ss
142ss
143ss
144ss
145ss
218ss
219ss
220ss
226ss
228ss
229ss
252ss
253ss
254ss
255ss
256ss
257ss
258ss
259ss
260ss
261ss
262ss
263ss
264ss
265ss
266ss
267ss
268ss
269ss
270ss
283ss
284ss
285ss
286ss
288ss
289ss
290ss
291ss
294ss
295ss
296ss
297ss
298ss
299ss
300ss
307ss
320ss
321ss
322ss
324ss
01sf
02sf
03sf
04sf
05sf
06sf
07sf
08sf
09sf
10sf
11sf
12sf
13sf
14sf
15sf
16sf
17sf
18sf
19sf
20sf
21sf
22sf
23sf
24sf
25sf
26sf
27sf
28sf
29sf
30sf
31sf
32sf
33sf
34sf
35sf
36sf
37sf
38sf
39sf
40sf
41sf
42sf
43sf
47sf
48sf
49sf
50sf
51sf
52sf
53sf
54sf
56sf
57sf
58sf
60sf
61sf
62sf
63sf
64sf
65sf
66sf
67sf
68sf
69sf
70sf
71sf
72sf
73sf
74sf
75sf
76sf
77sf
78sf
79sf
80sf
81sf
82sf
83sf
84sf
85sf
86sf
87sf
88sf
89sf
90sf
91sf
92sf
93sf
94sf
95sf
96sf
97sf
98sf
99sf
100sf
101sf
102sf
103sf
104sf
105sf
106sf
107sf
108sf
109sf
110sf
111sf
112sf
113sf
114sf
115sf
116sf
118sf
119sf
11Bsf
120sf
121sf
122sf
123sf
124sf
125sf
126sf
127sf
128sf
129sf
130sf
131sf
132sf
133sf
134sf
135sf
136sf
137sf
138sf
139sf
140sf
141sf
142sf
143sf
144sf
145sf
146sf
147sf
148sf
149sf
150sf
151sf
152sf
153sf
154sf
155sf
156sf
157sf
158sf
159sf
160sf
161sf
162sf
163sf
166sf
167sf
168sf
169sf
170sf
171sf
172sf
173sf
174sf
175sf
176sf
177sf
178sf
179sf
180sf
181sf
182sf
183sf
184sf
185sf
186sf
187sf
188sf
189sf
190sf
191sf
192sf
193sf
194sf
195sf
196sf
197sf
198sf
199sf
200sf
201sf
202sf
203sf
204sf
205sf
206sf
207sf
208sf
209sf
210sf
211sf
212sf
213sf
214sf
215sf
216sf
217sf
218sf
219sf
220sf
221sf
222sf
223sf
224sf
225sf
226sf
227sf
228sf
229sf
230sf
231sf
232sf
233sf
234sf
235sf
236sf
237sf
238sf
239sf
240sf
241sf
242sf
243sf
244sf
245sf
248sf
249sf
250sf
285sf
TM 70
TM 75
WB 50
WB 58
WB 69

Hope this is more than clear as mud! Got any ideas on how to properly sort the top part AND the bottom part?

 

[Golom]

Does this work?

Select Loc From myTable Order By VAL(Loc), Loc

Which produces

[tt]
Loc
$100,000 Loan
$300,000 Loan
A & W Loan - CTS Building
AHW 14 < and now it's in perfect order
AHW 19
Airport - 40 Acres
Benton Equipment BEC (Equipment) [CIT-1]
Benton Equipment BEC (Equipment) [CIT-2]
Benton Equipment BEC (Equipment) [CIT-3]
Benton Equipment BEC (Equipment) [Citicapital]
Benton Equipment BEC (Equipment) [GE Capital]
Benton Equipment BEC (Equipment) [Key]
Benton Equipment BEC (Equipment) [Regions]
Benton Equipment BEC (Equipment) [US-1]
Benton Equipment BEC (Equipment) [US-2]
Benton Equipment BEC (Equipment) [Western-1]
Benton Equipment BEC (Equipment) [Western-2]
Benton Equipment BEC (Property)
BO 06
BO 09
BO 23
BO 26
BO 28
BO 33
BO 36
BO 37
BO 39
BO 40
Caterpillar D3 Dozer
Choctaw Bay Resort (Duplex)
Church
Cornerstone - Vacant Land
Cornerstone 5 Acres Tract 1
Cornerstone 5 Acres Tract 2
Cornerstone Development
CP Loan - Bob Fewell
CP Loan Phase 6 & 3B
CP Skyline Phase & Aqu. of Land
Dingo
Direct Buy
Doug and Cindys House
DW 01
DW 03
DW 08
DW 09
DW 10
DW 12
DW 15
DW 16
DW 17
DW 19
DW 23
DW 44
DW 50
Emerald Mountain Land Development Loan
Equipment (Misc)
EW 13
EW 14
EW 17
EW 24
EW 28
EW 30
EW 31
Farm: 20006 Undersprings
Farn Project Multipurpose Property Owners Improve
FORCE Racetrack
Ford 1 Ton
Fusakawa Dozer
GL Rental Property Insurance
GNB Complex (Complete)
Guard Shack Trailer
Guns And Jewelry
Hensley Land
Hometex Development Loan
House Boat
Hurricane Lake Block 5 - Development Loan
Hurricane Lake Block 5-31 Lots - Land Loan
John Deere 310 E Backhoe
John Deere E 450 G Dozer
Kamatsu
Kobelco Trackhoe
Kubota Backhoe
Kubota Tractor
Lake Norrell 7 Acres
Lazer and Manhole Tools
Loftin Homes General Liability
Loftin Homes Workmans Comp
Lot 06 (The Farm)
Lot 14 (The Farm)
Lot 18 (The Farm)
Lot 2 Block 6
Lot 35 (The Farm)
Lot 47 Oak Meadows
Lot 60 Quail Run
Lowboy Trailer & 2 Box Trailers
Mahindra Tractor 3510
Mahindra Tractor 4110
Mini X - Mini Excavator - ME 15
Motel 6-Plex
Nagano Mini Excavator
Nagano Mini Excavator
Paron 50 Acres
Phase 7 CP
PO 16
PO 17
PO 18
PO 19
PO 20
PO 22
PO 24
PO 25
PO 27
PO 28
PO 29
PO 30
PO 32
PO 38
PO 47
PO 48
Polaris 4-Wheeler
Proscapes Building
QR 02
QR 03
QR 04
QR 05
QR 12
QR 18
QR 19
QR 23
QR 25
QR 26
QR 29
QR 30
QR 35
QR 36
QR 39
QR 45
QR 46
Quail Ridge Sewer
Rayco Dozer
Rayco Dozer
Rock Vac
RT 03
RT 13
RT 23
RT 24
RT 31
RT 35
RT 39
RT 41
RT 42
RT 53
RT 56
RT 62
RT 64
RT 68
RT 69
RT 73
RT 74
RT 79
RT 81
RT 82
RT 87
RT 89
Sewer Pumps for Alexander Mtn
Shop < notice starting here it's ALL out of order
Silver Springs Country Club
Silver Springs Phase 1
Silver Springs Phase 4, 5, 7 & 8
Silver Springs Subdivision
SS Land
SS Ph1
SS Ph2
SS Ph3
SSS Super Storage Senter
Suite A
Suite B
Suite C
Suite D
Suite E & F
Suite G
Suite H
The Farm
Timeshare
TM 70
TM 75
Vermeer Tub Grinder
Vimy Ridge 2.5 Acres
WB 50
WB 58
WB 69
01 Cornerstone Development
01-04hl
01-11hl
01-19hl
01sf
02 Cornerstone Development
02-04hl
02-19hl
02-24hl
02cp
02em
02sf
2x Kawasaki 220 4-Wheelers
03 Cornerstone Development
03-14hl
03-19hl
03cp
03em
03sf
3 School Buses
3x Cabins (Choctaw)
3x Trailers - 16 ft.
04 Cornerstone Development
04-03hl
04-12hl
04-14hl
04-19hl
04-21hl
04-23hl
04cp
04em
04sf
05 Cornerstone Development
05-12hl
05-14hl
05cp
05em
05sf
06 Cornerstone Development
06-09hl
06cp
06em
06sf
6-13hl
07 Cornerstone Development
07-02hl
07-03hl
07-10hl
07-18hl
07cp
07sf
7 Calais Court
08 Cornerstone Development
08-03hl
08-07hl
08-18hl
08cp
08sf
8-13hl
09 Cornerstone Development
09-03hl
09-18hl
09cp
09sf
10 Cornerstone Development
10cp
10sf
11 Cornerstone Development
11Bsf
11cp
11sf
12 Cornerstone Development
12-12hl
12-15hl
12-16hl
12sf
13 Cornerstone Development
13-05hl
13cp
13sf
14 Cornerstone Development
14-05hl
14cp
14sf
15-05hl
15-12hl
15cp
15sf
16-02hl
16-05hl
16cp
16sf
17-02hl
17-05hl
17cp
17sf
18em
18sf
19cp
19em
19sf
20cp
20em
20sf
21cp
21sf
22-02hl
22cp
22em
22sf
23sf
24cp
24em
24sf
25sf
26cp
26sf
27cp
27sf
28cp
28sf
29sf
30em
30sf
31cp
31em
31sf
32cp
32em
32sf
33cp
33sf
34cp
34sf
35cp
35em
35sf
36sf
37cp
37em
37sf
38cp
38sf
39cp
39sf
40cp
40sf
41cp
41sf
42cp
42em
42sf
43em
43sf
44em
45cp
45em
46cp
46em
47cp
47sf
48cp
48sf
49cp
49sf
49ss
50cp
50sf
50ss
51cp
51sf
52cp
52sf
53cp
53sf
53ss
54cp
54sf
54ss
55cp
55ss
56cp
56sf
57sf
58cp
58sf
59cp
59ss
60cp
60sf
60ss
61cp
61sf
61ss
62cp
62sf
62ss
63cp
63sf
63ss
64cp
64sf
64ss
65cp
65sf
65ss
66cp
66sf
66ss
67cp
67sf
67ss
68sf
68ss
69sf
69ss
70sf
70ss
71sf
71ss
72sf
72ss
73cp
73sf
73ss
74cp
74sf
74ss
75cp
75sf
75ss
76cp
76sf
76ss
77cp
77sf
77ss
78 Pinedale Circle
78cp
78sf
79cp
79sf
80cp
80sf
80ss
81cp
81sf
81ss
82cp
82sf
82ss
83cp
83sf
83ss
84cp
84sf
85sf
86sf
87sf
88sf
89sf
90sf
91sf
92sf
93sf
94sf
95cp
95sf
96cp
96sf
97sf
98sf
99sf
100sf
101sf
102sf
103sf
104sf
105sf
106sf
107sf
108sf
109sf
110sf
111cp
111sf
112cp
112sf
113cp
113sf
114cp
114sf
115cp
115sf
116cp
116sf
118sf
118ss
119cp
119sf
119ss
120cp
120sf
120ss
121cp
121sf
121ss
122cp
122sf
122ss
123cp
123sf
123ss
124cp
124sf
124ss
125cp
125sf
125ss
126cp
126sf
126ss
127cp
127sf
127ss
128cp
128sf
128ss
129cp
129sf
129ss
130 Indian Valley Cove
130cp
130sf
130ss
131cp
131sf
131ss
132cp
132sf
132ss
133cp
133sf
133ss
134cp
134sf
134ss
135cp
135sf
135ss
136cp
136sf
136ss
137cp
137sf
137ss
138cp
138sf
138ss
139cp
139sf
139ss
140cp
140sf
140ss
141cp
141sf
141ss
142cp
142sf
142ss
143cp
143sf
143ss
144cp
144sf
144ss
145cp
145sf
145ss
146cp
146sf
147cp
147sf
148cp
148sf
149cp
149sf
150cp
150sf
151cp
151sf
152cp
152sf
153cp
153sf
154cp
154sf
155cp
155sf
156cp
156sf
157cp
157sf
158cp
158sf
159cp
159sf
160cp
160sf
161cp
161sf
162cp
162sf
163cp
163sf
164cp
165 Crooked Lane (Choctaw)
165cp
166cp
166sf
167cp
167sf
168cp
168sf
169cp
169sf
170cp
170sf
171cp
171sf
172sf
173cp
173sf
174cp
174sf
175cp
175sf
176sf
177sf
178sf
179sf
180cp
180sf
181cp
181sf
182cp
182sf
183cp
183sf
184cp
184sf
185cp
185sf
186cp
186sf
187cp
187sf
188sf
189sf
190sf
191sf
192sf
193sf
194sf
195sf
196sf
197sf
198sf
199sf
200sf
201sf
202sf
203sf
204sf
205sf
206sf
207sf
208sf
209sf
210sf
211 Cornerstone
211sf
212sf
213sf
214sf
215sf
216sf
217sf
218sf
218ss
219sf
219ss
220sf
220ss
221 Glenn Hills Drive
221sf
222sf
223sf
224sf
225sf
226sf
226ss
227sf
228sf
228ss
229sf
229ss
230sf
231sf
232sf
233sf
234 Glenn Hills Road
234sf
235sf
236sf
237sf
238sf
239sf
240sf
241sf
242sf
243sf
244sf
245sf
248sf
249sf
250sf
252ss
253ss
254ss
255ss
256ss
257ss
258ss
259ss
260ss
261ss
262ss
263ss
264ss
265ss
266ss
267ss
268ss
269ss
270ss
283ss
284ss
285sf
285ss
286ss
288ss
289ss
290ss
291ss
294ss
295ss
296ss
297ss
298ss
299ss
300 Richwood Drive
300ss
307ss
320ss
321ss
322ss
324 Hogcreek Road
324ss
507 Prickett Road
603 School Drive
1000 Foxhunt Trail
1099 Foxhunt Trail
1515 Aspen Acres
1982 Ford Rescue Unit (Ambulance)
1984 Mack Dump Truck
1985 Phel Trailer
1986 Mack Tow Truck
1993 Riviera Cruise Party Barge
1996 Lexus ES 300
1998 Chevrolet Corvette (Black)
1998 Ford Expedition
1999 Aztec 22 ft. Crow Ski Boat
1999 Dodge Ram
1999 Toyota Tacoma
2001 Dodge Ram
2001 Jeep Cherokee
2001 Porsche Boxter
2002 Cadillac Escalade
2004 Chevrolet Suburban (Silver)
2496 Holly Ridge Cove
2615 Leslie Drive
2726 Leslie Drive
3014 Oakbrook Drive
3024 Scott Salem Road
3100 Oakbrook Drive
3100 Oakbrook Drive
3121 Hilltop Road
3202 Hilltop Road
3301 Hilltop Road
3515 Grable Lane
3810 Snow Lane
4508 Pine Drive
4606 North Lake Road
"5515 ""G"" Street"
"5520 ""G"" Street"
6263 Cynamid Road
6325 Cynamid Road
6708 Foxrun
7620 Ferndale Cutoff Road
12600 Southfork Road
12701 Hunters Hill Road
14624 Robinwood
15203 Springer Road
15620 Vimy Woods Road
17498 Oak Forest
[/tt]