|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
South Africa Rental Links
Durban South Africa homes for rent and short term rentals Durban
Rent house Camps Bay South Africa, apartment rentals Camps Bay, and Camps Bay South Africa short term rentals
Homes for rent by owner in Durban, rent house Durban South Africa, Durban rental properties, and Durban South Africa real estate rentals
Southbroom South Africa short term rentals and home rentals Southbroom
Rental apartment in Durban South Africa, short term rentals Durban South Africa, and houses for rent in Durban South Africa
Rental houses Hermanus South Africa, bed and breakfast rentals in Hermanus, home rentals in Hermanus South Africa, and Hermanus South Africa vacation homes for rent by owner
Camps Bay South Africa bed and breakfast rentals and Camps Bay South Africa homes for rent
Houses for rent in Somerset West South Africa, Somerset West South Africa real estate rentals, and rent houses in Somerset West South Africa
Vacation homes in Ballito South Africa, vacation homes in Ballito, rental home Ballito, and real estate rentals in Ballito South Africa
Short term rentals Durban South Africa and Durban South Africa rental properties
Apartment rentals in Cape Town, vacation homes for rent by owner in Cape Town South Africa, and rent house Cape Town South Africa
Rent houses in Hermanus South Africa, Hermanus South Africa house rentals, Hermanus South Africa vacation homes for rent by owner, and Hermanus bed and breakfast rentals
Short term rentals Ballito and vacation homes for rent by owner
Hermanus South Africa rental home, Hermanus rent houses, and Hermanus house rentals
Cape Town South Africa homes for rent by owner, rental apartment Cape Town, Cape Town South Africa rental apartment, and rental properties Cape Town South Africa
House rentals Kruger National Park and rental home Kruger National Park South Africa
Jeffrey s Bay vacation homes for rent by owner, vacation homes for rent by owner Jeffrey s Bay, and vacation homes Jeffrey s Bay South Africa
Southbroom South Africa vacation rentals, Southbroom South Africa rental houses, condos for rent in Southbroom South Africa, and houses for rent in Southbroom
Identify and debunk Secunda South Africa rent houses and vacation homes for rent by owner Secunda.
See beachfront online MLS, convenient online MLS, and exclusive listings that rental property owners and third party listing companies post on For Rent By Owner.
Light upon, ferret out, and discover condos for rent in Durban South Africa, short term rentals Durban South Africa, and for rent by owner homes Durban South Africa.
Cape Town South Africa is a appealing and stunning locality with foxy and superb villa, duplex, castle, and cabins.
Cape Town property agents, third party listing companies, and land owners list Cape Town apartments for rent, Cape Town house rentals, and homes for rent by owner.
Send marvelous and alluring statistics regarding Cape Town South Africa rental homes and rent houses in Cape Town South Africa found on our page.
The Cape Town South Africa lakeside online MLS and romantic ad directories for these principality can be mapped.
Ferret out, identify, and ascertain rental houses in Hazyview South Africa, real estate rentals in Hazyview, and Hazyview South Africa condo rentals.
This site, For Rent By Owner (FRBO.com) can place, conscribe, and register well appointed classifieds, exotic listed properties, and ski in/out lists of marked properties suburban classified ads, suburban ad directories, and hillside classifieds to run interference your Cape Town passage.
Determine, detect, and determine vacation rental in Westville South Africa, Westville South Africa holiday rentals, and vacation homes for rent by owner in Westville South Africa.
You can comb the lakefront advertisements, convenient lists of marked properties, and beachfront online MLS under Cape Town South Africa vacation rental and holiday rentals.
Espy unusual, sparse, express, and startling poop in Cape Town South Africa and invoice holiday rentals Cape Town.
Our for rent by owner website does incorporate express city decadent, hidden, rustic, and suburban home, house, house, and townhouses.
Gather, register, embody, and enter next weekend to get going, kick off, enter upon, and open on this ramble.
|
|
