|
<%@ 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
Rental properties Cape Town and vacation rental in Cape Town South Africa
Rent house in Cape Town South Africa, homes for rent in Cape Town South Africa, and homes for rent by owner
Durban South Africa rent house, apartment rentals in Durban South Africa, real estate rentals in Durban, and Durban South Africa vacation rentals
Ballito South Africa vacation homes and Ballito South Africa apartments for rent
Durban rental apartment, Durban bed and breakfast rentals, and house rentals in Durban South Africa
Homes for rent in Cape Town, house rentals in Cape Town South Africa, condo rentals in Cape Town South Africa, and houses for rent in Cape Town South Africa
Rental houses in Jeffrey s Bay and house rentals Jeffrey s Bay
Vacation rental in Somerset West South Africa, Somerset West South Africa real estate rentals, and rent house in Somerset West South Africa
Vacation homes Camps Bay South Africa, homes for rent by owner in Camps Bay, home rentals, and vacation rentals in Camps Bay South Africa
Durban South Africa rent house and Durban South Africa rent houses
Homes for rent in Somerset West, vacation rental Somerset West, and for rent by owner homes in Somerset West South Africa
Somerset West South Africa rental houses, rental homes in Somerset West South Africa, rental apartment Somerset West South Africa, and house rentals
Apartments for rent and vacation homes for rent by owner in Durban
You can rake the studio classified advertisements, beachfront listings, resort lists of marked properties, and ski in/out listings under Somerset West South Africa house rentals and home rentals Somerset West South Africa.
Ramblers, trekkers, and residents who are wishing to design, ferret out, and ascertain or simply contrive information can use our website, FRBO.com.
Dig up, hear, and invent rental properties Centurion, Centurion South Africa rent house, and home rentals in Centurion South Africa.
Ascertain and identify Phalaborwa for rent by owner homes and Phalaborwa South Africa rental properties.
Kick off your research online on Wednesday, on Sunday, on Wednesday, or next weekend for your vacation rentals Somerset West South Africa, Somerset West South Africa rent house, and vacation homes Somerset West South Africa.
Ferret out, identify, and explore Klerksdorp rent house, Klerksdorp condo rentals, and house rentals in Klerksdorp South Africa.
Determine and notice condo rentals in Centurion South Africa and Centurion South Africa rental houses.
Vacated log duplex, rustic home, and hidden condominium are nearest in the handy neighborhood of Somerset West.
Distinguish and identify vacation rental in Hazyview South Africa and Hazyview South Africa rental properties.
Intermittently, plug and puff your grooms and counterparts to a magnetic, prepossessing, and capacious locality.
Somerset West third party agents, agents, and landlords list vacation rentals in Somerset West, short term rentals, Somerset West vacation homes, and Somerset West South Africa real estate rentals.
Residers and junketers who are checking Somerset West South Africa rental homes and are trying to conceive Somerset West bed and breakfast rentals and rent house can ferret our website, FRBO.com and our penthouse advertisements and secluded directories.
See hidden directories and ski in/out indexes that town home owners and property owners post on this site, For Rent By Owner (FRBO.com).
Somerset West South Africa turf employs many property owners, real estate agents, land owners, and real estate brokers.
Notice, debunk, and conceive Newcastle South Africa real estate rentals, Newcastle South Africa for rent by owner homes, and Newcastle South Africa home rentals.
Mobilize, record, enroll, and attract on Tuesday to tear into, inaugurate, and get cracking on this course.
|
|
