Array
(
    [ERR_NO] => 1452
    [ERROR] => Cannot add or update a child row: a foreign key constraint fails (`tgadmin_zero`.`listing_views`, CONSTRAINT `listing_views_ibfk_1` FOREIGN KEY (`list_id`) REFERENCES `listings` (`list_id`) ON DELETE CASCADE)
    [SQL] => INSERT INTO listing_views SET list_id=101775,stamp=1575158400,year=2019,month=12
)
Array
(
    [file] => /var/www/listzero/app/models/Listing.php
    [line] => 411
    [function] => query
    [class] => Db
    [object] => Listing Object
        (
            [attributes:protected] => Array
                (
                    [property_type] => Array
                        (
                            [attribute_id] => 1
                            [name] => Property Type
                            [values] => Array
                                (
                                    [46] => Array
                                        (
                                            [value] => Single Family Home
                                            [sort] => 0
                                        )

                                    [47] => Array
                                        (
                                            [value] => Apartment Complex
                                            [sort] => 1
                                        )

                                    [48] => Array
                                        (
                                            [value] => Town Home / Condo
                                            [sort] => 2
                                        )

                                    [63] => Array
                                        (
                                            [value] => Multi Family Home
                                            [sort] => 3
                                        )

                                    [64] => Array
                                        (
                                            [value] => Manufactured
                                            [sort] => 4
                                        )

                                    [68] => Array
                                        (
                                            [value] => Vacant Land
                                            [sort] => 5
                                        )

                                )

                        )

                    [home_style] => Array
                        (
                            [attribute_id] => 2
                            [name] => Home Style
                            [values] => Array
                                (
                                    [6] => Array
                                        (
                                            [value] => 1-Story
                                            [sort] => 1
                                        )

                                    [7] => Array
                                        (
                                            [value] => 1-Story with Basement
                                            [sort] => 2
                                        )

                                    [8] => Array
                                        (
                                            [value] => 2-Story
                                            [sort] => 3
                                        )

                                    [9] => Array
                                        (
                                            [value] => 2-Story with basement
                                            [sort] => 4
                                        )

                                    [10] => Array
                                        (
                                            [value] => Multi Level
                                            [sort] => 5
                                        )

                                    [11] => Array
                                        (
                                            [value] => Twin Home
                                            [sort] => 6
                                        )

                                    [50] => Array
                                        (
                                            [value] => Town Home
                                            [sort] => 7
                                        )

                                    [51] => Array
                                        (
                                            [value] => Condo
                                            [sort] => 8
                                        )

                                    [52] => Array
                                        (
                                            [value] => Row House
                                            [sort] => 9
                                        )

                                    [53] => Array
                                        (
                                            [value] => Other
                                            [sort] => 10
                                        )

                                )

                        )

                    [foundation] => Array
                        (
                            [attribute_id] => 3
                            [name] => Foundation
                            [values] => Array
                                (
                                    [12] => Array
                                        (
                                            [value] => Full Basement
                                            [sort] => 1
                                        )

                                    [13] => Array
                                        (
                                            [value] => Half Basement
                                            [sort] => 2
                                        )

                                    [14] => Array
                                        (
                                            [value] => Slab
                                            [sort] => 3
                                        )

                                    [15] => Array
                                        (
                                            [value] => Crawl Space
                                            [sort] => 4
                                        )

                                )

                        )

                    [heating] => Array
                        (
                            [attribute_id] => 4
                            [name] => Heating
                            [values] => Array
                                (
                                    [16] => Array
                                        (
                                            [value] => Forced Air
                                            [sort] => 1
                                        )

                                    [17] => Array
                                        (
                                            [value] => Radiant Heat
                                            [sort] => 2
                                        )

                                    [18] => Array
                                        (
                                            [value] => Geothermal
                                            [sort] => 3
                                        )

                                    [66] => Array
                                        (
                                            [value] => Hydronic
                                            [sort] => 4
                                        )

                                    [19] => Array
                                        (
                                            [value] => See Remarks
                                            [sort] => 4
                                        )

                                    [65] => Array
                                        (
                                            [value] => Steam Radiant
                                            [sort] => 5
                                        )

                                )

                        )

                    [cooling] => Array
                        (
                            [attribute_id] => 5
                            [name] => Cooling
                            [values] => Array
                                (
                                    [20] => Array
                                        (
                                            [value] => Central Air
                                            [sort] => 1
                                        )

                                    [21] => Array
                                        (
                                            [value] => Evaporative Cooling
                                            [sort] => 2
                                        )

                                    [22] => Array
                                        (
                                            [value] => See Remarks
                                            [sort] => 3
                                        )

                                    [67] => Array
                                        (
                                            [value] => Air Condintioning- Window
                                            [sort] => 4
                                        )

                                )

                        )

                    [roof] => Array
                        (
                            [attribute_id] => 6
                            [name] => Roof
                            [values] => Array
                                (
                                    [23] => Array
                                        (
                                            [value] => Asphalt Shingles
                                            [sort] => 1
                                        )

                                    [24] => Array
                                        (
                                            [value] => Metal
                                            [sort] => 2
                                        )

                                    [25] => Array
                                        (
                                            [value] => Wood Shingles
                                            [sort] => 3
                                        )

                                    [26] => Array
                                        (
                                            [value] => Tar Gravel
                                            [sort] => 4
                                        )

                                    [27] => Array
                                        (
                                            [value] => See Remarks
                                            [sort] => 5
                                        )

                                )

                        )

                    [profession] => Array
                        (
                            [attribute_id] => 7
                            [name] => Profession
                            [values] => Array
                                (
                                    [28] => Array
                                        (
                                            [value] => Realtor
                                            [sort] => 1
                                        )

                                    [29] => Array
                                        (
                                            [value] => Lender
                                            [sort] => 2
                                        )

                                    [30] => Array
                                        (
                                            [value] => Appraiser
                                            [sort] => 3
                                        )

                                    [31] => Array
                                        (
                                            [value] => Title Company
                                            [sort] => 4
                                        )

                                    [32] => Array
                                        (
                                            [value] => Insurance
                                            [sort] => 5
                                        )

                                    [33] => Array
                                        (
                                            [value] => Inspector
                                            [sort] => 6
                                        )

                                    [34] => Array
                                        (
                                            [value] => Mover
                                            [sort] => 7
                                        )

                                    [69] => Array
                                        (
                                            [value] => Photographer/Stager
                                            [sort] => 8
                                        )

                                    [35] => Array
                                        (
                                            [value] => Other Pro
                                            [sort] => 9
                                        )

                                )

                        )

                    [building_type] => Array
                        (
                            [attribute_id] => 8
                            [name] => Building Type
                            [values] => Array
                                (
                                    [1] => Array
                                        (
                                            [value] => Single Family
                                            [sort] => 1
                                        )

                                    [2] => Array
                                        (
                                            [value] => Duplex
                                            [sort] => 2
                                        )

                                    [3] => Array
                                        (
                                            [value] => Triplex
                                            [sort] => 3
                                        )

                                    [4] => Array
                                        (
                                            [value] => Fourplex
                                            [sort] => 4
                                        )

                                )

                        )

                    [exterior] => Array
                        (
                            [attribute_id] => 9
                            [name] => Exterior Material
                            [values] => Array
                                (
                                    [38] => Array
                                        (
                                            [value] => Stucco
                                            [sort] => 1
                                        )

                                    [39] => Array
                                        (
                                            [value] => Siding
                                            [sort] => 2
                                        )

                                    [54] => Array
                                        (
                                            [value] => Brick
                                            [sort] => 3
                                        )

                                    [55] => Array
                                        (
                                            [value] => Stucco/Brick
                                            [sort] => 4
                                        )

                                    [56] => Array
                                        (
                                            [value] => Siding/Brick
                                            [sort] => 5
                                        )

                                    [57] => Array
                                        (
                                            [value] => Other
                                            [sort] => 6
                                        )

                                )

                        )

                    [fireplace] => Array
                        (
                            [attribute_id] => 10
                            [name] => Fireplace
                            [values] => Array
                                (
                                    [40] => Array
                                        (
                                            [value] => 1FP
                                            [sort] => 0
                                        )

                                    [41] => Array
                                        (
                                            [value] => 2FP
                                            [sort] => 1
                                        )

                                    [58] => Array
                                        (
                                            [value] => 3FP
                                            [sort] => 2
                                        )

                                    [59] => Array
                                        (
                                            [value] => 4FP
                                            [sort] => 3
                                        )

                                    [60] => Array
                                        (
                                            [value] => 1WS
                                            [sort] => 4
                                        )

                                    [61] => Array
                                        (
                                            [value] => 2WS
                                            [sort] => 5
                                        )

                                    [62] => Array
                                        (
                                            [value] => 3WS
                                            [sort] => 6
                                        )

                                )

                        )

                )

            [attributes_by_id:protected] => Array
                (
                    [1] => Array
                        (
                            [code] => property_type
                            [name] => Property Type
                        )

                    [2] => Array
                        (
                            [code] => home_style
                            [name] => Home Style
                        )

                    [3] => Array
                        (
                            [code] => foundation
                            [name] => Foundation
                        )

                    [4] => Array
                        (
                            [code] => heating
                            [name] => Heating
                        )

                    [5] => Array
                        (
                            [code] => cooling
                            [name] => Cooling
                        )

                    [6] => Array
                        (
                            [code] => roof
                            [name] => Roof
                        )

                    [7] => Array
                        (
                            [code] => profession
                            [name] => Profession
                        )

                    [8] => Array
                        (
                            [code] => building_type
                            [name] => Building Type
                        )

                    [9] => Array
                        (
                            [code] => exterior
                            [name] => Exterior Material
                        )

                    [10] => Array
                        (
                            [code] => fireplace
                            [name] => Fireplace
                        )

                )

            [amenities:protected] => Array
                (
                    [1] => Array
                        (
                            [amenity_id] => 1
                            [amenity] => Sprinklers
                            [sort] => 1
                            [status] => 1
                        )

                    [2] => Array
                        (
                            [amenity_id] => 2
                            [amenity] => Pool
                            [sort] => 2
                            [status] => 1
                        )

                    [3] => Array
                        (
                            [amenity_id] => 3
                            [amenity] => Wheelchair Access
                            [sort] => 3
                            [status] => 1
                        )

                    [4] => Array
                        (
                            [amenity_id] => 4
                            [amenity] => Fence
                            [sort] => 4
                            [status] => 1
                        )

                    [5] => Array
                        (
                            [amenity_id] => 5
                            [amenity] => Outbuildings
                            [sort] => 5
                            [status] => 1
                        )

                    [6] => Array
                        (
                            [amenity_id] => 6
                            [amenity] => Refrigerator
                            [sort] => 6
                            [status] => 1
                        )

                    [7] => Array
                        (
                            [amenity_id] => 7
                            [amenity] => Washer
                            [sort] => 7
                            [status] => 1
                        )

                    [8] => Array
                        (
                            [amenity_id] => 8
                            [amenity] => Dryer
                            [sort] => 8
                            [status] => 1
                        )

                    [9] => Array
                        (
                            [amenity_id] => 9
                            [amenity] => Stove
                            [sort] => 9
                            [status] => 1
                        )

                    [10] => Array
                        (
                            [amenity_id] => 10
                            [amenity] => Range
                            [sort] => 10
                            [status] => 1
                        )

                    [11] => Array
                        (
                            [amenity_id] => 11
                            [amenity] => Microwave
                            [sort] => 11
                            [status] => 1
                        )

                    [12] => Array
                        (
                            [amenity_id] => 12
                            [amenity] => Other
                            [sort] => 12
                            [status] => 1
                        )

                )

            [_listing:protected] => Array
                (
                )

            [_model:protected] => Listing
            [handle:protected] => mysqli Object
                (
                    [affected_rows] => -1
                    [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
                    [client_version] => 50012
                    [connect_errno] => 0
                    [connect_error] => 
                    [errno] => 1452
                    [error] => Cannot add or update a child row: a foreign key constraint fails (`tgadmin_zero`.`listing_views`, CONSTRAINT `listing_views_ibfk_1` FOREIGN KEY (`list_id`) REFERENCES `listings` (`list_id`) ON DELETE CASCADE)
                    [error_list] => Array
                        (
                            [0] => Array
                                (
                                    [errno] => 1452
                                    [sqlstate] => 23000
                                    [error] => Cannot add or update a child row: a foreign key constraint fails (`tgadmin_zero`.`listing_views`, CONSTRAINT `listing_views_ibfk_1` FOREIGN KEY (`list_id`) REFERENCES `listings` (`list_id`) ON DELETE CASCADE)
                                )

                        )

                    [field_count] => 5
                    [host_info] => Localhost via UNIX socket
                    [info] => 
                    [insert_id] => 0
                    [server_info] => 5.7.28-0ubuntu0.18.04.4
                    [server_version] => 50728
                    [stat] => Uptime: 1532387  Threads: 10  Questions: 2159746  Slow queries: 0  Opens: 523  Flush tables: 1  Open tables: 516  Queries per second avg: 1.409
                    [sqlstate] => 00000
                    [protocol_version] => 10
                    [thread_id] => 325278
                    [warning_count] => 0
                )

            [result:protected] => 
        )

    [type] => ->
    [args] => Array
        (
            [0] => INSERT INTO listing_views SET list_id=101775,stamp=1575158400,year=2019,month=12
        )

)
Home for sale at , , - Listzero.com - ListZero.com
Feature your ad on our site? Create an ad here
Bedroom(s)
Bathrooms
Sq. Ft.
Acres
LZ#:
MLS#: n/a

Find Listing on Map
X
$1,070 / mo
Estimated Monthly Payment
30 Year Fixed:
$
/ mo
20 Year Fixed:
$
/ mo
15 Year Fixed:
$
/ mo
Estimated taxes & insurance not included
Current Rates On Listzero.com Mortgage Marketplace
Mortgage Calculator

Tips and Tricks to buying a home

Buyer Be Wise

Buying a home isn’t just about the mortgage payment. Don’t forget about homeowner association fees, property taxes, utilities, etc. Long story short: do your research and make sure your budget matches the house.
Find out More