<?php 
require_once("header1.php");

$num_flat = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 1 AND `subtype_id` = 1"));
$num_house = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 1 AND `subtype_id` = 5"));
$num_office_space = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 2 AND `subtype_id` = 2"));
$num_commercial_space = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 2 AND `subtype_id` = 3"));

$num_1bhk = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 1 AND `bhk` = '1BHK'"));
$num_2bhk = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 1 AND `bhk` = '2BHK'"));
$num_3bhk = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 1 AND `bhk` = '3BHK'"));
$num_4bhk = mysqli_num_rows(mysqli_query($connection,"SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 1 AND `bhk` = '4BHK'"));
?>
  
			<!-- page template area start -->
			<section id="about" style="background:#003f7d;">
				<div class="container mt-0 pb-10 pt-0">
				    <h1 class="title mt-20 mb-10 text-white" style="text-align:center;">Continue Your Searach</h1>
				    <form action="property-list.php" method="GET">
				    <div class="row">
				        <div class="text-center text-white mb-10"><a href="home.php?type_id=1" <?php if(!isset($_REQUEST['type_id']) || $_REQUEST['type_id'] == 1) { ?>style="color:#fdd023; text-decoration:underline;"<?php } else { ?>style="color:#fff;"<?php } ?>>Residential</a> | <a href="home.php?type_id=2" <?php if($_REQUEST['type_id'] == 2) { ?>style="color:#fdd023; text-decoration:underline;"<?php } else { ?>style="color:#fff;"<?php } ?>>Commercial</a> | <a href="home.php?type_id=3" <?php if($_REQUEST['type_id'] == 3) { ?>style="color:#fdd023; text-decoration:underline;"<?php } else { ?>style="color:#fff;"<?php } ?>>Land</a></div>
						<div class="col-md-3">
							<div class="form-group">
								<select name="location_id" id="location_id" class="form-control" style="border-radius:5px;">
								   <option value="">Select Location</option>
							    <?php
								$sql_location = "SELECT * FROM `pd_locations` WHERE `location_status` = 'Active' ORDER BY `location_id` ASC";
								$exe_location = mysqli_query($connection,$sql_location);
								while($arr_location = mysqli_fetch_array($exe_location))
								{
									?>
									<option value="<?php echo $arr_location['location_id'];?>"><?php echo stripslashes($arr_location['location']);?></option> 
									<?php
								}
								?>
								</select>
							</div>
						</div>
						<div class="col-md-4">
							<div class="form-group">
							    <?php if(isset($_REQUEST['type_id'])) { ?>
								<select name="subtype_id" id="subtype_id" class="form-control" style="border-radius:5px;">
							    <?php
                                $sql_type1 = "SELECT * FROM `pd_property_subtype` WHERE `type_id`  = '".$_REQUEST['type_id']."' AND `subtype_status` = 'Active' ORDER BY `subtype_id` ASC";
                                $exe_type1 = mysqli_query($connection,$sql_type1);
                                while($arr_type1 = mysqli_fetch_array($exe_type1))
                                {
                                	?>
                                	<option value="<?php echo $arr_type1['subtype_id'];?>"><?php echo stripslashes($arr_type1['subtype']);?></option> 
                                	<?php
                                }
                                ?>
								</select>
								<?php } else { ?>
								<select name="subtype_id" id="subtype_id" class="form-control" style="border-radius:5px;">
							    <?php
                                $sql_type1 = "SELECT * FROM `pd_property_subtype` WHERE `type_id`  = '1' AND `subtype_status` = 'Active' ORDER BY `subtype_id` ASC";
                                $exe_type1 = mysqli_query($connection,$sql_type1);
                                while($arr_type1 = mysqli_fetch_array($exe_type1))
                                {
                                	?>
                                	<option value="<?php echo $arr_type1['subtype_id'];?>"><?php echo stripslashes($arr_type1['subtype']);?></option> 
                                	<?php
                                }
                                ?>
								</select>
								<?php } ?>
							</div>
						</div>
						<div class="col-md-3">
							<div class="form-group">
								<input name="price_to" id="price_to" class="form-control" style="border-radius:5px;" type="text" placeholder="Budget Upto">
							</div>
						</div>
						<div class="col-md-2 ">
						    <div class="form-group" style="">
							    <button type="submit" class="btn btn-flat btn-theme-colored border-left-theme-color-2-4px" style="height:46px;">Submit</button>
							</div>
						</div>
					</div>
					<?php if(!isset($_REQUEST['type_id'])) { ?>
					<input type="hidden" name="type_id" id="type_id" value="1">
					<?php } else { ?>
					<input type="hidden" name="type_id" id="type_id" value="<?php echo $_REQUEST['type_id'];?>">
					<?php } ?>
					</form>
			    </div>
		    </section>
			
			<section id="about" style="background:#eee;">
				<div class="container mt-0 pb-10 pt-0">
					<div class="row multi-row-clearfix">
					    <h1 class="title mt-15 mb-20" style="text-align:center;">Top <span style="color:#ff8e00;">Properties</span></h1>
						<div class="col-md-12">
						    <div class="owl-carousel-4col" data-nav="true">
                            <?php
							$sql_product = "SELECT * FROM `pd_property` WHERE `property_status` = 'Active' ORDER BY `price` DESC LIMIT 0,10";
							$exe_product = mysqli_query($connection,$sql_product);
							while($arr_order = mysqli_fetch_array($exe_product))
							{
								if($arr_order['floor'] == 0)
        						{
        						    $flr = "Ground";
        						}
        						else
        						{
        						    $flr = $arr_order['floor'];
        						}
								$get_location = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_locations` WHERE `location_id` = '".$arr_order['location_id']."'"));
                                $get_type = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_property_type` WHERE `type_id` = '".$arr_order['type_id']."'"));
                                $get_subtype = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_property_subtype` WHERE `subtype_id` = '".$arr_order['subtype_id']."'"));
                                $get_otype = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_ownership_type` WHERE `otype_id` = '".$arr_order['otype_id']."'"));
								?>	
								<a href="property-details.php?property_id=<?php echo $arr_order['property_id'];?>">
						    	<div class="item" style="background:#fff;">
									<div class="mb-20">							<div class="thumb">
											<img class="img-fullwidth" alt="" src="uploads/property/<?php echo stripslashes($arr_order['cover_photo']);?>" style="border-top-right-radius: 7px; border-top-left-radius: 7px;">
    									</div>
    									<div class="p-5 pt-5 pb-5" style="text-align:left; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc; background-color:#fff; border-bottom-right-radius: 7px; border-bottom-left-radius: 7px;">
											<h4 class="mt-5 mb-5 ml-5" style="color:#2b2b2b; font-weight:600;"><?php echo stripslashes($get_type['type']);?> - <?php echo stripslashes($get_subtype['subtype']);?></h4>
											<p style="margin-bottom:0; margin-left:5px;"><?php echo $get_location['location'];?></p>
											<?php if($arr_order['type_id'] == 1) { 
											?>
            						        <p style="margin-bottom:0; margin-left:5px;"><?php echo stripslashes($arr_order['bhk']);?>, <?php echo $flr;?> Floor</p>
            						        <?php 
            						    } 
            				            ?>
						                <?php if($arr_order['type_id'] == 2) 
						                { 
						                    ?>
						                    <p style="margin-bottom:0; margin-left:5px;"><?php echo $flr;?> Floor</p>
						                    <?php 
						                } 
						                ?>
						                <?php if($arr_order['type_id'] == 3) 
						                { 
						                    ?>
						        
						                    <?php 
						                } 
						                ?>
                                            <p style="margin-bottom:5px; margin-left:5px; font-size:17px; color:#e53935;"><b>&#8377;<?php echo $arr_order['price'];?></b></p>
                                        </div>	
    								</div>
								</div></a>
								<?php
							}
							?>
							</div>
						</div>
					</div>
				</div>
			</section>
			
			<section id="about">
				<div class="container mt-0 pb-10 pt-0">
					<div class="row multi-row-clearfix">
					    <h1 class="title mt-15 mb-20" style="text-align:center;">Residential <span style="color:#ff8e00;">Properties</span></h1>
						<div class="col-md-12">
						    <div class="owl-carousel-4col" data-nav="true">
                            <?php
							$sql_product = "SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 1 ORDER BY `property_id` DESC LIMIT 0,10";
							$exe_product = mysqli_query($connection,$sql_product);
							while($arr_order = mysqli_fetch_array($exe_product))
							{
								if($arr_order['floor'] == 0)
        						{
        						    $flr = "Ground";
        						}
        						else
        						{
        						    $flr = $arr_order['floor'];
        						}
								$get_location = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_locations` WHERE `location_id` = '".$arr_order['location_id']."'"));
                                $get_type = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_property_type` WHERE `type_id` = '".$arr_order['type_id']."'"));
                                $get_subtype = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_property_subtype` WHERE `subtype_id` = '".$arr_order['subtype_id']."'"));
                                $get_otype = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_ownership_type` WHERE `otype_id` = '".$arr_order['otype_id']."'"));
								?>	
								<a href="property-details.php?property_id=<?php echo $arr_order['property_id'];?>">
						    	<div class="item" style="background:#fff;">
									<div class="mb-20">							<div class="thumb">
											<img class="img-fullwidth" alt="" src="uploads/property/<?php echo stripslashes($arr_order['cover_photo']);?>" style="border-top-right-radius: 7px; border-top-left-radius: 7px;">
    									</div>
    									<div class="p-5 pt-5 pb-5" style="text-align:left; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc; background-color:#fff; border-bottom-right-radius: 7px; border-bottom-left-radius: 7px;">
											<h4 class="mt-5 mb-5 ml-5" style="color:#2b2b2b; font-weight:600;"><?php echo stripslashes($get_type['type']);?> - <?php echo stripslashes($get_subtype['subtype']);?></h4>
											<p style="margin-bottom:0; margin-left:5px;"><?php echo $get_location['location'];?></p>
											<?php if($arr_order['type_id'] == 1) { 
											?>
            						        <p style="margin-bottom:0; margin-left:5px;"><?php echo stripslashes($arr_order['bhk']);?>, <?php echo $flr;?> Floor</p>
            						        <?php 
            						    } 
            				            ?>
						                <?php if($arr_order['type_id'] == 2) 
						                { 
						                    ?>
						                    <p style="margin-bottom:0; margin-left:5px;"><?php echo $flr;?> Floor</p>
						                    <?php 
						                } 
						                ?>
						                <?php if($arr_order['type_id'] == 3) 
						                { 
						                    ?>
						        
						                    <?php 
						                } 
						                ?>
                                            <p style="margin-bottom:5px; margin-left:5px; font-size:17px; color:#e53935;"><b>&#8377;<?php echo $arr_order['price'];?></b></p>
                                        </div>	
    								</div>
								</div></a>
								<?php
							}
							?>
							</div>
						</div>
					</div>
				</div>
			</section>
			
			<section id="about" style="background:#eee;">
				<div class="container mt-0 pb-10 pt-0">
					<div class="row multi-row-clearfix">
					    <h1 class="title mt-15 mb-20" style="text-align:center;">Commercial <span style="color:#ff8e00;">Properties</span></h1>
						<div class="col-md-12">
						    <div class="owl-carousel-4col" data-nav="true">
                            <?php
							$sql_product = "SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `type_id` = 2 ORDER BY `property_id` DESC LIMIT 0,10";
							$exe_product = mysqli_query($connection,$sql_product);
							while($arr_order = mysqli_fetch_array($exe_product))
							{
								if($arr_order['floor'] == 0)
        						{
        						    $flr = "Ground";
        						}
        						else
        						{
        						    $flr = $arr_order['floor'];
        						}
								$get_location = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_locations` WHERE `location_id` = '".$arr_order['location_id']."'"));
                                $get_type = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_property_type` WHERE `type_id` = '".$arr_order['type_id']."'"));
                                $get_subtype = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_property_subtype` WHERE `subtype_id` = '".$arr_order['subtype_id']."'"));
                                $get_otype = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_ownership_type` WHERE `otype_id` = '".$arr_order['otype_id']."'"));
								?>	
								<a href="property-details.php?property_id=<?php echo $arr_order['property_id'];?>">
						    	<div class="item" style="background:#fff;">
									<div class="mb-20">							<div class="thumb">
											<img class="img-fullwidth" alt="" src="uploads/property/<?php echo stripslashes($arr_order['cover_photo']);?>" style="border-top-right-radius: 7px; border-top-left-radius: 7px;">
    									</div>
    									<div class="p-5 pt-5 pb-5" style="text-align:left; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc; background-color:#fff; border-bottom-right-radius: 7px; border-bottom-left-radius: 7px;">
											<h4 class="mt-5 mb-5 ml-5" style="color:#2b2b2b; font-weight:600;"><?php echo stripslashes($get_type['type']);?> - <?php echo stripslashes($get_subtype['subtype']);?></h4>
											<p style="margin-bottom:0; margin-left:5px;"><?php echo $get_location['location'];?></p>
											<?php if($arr_order['type_id'] == 1) { 
											?>
            						        <p style="margin-bottom:0; margin-left:5px;"><?php echo stripslashes($arr_order['bhk']);?>, <?php echo $flr;?> Floor</p>
            						        <?php 
            						    } 
            				            ?>
						                <?php if($arr_order['type_id'] == 2) 
						                { 
						                    ?>
						                    <p style="margin-bottom:0; margin-left:5px;"><?php echo $flr;?> Floor</p>
						                    <?php 
						                } 
						                ?>
						                <?php if($arr_order['type_id'] == 3) 
						                { 
						                    ?>
						        
						                    <?php 
						                } 
						                ?>
                                            <p style="margin-bottom:5px; margin-left:5px; font-size:17px; color:#e53935;"><b>&#8377;<?php echo $arr_order['price'];?></b></p>
                                        </div>	
    								</div>
								</div></a>
								<?php
							}
							?>
							</div>
						</div>
					</div>
				</div>
			</section>
			
			<section id="about" style="background:#003f7d;">
				<div class="container mt-0 pb-10 pt-30">
					<div class="section-content">
						<div class="">
						    <div class="col-md-3 col-xs-12 pr-10 pl-10">
						        <a href="property-list.php?type_id=1&subtype_id=1">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; background:#fff;">
							        <div class="mt-5 mb-10"><img src="images/flat.jpg" alt=""></div>
							        <div class="hpk1 mt-0 mb-0" style="background:#fff">Flat</div>
							        <p style="color:#888; margin-bottom:5px;"><?php echo $num_flat;?> Properties</p>
								</div></a>
							</div>
						    <div class="col-md-3 col-xs-12 pr-10 pl-10">
						        <a href="property-list.php?type_id=1&subtype_id=5">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; background:#fff;">
							        <div class="mt-5 mb-10"><img src="images/house.jpg" alt=""></div>
							        <div class="hpk1 mt-0 mb-0" style="background:#fff">House</div>
							        <p style="color:#888; margin-bottom:5px;"><?php echo $num_house;?> Properties</p>
								</div></a>
							</div>
						    <div class="col-md-3 col-xs-12 pr-10 pl-10">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; background:#fff;">
							        <div class="mt-5 mb-10"><img src="images/office.jpg" alt=""></div>
							        <div class="hpk1 mt-0 mb-0" style="background:#fff">Office Space</div>
							        <p style="color:#888; margin-bottom:5px;"><?php echo $num_office_space;?> Properties</p>
								</div>
							</div>
						    <div class="col-md-3 col-xs-12 pr-10 pl-10">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; background:#fff;">
							        <div class="mt-5 mb-10"><img src="images/commercial.jpg" alt=""></div>
							        <div class="hpk1 mt-0 mb-0" style="background:#fff">Commercial Space</div>
							        <p style="color:#888; margin-bottom:5px;"><?php echo $num_commercial_space;?> Properties</p>
								</div>
							</div>
						</div>
					</div>
				</div>
			</section>
			
			<section id="about">
				<div class="container mt-0 pb-10 pt-0">
					<h1 class="title mt-15 mb-20" style="text-align:center;">Our <span style="color:#ff8e00;">Services</span></h1>
					<div class="section-content">
						<div class="">
						    <div class="col-md-4 col-xs-6 pr-10 pl-10">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #003f7d; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <img src="images/icon3.png" alt=""></div>
							        </div>
							        <div class="hpk mt-0 mb-5">Land Searching</div>
								</div>
							</div>
						    <div class="col-md-4 col-xs-6 pr-10 pl-10">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #003f7d; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <img src="images/icon5.png" alt=""></div>
							        </div>
							        <div class="hpk mt-0 mb-5">Land/Flat Registry</div>
								</div>
							</div>
						    <div class="col-md-4 col-xs-6 pr-10 pl-10">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #003f7d; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <img src="images/icon1.png" alt=""></div>
							        </div>
							        <div class="hpk mt-0 mb-5">Construction</div>
								</div>
							</div>
						    <div class="col-md-4 col-xs-6 pr-10 pl-10">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #003f7d; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <img src="images/icon2.png" alt=""></div>
							        </div>
							        <div class="hpk mt-0 mb-5">Interior Design</div>
								</div>
							</div>
						    <div class="col-md-4 col-xs-6 pr-10 pl-10">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #003f7d; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <img src="images/icon4.png" alt=""></div>
							        </div>
							        <div class="hpk mt-0 mb-5">Loan</div>
								</div>
							</div>
						    <div class="col-md-4 col-xs-6 pr-10 pl-10">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #003f7d; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <img src="images/icon6.png" alt=""></div>
							        </div>
							        <div class="hpk mt-0 mb-5">Rental Agreement</div>
								</div>
							</div>
						</div>
					</div>
				</div>
			</section>
			
			<section id="about" style="background:#eee;">
				<div class="container mt-0 pb-10 pt-0">
					<div class="row multi-row-clearfix">
					    <h1 class="title mt-15 mb-20" style="text-align:center;">Properties in <span style="color:#ff8e00;">Kolkata</span></h1>
						<div class="col-md-12">
						    <div class="owl-carousel-4col" data-nav="true">
                            <?php
							$sql_product = "SELECT * FROM `pd_property` WHERE `property_status` = 'Active' AND `location_id` IN ('1','2','3','4') ORDER BY `property_id` DESC LIMIT 0,10";
							$exe_product = mysqli_query($connection,$sql_product);
							while($arr_order = mysqli_fetch_array($exe_product))
							{
								if($arr_order['floor'] == 0)
        						{
        						    $flr = "Ground";
        						}
        						else
        						{
        						    $flr = $arr_order['floor'];
        						}
								$get_location = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_locations` WHERE `location_id` = '".$arr_order['location_id']."'"));
                                $get_type = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_property_type` WHERE `type_id` = '".$arr_order['type_id']."'"));
                                $get_subtype = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_property_subtype` WHERE `subtype_id` = '".$arr_order['subtype_id']."'"));
                                $get_otype = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `pd_ownership_type` WHERE `otype_id` = '".$arr_order['otype_id']."'"));
								?>	
								<a href="property-details.php?property_id=<?php echo $arr_order['property_id'];?>">
						    	<div class="item" style="background:#fff;">
									<div class="mb-20">							<div class="thumb">
											<img class="img-fullwidth" alt="" src="uploads/property/<?php echo stripslashes($arr_order['cover_photo']);?>" style="border-top-right-radius: 7px; border-top-left-radius: 7px;">
    									</div>
    									<div class="p-5 pt-5 pb-5" style="text-align:left; border: 1px solid #ccc; box-shadow: -3px 5px 7px 0px #ccc; background-color:#fff; border-bottom-right-radius: 7px; border-bottom-left-radius: 7px;">
											<h4 class="mt-5 mb-5 ml-5" style="color:#2b2b2b; font-weight:600;"><?php echo stripslashes($get_type['type']);?> - <?php echo stripslashes($get_subtype['subtype']);?></h4>
											<p style="margin-bottom:0; margin-left:5px;"><?php echo $get_location['location'];?></p>
											<?php if($arr_order['type_id'] == 1) { 
											?>
            						        <p style="margin-bottom:0; margin-left:5px;"><?php echo stripslashes($arr_order['bhk']);?>, <?php echo $flr;?> Floor</p>
            						        <?php 
            						    } 
            				            ?>
						                <?php if($arr_order['type_id'] == 2) 
						                { 
						                    ?>
						                    <p style="margin-bottom:0; margin-left:5px;"><?php echo $flr;?> Floor</p>
						                    <?php 
						                } 
						                ?>
						                <?php if($arr_order['type_id'] == 3) 
						                { 
						                    ?>
						        
						                    <?php 
						                } 
						                ?>
                                            <p style="margin-bottom:5px; margin-left:5px; font-size:17px; color:#e53935;"><b>&#8377;<?php echo $arr_order['price'];?></b></p>
                                        </div>	
    								</div>
								</div></a>
								<?php
							}
							?>
							</div>
						</div>
					</div>
				</div>
			</section>
			
			<section id="about" style="background:#ff8e00;">
				<div class="container mt-0 pb-10 pt-0">
				    <h1 class="title mt-20 mb-20 text-white" style="text-align:center;">BHK Choice in Mind</h1>
					<div class="section-content">
						<div class="">
						    <div class="col-md-3 col-xs-6 pr-10 pl-10">
						        <a href="property-list.php?type_id=1&bhk=1BHK">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; background:#fff;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #ff8e00; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <i class="fa fa-home" style="color:#003f7d; font-size:50px;"></i></div>
							        </div>
							        <div class="hpk mt-0 mb-0" style="background:#fff">1 BHK</div>
							        <p style="color:#888; margin-bottom:5px;"><?php echo $num_1bhk;?> Properties</p>
								</div></a>
							</div>
						    <div class="col-md-3 col-xs-6 pr-10 pl-10">
						        <a href="property-list.php?type_id=1&bhk=2BHK">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; background:#fff;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #ff8e00; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <i class="fa fa-home" style="color:#003f7d; font-size:50px;"></i></div>
							        </div>
							        <div class="hpk mt-0 mb-0" style="background:#fff">2 BHK</div>
							        <p style="color:#888; margin-bottom:5px;"><?php echo $num_2bhk;?> Properties</p>
								</div></a>
							</div>
						    <div class="col-md-3 col-xs-6 pr-10 pl-10">
						        <a href="property-list.php?type_id=1&bhk=3BHK">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; background:#fff;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #ff8e00; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <i class="fa fa-home" style="color:#003f7d; font-size:50px;"></i></div>
							        </div>
							        <div class="hpk mt-0 mb-0" style="background:#fff">3 BHK</div>
							        <p style="color:#888; margin-bottom:5px;"><?php echo $num_3bhk;?> Properties</p>
								</div></a>
							</div>
						    <div class="col-md-3 col-xs-6 pr-10 pl-10">
						        <a href="property-list.php?type_id=1&bhk=4BHK">
							    <div style="padding:10px 20px; border-radius:5px; margin-bottom:20px; text-align:center; background:#fff;">
							        <div class="mt-5 mb-10">
							            <div style="border:4px solid #ff8e00; text-align:center; padding:19px; border-radius:50%; position:relative; margin:0 auto; margin-top:15px; width:100px;">
							            <i class="fa fa-home" style="color:#003f7d; font-size:50px;"></i></div>
							        </div>
							        <div class="hpk mt-0 mb-0" style="background:#fff">4 BHK</div>
							        <p style="color:#888; margin-bottom:5px;"><?php echo $num_4bhk;?> Properties</p>
								</div></a>
							</div>
						</div>
					</div>
				</div>
			</section>
			<!-- page template area end -->
  
<?php require_once("footer1.php");?>
