Property Details

info@freezylist.com

Property ID : 127238

Days on Market : 1936 days

Baths	0.5
Year Built	1993
City	Texas City
County	Angelina County
Beds	3

Lot Size(Acres)	3000
State	Texas
Zip Code	75230
Street Address	trst
Townhouse/APT#	2

Back to Listings

Get Directions

Schedule a Viewing

Make an Offer

(765) 756-7567

Price : $ 333,333

Contact Seller

Property Details

w

General Information

Beds	3
Baths	0.5
Size of Home (Sq Ft)	250
Cooling Type	Central, Solar
Heating Type	NA
Total Rooms	12
Outdoor Amenities	NA
Capacity of Garage	1
View	NA
Rooms	NA
Virtual Tour	NA

Home Type	Condominium
Updated Year	NA
HOA dues/mo ($)	NA
Floor Covering	NA
Heating Fuel	NA
Building/Development Amenities	NA
Architectural Style	NA
Number of Stories	2
Basement	NA
Roof Type	NA

Interior Features

NA

Exterior

NA

Appliances

Dishwasher, Microwave, Washer

Parkings

NA

Additional Features

2

Add To Favorites

View Property Condition Disclosure

Nearby Schools

School District :- SPUR ISD

School Name :- SPUR SCHOOL

Photo Gallery

Back

Messages Timeline Exceptions Views6 Route Queries18 Mails Auth Gate Session Request

76.33ms2MBGET property/details/{id}/{type?}

Booting (13.8ms)
Application (70.28ms)

6 templates were rendered

frontend.property.details (resources/views/frontend/property/details.blade.php)8blade
Params
0
property
1
schools
2
state
3
schoolDistrict
4
county
5
city
6
zipCode
7
additional_information

frontend.layouts.app (resources/views/frontend/layouts/app.blade.php)26blade


obLevel
__env
app
errors
property
schools
state
schoolDistrict
county
city
zipCode
additional_information
logged_in_user
width
height
fbAppId
fbAppVersion
notAvailable
__currentLoopData
image
loop
rooms
information
allRooms
appliances
appliancesAll

includes.partials.logged-in-as (resources/views/includes/partials/logged-in-as.blade.php)26blade


obLevel
__env
app
errors
property
schools
state
schoolDistrict
county
city
zipCode
additional_information
logged_in_user
width
height
fbAppId
fbAppVersion
notAvailable
__currentLoopData
image
loop
rooms
information
allRooms
appliances
appliancesAll

frontend.includes.header (resources/views/frontend/includes/header.blade.php)26blade


obLevel
__env
app
errors
property
schools
state
schoolDistrict
county
city
zipCode
additional_information
logged_in_user
width
height
fbAppId
fbAppVersion
notAvailable
__currentLoopData
image
loop
rooms
information
allRooms
appliances
appliancesAll

includes.partials.messages (resources/views/includes/partials/messages.blade.php)26blade


obLevel
__env
app
errors
property
schools
state
schoolDistrict
county
city
zipCode
additional_information
logged_in_user
width
height
fbAppId
fbAppVersion
notAvailable
__currentLoopData
image
loop
rooms
information
allRooms
appliances
appliancesAll

frontend.includes.footer (resources/views/frontend/includes/footer.blade.php)26blade


obLevel
__env
app
errors
property
schools
state
schoolDistrict
county
city
zipCode
additional_information
logged_in_user
width
height
fbAppId
fbAppVersion
notAvailable
__currentLoopData
image
loop
rooms
information
allRooms
appliances
appliancesAll

uri: GET property/details/{id}/{type?}
middleware: web
controller: App\Http\Controllers\Frontend\PropertyController@propertyDetails
as: frontend.propertyDetails
namespace: App\Http\Controllers\Frontend
prefix: null
where
file: app/Http/Controllers/Frontend/PropertyController.php:1345-1385

18 statements were executed, 4 of which were duplicated, 14 unique31.54ms

select exists(select * from `properties` where `id` = '24' and exists (select * from `users` where `properties`.`user_id` = `users`.`id` and `users`.`deleted_at` is null) and `properties`.`deleted_at` is null) as `exists`5.76ms/app/Http/Controllers/Frontend/PropertyController.php:1347freezylist
Metadata
Bindings
0. 24
Backtrace
10. /app/Http/Controllers/Frontend/PropertyController.php:1347
18. /app/Http/Middleware/LocaleMiddleware.php:57
63. /public/index.php:52
- EXPLAIN #1: `` (PRIMARY)null1
Metadata
id 1
select_type PRIMARY
table null
partitions null
type null
possible_keys null
key null
key_len null
ref null
rows null
filtered null
Extra No tables used
- EXPLAIN #2: `properties` (SUBQUERY)12
Metadata
id 2
select_type SUBQUERY
table properties
partitions null
type const
possible_keys PRIMARY,user_id
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null
- EXPLAIN #2: `users` (SUBQUERY)12
Metadata
id 2
select_type SUBQUERY
table users
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `properties` where `id` = '24' and exists (select * from `users` where `properties`.`user_id` = `users`.`id` and `users`.`deleted_at` is null) and `properties`.`deleted_at` is null limit 1

