<footer class="site-footer site-footer-two">
    <div class="container">
        <div class="row">
            <div class="col-lg-3 footer-logo">
                <a href="#">
                    <img class="img-responsive" src="images/logo1.png" alt="Footer Logo"/>
                </a>
                <p class="copyright-text">
                    © Copyright 2015 All rights reserved by <a href="#">Real Places</a>
                </p>
            </div>
            <div class="col-lg-9 footer-widget-area">
                <div class="row">
                    <div class="col-sm-6 col-md-3">
                        <section class="widget clearfix widget_lc_taxonomy">
                            <h3 class="widget-title">Locations</h3>
                            <ul>
                                <!--<li>
                                    <a href="#">Miami</a> (12)
                                    <ul class="children">
                                        <li><a href="#">Little Havana</a> (2)</li>
                                        <li><a href="#">Perrine</a> (1)</li>
                                        <li><a href="#">Doral</a> (1)</li>
                                    </ul>
                                </li>-->
                                <?php
									   $propLocSql = db_query("select * from tbl_location where 1 and location_pid='0'");
									     if(mysqli_num_rows($propLocSql)>0){
										   while($PLOCDATA = mysqli_fetch_array($propLocSql)){
									  ?>
                                <li><a href="property-by-location.php?location=<?=$PLOCDATA['location_name']?>"><?=$PLOCDATA['location_name']?></a> (<?=db_scalar("select count(*) from tbl_posted_properties where 1 and posted_properties_status='Approved' and posted_properties_loc_parent='$PLOCDATA[location_name]'");?>)</li>
                                <? }} ?>
                            </ul>
                        </section>
                    </div>
                    <div class="col-sm-6 col-md-3">
                        <section class="widget clearfix widget_lc_taxonomy">
                            <h3 class="widget-title">Property Types</h3>
                            <ul>
                            <?php
								 $prTypeSql = db_query("select * from tbl_property_type where 1 and property_type_pid='0'");
								  if(mysqli_num_rows($prTypeSql)>0){
									 while($pTYPEDATA = mysqli_fetch_array($prTypeSql)){
								?>                          
                                <li>
                                    <a href="property-by-type.php?proType=<?=$pTYPEDATA['property_type_name']?>&proSbType=No"><?=$pTYPEDATA['property_type_name']?></a> (<?=db_scalar("select count(*) from tbl_posted_properties where 1 and posted_properties_status='Approved' and posted_properties_type_parent='$pTYPEDATA[property_type_name]'");?>)
                                    <?php
												$proSbTypeSql = db_query("select * from tbl_property_type where 1 and property_type_pid='$pTYPEDATA[property_type_id]'");
												 if(mysqli_num_rows($proSbTypeSql)>0){
												?>
                                    <ul class="children">
                                    <?php
										while($SUBTPDATA = mysqli_fetch_array($proSbTypeSql)){
                                        ?>
                                        <li><a href="property-by-type.php?proType=<?=$pTYPEDATA['property_type_name']?>&proSbType=<?=$SUBTPDATA['property_type_name']?>"><?=$SUBTPDATA['property_type_name']?></a> (<?=db_scalar("select count(*) from tbl_posted_properties where 1 and posted_properties_status='Approved' and posted_properties_type_child='$SUBTPDATA[property_type_name]'");?>)</li>
                                       <? } ?>
                                    </ul>
                                    <? } ?>
                                </li>
                                <? }} ?>
                            </ul>
                        </section>
                    </div>
                    <div class="clearfix visible-sm"></div>
                    <div class="col-sm-6 col-md-3">
                        <section class="widget clearfix widget_lc_taxonomy">
                            <h3 class="widget-title">Property Statuses</h3>
                            <ul>
                                <li><a href="rent-property.php">For Rent</a> (<?=db_scalar("select count(*) from tbl_posted_properties where 1 and posted_properties_status='Approved' and posted_properties_rent_sale='For Rent'");?>)</li>
                                <li><a href="sell-property.php">For Sale</a> (<?=db_scalar("select count(*) from tbl_posted_properties where 1 and posted_properties_status='Approved' and posted_properties_rent_sale='For Sale'");?>)</li>
                                <li><a href="lease-property.php">For Lease</a> (<?=db_scalar("select count(*) from tbl_posted_properties where 1 and posted_properties_status='Approved' and posted_properties_rent_sale='For Lease'");?>)</li>
                            </ul>
                        </section>
                    </div>
                    <div class="col-sm-6 col-md-3">
                        <section id="inspiry_social_media_icons-1" class="widget clearfix widget_inspiry_social_media_icons">
                            <h3 class="widget-title">Connect With Us</h3>
                            <div class="social-networks clearfix">
                                <a class="twitter" href="https://twitter.com/uttamproperties" target="_blank"><i class="fa fa-twitter fa-lg"></i></a><a class="facebook" href="https://www.facebook.com/Uttam-Nagar-Properties-815908325201633/" target="_blank"><i class="fa fa-facebook fa-lg"></i></a>
                                <a class="linkedin" href="https://in.linkedin.com/in/UttamNagarProperties" target="_blank"><i class="fa fa-linkedin fa-lg"></i></a><a class="google-plus" href="https://plus.google.com/b/103635967861887266492/103635967861887266492/about" target="_blank"><i class="fa fa-google-plus fa-lg"></i></a>
                            </div>
                        </section>
                    </div>
                </div>
            </div>
        </div>
    </div>
</footer>
<!-- .footer -->

<script src="js/jquery-1.11.2.min.js"></script>
<script src="js/flexslider/jquery.flexslider-min.js"></script>
<script src="js/lightslider/js/lightslider.min.js"></script>
<script src="js/select2/select2.min.js"></script>
<script src="js/owl.carousel/owl.carousel.min.js"></script>
<script src="js/swipebox/js/jquery.swipebox.min.js"></script>
<script src="js/jquery.hoverIntent.js"></script>
<script src="js/jquery.validate.min.js"></script>
<script src="js/jquery.form.js"></script>
<script src="js/transition.js"></script>
<script src="js/jquery.appear.js"></script>
<script src="js/modal.js"></script>
<script src="js/meanmenu/jquery.meanmenu.min.js"></script>
<script src="js/jquery.placeholder.min.js"></script>
<script src="js/magnific-popup/jquery.magnific-popup.min.js"></script>
<script src="js/share.min.js"></script>
<script src="js/property-share.js"></script>
<script src="js/sly.min.js"></script>
<script src="js/property-horizontal-scrolling.js"></script>
<script src="js/custom.js"></script>
<?php include("login-signup.php");?>
<!-- .modal -->
<script>
    (function ($) {
        "use strict";

        if (jQuery().validate) {

            //Login
            $('#login-form').validate();

            //Register
            $('#register-form').validate();

            //Forgot Password
            $('#forgot-form').validate();
        }

        /*-----------------------------------------------------------------------------------*/
        /* Modal dialog for Login and Register
         /*-----------------------------------------------------------------------------------*/
        var loginModal = $('#login-modal'),
            modalSections = loginModal.find('.modal-section');

        $('.activate-section').on('click', function (event) {
            var targetSection = $(this).data('section');
            modalSections.slideUp();
            loginModal.find('.' + targetSection).slideDown();
            event.preventDefault();
        });

    })(jQuery);
</script>
</body>


</html>