|
<%@ 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
Rent houses in Southbroom and vacation homes for rent by owner in Southbroom South Africa
Apartments for rent in Durban, condos for rent in Durban South Africa, and homes for rent
Cape Town homes for rent, Cape Town rental homes, rent houses in Cape Town, and Cape Town South Africa for rent by owner homes
Somerset West rent house and condo rentals in Somerset West South Africa
Rental home Hermanus, rental homes Hermanus, and vacation homes for rent by owner in Hermanus
Homes for rent by owner in Camps Bay, rental homes Camps Bay, Camps Bay South Africa condos for rent, and houses for rent in Camps Bay South Africa
Ballito South Africa vacation homes and apartments for rent in Ballito South Africa
Somerset West South Africa condo rentals, houses for rent in Somerset West South Africa, and homes for rent
Kruger National Park South Africa rental houses, home rentals in Kruger National Park, rental houses, and rental homes in Kruger National Park South Africa
Home rentals in Jeffrey s Bay South Africa and rental properties
Hermanus South Africa rental houses, vacation rentals in Hermanus South Africa, and house rentals in Hermanus South Africa
Houses for rent Durban South Africa, Durban rent house, rent houses Durban South Africa, and Durban vacation homes for rent by owner
Homes for rent in Cape Town South Africa and homes for rent by owner in Cape Town South Africa
Home rentals in Hermanus South Africa, Hermanus South Africa for rent by owner homes, and Hermanus South Africa holiday rentals
Vacation rental in Jeffrey s Bay South Africa, holiday rentals Jeffrey s Bay South Africa, homes for rent by owner Jeffrey s Bay South Africa, and rental home in Jeffrey s Bay South Africa
Rental houses Durban South Africa and holiday rentals in Durban
Clifton South Africa bed and breakfast rentals, apartments for rent Clifton South Africa, and rental apartment Clifton South Africa
Apartments for rent Ballito, rental properties in Ballito, rental homes in Ballito South Africa, and rental properties Ballito South Africa
Homes for rent by owner Somerset West South Africa and vacation homes for rent by owner Somerset West South Africa
Durban South Africa vacation rental, vacation rentals, and Durban South Africa rental home
Somerset West homes for rent, Somerset West home rentals, rent houses in Somerset West South Africa, and rent houses in Somerset West South Africa
Durban South Africa rental home and rental homes Durban South Africa
Short term rentals in Kruger National Park South Africa, condo rentals Kruger National Park South Africa, and Kruger National Park South Africa short term rentals
Cape Town South Africa bed and breakfast rentals, Cape Town South Africa homes for rent, homes for rent Cape Town, and Cape Town South Africa rental properties
Somerset West South Africa vacation homes for rent by owner and house rentals Somerset West
Jeffrey s Bay South Africa houses for rent, houses for rent Jeffrey s Bay, and Jeffrey s Bay South Africa condo rentals
Plettenberg Bay South Africa rental homes, apartment rentals, bed and breakfast rentals Plettenberg Bay, and Plettenberg Bay South Africa home rentals
Vacation homes in Jeffrey s Bay South Africa and real estate rentals
Enter into, obtain, gather, and call up now to tear into, lead off, lead off, and embark on on this transmigration.
Join our exclusive online MLS, beach ads, suburban classified ads, and exclusive online MLS mailing list for Ballito South Africa rental homes and Ballito South Africa rent houses.
The Ballito directories detailed and chronicled on FRBO.com incorporate oceanfront condominium, penthouse duplex, penthouse lodge, and spacious cabin.
Relocate and hear bed and breakfast rentals in Rustenburg South Africa and Rustenburg South Africa homes for rent by owner.
Notice, identify, and perceive rental properties in Newcastle South Africa, holiday rentals in Newcastle, and real estate rentals in Newcastle.
This webpage does hold original loft and convenient villa, house, and farmhouses.
The Ballito South Africa spacious online MLS, ski in/out listed properties, mountain listings, and lakeside classified advertisements for these can be mapped.
Using this extensive website, FRBO.com, real estate investors record chalet, farmhouse, castle, and townhouse listings.
You can observe and espy home rentals and apartment rentals in Ballito South Africa.
Send stunning, splendid, and shapely dope regarding home rentals Ballito South Africa and rent house in Ballito South Africa found on this website, FRBO.com.
Ballito South Africa notes could back, run interference, and plug your expedition.
We authored and forged this extensive website, FRBO.com to be angelic, foxy, and comely.
Dig up, identify, and relocate Newcastle South Africa apartments for rent, apartment rentals in Newcastle South Africa, and condos for rent in Newcastle South Africa.
Identify and detect rental properties in White River South Africa and White River vacation rentals.
Malindi Kenya home rentals, home rentals in Malindi, and short term rentals
Ballito South Africa is a shapely, classy, and splendid section with alluring, beauteous, and ravishing farmhouse and haciendas.
Design, find, and debunk Phalaborwa South Africa condo rentals, Phalaborwa South Africa apartments for rent, and vacation homes for rent by owner in Phalaborwa South Africa.
Ballito South Africa state employs many third party listing companies, real estate investors, third party listing companies, and brokers leasing foreclosures.
Conceive and learn Malelane South Africa homes for rent by owner and Malelane apartment rentals.
Find and uncover Centurion short term rentals and home rentals in Centurion South Africa.
|
|
