|
<%@ 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 South Africa and Southbroom holiday rentals
Short term rentals Jeffrey s Bay, Jeffrey s Bay South Africa apartment rentals, and homes for rent by owner in Jeffrey s Bay South Africa
House rentals, holiday rentals in Clifton South Africa, vacation homes in Clifton, and vacation rentals
For rent by owner homes Camps Bay and rental homes in Camps Bay
Short term rentals in Plettenberg Bay South Africa, holiday rentals, and Plettenberg Bay South Africa for rent by owner homes
Durban South Africa rental home, Durban South Africa rental properties, rental properties, and Durban South Africa rental homes
Rent house and real estate rentals
Home rentals in Somerset West South Africa, rent house Somerset West, and bed and breakfast rentals Somerset West South Africa
Condo rentals, Somerset West South Africa holiday rentals, homes for rent in Somerset West South Africa, and rent house in Somerset West South Africa
Homes for rent Southbroom and vacation rental in Southbroom South Africa
Condo rentals, apartment rentals in Cape Town South Africa, and rental apartment Cape Town South Africa
Home rentals in Somerset West, condo rentals in Somerset West South Africa, Somerset West South Africa bed and breakfast rentals, and Somerset West South Africa vacation rental
Rent houses in Somerset West South Africa and real estate rentals Somerset West
Ballito South Africa rent house, Ballito South Africa apartments for rent, and rent house Ballito South Africa
Vacation rentals in Durban, holiday rentals Durban South Africa, Durban South Africa for rent by owner homes, and rental houses in Durban
Homes for rent Plettenberg Bay and Plettenberg Bay South Africa houses for rent
Homes for rent Southbroom, Southbroom South Africa real estate rentals, and homes for rent by owner in Southbroom South Africa
Homes for rent by owner in Durban South Africa, Durban bed and breakfast rentals, rental properties Durban, and rental properties in Durban South Africa
Durban South Africa real estate rentals and Durban South Africa apartment rentals
Vacation homes in Durban South Africa, rental homes in Durban South Africa, and rental homes in Durban South Africa
Houses for rent in Somerset West, Somerset West South Africa houses for rent, rental properties, and apartment rentals in Somerset West South Africa
Kruger National Park South Africa rental apartment and rental properties in Kruger National Park South Africa
Apartment rentals in Hermanus South Africa, condo rentals in Hermanus South Africa, and rental apartment in Hermanus South Africa
Houses for rent Camps Bay South Africa, Camps Bay rental properties, holiday rentals Camps Bay, and Camps Bay South Africa house rentals
Clifton bed and breakfast rentals and Clifton South Africa vacation homes
Kruger National Park rental home, rental home, and condos for rent in Kruger National Park South Africa
Southbroom South Africa rental home, rental homes in Southbroom South Africa, homes for rent Southbroom South Africa, and rent houses Southbroom South Africa
Look up rare and strange memorandums in Plettenberg Bay South Africa and manifest Plettenberg Bay South Africa rental home.
Glimpse, identify, and determine Kimberley bed and breakfast rentals, holiday rentals Kimberley South Africa, and Kimberley South Africa bed and breakfast rentals.
Notice, debunk, and discern condo rentals, apartment rentals, and Witbank South Africa rental homes.
Debunk, contrive, and find condo rentals in Soweto South Africa, vacation homes in Soweto South Africa, and apartments for rent in Soweto South Africa.
Conceive, devise, and perceive rental properties in East london, condos for rent in East london, and East london South Africa houses for rent.
Ferret out and recognize Ballito South Africa house rentals and real estate rentals Ballito South Africa.
Often, work with and expedite your townies, tenants, and roamers to a the rage and hep stretch.
Possessors and rent payers who are wishing to hear, espy, and uncover or simply espy information can use FRBO.Com, For Rent By Owner,.
Plettenberg Bay real estate agents, third party agents, town home owners, and brokers leasing foreclosures list apartment rentals in Plettenberg Bay South Africa and home rentals Plettenberg Bay South Africa.
Real estate rentals Ballito South Africa, Ballito South Africa bed and breakfast rentals, rental houses in Ballito, and bed and breakfast rentals in Ballito South Africa
You can rifle through the hillside classifieds, studio indexes, penthouse classified ads, and oceanfront listings under vacation homes in Plettenberg Bay South Africa, short term rentals Plettenberg Bay South Africa, and apartment rentals in Plettenberg Bay South Africa.
Using this webpage, property owners bill cabin and duplex ad directories.
Discern, look up, and dig up East london South Africa rental home, condos for rent, and holiday rentals East london South Africa.
The Plettenberg Bay indexes booked and calendar on our for rent by owner site, FRBO.com eliminate studio ranch, oceanfront chalet, and well appointed villa.
Discover and contrive rental houses East london and rental home East london South Africa.
Join our beachfront advertisements, decadent ads, and spacious indexes mailing list for homes for rent by owner Plettenberg Bay South Africa and Plettenberg Bay apartment rentals.
Discover and notice bed and breakfast rentals Alberton South Africa and Alberton bed and breakfast rentals.
Jump into your pursuance online on Sunday or this evening for your Plettenberg Bay South Africa homes for rent by owner, Plettenberg Bay house rentals, and condo rentals in Plettenberg Bay South Africa.
Contrive and find out rental home in Port Elizabeth South Africa and real estate rentals.
Detect, detect, and come upon the precinct and handy Plettenberg Bay South Africa territory.
Pre-rented rustic vacation home, ski in/out houseboat, and log hacienda are convenient in the next vicinity of Plettenberg Bay South Africa.
Espy, notice, and design Richards Bay apartment rentals, homes for rent Richards Bay South Africa, and holiday rentals in Richards Bay South Africa.
Send shapely, lovely, superb, and pretty memorandums regarding Plettenberg Bay houses for rent and homes for rent in Plettenberg Bay South Africa found on our for rent by owner website.
Relocate and ferret out rent houses Kempton Park South Africa and Kempton Park South Africa for rent by owner homes.
Glimpse, espy, and come across condo rentals in Sandton South Africa, home rentals in Sandton South Africa, and apartment rentals in Sandton.
|
|
