Excel Assignment 5
Eggert Realty/Eggert.xlsx
Documentation
| Eggert Realty | |
| Author | |
| Date | |
| Purpose | To retrieve home listings from homes in the New Braunfels area |
Home Listings
| Eggert Realty | ||
| Home Listings | ||
| Eggert Realty | ||
| Current Sales Prices for homes in New Braunfels | ||
| as of 3 | 15 | 2016 |
| Compiled by David Eggert | ||
| Listing ID | Price | Offer Pending |
| NB-5-205-88 | 372,800 | No |
| NB-1-189-57 | 420,800 | No |
| NB-3-181-44 | 390,000 | No |
| NB-3-225-95 | 371,000 | No |
| NB-5-213-88 | 342,800 | Yes |
| NB-3-152-67 | 350,000 | No |
| NB-1-139-60 | 463,000 | Yes |
| NB-2-125-54 | 430,000 | No |
| NB-3-104-72 | 381,000 | No |
| NB-5-170-54 | 372,000 | No |
| NB-2-158-25 | 422,800 | No |
| NB-2-153-72 | 403,000 | No |
| NB-5-184-26 | 401,000 | No |
| NB-2-275-40 | 402,000 | Yes |
| NB-3-171-20 | 364,400 | No |
| NB-2-112-74 | 381,000 | Yes |
| NB-5-219-84 | 373,000 | Yes |
| NB-1-110-43 | 372,000 | No |
| NB-4-176-58 | 365,800 | No |
| NB-5-161-95 | 345,200 | Yes |
| NB-1-109-89 | 401,000 | No |
| NB-1-217-30 | 373,000 | No |
| NB-4-183-78 | 361,000 | No |
| NB-4-299-24 | 328,000 | Yes |
| NB-5-174-64 | 320,000 | No |
| NB-4-266-51 | 516,000 | No |
| NB-3-184-92 | 316,000 | No |
| NB-4-228-90 | 459,000 | Yes |
| NB-2-176-71 | 356,000 | No |
| NB-5-102-49 | 308,000 | No |
| NB-5-124-15 | 414,000 | No |
| NB-4-162-12 | 620,000 | No |
| NB-4-140-13 | 332,000 | No |
| NB-3-230-47 | 345,000 | No |
| NB-1-183-18 | 387,800 | No |
| NB-1-231-14 | 364,000 | No |
| NB-3-108-77 | 324,000 | No |
| NB-3-161-78 | 568,800 | No |
| NB-3-101-96 | 339,800 | Yes |
| NB-1-233-59 | 512,000 | No |
| NB-2-172-11 | 489,800 | No |
| NB-2-252-30 | 560,000 | No |
| NB-1-219-61 | 630,000 | No |
| NB-2-222-44 | 351,000 | No |
| NB-1-113-84 | 599,800 | No |
| NB-3-109-16 | 580,000 | No |
| NB-5-294-14 | 475,000 | No |
| NB-3-199-22 | 630,000 | No |
| NB-5-135-62 | 350,000 | Yes |
| NB-1-162-38 | 351,800 | No |
| NB-1-100-28 | 374,000 | No |
| NB-3-105-87 | 371,000 | No |
| NB-3-139-24 | 630,000 | No |
| NB-1-127-70 | 475,000 | No |
| NB-5-212-99 | 462,000 | No |
| NB-5-253-54 | 450,000 | No |
| NB-1-190-56 | 477,800 | No |
| NB-4-113-35 | 461,000 | Yes |
| NB-2-158-64 | 554,000 | No |
| NB-2-114-81 | 716,000 | No |
| NB-5-122-62 | 490,000 | No |
| NB-4-222-84 | 378,000 | No |
| NB-2-293-35 | 323,800 | No |
| NB-3-140-29 | 460,000 | No |
| NB-1-111-44 | 367,000 | Yes |
| NB-3-221-72 | 399,000 | No |
| NB-1-144-57 | 610,000 | No |
| NB-3-219-82 | 395,000 | No |
| NB-5-180-25 | 385,000 | Yes |
| NB-1-247-47 | 410,000 | No |
| NB-2-265-99 | 334,000 | No |
| NB-5-125-37 | 447,000 | No |
| NB-1-179-97 | 395,000 | No |
| NB-1-231-60 | 384,400 | No |
| NB-3-246-72 | 447,800 | No |
| NB-3-186-82 | 440,000 | No |
| NB-3-217-21 | 359,800 | No |
| NB-3-148-39 | 450,000 | No |
| NB-5-136-62 | 422,000 | Yes |
| NB-1-228-87 | 399,000 | No |
| NB-2-128-28 | 340,000 | No |
| NB-4-181-18 | 346,000 | No |
| NB-1-141-91 | 338,000 | No |
| NB-5-279-63 | 431,000 | No |
| NB-5-294-43 | 380,000 | Yes |
| NB-4-112-21 | 372,000 | No |
| NB-5-281-83 | 425,000 | No |
| NB-5-196-63 | 427,800 | Yes |
| NB-2-300-70 | 392,000 | No |
| NB-1-229-27 | 450,000 | Yes |
| NB-2-210-93 | 434,000 | No |
| NB-5-156-49 | 519,800 | No |
| NB-1-262-88 | 345,800 | No |
| NB-1-149-39 | 420,000 | No |
| NB-4-122-63 | 391,000 | No |
| NB-4-287-16 | 386,800 | No |
| NB-2-256-15 | 334,000 | No |
| NB-5-218-37 | 379,800 | No |
| NB-3-265-38 | 342,000 | No |
| NB-4-139-23 | 436,000 | No |
| NB-1-279-81 | 375,200 | No |
| NB-4-239-45 | 470,000 | No |
| NB-4-179-27 | 346,200 | No |
| NB-2-226-89 | 354,600 | No |
| NB-3-103-12 | 450,000 | No |
| NB-5-265-28 | 459,800 | Yes |
| NB-2-196-48 | 416,000 | No |
| NB-2-244-53 | 539,000 | Yes |
| NB-3-251-19 | 510,600 | No |
| NB-5-236-48 | 404,000 | Yes |
| NB-2-292-70 | 345,000 | Yes |
| NB-4-176-82 | 409,800 | No |
| NB-3-113-19 | 344,000 | No |
| NB-4-147-30 | 370,000 | No |
| NB-2-251-56 | 349,800 | No |
| NB-5-207-43 | 344,000 | No |
| NB-5-100-89 | 404,000 | Yes |
Home Data
| Eggert Realty | ||||||
| Home Data | ||||||
| Eggert Realty | ||||||
| Summary of features for homes in New Braunfels | ||||||
| as of 3 | 15 | 2016 | ||||
| Compiled by David Eggert | ||||||
| Listing ID | Square Feet | Age | Features | NE Sector | Corner Lot | Annual Tax |
| NB-5-205-88 | 1,200 | 0 to 10 Years | 4 | No | No | 1,414 |
| NB-1-189-57 | 1,800 | 0 to 10 Years | 3 | No | No | 1,632 |
| NB-3-181-44 | 1,800 | 0 to 10 Years | 3 | No | No | 1,800 |
| NB-3-225-95 | 1,400 | 0 to 10 Years | 4 | No | No | 1,276 |
| NB-5-213-88 | 1,000 | 0 to 10 Years | 4 | No | No | 1,082 |
| NB-3-152-67 | 1,000 | 0 to 10 Years | 3 | No | No | 782 |
| NB-1-139-60 | 2,000 | 0 to 10 Years | 5 | No | Yes | 1,946 |
| NB-2-125-54 | 1,800 | 0 to 10 Years | 4 | No | No | 1,734 |
| NB-3-104-72 | 1,600 | 0 to 10 Years | 4 | No | No | 1,622 |
| NB-5-170-54 | 1,400 | 0 to 10 Years | 3 | No | No | 1,294 |
| NB-2-158-25 | 1,800 | 0 to 10 Years | 4 | No | No | 1,450 |
| NB-2-153-72 | 1,600 | 0 to 10 Years | 4 | No | No | 1,600 |
| NB-5-184-26 | 1,600 | 0 to 10 Years | 4 | No | No | 1,500 |
| NB-2-275-40 | 1,600 | 0 to 10 Years | 2 | No | No | 1,652 |
| NB-3-171-20 | 1,200 | 0 to 10 Years | 3 | No | No | 1,442 |
| NB-2-112-74 | 1,600 | 0 to 10 Years | 3 | No | Yes | 1,400 |
| NB-5-219-84 | 1,600 | 0 to 10 Years | 5 | No | No | 1,336 |
| NB-1-110-43 | 1,400 | 0 to 10 Years | 4 | No | No | 1,732 |
| NB-4-176-58 | 1,200 | 0 to 10 Years | 4 | No | No | 1,388 |
| NB-5-161-95 | 1,200 | 0 to 10 Years | 4 | No | No | 1,268 |
| NB-1-109-89 | 2,000 | 0 to 10 Years | 4 | No | No | 1,888 |
| NB-1-217-30 | 1,600 | 0 to 10 Years | 3 | No | No | 1,620 |
| NB-4-183-78 | 1,800 | 11 to 20 Years | 3 | No | No | 1,760 |
| NB-4-299-24 | 1,600 | 11 to 20 Years | 2 | No | No | 1,182 |
| NB-5-174-64 | 1,200 | 11 to 20 Years | 4 | No | No | 918 |
| NB-4-266-51 | 2,600 | 11 to 20 Years | 2 | No | Yes | 2,378 |
| NB-3-184-92 | 1,200 | 11 to 20 Years | 2 | No | No | 852 |
| NB-4-228-90 | 3,800 | 11 to 20 Years | 4 | No | Yes | 2,400 |
| NB-2-176-71 | 1,200 | More than 20 Years | 3 | No | Yes | 1,200 |
| NB-5-102-49 | 1,200 | More than 20 Years | 0 | No | No | 446 |
| NB-5-124-15 | 1,600 | More than 20 Years | 2 | No | No | 752 |
| NB-4-162-12 | 2,200 | More than 20 Years | 3 | No | Yes | 2,418 |
| NB-4-140-13 | 1,200 | More than 20 Years | 0 | No | No | 450 |
| NB-3-230-47 | 1,400 | More than 20 Years | 3 | No | No | 894 |
| NB-1-183-18 | 1,400 | More than 20 Years | 2 | No | No | 1,402 |
| NB-1-231-14 | 1,400 | More than 20 Years | 1 | No | No | 1,170 |
| NB-3-108-77 | 1,600 | More than 20 Years | 4 | No | No | 950 |
| NB-3-161-78 | 2,400 | More than 20 Years | 6 | No | Yes | 1,830 |
| NB-3-101-96 | 1,400 | More than 20 Years | 1 | No | Yes | 962 |
| NB-1-233-59 | 2,000 | 0 to 10 Years | 5 | Yes | Yes | 2,322 |
| NB-2-172-11 | 1,800 | 0 to 10 Years | 3 | Yes | Yes | 2,020 |
| NB-2-252-30 | 2,800 | 0 to 10 Years | 4 | Yes | No | 3,530 |
| NB-1-219-61 | 3,000 | 0 to 10 Years | 6 | Yes | Yes | 3,270 |
| NB-2-222-44 | 1,400 | 0 to 10 Years | 5 | Yes | No | 1,140 |
| NB-1-113-84 | 2,600 | 0 to 10 Years | 4 | Yes | Yes | 3,464 |
| NB-3-109-16 | 2,600 | 0 to 10 Years | 4 | Yes | No | 3,068 |
| NB-5-294-14 | 1,800 | 0 to 10 Years | 5 | Yes | No | 2,382 |
| NB-3-199-22 | 2,800 | 0 to 10 Years | 6 | Yes | Yes | 2,974 |
| NB-5-135-62 | 1,400 | 0 to 10 Years | 3 | Yes | No | 1,298 |
| NB-1-162-38 | 1,000 | 0 to 10 Years | 4 | Yes | No | 922 |
| NB-1-100-28 | 1,400 | 0 to 10 Years | 1 | Yes | No | 1,198 |
| NB-3-105-87 | 2,000 | 0 to 10 Years | 3 | Yes | No | 1,560 |
| NB-3-139-24 | 2,800 | 0 to 10 Years | 5 | Yes | Yes | 2,386 |
| NB-1-127-70 | 1,200 | 0 to 10 Years | 4 | Yes | No | 912 |
| NB-5-212-99 | 1,400 | 0 to 10 Years | 2 | Yes | No | 1,346 |
| NB-5-253-54 | 1,000 | 0 to 10 Years | 1 | Yes | No | 972 |
| NB-1-190-56 | 1,600 | 0 to 10 Years | 4 | Yes | No | 1,446 |
| NB-4-113-35 | 1,400 | 0 to 10 Years | 4 | Yes | No | 1,642 |
| NB-2-158-64 | 2,000 | 0 to 10 Years | 6 | Yes | No | 1,860 |
| NB-2-114-81 | 2,600 | 0 to 10 Years | 4 | Yes | Yes | 2,176 |
| NB-5-122-62 | 2,200 | 0 to 10 Years | 4 | Yes | No | 2,100 |
| NB-4-222-84 | 1,800 | 0 to 10 Years | 2 | Yes | No | 1,182 |
| NB-2-293-35 | 800 | 0 to 10 Years | 2 | Yes | No | 684 |
| NB-3-140-29 | 2,000 | 11 to 20 Years | 3 | Yes | Yes | 2,152 |
| NB-1-111-44 | 1,600 | 11 to 20 Years | 5 | Yes | No | 1,276 |
| NB-3-221-72 | 1,800 | 11 to 20 Years | 3 | Yes | No | 1,846 |
| NB-1-144-57 | 2,800 | 11 to 20 Years | 7 | Yes | Yes | 3,278 |
| NB-3-219-82 | 1,400 | 11 to 20 Years | 3 | Yes | No | 1,504 |
| NB-5-180-25 | 1,200 | 11 to 20 Years | 2 | Yes | No | 1,106 |
| NB-1-247-47 | 1,800 | 11 to 20 Years | 4 | Yes | No | 1,750 |
| NB-2-265-99 | 1,400 | 11 to 20 Years | 2 | Yes | No | 1,244 |
| NB-5-125-37 | 2,000 | 11 to 20 Years | 5 | Yes | Yes | 2,224 |
| NB-1-179-97 | 1,400 | 11 to 20 Years | 4 | Yes | No | 1,392 |
| NB-1-231-60 | 1,400 | 11 to 20 Years | 4 | Yes | No | 1,336 |
| NB-3-246-72 | 1,800 | 11 to 20 Years | 4 | Yes | No | 1,620 |
| NB-3-186-82 | 2,000 | 11 to 20 Years | 4 | Yes | No | 1,798 |
| NB-3-217-21 | 1,400 | 11 to 20 Years | 2 | Yes | No | 1,342 |
| NB-3-148-39 | 2,200 | 11 to 20 Years | 3 | Yes | No | 1,968 |
| NB-5-136-62 | 1,600 | 11 to 20 Years | 3 | Yes | No | 1,734 |
| NB-1-228-87 | 1,600 | 11 to 20 Years | 4 | Yes | No | 1,486 |
| NB-2-128-28 | 1,200 | 11 to 20 Years | 3 | Yes | No | 954 |
| NB-4-181-18 | 1,000 | 11 to 20 Years | 3 | Yes | No | 854 |
| NB-1-141-91 | 1,400 | 11 to 20 Years | 2 | Yes | Yes | 1,040 |
| NB-5-279-63 | 1,800 | 11 to 20 Years | 4 | Yes | No | 1,588 |
| NB-5-294-43 | 1,400 | 11 to 20 Years | 2 | Yes | No | 1,462 |
| NB-4-112-21 | 1,400 | 11 to 20 Years | 2 | Yes | No | 1,306 |
| NB-5-281-83 | 1,800 | 11 to 20 Years | 4 | Yes | Yes | 1,600 |
| NB-5-196-63 | 1,800 | 11 to 20 Years | 4 | Yes | No | 1,500 |
| NB-2-300-70 | 1,600 | 11 to 20 Years | 6 | Yes | No | 1,536 |
| NB-1-229-27 | 2,200 | 11 to 20 Years | 4 | Yes | No | 2,282 |
| NB-2-210-93 | 2,000 | 11 to 20 Years | 8 | Yes | Yes | 1,200 |
| NB-5-156-49 | 2,400 | 11 to 20 Years | 5 | Yes | Yes | 2,530 |
| NB-1-262-88 | 1,000 | 11 to 20 Years | 6 | Yes | No | 1,026 |
| NB-1-149-39 | 1,800 | 11 to 20 Years | 4 | Yes | No | 1,730 |
| NB-4-122-63 | 1,600 | 11 to 20 Years | 3 | Yes | Yes | 1,296 |
| NB-4-287-16 | 1,600 | 11 to 20 Years | 3 | Yes | No | 1,640 |
| NB-2-256-15 | 1,200 | More than 20 Years | 4 | Yes | No | 880 |
| NB-5-218-37 | 1,600 | More than 20 Years | 2 | Yes | Yes | 1,132 |
| NB-3-265-38 | 1,200 | More than 20 Years | 4 | Yes | No | 1,008 |
| NB-4-139-23 | 1,800 | More than 20 Years | 3 | Yes | No | 1,466 |
| NB-1-279-81 | 1,200 | More than 20 Years | 1 | Yes | No | 1,300 |
| NB-4-239-45 | 2,400 | More than 20 Years | 4 | Yes | Yes | 1,878 |
| NB-4-179-27 | 1,400 | More than 20 Years | 6 | Yes | No | 1,170 |
| NB-2-226-89 | 1,400 | More than 20 Years | 5 | Yes | No | 1,160 |
| NB-3-103-12 | 2,400 | More than 20 Years | 4 | Yes | Yes | 1,840 |
| NB-5-265-28 | 2,800 | More than 20 Years | 5 | Yes | Yes | 2,464 |
| NB-2-196-48 | 2,200 | More than 20 Years | 4 | Yes | No | 2,152 |
| NB-2-244-53 | 3,000 | More than 20 Years | 3 | Yes | No | 2,284 |
| NB-3-251-19 | 2,200 | More than 20 Years | 4 | Yes | No | 2,070 |
| NB-5-236-48 | 1,800 | More than 20 Years | 4 | Yes | No | 1,200 |
| NB-2-292-70 | 1,200 | More than 20 Years | 3 | Yes | No | 980 |
| NB-4-176-82 | 2,000 | More than 20 Years | 3 | Yes | No | 1,380 |
| NB-3-113-19 | 1,200 | More than 20 Years | 1 | Yes | No | 1,084 |
| NB-4-147-30 | 1,200 | More than 20 Years | 1 | Yes | No | 1,200 |
| NB-2-251-56 | 1,800 | More than 20 Years | 6 | Yes | No | 1,312 |
| NB-5-207-43 | 1,200 | More than 20 Years | 4 | Yes | No | 796 |
| NB-5-100-89 | 1,600 | More than 20 Years | 3 | Yes | No | 1,252 |
Housing Summary
| Eggert Realty |
| Housing Summary |
Tax Summary
| Sum of Annual Tax | Column Labels | |||
| Row Labels | 0 to 10 Years | 11 to 20 Years | More than 20 Years | Grand Total |
| 800 | 684 | 684 | ||
| 1,000 | 3,758 | 1,880 | 5,638 | |
| 1,200 | 6,424 | 3,830 | 9,344 | 19,598 |
| 1,400 | 10,926 | 10,626 | 6,758 | 28,310 |
| 1,600 | 12,176 | 10,150 | 4,086 | 26,412 |
| 1,800 | 12,200 | 13,394 | 3,978 | 29,572 |
| 2,000 | 9,576 | 7,374 | 1,380 | 18,330 |
| 2,200 | 2,100 | 4,250 | 6,640 | 12,990 |
| 2,400 | 2,530 | 5,548 | 8,078 | |
| 2,600 | 8,708 | 2,378 | 11,086 | |
| 2,800 | 8,890 | 3,278 | 2,464 | 14,632 |
| 3,000 | 3,270 | 2,284 | 5,554 | |
| 3,800 | 2,400 | 2,400 | ||
| Grand Total | 78,712 | 62,090 | 42,482 | 183,284 |
Eggert Realty/Eggert.xlsx Instuctions.docx
“Complete steps 1-3 & 5 of your Eggert Realty assignment. Using the imported data from the Home Data sheet create a pivot table on a new sheet (named Tax Summary). Use the Square Feet for the rows, the Age for the columns, and the Annual Tax for the value area. The tax should reflect the average tax, formatted as comma (,) format with zero decimal places. This will expose you to importing text files and some more practice with pivot tables.”
Eggert.xlsx
(Steps 1-8 have already been completed)
9. Place the PivotTable report in cell A4 of the Housing of Summary Worksheet
10. David wants to compare house prices based on the size of the house in square feet, its age, and its location. Place the square feet field from the Home Data table in the ROWS section of the table. Place the Age field in the COLUMNS section and the Price field in the VALUES section.
11. Change the value field settings of the price field to display the average price value in the PivotTable
12. In cell A5, change the Row Labels text square feet. In cell B4, change the Column Lables text to Age Category. In the cell A4, change the label Average Price. In cell E5 and cell A19, change the labels from Grand Total to Overall Average.
13. Format the PivotTable to make the content easy to read and understand.
14. Add a PivotTable slicer containing the NE sector field to range F4:J8
15. Create a Pivotchart of the PivotTable data using the Clustered bar chart type with the Age field as the legend category. Place the chart to cover the range F9:J19. Format the chart so that it is easy to read and interpret.
16. Save the workbook, and the close it.
Eggert Realty/Home Data.txt
| Eggert Realty | ||
| Summary of features for homes in New Braunfels | ||
| as of 3/15/2016 | ||
| Compiled by David Eggert | ||
| Listing ID/Square Feet/Age/Features/NE Sector/Corner Lot/Annual Tax | ||
| NB-5-205-88/1 | 200/0 to 10 Years/4/No/No/1 | 414 |
| NB-1-189-57/1 | 800/0 to 10 Years/3/No/No/1 | 632 |
| NB-3-181-44/1 | 800/0 to 10 Years/3/No/No/1 | 800 |
| NB-3-225-95/1 | 400/0 to 10 Years/4/No/No/1 | 276 |
| NB-5-213-88/1 | 000/0 to 10 Years/4/No/No/1 | 082 |
| NB-3-152-67/1 | 000/0 to 10 Years/3/No/No/782 | |
| NB-1-139-60/2 | 000/0 to 10 Years/5/No/Yes/1 | 946 |
| NB-2-125-54/1 | 800/0 to 10 Years/4/No/No/1 | 734 |
| NB-3-104-72/1 | 600/0 to 10 Years/4/No/No/1 | 622 |
| NB-5-170-54/1 | 400/0 to 10 Years/3/No/No/1 | 294 |
| NB-2-158-25/1 | 800/0 to 10 Years/4/No/No/1 | 450 |
| NB-2-153-72/1 | 600/0 to 10 Years/4/No/No/1 | 600 |
| NB-5-184-26/1 | 600/0 to 10 Years/4/No/No/1 | 500 |
| NB-2-275-40/1 | 600/0 to 10 Years/2/No/No/1 | 652 |
| NB-3-171-20/1 | 200/0 to 10 Years/3/No/No/1 | 442 |
| NB-2-112-74/1 | 600/0 to 10 Years/3/No/Yes/1 | 400 |
| NB-5-219-84/1 | 600/0 to 10 Years/5/No/No/1 | 336 |
| NB-1-110-43/1 | 400/0 to 10 Years/4/No/No/1 | 732 |
| NB-4-176-58/1 | 200/0 to 10 Years/4/No/No/1 | 388 |
| NB-5-161-95/1 | 200/0 to 10 Years/4/No/No/1 | 268 |
| NB-1-109-89/2 | 000/0 to 10 Years/4/No/No/1 | 888 |
| NB-1-217-30/1 | 600/0 to 10 Years/3/No/No/1 | 620 |
| NB-4-183-78/1 | 800/11 to 20 Years/3/No/No/1 | 760 |
| NB-4-299-24/1 | 600/11 to 20 Years/2/No/No/1 | 182 |
| NB-5-174-64/1 | 200/11 to 20 Years/4/No/No/918 | |
| NB-4-266-51/2 | 600/11 to 20 Years/2/No/Yes/2 | 378 |
| NB-3-184-92/1 | 200/11 to 20 Years/2/No/No/852 | |
| NB-4-228-90/3 | 800/11 to 20 Years/4/No/Yes/2 | 400 |
| NB-2-176-71/1 | 200/More than 20 Years/3/No/Yes/1 | 200 |
| NB-5-102-49/1 | 200/More than 20 Years/0/No/No/446 | |
| NB-5-124-15/1 | 600/More than 20 Years/2/No/No/752 | |
| NB-4-162-12/2 | 200/More than 20 Years/3/No/Yes/2 | 418 |
| NB-4-140-13/1 | 200/More than 20 Years/0/No/No/450 | |
| NB-3-230-47/1 | 400/More than 20 Years/3/No/No/894 | |
| NB-1-183-18/1 | 400/More than 20 Years/2/No/No/1 | 402 |
| NB-1-231-14/1 | 400/More than 20 Years/1/No/No/1 | 170 |
| NB-3-108-77/1 | 600/More than 20 Years/4/No/No/950 | |
| NB-3-161-78/2 | 400/More than 20 Years/6/No/Yes/1 | 830 |
| NB-3-101-96/1 | 400/More than 20 Years/1/No/Yes/962 | |
| NB-1-233-59/2 | 000/0 to 10 Years/5/Yes/Yes/2 | 322 |
| NB-2-172-11/1 | 800/0 to 10 Years/3/Yes/Yes/2 | 020 |
| NB-2-252-30/2 | 800/0 to 10 Years/4/Yes/No/3 | 530 |
| NB-1-219-61/3 | 000/0 to 10 Years/6/Yes/Yes/3 | 270 |
| NB-2-222-44/1 | 400/0 to 10 Years/5/Yes/No/1 | 140 |
| NB-1-113-84/2 | 600/0 to 10 Years/4/Yes/Yes/3 | 464 |
| NB-3-109-16/2 | 600/0 to 10 Years/4/Yes/No/3 | 068 |
| NB-5-294-14/1 | 800/0 to 10 Years/5/Yes/No/2 | 382 |
| NB-3-199-22/2 | 800/0 to 10 Years/6/Yes/Yes/2 | 974 |
| NB-5-135-62/1 | 400/0 to 10 Years/3/Yes/No/1 | 298 |
| NB-1-162-38/1 | 000/0 to 10 Years/4/Yes/No/922 | |
| NB-1-100-28/1 | 400/0 to 10 Years/1/Yes/No/1 | 198 |
| NB-3-105-87/2 | 000/0 to 10 Years/3/Yes/No/1 | 560 |
| NB-3-139-24/2 | 800/0 to 10 Years/5/Yes/Yes/2 | 386 |
| NB-1-127-70/1 | 200/0 to 10 Years/4/Yes/No/912 | |
| NB-5-212-99/1 | 400/0 to 10 Years/2/Yes/No/1 | 346 |
| NB-5-253-54/1 | 000/0 to 10 Years/1/Yes/No/972 | |
| NB-1-190-56/1 | 600/0 to 10 Years/4/Yes/No/1 | 446 |
| NB-4-113-35/1 | 400/0 to 10 Years/4/Yes/No/1 | 642 |
| NB-2-158-64/2 | 000/0 to 10 Years/6/Yes/No/1 | 860 |
| NB-2-114-81/2 | 600/0 to 10 Years/4/Yes/Yes/2 | 176 |
| NB-5-122-62/2 | 200/0 to 10 Years/4/Yes/No/2 | 100 |
| NB-4-222-84/1 | 800/0 to 10 Years/2/Yes/No/1 | 182 |
| NB-2-293-35/800/0 to 10 Years/2/Yes/No/684 | ||
| NB-3-140-29/2 | 000/11 to 20 Years/3/Yes/Yes/2 | 152 |
| NB-1-111-44/1 | 600/11 to 20 Years/5/Yes/No/1 | 276 |
| NB-3-221-72/1 | 800/11 to 20 Years/3/Yes/No/1 | 846 |
| NB-1-144-57/2 | 800/11 to 20 Years/7/Yes/Yes/3 | 278 |
| NB-3-219-82/1 | 400/11 to 20 Years/3/Yes/No/1 | 504 |
| NB-5-180-25/1 | 200/11 to 20 Years/2/Yes/No/1 | 106 |
| NB-1-247-47/1 | 800/11 to 20 Years/4/Yes/No/1 | 750 |
| NB-2-265-99/1 | 400/11 to 20 Years/2/Yes/No/1 | 244 |
| NB-5-125-37/2 | 000/11 to 20 Years/5/Yes/Yes/2 | 224 |
| NB-1-179-97/1 | 400/11 to 20 Years/4/Yes/No/1 | 392 |
| NB-1-231-60/1 | 400/11 to 20 Years/4/Yes/No/1 | 336 |
| NB-3-246-72/1 | 800/11 to 20 Years/4/Yes/No/1 | 620 |
| NB-3-186-82/2 | 000/11 to 20 Years/4/Yes/No/1 | 798 |
| NB-3-217-21/1 | 400/11 to 20 Years/2/Yes/No/1 | 342 |
| NB-3-148-39/2 | 200/11 to 20 Years/3/Yes/No/1 | 968 |
| NB-5-136-62/1 | 600/11 to 20 Years/3/Yes/No/1 | 734 |
| NB-1-228-87/1 | 600/11 to 20 Years/4/Yes/No/1 | 486 |
| NB-2-128-28/1 | 200/11 to 20 Years/3/Yes/No/954 | |
| NB-4-181-18/1 | 000/11 to 20 Years/3/Yes/No/854 | |
| NB-1-141-91/1 | 400/11 to 20 Years/2/Yes/Yes/1 | 040 |
| NB-5-279-63/1 | 800/11 to 20 Years/4/Yes/No/1 | 588 |
| NB-5-294-43/1 | 400/11 to 20 Years/2/Yes/No/1 | 462 |
| NB-4-112-21/1 | 400/11 to 20 Years/2/Yes/No/1 | 306 |
| NB-5-281-83/1 | 800/11 to 20 Years/4/Yes/Yes/1 | 600 |
| NB-5-196-63/1 | 800/11 to 20 Years/4/Yes/No/1 | 500 |
| NB-2-300-70/1 | 600/11 to 20 Years/6/Yes/No/1 | 536 |
| NB-1-229-27/2 | 200/11 to 20 Years/4/Yes/No/2 | 282 |
| NB-2-210-93/2 | 000/11 to 20 Years/8/Yes/Yes/1 | 200 |
| NB-5-156-49/2 | 400/11 to 20 Years/5/Yes/Yes/2 | 530 |
| NB-1-262-88/1 | 000/11 to 20 Years/6/Yes/No/1 | 026 |
| NB-1-149-39/1 | 800/11 to 20 Years/4/Yes/No/1 | 730 |
| NB-4-122-63/1 | 600/11 to 20 Years/3/Yes/Yes/1 | 296 |
| NB-4-287-16/1 | 600/11 to 20 Years/3/Yes/No/1 | 640 |
| NB-2-256-15/1 | 200/More than 20 Years/4/Yes/No/880 | |
| NB-5-218-37/1 | 600/More than 20 Years/2/Yes/Yes/1 | 132 |
| NB-3-265-38/1 | 200/More than 20 Years/4/Yes/No/1 | 008 |
| NB-4-139-23/1 | 800/More than 20 Years/3/Yes/No/1 | 466 |
| NB-1-279-81/1 | 200/More than 20 Years/1/Yes/No/1 | 300 |
| NB-4-239-45/2 | 400/More than 20 Years/4/Yes/Yes/1 | 878 |
| NB-4-179-27/1 | 400/More than 20 Years/6/Yes/No/1 | 170 |
| NB-2-226-89/1 | 400/More than 20 Years/5/Yes/No/1 | 160 |
| NB-3-103-12/2 | 400/More than 20 Years/4/Yes/Yes/1 | 840 |
| NB-5-265-28/2 | 800/More than 20 Years/5/Yes/Yes/2 | 464 |
| NB-2-196-48/2 | 200/More than 20 Years/4/Yes/No/2 | 152 |
| NB-2-244-53/3 | 000/More than 20 Years/3/Yes/No/2 | 284 |
| NB-3-251-19/2 | 200/More than 20 Years/4/Yes/No/2 | 070 |
| NB-5-236-48/1 | 800/More than 20 Years/4/Yes/No/1 | 200 |
| NB-2-292-70/1 | 200/More than 20 Years/3/Yes/No/980 | |
| NB-4-176-82/2 | 000/More than 20 Years/3/Yes/No/1 | 380 |
| NB-3-113-19/1 | 200/More than 20 Years/1/Yes/No/1 | 084 |
| NB-4-147-30/1 | 200/More than 20 Years/1/Yes/No/1 | 200 |
| NB-2-251-56/1 | 800/More than 20 Years/6/Yes/No/1 | 312 |
| NB-5-207-43/1 | 200/More than 20 Years/4/Yes/No/796 | |
| NB-5-100-89/1 | 600/More than 20 Years/3/Yes/No/1 | 252 |
Eggert Realty/Price List.txt
| Eggert Realty | |
| Current Sales Prices for homes in New Braunfels | |
| as of 3/15/2016 | |
| Compiled by David Eggert | |
| Listing ID/Price/Offer Pending | |
| NB-5-205-88/372 | 800/No |
| NB-1-189-57/420 | 800/No |
| NB-3-181-44/390 | 000/No |
| NB-3-225-95/371 | 000/No |
| NB-5-213-88/342 | 800/Yes |
| NB-3-152-67/350 | 000/No |
| NB-1-139-60/463 | 000/Yes |
| NB-2-125-54/430 | 000/No |
| NB-3-104-72/381 | 000/No |
| NB-5-170-54/372 | 000/No |
| NB-2-158-25/422 | 800/No |
| NB-2-153-72/403 | 000/No |
| NB-5-184-26/401 | 000/No |
| NB-2-275-40/402 | 000/Yes |
| NB-3-171-20/364 | 400/No |
| NB-2-112-74/381 | 000/Yes |
| NB-5-219-84/373 | 000/Yes |
| NB-1-110-43/372 | 000/No |
| NB-4-176-58/365 | 800/No |
| NB-5-161-95/345 | 200/Yes |
| NB-1-109-89/401 | 000/No |
| NB-1-217-30/373 | 000/No |
| NB-4-183-78/361 | 000/No |
| NB-4-299-24/328 | 000/Yes |
| NB-5-174-64/320 | 000/No |
| NB-4-266-51/516 | 000/No |
| NB-3-184-92/316 | 000/No |
| NB-4-228-90/459 | 000/Yes |
| NB-2-176-71/356 | 000/No |
| NB-5-102-49/308 | 000/No |
| NB-5-124-15/414 | 000/No |
| NB-4-162-12/620 | 000/No |
| NB-4-140-13/332 | 000/No |
| NB-3-230-47/345 | 000/No |
| NB-1-183-18/387 | 800/No |
| NB-1-231-14/364 | 000/No |
| NB-3-108-77/324 | 000/No |
| NB-3-161-78/568 | 800/No |
| NB-3-101-96/339 | 800/Yes |
| NB-1-233-59/512 | 000/No |
| NB-2-172-11/489 | 800/No |
| NB-2-252-30/560 | 000/No |
| NB-1-219-61/630 | 000/No |
| NB-2-222-44/351 | 000/No |
| NB-1-113-84/599 | 800/No |
| NB-3-109-16/580 | 000/No |
| NB-5-294-14/475 | 000/No |
| NB-3-199-22/630 | 000/No |
| NB-5-135-62/350 | 000/Yes |
| NB-1-162-38/351 | 800/No |
| NB-1-100-28/374 | 000/No |
| NB-3-105-87/371 | 000/No |
| NB-3-139-24/630 | 000/No |
| NB-1-127-70/475 | 000/No |
| NB-5-212-99/462 | 000/No |
| NB-5-253-54/450 | 000/No |
| NB-1-190-56/477 | 800/No |
| NB-4-113-35/461 | 000/Yes |
| NB-2-158-64/554 | 000/No |
| NB-2-114-81/716 | 000/No |
| NB-5-122-62/490 | 000/No |
| NB-4-222-84/378 | 000/No |
| NB-2-293-35/323 | 800/No |
| NB-3-140-29/460 | 000/No |
| NB-1-111-44/367 | 000/Yes |
| NB-3-221-72/399 | 000/No |
| NB-1-144-57/610 | 000/No |
| NB-3-219-82/395 | 000/No |
| NB-5-180-25/385 | 000/Yes |
| NB-1-247-47/410 | 000/No |
| NB-2-265-99/334 | 000/No |
| NB-5-125-37/447 | 000/No |
| NB-1-179-97/395 | 000/No |
| NB-1-231-60/384 | 400/No |
| NB-3-246-72/447 | 800/No |
| NB-3-186-82/440 | 000/No |
| NB-3-217-21/359 | 800/No |
| NB-3-148-39/450 | 000/No |
| NB-5-136-62/422 | 000/Yes |
| NB-1-228-87/399 | 000/No |
| NB-2-128-28/340 | 000/No |
| NB-4-181-18/346 | 000/No |
| NB-1-141-91/338 | 000/No |
| NB-5-279-63/431 | 000/No |
| NB-5-294-43/380 | 000/Yes |
| NB-4-112-21/372 | 000/No |
| NB-5-281-83/425 | 000/No |
| NB-5-196-63/427 | 800/Yes |
| NB-2-300-70/392 | 000/No |
| NB-1-229-27/450 | 000/Yes |
| NB-2-210-93/434 | 000/No |
| NB-5-156-49/519 | 800/No |
| NB-1-262-88/345 | 800/No |
| NB-1-149-39/420 | 000/No |
| NB-4-122-63/391 | 000/No |
| NB-4-287-16/386 | 800/No |
| NB-2-256-15/334 | 000/No |
| NB-5-218-37/379 | 800/No |
| NB-3-265-38/342 | 000/No |
| NB-4-139-23/436 | 000/No |
| NB-1-279-81/375 | 200/No |
| NB-4-239-45/470 | 000/No |
| NB-4-179-27/346 | 200/No |
| NB-2-226-89/354 | 600/No |
| NB-3-103-12/450 | 000/No |
| NB-5-265-28/459 | 800/Yes |
| NB-2-196-48/416 | 000/No |
| NB-2-244-53/539 | 000/Yes |
| NB-3-251-19/510 | 600/No |
| NB-5-236-48/404 | 000/Yes |
| NB-2-292-70/345 | 000/Yes |
| NB-4-176-82/409 | 800/No |
| NB-3-113-19/344 | 000/No |
| NB-4-147-30/370 | 000/No |
| NB-2-251-56/349 | 800/No |
| NB-5-207-43/344 | 000/No |
| NB-5-100-89/404 | 000/Yes |