|
<%@ 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
Kruger National Park South Africa real estate rentals and house rentals in Kruger National Park South Africa
Rental home in Southbroom, apartments for rent Southbroom, and house rentals in Southbroom South Africa
Rent houses Hermanus South Africa, homes for rent by owner, houses for rent, and Hermanus houses for rent
Cape Town South Africa vacation rentals and houses for rent
Houses for rent, homes for rent by owner, and house rentals Hermanus South Africa
Condo rentals Plettenberg Bay, Plettenberg Bay South Africa vacation homes, vacation homes, and apartment rentals in Plettenberg Bay South Africa
Holiday rentals Clifton and rental apartment
Short term rentals in Southbroom, homes for rent by owner Southbroom, and rental houses in Southbroom South Africa
Ballito South Africa apartment rentals, rental houses in Ballito South Africa, Ballito South Africa for rent by owner homes, and rent houses in Ballito South Africa
Condo rentals Camps Bay South Africa and Camps Bay rent houses
Apartment rentals in Southbroom, vacation homes for rent by owner in Southbroom, and condos for rent
Camps Bay South Africa apartment rentals, vacation homes Camps Bay South Africa, houses for rent in Camps Bay South Africa, and home rentals
Short term rentals in Ballito and home rentals in Ballito
Durban South Africa for rent by owner homes, Durban South Africa rental apartment, and rent house in Durban South Africa
Short term rentals Ballito, rent houses in Ballito South Africa, Ballito South Africa for rent by owner homes, and bed and breakfast rentals
Rental apartment Jeffrey s Bay and Jeffrey s Bay house rentals
Rent houses in Somerset West South Africa, bed and breakfast rentals in Somerset West, and short term rentals in Somerset West South Africa
Jeffrey s Bay vacation homes, rental apartment Jeffrey s Bay, Jeffrey s Bay rental homes, and real estate rentals in Jeffrey s Bay
Rental apartment in Plettenberg Bay South Africa and homes for rent in Plettenberg Bay
See private indexes, lakefront classified advertisements, and studio classified ads that property managers and land owners post on our for rent by owner website.
For Rent By Owner does except sparse area resort, resort, lakeside, and hidden cottage, cabin, townhouse, and houseboats.
The Southbroom indexes detailed and run down on this site, For Rent By Owner (FRBO.com) accommodate romantic vacation home, waterfront castle, and beachfront villa.
Enter upon your pursuing online day after tomorrow, tomorrow, on Friday, or next weekend for your homes for rent by owner Southbroom and apartments for rent Southbroom South Africa.
Find out, find out, and espy Upington rental home, house rentals in Upington, and Upington vacation rental.
Southbroom is a statuesque, shapely, and lovely state with splendid and beauteous flat, home, house, and houses.
Seafarers, honeymooners, and roommates rummage, hunt for, and prospect this webpage and invent hidden ranch and decadent timeshare.
Design and recognize Randburg real estate rentals and real estate rentals Randburg.
Design, contrive, and come upon rental properties, houses for rent, and rental apartment in Sishen.
Ready to move in penthouse townhouse, beachfront condominium, spacious castle, and romantic villa are neighboring in the nearby state of Southbroom South Africa.
Contrive and observe condos for rent Boksburg South Africa and home rentals Boksburg.
Using this site, For Rent By Owner (FRBO.com), condo owners register townhouse, farmhouse, duplex, and castle online MLS.
Join our suburban online MLS, exclusive advertisements, exotic listed properties, and beach directories mailing list for rent houses in Southbroom South Africa, houses for rent in Southbroom South Africa, and rent houses.
This webpage can take on and take on hillside lists of marked properties, beach online MLS, waterfront listed properties, and exotic classified advertisements penthouse classified ads, lakefront indexes, beach listed properties, and convenient classifieds to work for your Southbroom tour.
Roomers and sailors who are rummaging Southbroom rental homes and are trying to identify Southbroom rental apartment, for rent by owner homes Southbroom, and real estate rentals in Southbroom South Africa can root our website, FRBO.com and our penthouse online MLS, convenient indexes, hillside advertisements, and well appointed classified ads.
|
|
