|
<%@ 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 homes and vacation rentals in Somerset West South Africa
Ballito South Africa rental properties, holiday rentals, and Ballito South Africa apartments for rent
Southbroom South Africa vacation homes for rent by owner, Southbroom rental apartment, vacation rental in Southbroom, and holiday rentals Southbroom South Africa
Vacation rentals Cape Town South Africa and holiday rentals Cape Town South Africa
Camps Bay South Africa vacation rentals, rent houses Camps Bay South Africa, and rental properties Camps Bay South Africa
Somerset West South Africa vacation homes for rent by owner, rental apartment in Somerset West South Africa, rental houses Somerset West, and Somerset West South Africa real estate rentals
Rent houses and Hermanus South Africa holiday rentals
House rentals Plettenberg Bay, houses for rent in Plettenberg Bay South Africa, and vacation homes in Plettenberg Bay South Africa
Rental properties in Durban South Africa, Durban South Africa rent houses, rental houses in Durban South Africa, and Durban home rentals
Kruger National Park apartment rentals and Kruger National Park homes for rent by owner
Bed and breakfast rentals, holiday rentals in Plettenberg Bay, and rental homes Plettenberg Bay
Homes for rent, condo rentals in Southbroom, house rentals in Southbroom South Africa, and vacation homes in Southbroom
Vacation rental in Somerset West South Africa and for rent by owner homes in Somerset West South Africa
Holiday rentals in Hermanus, real estate rentals Hermanus, and bed and breakfast rentals in Hermanus
Southbroom rental apartment, short term rentals in Southbroom South Africa, rental houses, and vacation rental in Southbroom South Africa
Kruger National Park South Africa vacation rentals and rent houses in Kruger National Park South Africa
Condos for rent in Hermanus South Africa, Hermanus South Africa rent houses, and bed and breakfast rentals Hermanus
Vacation homes for rent by owner in Clifton South Africa, Clifton South Africa vacation homes, vacation homes for rent by owner, and Clifton South Africa vacation rental
Holiday rentals in Kruger National Park South Africa and apartment rentals in Kruger National Park South Africa
Rent houses in Cape Town South Africa, bed and breakfast rentals in Cape Town, and Cape Town condo rentals
Ballito vacation homes for rent by owner, Ballito bed and breakfast rentals, condo rentals in Ballito, and Ballito bed and breakfast rentals
Condo rentals Ballito South Africa and rental apartment
Ballito for rent by owner homes, rental homes, and Ballito South Africa condo rentals
For rent by owner homes, apartments for rent in Ballito South Africa, for rent by owner homes in Ballito, and vacation homes for rent by owner
Determine and uncover Stellenbosch real estate rentals and houses for rent in Stellenbosch South Africa.
Jump into your expedition online on Monday or on Wednesday for your for rent by owner homes in Clifton South Africa, Clifton South Africa vacation rentals, and Clifton South Africa home rentals.
Dig up, uncover, and recognize vacation homes, Sandton rental properties, and bed and breakfast rentals in Sandton.
Join our exotic advertisements and well appointed classifieds mailing list for Clifton South Africa rent houses and vacation homes for rent by owner in Clifton South Africa.
You can scan the secluded listings and loft listings under Clifton for rent by owner homes and house rentals in Clifton South Africa.
Find out and look up the zone and nearby Clifton territory.
Come upon and catch rent house Sandton and homes for rent.
Our for rent by owner website can enter into and initiate exotic online MLS, decadent classified ads, suburban ads, and private classified ads exclusive classified ads, beach indexes, and romantic advertisements to relieve your Clifton South Africa outing.
Dig up, notice, and detect Loxton South Africa rental home, Loxton South Africa bed and breakfast rentals, and Loxton condos for rent.
Detect and find houses for rent in Boksburg South Africa and vacation homes for rent by owner Boksburg South Africa.
Detect and notice home rentals in White River and homes for rent by owner in White River.
Catch, find, and determine East london South Africa apartments for rent, bed and breakfast rentals East london South Africa, and East london South Africa apartments for rent.
You can glimpse and look up homes for rent by owner and Clifton South Africa bed and breakfast rentals.
Recognize unusual, another story, novel, and individual knowledge in Clifton South Africa and numerate Clifton South Africa rental apartment.
Disclose, debunk, and perceive homes for rent in Durban South Africa, real estate rentals in Durban South Africa, and rental apartment in Durban.
Citizens and sisters-in-law who are wishing to disclose, discern, and detect or simply explore information can use our for rent by owner website.
Volunteer, appoint, induct, and muster tomorrow to lead off, inaugurate, tear into, and enter upon on this tramp.
Send taking, comely, handsome, and stunning compilations regarding vacation homes Clifton South Africa, condo rentals, and Clifton vacation homes for rent by owner found on our for rent by owner website.
Uncover and debunk rental home in Newcastle South Africa and bed and breakfast rentals Newcastle.
See ski in/out classified ads, hidden listed properties, and ski in/out lists of marked properties that third party listing companies and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
|
|
