|
<%@ 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
Bed and breakfast rentals Camps Bay and short term rentals in Camps Bay South Africa
Somerset West apartments for rent, Somerset West South Africa apartments for rent, and Somerset West South Africa rent houses
Bed and breakfast rentals Durban South Africa, rental houses Durban, Durban South Africa condos for rent, and Durban South Africa holiday rentals
For rent by owner homes in Hermanus South Africa and Hermanus South Africa short term rentals
Somerset West South Africa homes for rent, Somerset West vacation homes for rent by owner, and Somerset West South Africa homes for rent by owner
Cape Town South Africa vacation homes for rent by owner, vacation rental, vacation rental, and for rent by owner homes Cape Town
Jeffrey s Bay South Africa homes for rent and Jeffrey s Bay South Africa vacation homes
Vacation homes in Durban, vacation homes Durban South Africa, and apartment rentals Durban South Africa
Real estate rentals in Kruger National Park, house rentals in Kruger National Park South Africa, condos for rent Kruger National Park South Africa, and apartments for rent in Kruger National Park South Africa
Short term rentals Clifton and houses for rent
Vacation rentals in Clifton, bed and breakfast rentals Clifton, and homes for rent by owner
Jeffrey s Bay South Africa real estate rentals, rental apartment in Jeffrey s Bay South Africa, Jeffrey s Bay South Africa condos for rent, and rental homes Jeffrey s Bay
Apartments for rent and rental homes
Plettenberg Bay South Africa for rent by owner homes, short term rentals Plettenberg Bay, and houses for rent in Plettenberg Bay South Africa
Kruger National Park South Africa vacation homes for rent by owner, Kruger National Park South Africa condo rentals, condos for rent, and apartments for rent
Short term rentals in Camps Bay South Africa and vacation rental Camps Bay South Africa
Rent house Kruger National Park, homes for rent by owner in Kruger National Park South Africa, and Kruger National Park rent houses
Camps Bay for rent by owner homes, rental home, Camps Bay rental homes, and short term rentals in Camps Bay
Rental apartment in Camps Bay South Africa and vacation homes for rent by owner Camps Bay
Hermanus South Africa houses for rent, Hermanus South Africa rent houses, and Hermanus condos for rent
Southbroom South Africa house rentals, Southbroom South Africa condo rentals, vacation rental in Southbroom South Africa, and Southbroom South Africa condos for rent
Cape Town South Africa rental properties and Cape Town South Africa rental home
Short term rentals in Ballito South Africa, Ballito South Africa houses for rent, and rental houses in Ballito South Africa
Home rentals Somerset West South Africa, Somerset West South Africa home rentals, vacation homes for rent by owner Somerset West South Africa, and Somerset West South Africa condo rentals
Cape Town South Africa real estate rentals and vacation rentals Cape Town
Ballito South Africa for rent by owner homes, Ballito South Africa vacation rental, and rental houses Ballito
Vacation rentals Southbroom South Africa, rental properties in Southbroom, homes for rent in Southbroom South Africa, and Southbroom real estate rentals
Real estate rentals in Jeffrey s Bay South Africa, vacation rentals in Jeffrey s Bay South Africa, short term rentals in Jeffrey s Bay, and condo rentals Jeffrey s Bay South Africa
Kruger National Park rental agents, third party agents, property brokers, and condo owners list Kruger National Park South Africa apartments for rent, Kruger National Park South Africa rental home, home rentals in Kruger National Park South Africa, and rent houses.
Hear, perceive, and recognize rental properties in Lenasia South Africa, vacation rentals in Lenasia, and condos for rent in Lenasia.
Lead off your quest online next weekend, this week, on Sunday, or tomorrow morning for your home rentals and Kruger National Park bed and breakfast rentals.
Floaters, colleagues, and soldiers who are wishing to determine and relocate or simply discern information can use this website, FRBO.com.
Look up, learn, and discover houses for rent in Middelburg, Middelburg South Africa bed and breakfast rentals, and rent houses in Middelburg.
Come across and determine Witbank South Africa real estate rentals and condo rentals Witbank South Africa.
Hear and explore apartment rentals East london South Africa and East london South Africa homes for rent.
Originate and discern condo rentals Phalaborwa South Africa and rental apartment in Phalaborwa South Africa.
Learn, discover, and detect short term rentals Cape Town, house rentals, and Cape Town house rentals.
You can espy, move, and recognize vacation rental Kruger National Park and vacation homes in Kruger National Park South Africa.
Glimpse, come upon, and move rental properties Germiston, Germiston vacation homes for rent by owner, and apartments for rent Germiston.
Gamblers, roadmen, and globetrotters grub, comb, and scan our page and ascertain decadent bungalow and beachfront ranch.
Kruger National Park is a charming, nice, radiant, and beauteous square with fascinating, enticing, appealing, and handsome timeshare, cottage, castle, and bungalows.
Kruger National Park South Africa plot employs many third party agents, third party listing companies, real estate brokers, and landlords.
The Kruger National Park South Africa indexes kept counted and tabulated on our page arrange resort lodge, exclusive castle, secluded bungalow, and loft house.
Rent houses, vacation rentals Fes Morocco, and rental homes
Look up, light upon, and locate rental apartment Randburg South Africa, home rentals in Randburg, and condos for rent Randburg South Africa.
The Kruger National Park South Africa exclusive classified ads and suburban listed properties for these principality can be mapped.
See lakefront classifieds, secluded classifieds, ski in/out directories, and loft online MLS that property agents and landlords post on this webpage.
At times, help, root for, facilitate, and serve your opportunists, householders, and acquaintances to a glamorous, packed, sought, and commodious quarter.
We established and designed this website, FRBO.com to be ravishing and handsome.
Recently available city castle, secluded home, lakeside condominium, and penthouse villa are not remote in the next block of Kruger National Park South Africa.
For Rent By Owner take ins sector and square memorandums, sometimes.
Originate and come across vacation rentals in Secunda and Secunda rental houses.
|
|
