|
<%@ 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" %>
|
Fiji Rental Links
Vacation rental Nadi and real estate rentals Nadi Fiji
Nadi Fiji rent house, Nadi Fiji vacation homes for rent by owner, and rent houses Nadi
Rental apartment in Sigatoka Fiji, Sigatoka vacation homes for rent by owner, apartments for rent Sigatoka Fiji, and Sigatoka Fiji vacation homes
Rakiraki Fiji for rent by owner homes and Rakiraki Fiji rental homes
Apartments for rent Savusavu Fiji, Savusavu Fiji homes for rent by owner, and Savusavu Fiji homes for rent
Trekkers, gypsies, and traveling men comb and root For Rent By Owner and detect romantic hacienda, decadent apartment, romantic home, and spacious castle.
Matei is a admirable and stunning precinct with sublime, pulchritudinous, and radiant timeshare and timeshares.
You can invent and recognize for rent by owner homes in Matei Fiji, rent houses Matei Fiji, and short term rentals in Matei Fiji.
Contrive and ferret out short term rentals Suva and houses for rent Suva Fiji.
Wanderers and explorers who are investigating rent houses Matei Fiji and are trying to come upon rental apartment in Matei Fiji, condo rentals, and Matei Fiji rental houses can frisk this extensive website, FRBO.com and our well appointed classifieds, waterfront advertisements, suburban classified ads, and romantic ad directories.
Contrive and come across bed and breakfast rentals and Suva condos for rent.
We actualize and constituted our for rent by owner website to be splendid, elegant, and pretty.
|
|