760μs/app/Http/Controllers/Frontend/PropertyController.php:1363freezylist

Metadata
Bindings	0. 24
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/Http/Controllers/Frontend/PropertyController.php:1363 21. /app/Http/Middleware/LocaleMiddleware.php:57 66. /public/index.php:52

- EXPLAIN #1: `properties` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table properties
partitions null
type const
possible_keys PRIMARY,user_id
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null
- EXPLAIN #1: `users` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table users
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `users` where `users`.`id` in ('39') and `users`.`deleted_at` is null590μs/app/Http/Controllers/Frontend/PropertyController.php:1363freezylist

Metadata
Bindings	0. 39
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/PropertyController.php:1363 27. /app/Http/Middleware/LocaleMiddleware.php:57 72. /public/index.php:52

- EXPLAIN #1: `users` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table users
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `sale_offers` where `sale_offers`.`property_id` in ('24') and `sale_offers`.`deleted_at` is null3.84ms/app/Http/Controllers/Frontend/PropertyController.php:1363freezylist

Metadata
Bindings	0. 24
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/PropertyController.php:1363 27. /app/Http/Middleware/LocaleMiddleware.php:57 72. /public/index.php:52

- EXPLAIN #1: `sale_offers` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table sale_offers
partitions null
type ref
possible_keys property_id
key property_id
key_len 4
ref const
rows 1
filtered 10
Extra Using where

select * from `rent_offers` where `rent_offers`.`property_id` in ('24') and `rent_offers`.`deleted_at` is null2.59ms/app/Http/Controllers/Frontend/PropertyController.php:1363freezylist

Metadata
Bindings	0. 24
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/PropertyController.php:1363 27. /app/Http/Middleware/LocaleMiddleware.php:57 72. /public/index.php:52

- EXPLAIN #1: `rent_offers` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table rent_offers
partitions null
type ref
possible_keys property_id
key property_id
key_len 4
ref const
rows 1
filtered 25
Extra Using where

select * from `favorites` where `favorites`.`property_id` in ('24') and `favorites`.`deleted_at` is null2.82ms/app/Http/Controllers/Frontend/PropertyController.php:1363freezylist

Metadata
Bindings	0. 24
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/PropertyController.php:1363 27. /app/Http/Middleware/LocaleMiddleware.php:57 72. /public/index.php:52

- EXPLAIN #1: `favorites` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table favorites
partitions null
type ref
possible_keys property_id
key property_id
key_len 4
ref const
rows 1
filtered 50
Extra Using where

select * from `property_architectures` where `property_architectures`.`property_id` in ('24') and `property_architectures`.`deleted_at` is null

650μs/app/Http/Controllers/Frontend/PropertyController.php:1363freezylist

Metadata
Bindings	0. 24
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/PropertyController.php:1363 27. /app/Http/Middleware/LocaleMiddleware.php:57 72. /public/index.php:52

- EXPLAIN #1: `property_architectures` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table property_architectures
partitions null
type ref
possible_keys property_id
key property_id
key_len 4
ref const
rows 1
filtered 10
Extra Using where

select * from `property_images` where `property_images`.`property_id` in ('24') and `property_images`.`deleted_at` is null

590μs/app/Http/Controllers/Frontend/PropertyController.php:1363freezylist

Metadata
Bindings	0. 24
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/PropertyController.php:1363 27. /app/Http/Middleware/LocaleMiddleware.php:57 72. /public/index.php:52

- EXPLAIN #1: `property_images` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table property_images
partitions null
type ref
possible_keys property_id
key property_id
key_len 4
ref const
rows 1
filtered 10
Extra Using where

select * from `property_availabilities` where `property_availabilities`.`property_id` in ('24') and `user_id` is null and `property_availabilities`.`deleted_at` is null

2.4ms/app/Http/Controllers/Frontend/PropertyController.php:1363freezylist

Metadata
Bindings	0. 24
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/Frontend/PropertyController.php:1363 27. /app/Http/Middleware/LocaleMiddleware.php:57 72. /public/index.php:52

- EXPLAIN #1: `property_availabilities` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table property_availabilities
partitions null
type ref
possible_keys property_id,user_id
key property_id
key_len 4
ref const
rows 1
filtered 11.111111640930176
Extra Using where
select `additional_information`.*, `a_i_2`.`name` as `parent_name`, `additional_information_property`.`property_id` as `pivot_property_id`, `additional_information_property`.`additional_information_id` as `pivot_additional_information_id` from `additional_information` inner join `additional_information_property` on `additional_information`.`id` = `additional_information_property`.`additional_information_id` inner join `additional_information` as `a_i_2` on `a_i_2`.`id` = `additional_information`.`parent_id` where `additional_information_property`.`property_id` in ('24') and `additional_information`.`deleted_at` is null2.93ms/app/Http/Controllers/Frontend/PropertyController.php:1363freezylist
Metadata
Bindings
0. 24
Backtrace
17. /app/Http/Controllers/Frontend/PropertyController.php:1363
25. /app/Http/Middleware/LocaleMiddleware.php:57
70. /public/index.php:52
- EXPLAIN #1: `additional_information_property` (SIMPLE)51
Metadata
id 1
select_type SIMPLE
table additional_information_property
partitions null
type ref
possible_keys property_id,additional_information_id
key property_id
key_len 4
ref const
rows 5
filtered 100
Extra null

