';
// // print_r($row);
// echo $detailsquery;
// echo '';
// }
$queryname = mysqli_query($dbcmls,$detailsquery) or trigger_error("Bad 1 query: " . mysqli_error($dbcmls).'
'.$detailsquery);
if ( !$queryname ) {
include 'header.php';
include 'technical.php';
include 'footer.php';
exit;
}
if ( mysqli_num_rows($queryname) > 0 ) {
// echo 'yes';
while ($row = mysqli_fetch_array($queryname)) {
// while (list($key,$val) = each($row)) {
// $$key = $val;
// }
extract( $row );
// reset($row);
}
}
else {
header("HTTP/1.0 404 Not Found");
include 'header.php';
// include 'technical.php';
$errmsg = 'Listing No Longer Available
Sorry, that listing can\'t be found. Please try again.
'."\n";
echo $errmsg;
include 'searchform.php';
include 'footer.php';
exit;
}
// if ( $_SERVER['REMOTE_ADDR'] == '172.58.174.152' ) {
echo '';
print_r($row);
echo '
';
// }
$City = ucwords(strtolower($City));
$Address = $UnparsedAddress.', '.$City.' '.$PostalCode;
// echoit('Address',$Address);
$page_title = 'Property Details: MLS Listing #'.$ListingId.' - ';
$page_title .= "$PropertySubType $PropertyType for sale";
$page_title .= " $City Real Estate" ;
//$page_title .= " - Call ". $config['company'];
$headlineproptype = 'Residential Property';
if ( $PropertyType == 'Land') {
$headlineproptype = $PropertyType. ' for Sale ';
}
elseif ( $PropertyType == 'Commercial' ) {
$headlineproptype = $PropertySubType.' Property for Sale ';
}
elseif ( $PropertyType == 'Residential' ) {
if ( $PropertySubType == '1/2 Duplex' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Condominium' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Manufactured Home' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Mobile Home' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Single Family Residence' ) {
$headlineproptype = 'Single Family Home for Sale ';
}
elseif ( $PropertySubType == 'Townhouse' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Villa' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
}
elseif ( $PropertyType == 'Residential Income' ) {
$headlineproptype = $PropertySubType.' Property for Sale ';
}
elseif ( $PropertyType == 'Residential Lease' ) {
$headlineproptype = $PropertySubType.' Property for Lease ';
}
$page_title = 'Property Details: MLS Listing #'.$ListingId.' - '.$headlineproptype . ' in '.$City;
$page_keywords = "Punta Gorda, Port Charlotte, Englewood, Venice, Burnt Store, Gulf Coast, southwest, Florida, south, Fl, fla, real estate, homes, land, lots, condos, commercial, investment, property, MLS, listings, realtor, real estate agent";
$page_description = 'Property Details: MLS Listing #'.$ListingId.' - ';
$page_description .= ( $City != 'Any city') ? " $City Real Estate - " :'';
// $page_description .= "$myprop for sale";
$headline = 'Details on MLS # ' . $ListingId;
$subhead = '';
if ( $PropertyType == 'Residential' ) {
$subhead .= (!empty($BedroomsTotal)) ?$BedroomsTotal .' Bedroom ':'';
$subhead .= ( !empty($BedroomsTotal) && !empty($BathroomsFull) ) ? ' ':'';
$subhead .= (!empty($BathroomsFull)) ? ' '.$BathroomsFull .' ' : '' ;
$subhead .= (!empty($BathroomsHalf)) ? ' '.$BathroomsHalf .'/2' : '' ;
$subhead .= (!empty($BathroomsFull)) ? ' Bathroom':'';
$subhead .= ' '.rtrim($PropertyType,'s'). ' '.$PropertySubType. ' for Sale ';
$subhead .= ($City !='' && $City!='Any city') ? ' in '.$City:'';
} else {
$subhead .= rtrim($PropertyType,'s') . ' Property for sale in ';
$subhead .= ($City != 'Any city') ? $City : 'southwest Florida' ;
}
if ( !isset($h1) ) {
$h1 = 'Property Details: MLS Listing #'.$ListingId;
}
include 'header.php';
if ( isset($PropertyType) ) {
$proptype = $PropertyType;
} else {
$proptype = 'Homes';
}
if ( $proptype == 'Commercial' ) {
$myprop = 'Commercial Property';
} else {
$myprop = $PropertyType;
}
if ( $proptype == 'Multifamily' ) {
$myprop = 'Multifamily Property';
}
if ( $proptype == 'Commercial' ) {
$myprop = 'Commercial Property';
}
if ( $proptype == 'Mobile-Home' ) {
$myprop = 'Mobile Home';
}
if ( $proptype == 'Land' ) {
$myprop = 'Vacant-Land';
}
$headlineproptype = 'Residential Property';
if ( $PropertyType == 'Land') {
$headlineproptype = $PropertyType. ' for Sale ';
}
elseif ( $PropertyType == 'Commercial' ) {
$headlineproptype = $PropertySubType.' Property for Sale ';
}
elseif ( $PropertyType == 'Residential' ) {
if ( $PropertySubType == '1/2 Duplex' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Condominium' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Manufactured Home' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Mobile Home' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Single Family Residence' ) {
$headlineproptype = 'Single Family Home for Sale ';
}
elseif ( $PropertySubType == 'Townhouse' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
elseif ( $PropertySubType == 'Villa' ) {
$headlineproptype = $PropertySubType.' for Sale ';
}
}
elseif ( $PropertyType == 'Residential Income' ) {
$headlineproptype = $PropertySubType.' Property for Sale ';
}
elseif ( $PropertyType == 'Residential Lease' ) {
$headlineproptype = $PropertySubType.' Property for Lease ';
}
echo '';
echo $headlineproptype.' in '.$City;
echo '
';
$details = '';
$details .= '';
$details .= 'MLS #'.$ListingId.'
';
$details .= ( !empty($ListPrice) && $ListPrice>1000 ) ? 'Listing Price: $'.number_format((float)$ListPrice).'
' : '';
if ($InternetAddressDisplayYN == 1) {
$details .= $UnparsedAddress.'
';
$theaddyforgeocode = $UnparsedAddress . ', ' . $City . ', ' . $UnparsedAddress . ' ' . $PostalCode;
}
$details .= $City.', '.$StateOrProvince.' '.$PostalCode.'
';
// $getpicsquery = " SELECT *, DATE_FORMAT(ListingContractDate, '%Y') as ListYear FROM Listings WHERE ListingId = '$MLSNum' ";
// $getpics = mysqli_query($dbcmls,$getpicsquery) or trigger_error("Bad 1 query: " . mysqli_error($dbcmls).'
'.$getpicsquery);
if ( isset($PhotosCount) && $PhotosCount > 0 ) {
if ( isset($_GET['showme']) ) {
// $details .= 'hello';
}
$picstr = '';
// $picstr .= 'HERE';
$phototable = 'PhotoURLs';
$getpicsquery = " SELECT $phototable.ResourceRecordKey, $phototable.MediaURL, $phototable.ShortDescription FROM $phototable
WHERE $phototable.ResourceRecordKey = '$ListingKey' ORDER BY $phototable.DisplayOrder ASC ";
$getpics = mysqli_query($dbcmls,$getpicsquery) or trigger_error('Bad myquery: '.mysqli_error($dbcmls)."\n\n".$getpicsquery);
if ( $_SERVER['REMOTE_ADDR'] == '172.58.128.198' ) {
echo 'getpics query: '."
";
echo $getpicsquery;
echo "
";
}
// if ( !$getpics) {
// echo 'ERROR: '."
";
// mysqli_error($dbcmls);
// echo "
";
// }
$picsarry = array();
if ( $getpics && mysqli_num_rows($getpics) > 0 ) {
while ($rowpics = mysqli_fetch_assoc($getpics)) {
$picsarry[] = array(
'picurl' => $rowpics['MediaURL'],
'picdesc' => $rowpics['ShortDescription'],
);
}
}
$picstr .= '
'."\n";
$picstr .= ''."\n";
foreach ($picsarry as $apic) {
$picdesc = 'MLS #'.$ListingId. ' in ' . $City;
$picdesc = htmlentities($picdesc);
// if ( isset($apic['picdesc']) &&. strlen($apic['picdesc']) > 0 ) {
// $picdesc = $apic['picdesc'];
// }
$picstr .= '
';
$picstr .= '
';
$picstr .= '';
}
$picstr .= '
';
}
$details .= $picstr;
}
$details .= 'Property Type: '.str_replace('-',' ',$PropertyType).'
';
$details .= (!empty($PropertySubType) ) ? 'Property Style: '.ucwords(strtolower(nl2br($PropertySubType))).'
':'';
$condoarry = array('Condo','Townhouse','Villa');
if ( in_array($PropertyStyles,$condoarry) ) {
if ( ( isset($CondoFees) && $CondoFees > 0 ) || ( isset($CondoFeesTerm) && $CondoFeesTerm != '' ) ) {
$details .= 'Condo Fee: ';
if ( ( isset($CondoFees) && $CondoFees > 0 ) ) {
$details .= ' $'.number_format($CondoFees,0).' ';
}
if ( ( isset($CondoFeesTerm) && $CondoFeesTerm != '' ) ) {
$details .= ' '.$CondoFeesTerm;
}
$details .= '
';
}
}
$details .= (!empty($MHWidth) ) ? 'Width: '.ucwords(strtolower(fixcommaspaces(nl2br($MHWidth)))).'
':'';
$details .= ($City != '') ?'City: '.$City.'
': 'City: *
';
$details .= ($CountyOrParish != '') ?'County: '.$CountyOrParish.'
': 'County: *
';
if ( !empty($SubdivisionName) || !empty($SWSubdivCommunityName) ) {
$details .= 'Subdivision/Community: ';
if ( !empty($SubdivisionName) ) {
$details .= fixsubdivision(ucwords(strtolower($SubdivisionName)));
}
if ( !empty($SWSubdivCommunityName) && ( !empty($SubdivisionName) || $SubdivisionName != $SWSubdivCommunityName ) ) {
$details .= ' / ';
}
if ( !empty($SWSubdivCommunityName) ) {
$details .= fixsubdivision(ucwords(strtolower($SWSubdivCommunityName)));
}
$details .= '
';
}
if ( !empty($ComplexCommunityNameNCCB) ) {
$details .= fixsubdivision(ucwords(strtolower($ComplexCommunityNameNCCB))).'
';
}
if ( !empty($ComplexDevelopmentName) ) {
$details .= fixsubdivision(ucwords(strtolower($ComplexDevelopmentName))).'
';
}
// if (!empty($SubdivisionName) || !empty($SWSubdivCommunityName) ) {
// $details .= 'Subdivision: ';
// if (!empty($SubdivisionName) ) {
// $details .= htmlentities(fixsubdivision(ucwords(strtolower($SubdivisionName))));
// }
// if (!empty($SWSubdivCommunityName) && (!empty($SubdivisionName) || $SubdivisionName != $SWSubdivCommunityName ) ) {
// $details .= ' / ';
// }
// if (!empty($SWSubdivCommunityName) ) {
// $details .= htmlentities(fixsubdivision(ucwords(strtolower($SWSubdivCommunityName))));
// }
// $details .= '
';
// }
// $details .= (isset($BedroomsTotal) && !empty($BedroomsTotal) && $BedroomsTotal != '')?'Bedrooms: '.$BedroomsTotal.'
':'';
// $details .= (isset($BathroomsFull) && !empty($BathroomsFull))?'Bathrooms: '.$BathroomsFull.'
':'';
// $details .= (isset($BathroomsHalf) && !empty($BathroomsHalf))?'Half Baths: '.$BathroomsHalf.'
':'';
// $details .= ( !empty($BuildingAreaTotal)) ? 'Sq. Ft. Gross: '.number_format((float)$BuildingAreaTotal).'
':'';
// $details .= ( !empty($LivingArea)) ? 'Sq. Ft. Heated: '.number_format((float)$LivingArea).'
':'';
//
//
//
// $details .= (!empty($PublicRemarks) && $PublicRemarks != '.') ? '
'.fixcommaspaces(htmlentities($PublicRemarks)).'
';
$details .= (isset($PublicRemarks) && !empty($PublicRemarks) ) ? '
'.htmlentities($PublicRemarks).'
' : '';
$details .= (isset($TotalNumBuildings) && $TotalNumBuildings!=0 && $TotalNumBuildings!='')?'# of Buildings: '.$TotalNumBuildings.'
':'';
if ( isset($PoolPrivateYN) && $PoolPrivateYN == 1 ) {
$details .= 'Private Pool: Yes'.'
';
// $details .= fixcommaspaces($row['PoolFeatures']);
$details .= bulletsorcommalist($PoolFeatures,'Pool Features','h4');
}
$details .= (!empty($WaterfrontYN) ) ? 'Water Front: '.zerooneorempty(nl2br($WaterfrontYN)).'
':'';
$details .= bulletsorcommalist($WaterfrontFeatures,'Water Frontage','h4');
$details .= 'Water Access: '.zerooneorempty($STELLAR_WaterAccess)."
\n";
$details .= bulletsorcommalist($STELLAR_WaterAccess,'Water Access Type','h4');
// $details .= 'Water Frontage: '.zerooneorempty($WaterfrontYN)."
\n";
$details .= (!empty($WaterfrontFeetTotal) ) ? 'Waterfront Feet: '.fixcommaspaces(nl2br($WaterfrontFeetTotal)).'
':'';
$details .= (!empty($WaterViewYN) ) ? 'Water View: '.zerooneorempty($WaterViewYN)."
\n" : '';
$details .= bulletsorcommalist($STELLAR_WaterView,'Water View','h4');
// $details .= (!empty($WaterView) ) ? 'Water View: '.fixcommaspaces(nl2br($WaterView)).'
':'';
$details .= (!empty($WaterBodyName) ) ? 'Water Name: '.fixcommaspaces(nl2br(htmlentities($WaterBodyName))).'
':'';
$details .= '';
$details .= bulletsorcommalist($STELLAR_WaterExtras,'Water Extras','h4');
$virt = '';
$virtli = '';
$virtli2 = '';
if ( !isset($issold) || $issold == 'no' ) {
if ( ( isset($row['VirtualTourURLUnbranded']) && !empty($row['VirtualTourURLUnbranded']) ) || ( isset($row['VirtualTourURLUnbranded2']) && !empty($row['VirtualTourURLUnbranded2']) ) ) {
if ( strlen($row['VirtualTourURLUnbranded']) > 0 ) {
if ( substr($row['VirtualTourURLUnbranded'], 0, 7) == 'http://' || substr($row['VirtualTourURLUnbranded'], 0, 8) == 'https://' ) {
$virtlink = $row['VirtualTourURLUnbranded'];
} else {
$virtlink = 'http://'.$row['VirtualTourURLUnbranded'];
}
$virtli = 'Virtual Tour';
}
if ( strlen($row['VirtualTourURLUnbranded2']) > 0 ) {
if ( substr($row['VirtualTourURLUnbranded2'], 0, 7) == 'http://' || substr($row['VirtualTourURLUnbranded2'], 0, 8) == 'https://' ) {
$virtlink2 = $row['VirtualTourURLUnbranded2'];
} else {
$virtlink2 = 'http://'.$row['VirtualTourURLUnbranded2'];
}
$virtli2 = 'Virtual Tour';
}
if ( strlen($virtli) > 0 || strlen($virtli2) > 0 ) {
$virt = '';
}
}
$details .= $virt;
}
$details .= isset($row['PropertyType']) ? 'Property Type: '.str_replace('-',' ',$row['PropertyType']).'
' : '';
$details .= isset($row['PropertySubType']) ? 'Property Use or Sub Type: '.$row['PropertySubType'].'
' : '';
$details .= bulletsorcommalist($SpaFeatures,'Spa Features','h4');
if ( isset($row['CommunityFeatures']) && tww_lookupcontains('Pool',$row['CommunityFeatures']) ) {
$details .= 'Community Pool: Yes'.'
';
}
$details .= bulletsorcommalist($WaterfrontFeatures,'Water Frontage','h4');
$details .= bulletsorcommalist($STELLAR_WaterExtras,'Water Features','h4');
$details .= bulletsorcommalist($STELLAR_WaterAccess,'Water Access','h4');
$details .= bulletsorcommalist($STELLAR_AdditionalWaterInformation,'Additional Water Information','h4');
$details .= (isset($BedroomsTotal) && !empty($BedroomsTotal) && $BedroomsTotal != '') ? 'Bedrooms: '.$BedroomsTotal.'
' : '';
$details .= (isset($BathroomsFull) && !empty($BathroomsFull))?'Bathrooms: '.$BathroomsFull.'
':'';
$details .= (isset($BathroomsHalf) && !empty($BathroomsHalf))?'Half Baths: '.$BathroomsHalf.'
':'';
$details .= (!empty($BuildingAreaTotal)) ? 'Sq. Ft. Gross: '.number_format((float)$BuildingAreaTotal).'
':'';
$details .= (!empty($LivingArea)) ? 'Sq. Ft. Living Area: '.number_format((float)$LivingArea).'
':'';
if ( strlen($LivingArea) > 0 && $LivingArea > 0 && $ListPrice != 0 ) {
$costpersqft = $ListPrice/$LivingArea;
$details .= 'Cost per (heated) sqare foot: $'.number_format((float)$costpersqft).'
';
}
$details .= (isset($YearBuilt) && !empty($YearBuilt) )?'Year built: '.$YearBuilt.'
': '';
$details .= (!empty($TaxAnnualAmount))?'Taxes: $'.number_format((float)$TaxAnnualAmount).'
':'';
$details .= (!empty($NumberOfUnitsTotal)) ? 'Total Units: '.number_format((float)$NumberOfUnitsTotal, 0).'
':'';
$details .= (!empty($TaxAnnualAmount))?'Annual Tax: $'.number_format((float)$TaxAnnualAmount).'
':'';
if ( isset($PropertyType) && $PropertyType == 'Residential' ) {
if ( isset($HomesteadYN) && $HomesteadYN == 1 ) {
$details .= 'Homestead: Yes. This property has homestead exemption.
Property tax will be adjusted to reflect market value upon sale of the property.';
} elseif ( isset($HomesteadYN) && $HomesteadYN == 0 ) {
$details .= 'Homestead: No. This property does not currently have homestead exemption.';
}
}
$details .= '
';
if ( isset($CondoFees) && $CondoFees > 0 && isset($CondoFeesTerm) && strlen($CondoFeesTerm) > 0 ) {
$details .= 'Condo Fee: ';
$details .= ' $'.number_format($CondoFees,0).' ';
$details .= ' '.$CondoFeesTerm;
$details .= '
';
}
if ( isset($AssociationFeeFrequency) && $AssociationFeeFrequency > 0 && isset($AssociationFeeFrequency) && strlen($AssociationFeeFrequency) > 0 ) {
$details .= 'HOA Fee: ';
$details .= ' $'.number_format($AssociationFee,0).' ';
$details .= ' '.$AssociationFeeFrequency;
$details .= '
';
}
$details .= !empty($AssociationFeeRequirement) ? 'Association Fee Requirement: '.$AssociationFeeRequirement.'
' : '';
$details .= (!empty($TaxOtherAnnualAssessmentAmount)) ? 'Other Tax Assessments: $'.number_format((float)$TaxOtherAnnualAssessmentAmount).'
':'';
$details .= (!empty($MontlyMaintAmtAdditionToHOA) ) ? 'Add\'l Maint. Fee: $'.$MontlyMaintAmtAdditionToHOA.'
':'';
$details .= 'Taxes and fees can change periodically, and other fees may apply. '.
' Please check with your Realtor for more details.';
$details .= '';
$details .= !empty($AssociationFeeIncludes) ? 'Association Fee Includes: '.tww_turncommastolistitems(htmlentities($AssociationFeeIncludes)) : '';
if ( $PropertyType != 'Land' ) {
$details .= bulletsorcommalist($InteriorFeatures,'Interior Features','h3');
}
$details .= bulletsorcommalist($Appliances,'Appliances','h4');
// $roomarry = array();
// $myroomsquery = " SELECT RoomType, RoomArea, RoomDescription, RoomDimensions,RoomFeatures, RoomFlooring
// FROM Rooms WHERE ListingKeyNumeric = '$ListingKeyNumeric' ORDER BY RoomType * 1, RoomType ASC ";
// $myrooms = mysqli_query($dbcmls,$myroomsquery) or trigger_error('Bad myroomsquery: '.mysqli_error().$myroomsquery);
// if ( $myrooms && mysqli_num_rows($myrooms) > 0 ) {
// while ($roomsrow = mysqli_fetch_assoc($myrooms)) {
// $roomarry[$roomsrow['RoomType']] = $roomsrow;
// }
// }
// if ( isset($roomarry['Kitchen']['RoomFeatures']) && strlen(trim($roomarry['Kitchen']['RoomFeatures'])) > 0 ) {
// $details .= 'Kitchen:
'. tww_turncommastolistitems(htmlentities($roomarry['Kitchen']['RoomFeatures']));
// }
// if ( isset($roomarry['Master Bathroom']['RoomFeatures']) && strlen(trim($roomarry['Master Bathroom']['RoomFeatures'])) > 0 ) {
// $details .= 'Master Bathroom:
'. tww_turncommastolistitems(htmlentities($roomarry['Master Bathroom']['RoomFeatures']));
// }
$details .= bulletsorcommalist($AccessibilityFeatures,'Accessibility Features','h4');
// $details .= bulletsorcommalist($DisasterMitigation,'Disaster Mitigation','h4');
if ( $PropertyType != 'Commercial' && $PropertyType != 'Land' ) {
if ( isset($FireplaceYN) ) {
$details .= 'Fireplace: '.zerooneorempty($FireplaceYN)."
\n";
$details .= bulletsorcommalist($FireplaceFeatures,'Fireplace Features','h4');
// if ( strlen(zerooneorempty($FireplaceYN)) > 0 || strlen($FireplaceFeatures) > 0 ) {
// $details .= '
';
// }
}
}
$details .= bulletsorcommalist($WindowFeatures,'Window Features','h4');
if ( $PropertyType == 'Commercial' ) {
$details .= (!empty($FreezerSpaceYN) ) ? 'Freezer Space: '.zerooneorempty($FreezerSpaceYN).'
':'';
$details .= (!empty($WarehouseSpaceHeated) ) ? 'Warehouse Space - Heated: '.number_format($WarehouseSpaceHeated,0).'
':'';
$details .= (!empty($WarehouseSpaceTotal) ) ? 'Warehouse Space - Total: '.number_format($WarehouseSpaceTotal,0).'
':'';
$details .= (!empty($FlexSpaceSqFt) ) ? 'Flex Space Sq.Ft.: '.number_format($FlexSpaceSqFt,0).'
':'';
$details .= (!empty($DoorHeight) ) ? 'Door Height: '.$DoorHeight.'
':'';
$details .= (!empty($DoorWidth) ) ? 'Door Width: '.$DoorWidth.'
':'';
$details .= (!empty($NumofBays) ) ? 'Number of Bays: '.$NumofBays.'
':'';
$details .= (!empty($NumofBaysGradeLevel) ) ? 'Bays Grade Level: '.$NumofBaysGradeLevel.'
':'';
$details .= (!empty($NumofBaysDockHigh) ) ? 'Bays Dock High: '.$NumofBaysDockHigh.'
':'';
$details .= (!empty($ExistLseTenantYN)) ? 'Existing Lease Tenant: '.zerooneorempty($ExistLseTenantYN).'
':'';
$details .= (!empty($LeasableArea)) ? 'Leasable Area: '.number_format((float)$LeasableArea).'
':'';
$details .= (!empty($NetOperatingIncome)) ? 'Net Operating Income: '.number_format((float)$NetOperatingIncome).'
':'';
$details .= (!empty($NumofHotelMotelRms)) ? 'Num. Hotel/Motel Rooms: '.$NumofHotelMotelRms.'
':'';
$details .= (!empty($NumofOffices)) ? 'Num. Offices: '.$NumofOffices.'
':'';
$details .= (!empty($NumofRestrooms)) ? 'Num. Restrooms: '.$NumofRestrooms.'
':'';
$details .= (!empty($RentConcession)) ? 'Rent Concession: '.$RentConcession.'
':'';
}
$details .= bulletsorcommalist($STELLAR_AdditionalRooms,'Additional Rooms','h4');
$details .= '';
$details .= bulletsorcommalist($STELLAR_CeilingType,'Ceiling Type','h4');
$details .= (!empty($STELLAR_CeilingHeight) ) ? 'Ceiling Height: '.fixcommaspaces($STELLAR_CeilingHeight).'
':'';
$details .= bulletsorcommalist($Flooring,'Flooring','h4');
$details .= '
';
// reset($roomarry);
// $showdims = 'n';
// foreach ($roomarry as $roomkey => $roomvalue) {
// if ( (isset($roomvalue['RoomDimensions']) && strlen($roomvalue['RoomDimensions']) > 0) || (isset($roomvalue['RoomFlooring']) && strlen($roomvalue['RoomFlooring']) > 0) ) {
// $showdims = 'y';
// }
// }
// if ( $showdims == 'y' ) {
// $details .= 'Room Dimensions & Flooring'.'
';
// $details .= '';
// $details .= '';
// }
// reset($roomarry);
// foreach ($roomarry as $roomkey => $roomvalue) {
// if ( (isset($roomvalue['RoomDimensions']) && strlen($roomvalue['RoomDimensions']) > 0) || (isset($roomvalue['RoomFlooring']) && strlen($roomvalue['RoomFlooring']) > 0) ) {
// $details .= '- ';
// $details .= ''.$roomkey.':'.' ';
// $details .= $roomvalue['RoomDimensions'].' ';
// $details .= ' '.htmlentities($roomvalue['RoomFlooring']);
// $details .= '
';
// }
// }
// if ( $showdims == 'y' ) {
// $details .= '
';
// }
$details .= bulletsorcommalist($LaundryFeatures,'Laundry Features','h4');
if ( strlen($GreenIndoorAirQuality) > 0 || strlen($GreenBuildingVerificationType) > 0 || strlen($GreenEnergyEfficient) > 0 || strlen($STELLAR_GreenLandscaping) > 0 || strlen($GreenWaterConservation) > 0 ) {
$details .= 'Green Features
';
$details .= bulletsorcommalist($GreenIndoorAirQuality,'Indoor Air Quality','h4');
$details .= bulletsorcommalist($GreenBuildingVerificationType,'Green Certifications','h4');
$details .= bulletsorcommalist($GreenEnergyEfficient,'Green Energy Features','h4');
$details .= bulletsorcommalist($STELLAR_GreenLandscaping,'Green Landscaping','h4');
$details .= bulletsorcommalist($GreenWaterConservation,'GreenWater Conservation','h4');
}
if (!empty($Miscellaneous) || !empty($Miscellaneous2) ) {
$misc = $Miscellaneous.' '.$Miscellaneous2;
$details .= bulletsorcommalist($misc,'Miscellaneous','h4');
}
/// Schools
if ( $PropertyType != 'Commercial' && ( !empty($ElementarySchool) || !empty($MiddleOrJuniorSchool) || !empty($HighSchool) ) ) {
$details .= 'Schools
'."\n";
$details .= '';
$details .= (!empty($ElementarySchool)) ? 'Elementary School: '.htmlspecialchars($ElementarySchool).'
':'';
$details .= (!empty($MiddleOrJuniorSchool)) ? 'Middle/Junior High School: '.htmlspecialchars($MiddleOrJuniorSchool).'
':'';
$details .= (!empty($HighSchool)) ? 'High School: '.htmlspecialchars($HighSchool).'
':'';
$details .= '
';
}
$details .= 'Exterior & Construction
';
$details .= '';
// $details .= bulletsorcommalist($STELLAR_PropertyDescription,'Property Features','h4');
$details .= bulletsorcommalist($ArchitecturalStyle,'Architectural Style','h4');
// $details .= bulletsorcommalist($STELLAR_RoomCount,'Rooms','strong');
$details .= bulletsorcommalist($ConstructionMaterials,'Construction','strong');
$details .= bulletsorcommalist($FoundationDetails,'Foundation','strong');
$details .= bulletsorcommalist($Roof,'Roof','strong');
$details .= (!empty($GarageYN) ) ? 'Garage: '.zerooneorempty($GarageYN).'
':'';
$details .= (!empty($GarageSpaces) ) ? 'Garage Spaces: '.$GarageSpaces.'
':'';
$details .= (!empty($CarportYN) ) ? 'Carport: '.zerooneorempty($CarportYN).'
':'';
$details .= (!empty($CarportSpaces) ) ? 'Carport Spaces: '.$CarportSpaces.'
':'';
$details .= (!empty($GarageDimensions) ) ? 'Garage Dimensions: '.fixcommaspaces(nl2br($GarageDimensions)).'
':'';
$details .= (!empty($GarageDoorHeight) ) ? 'Garage Door Height: '.fixcommaspaces(nl2br($GarageDoorHeight)).'
':'';
$details .= bulletsorcommalist($ParkingFeatures,'Parking Features','strong');
$details .= bulletsorcommalist($StoriesTotal,'Floors Total','strong');
$details .= bulletsorcommalist($Levels,'Floors in Unit','strong');
$details .= bulletsorcommalist($Cooling,'Cooling','strong');
$details .= bulletsorcommalist($Heating,'Heating & Fuel','strong');
$details .= bulletsorcommalist($Electric,'Electric','strong');
$details .= bulletsorcommalist($PatioAndPorchFeatures,'Patio & Porch Features','h4');
$details .= bulletsorcommalist($SecurityFeatures,'Security Features','h4');
$details .= bulletsorcommalist($OtherStructures,'Other Structures','h4');
// $details .= bulletsorcommalist($Vegetation,'Vegetation','h4');
$details .= bulletsorcommalist($View,'View','h4');
$details .= bulletsorcommalist($Fencing,'Fencing','h4');
$details .= '
';
$details .= bulletsorcommalist($ExteriorFeatures,'Exterior Features','h4');
$details .= bulletsorcommalist($Utilities,'Utilities','h4');
$details .= bulletsorcommalist($CommunityFeatures,'Community Features','h3');
$details .= bulletsorcommalist($AssociationAmenities,'Association Amenities','h3');
if ( isset($AmenitiesAdditionalFees) && $AmenitiesAdditionalFees != '' && $AmenitiesAdditionalFees != 0 ) {
$details .= 'Amenities Additional Fees
';
$details .= '';
$details .= $AmenitiesAdditionalFees;
$details .= '
';
}
$lotarry = array('STELLAR_TotalAcreage', 'LotSizeAcres', 'LotSizeSquareFeetreFeet', 'LotSizeDimensions','RoadFrontageType','RoadFrontageFt','FrontFootage', 'DirectionFaces','OtherEquipment','STELLAR_AdjoiningProperty', 'STELLAR_CurrentAdjacentUse');
$havelotinfo = 'no';
foreach( $lotarry as $lotkey => $lotval ) {
if (!empty(${$lotval}) ) {
$havelotinfo = 'yes';
}
}
if ( $havelotinfo == 'yes' ) {
$details .= 'Lot Information
';
$details .= '';
$LotFeatures = str_replace('FloodZone', 'Flood Zone',$LotFeatures);
$details .= bulletsorcommalist($LotFeatures,'Lot Features','h4');
$details .= (!empty($FloodZoneCode)) ? 'Flood Zone Code: '.htmlspecialchars($FloodZoneCode).'
':'';
$details .= (!empty($FloodZoneDate)) ? 'Flood Zone Date: '.htmlspecialchars($FloodZoneDate).'
':'';
$details .= (!empty($FloodZonePanel)) ? 'Flood Zone Panel: '.htmlspecialchars($FloodZonePanel).'
':'';
$details .= (!empty($STELLAR_TotalAcreage) && $STELLAR_TotalAcreage != '' && $STELLAR_TotalAcreage != '0' ) ? 'Acreage Description: '.$STELLAR_TotalAcreage.'
' : '';
$details .= (!empty($LotSizeAcres) && $LotSizeAcres > 0 ) ? 'Lot Size (acres): '.round($LotSizeAcres,4).'
' : '';
$details .= (!empty($LotSizeSquareFeet) && $LotSizeSquareFeet > 0 ) ? 'Lot Size (sq. ft.): '.(float)$LotSizeSquareFeet.' square feet
' : '';
$details .= (!empty($LotSizeDimensions) && $LotSizeDimensions != '0' && $LotSizeDimensions != '') ? 'Lot Dimensions: '.$LotSizeDimensions.'
': '';
$details .= (!empty($RoadFrontageType)) ? 'Road Frontage: '.htmlspecialchars($RoadFrontageType).'
':'';
$details .= (!empty($RoadFrontageFt)) ? 'Road Frontage Feet: '.htmlspecialchars($RoadFrontageFt).'
':'';
$details .= (!empty($FrontFootage)) ? 'Front Footage: '.htmlspecialchars($FrontFootage).'
':'';
$details .= (!empty($DirectionFaces)) ? 'Front Exposure: '.fixcommaspaces($DirectionFaces).'
':'';
// $details .= bulletsorcommalist($OtherEquipment,'Site Improvements','strong');
$details .= bulletsorcommalist($STELLAR_AdjoiningProperty,'Adjoining Property','strong');
$details .= bulletsorcommalist($STELLAR_CurrentAdjacentUse,'Current Adjacent Use','strong');
$details .= (!empty($AdditionalParcelsYN) ) ? 'Additional Parcels: '.zerooneorempty($AdditionalParcelsYN).'
':'';
$details .= (!empty($AdditionalParcelsDescription) && $AdditionalParcelsDescription != '' ) ? 'Additional Parcels Description: ' .htmlentities($AdditionalParcelsDescription).'
' : '';
$details .= '
';
}
//// Legal
$details .= 'Legal Description & Other Information
'."\n";
$details .= '';
$details .= (!empty($ParcelNumber)) && trim($ParcelNumber) != 'NEWCONSTRUCTION' ? 'Parcel Number: '.htmlspecialchars($ParcelNumber).'
':'';
$details .= (!empty($ListingTerms)) ? 'Financing Available: '.fixcommaspaces(htmlentities($ListingTerms)).'
':'';
$details .= (!empty($LeasePrice)) ? 'For Lease Price: '.$LeasePrice.'
':'';
$details .= (!empty($LeaseTerm)) ? 'Lease Term: '.fixcommaspaces($LeaseTerm).'
':'';
$details .= (!empty($SeniorCommunityYN)) ? 'Senior Community: '.zerooneorempty($SeniorCommunityYN).'
':'';
$details .= !empty($PetsAllowed) ? 'Pets Allowed/Pet Policies: '.fixcommaspaces(htmlentities($PetsAllowed))."
\n" : '';
$details .= (!empty($PetRestrictions)) ? 'Pet Restrictions: '.htmlentities($PetRestrictions).'
':'';
$details .= (!empty($NumberOfPets)) ? 'Number of Pets: '.$NumberOfPets.'
':'';
$details .= (!empty($PetSize)) ? 'Pet Size Permitted: '.htmlentities($PetSize).'
':'';
$details .= (!empty($NewConstructionYN)) ? 'New Construction: '.zerooneorempty($NewConstructionYN).'
':'';
$details .= (!empty($Model)) ? 'Model: '.htmlentities($Model).'
':'';
$details .= (!empty($SpaceType)) ? 'Space Type: '.htmlspecialchars($SpaceType).'
':'';
$details .= (!empty($Zoning)) ? 'Zoning: '.htmlspecialchars($Zoning).'
':'';
$details .= (!empty($SubdivisionSectionNumber)) ? 'Subdivision Section No.: '.$SubdivisionSectionNumber.'
':'';
$details .= (!empty($ClassofSpace)) ? 'Class of Space: '.htmlspecialchars($ClassofSpace).'
':'';
$details .= (!empty($TotalNumBuildings)) ? 'Total # of Buildings: '.htmlspecialchars($TotalNumBuildings).'
':'';
$details .= (!empty($ConvertedResidenceYN)) ? 'Converted Residence: '.zerooneorempty($ConvertedResidenceYN).'
':'';
$details .= (!empty($TaxLegalDescription)) ? 'Tax Legal Desc.: '.htmlspecialchars($TaxLegalDescription).'
':'';
$details .= (!empty($Disclosures)) ? 'Disclosures: '.fixcommaspaces(htmlspecialchars($Disclosures)).'
':'';
$details .= (!empty($Easements)) ? 'Easements: '.fixcommaspaces(htmlspecialchars($Easements)).'
':'';
$details .= (!empty($PublicSurveySection)) ? 'Section: '.htmlspecialchars($PublicSurveySection).'
':'';
$details .= (!empty($PublicSurveyRange)) ? 'Range: '.htmlspecialchars($PublicSurveyRange).'
':'';
$details .= (!empty($Township)) ? 'Township: '.htmlspecialchars($Township).'
':'';
// $details .= (!empty($MntExp)) ? 'Maintenance Expense: '.fixcommaspaces($MntExp).'
':'';
$details .= '
';
// map
$apikey = 'AIzaSyBu3j1jRo4fROBOyqBkBJdjwAR_NJmDfhQ';
$haveit = false;
if (isset($Latitude) && isset($Longitude) && $Latitude > 22 && $Latitude < 30 && abs($Longitude) > 78 && abs($Longitude) < 90 ) {
$haveit = true;
}
if ( $InternetAddressDisplayYN == 1 && $haveit == true ) {
$theprice = '$'.number_format((float)$ListPrice,0);
$details .= 'Map
';
$windowcontent = '';
$windowcontent .= '
MLS# '.$ListingId.'';
$windowcontent .= '
'.$theprice.'';
$windowcontent .= $theaddyforgeocode.'
';
// $windowcontent .= '
Get Directions »';
$windowcontent .= '
Get Directions »';
$details .= '
Listing courtesy of '.htmlentities($ListOfficeName).'. ';
$details .= 'The information relating to real estate for sale on this website comes in part from the '.$mlsname.'. This information is provided exclusively for consumers\' personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS.';
$details .= '
'."\n";
echo $details;
// require_once('/home/flaidx/public_html/incsrets2018/getdetails.php');
// echo getdetails($PropertyType, $detailsquery, 'getdetails',$City);
echo 'Please call '. $config['company'].' to help you find the perfect home, condo or lot, or search again:
';
include('searchform.php');
include('footer.php');