|
<%@ 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
Homes for rent Hermanus South Africa and rental properties in Hermanus South Africa
Rental homes in Hermanus South Africa, rental home in Hermanus South Africa, and vacation rentals Hermanus
Rent house, homes for rent Somerset West, home rentals in Somerset West, and vacation rentals in Somerset West South Africa
Rent house Ballito South Africa and condo rentals in Ballito
Rent houses in Ballito South Africa, rental apartment in Ballito South Africa, and vacation homes in Ballito South Africa
Rent house Durban South Africa, Durban South Africa rental home, real estate rentals Durban South Africa, and homes for rent in Durban
Holiday rentals Southbroom and rental homes in Southbroom South Africa
Homes for rent by owner in Ballito South Africa, rental properties Ballito South Africa, and homes for rent in Ballito
Cape Town South Africa real estate rentals, home rentals, apartment rentals Cape Town South Africa, and vacation homes for rent by owner in Cape Town South Africa
Homes for rent in Southbroom South Africa and vacation rentals in Southbroom South Africa
Vacation rentals Ballito South Africa, Ballito South Africa apartment rentals, and homes for rent Ballito
Southbroom South Africa apartments for rent, Southbroom houses for rent, rent houses in Southbroom South Africa, and homes for rent by owner Southbroom
Condos for rent and rent houses in Cape Town South Africa
Clifton South Africa real estate rentals, condos for rent in Clifton South Africa, and apartments for rent in Clifton
Design, move, and conceive Benoni South Africa vacation rental, real estate rentals in Benoni South Africa, and condo rentals.
The Jeffrey s Bay city lists of marked properties, hidden listed properties, and penthouse indexes for these dominion can be mapped.
Come upon, dig up, and explore Welkom South Africa house rentals, bed and breakfast rentals in Welkom South Africa, and Welkom houses for rent.
Discern, identify, and discover Midrand South Africa short term rentals, rental properties in Midrand South Africa, and Midrand home rentals.
Using this site, FRBO.com, rental property owners classify home, cottage, houseboat, and duplex listings.
We procreated and constructed FRBO.Com, For Rent By Owner, to be admirable, magnificent, and fine.
See beach listed properties, resort listed properties, exotic directories, and loft classified advertisements that real estate brokers and rental owners post on this website, FRBO.com.
Jeffrey s Bay South Africa parcel employs many property agents, rental property owners, property owners, and rental agents.
Send good-looking, marvelous, divine, and exquisite dope regarding vacation homes for rent by owner in Jeffrey s Bay, Jeffrey s Bay South Africa real estate rentals, and vacation rentals Jeffrey s Bay South Africa found on our site, FRBO.com.
Dig up and invent Randburg home rentals and bed and breakfast rentals.
Notice and contrive Malelane apartment rentals and Malelane South Africa rental home.
Ascertain, conceive, and design Malelane South Africa homes for rent, condos for rent in Malelane, and homes for rent by owner Malelane.
Glimpse, hear, and ascertain bed and breakfast rentals in Ballito, Ballito short term rentals, and Ballito vacation homes for rent by owner.
|
|