- EXPLAIN #1: `additional_information` (SIMPLE)11

Metadata
id	1
select_type	SIMPLE
table	additional_information
partitions	null
type	eq_ref
possible_keys	PRIMARY
key	PRIMARY
key_len	4
ref	freezylist.additional_information_property.additional_information_id
rows	1
filtered	10
Extra	Using where

- EXPLAIN #1: `a_i_2` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table a_i_2
partitions null
type eq_ref
possible_keys PRIMARY
key PRIMARY
key_len 4
ref freezylist.additional_information.parent_id
rows 1
filtered 100
Extra null

select * from `states` where `id` = '48' limit 1410μs/app/Http/Controllers/Frontend/PropertyController.php:1364freezylist

Metadata
Bindings	0. 48
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/Http/Controllers/Frontend/PropertyController.php:1364 21. /app/Http/Middleware/LocaleMiddleware.php:57 66. /public/index.php:52

- EXPLAIN #1: `states` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table states
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `counties` where `id` = '48005' limit 11.3ms/app/Http/Controllers/Frontend/PropertyController.php:1365freezylist

Metadata
Bindings	0. 48005
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/Http/Controllers/Frontend/PropertyController.php:1365 21. /app/Http/Middleware/LocaleMiddleware.php:57 66. /public/index.php:52

- EXPLAIN #1: `counties` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table counties
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `cities` where `id` = '4807420' limit 11.52ms/app/Http/Controllers/Frontend/PropertyController.php:1366freezylist

Metadata
Bindings	0. 4807420
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/Http/Controllers/Frontend/PropertyController.php:1366 21. /app/Http/Middleware/LocaleMiddleware.php:57 66. /public/index.php:52

- EXPLAIN #1: `cities` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table cities
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `zip_codes` where `id` = '9975230' limit 11.72ms/app/Http/Controllers/Frontend/PropertyController.php:1367freezylist

Metadata
Bindings	0. 9975230
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/Http/Controllers/Frontend/PropertyController.php:1367 21. /app/Http/Middleware/LocaleMiddleware.php:57 66. /public/index.php:52

- EXPLAIN #1: `zip_codes` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table zip_codes
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `schools` where `id` in ('80517')1.43ms/app/Http/Controllers/Frontend/PropertyController.php:1368freezylist

Metadata
Bindings	0. 80517
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Http/Controllers/Frontend/PropertyController.php:1368 20. /app/Http/Middleware/LocaleMiddleware.php:57 65. /public/index.php:52

- EXPLAIN #1: `schools` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table schools
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `school_districts` where `id` = '14613' limit 1900μs/app/Http/Controllers/Frontend/PropertyController.php:1369freezylist

Metadata
Bindings	0. 14613
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/Http/Controllers/Frontend/PropertyController.php:1369 21. /app/Http/Middleware/LocaleMiddleware.php:57 66. /public/index.php:52

- EXPLAIN #1: `school_districts` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table school_districts
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `cities` where `id` = '4807420' limit 1900μs/app/helpers.php:229freezylist

Metadata
Bindings	0. 4807420
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/helpers.php:229 21. /vendor/symfony/http-foundation/Response.php:201 25. /app/Http/Middleware/LocaleMiddleware.php:57 70. /public/index.php:52

- EXPLAIN #1: `cities` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table cities
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

select * from `states` where `id` = '48' limit 1430μs/app/helpers.php:241freezylist

Metadata
Bindings	0. 48
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/helpers.php:241 21. /vendor/symfony/http-foundation/Response.php:201 25. /app/Http/Middleware/LocaleMiddleware.php:57 70. /public/index.php:52

- EXPLAIN #1: `states` (SIMPLE)11
Metadata
id 1
select_type SIMPLE
table states
partitions null
type const
possible_keys PRIMARY
key PRIMARY
key_len 4
ref const
rows 1
filtered 100
Extra null

web: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
api: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]

_token: ZFIl21uEUwvls5DUaedVqf5ro7XdyqYpre0FsiLj
_previous: array:1 [ "url" => "https://freezylist.lusites.xyz/property/details/24" ]
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: []
request_request: []
request_headers: array:17 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 =>...
request_server: array:40 [ "USER" => "freezylist" "HOME" => "/home/freezylist" "HTTP_PRIORITY" => "u=0, i" "...
request_cookies: []
response_headers: array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /property/details/24
session_attributes: array:3 [ "_token" => "ZFIl21uEUwvls5DUaedVqf5ro7XdyqYpre0FsiLj" "_previous" => array:1 [ "u...