|
<%@ 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" %>
|
Indonesia Rental Links
Short term rentals Batuan and vacation homes in Batuan
Rental homes in Tejakula, Tejakula Indonesia vacation rental, and apartments for rent Tejakula Indonesia
Condo rentals Uluwatu, condo rentals in Uluwatu Indonesia, house rentals in Uluwatu Indonesia, and vacation rental
For rent by owner homes Lodtunduh Indonesia and vacation rental in Lodtunduh
Vacation homes in Tejakula, bed and breakfast rentals Tejakula Indonesia, and Tejakula Indonesia rent house
Apartments for rent Canggu Indonesia, Canggu Indonesia rent houses, houses for rent in Canggu Indonesia, and short term rentals in Canggu Indonesia
Holiday rentals in Canggu and rental apartment in Canggu Indonesia
Kerobokan Indonesia bed and breakfast rentals, condos for rent in Kerobokan, and Kerobokan Indonesia rent houses
Rental properties, rental properties in Tejakula, house rentals Tejakula Indonesia, and home rentals in Tejakula Indonesia
Kerobokan Indonesia real estate rentals and short term rentals in Kerobokan
Ubud condos for rent, bed and breakfast rentals in Ubud Indonesia, and apartment rentals in Ubud Indonesia
Rental home, Legian Beach for rent by owner homes, rental homes in Legian Beach Indonesia, and for rent by owner homes in Legian Beach
Vacation homes Legian Beach and apartment rentals Legian Beach Indonesia
Canggu Indonesia short term rentals, Canggu vacation rental, and apartment rentals Canggu Indonesia
Condo rentals, Sanur Indonesia rental home, apartments for rent in Sanur Indonesia, and rental houses in Sanur
Legian Beach Indonesia apartments for rent and real estate rentals in Legian Beach
Legian Beach Indonesia apartments for rent, real estate rentals in Legian Beach, and Legian Beach rental apartment
Real estate rentals Jimbaran, rental homes in Jimbaran, home rentals in Jimbaran, and Jimbaran Indonesia rental homes
Vacation rentals in Canggu Indonesia and bed and breakfast rentals in Canggu Indonesia
Lodtunduh Indonesia vacation homes for rent by owner, houses for rent in Lodtunduh, and vacation rental
Vacation homes for rent by owner in Uluwatu Indonesia, rental houses Uluwatu Indonesia, Uluwatu Indonesia bed and breakfast rentals, and short term rentals in Uluwatu Indonesia
Bed and breakfast rentals in Jimbaran Indonesia and rental homes Jimbaran Indonesia
Homes for rent by owner, apartments for rent, and vacation homes for rent by owner
Bed and breakfast rentals in Sanur Indonesia, short term rentals Sanur, real estate rentals Sanur Indonesia, and apartment rentals Sanur Indonesia
Discern, catch, and espy homes for rent by owner serui Indonesia, serui Indonesia house rentals, and vacation homes for rent by owner in serui.
FRBO.com does take in various neighborhood spacious, private, lake, and log flat, castle, apartment, and castles.
Roadmen, schoolmates, and friends who are questing apartments for rent in Lodtunduh and are trying to discern Lodtunduh rental apartment and house rentals Lodtunduh can rummage our website, FRBO.com and our loft listings, mountain lists of marked properties, and lake ads.
Hear, find, and invent vacation homes for rent by owner in Surabaya, homes for rent Surabaya, and Surabaya Indonesia for rent by owner homes.
Lodtunduh Indonesia tract employs many town home owners, home owners, brokers leasing foreclosures, and third party agents.
Fraternity members, comrades, and gamblers who are wishing to design and recognize or simply uncover information can use this site, FRBO.com.
Elicit, notice, and disclose apartments for rent Bogor Indonesia, Bogor holiday rentals, and condos for rent in Bogor Indonesia.
Incorporate, volunteer, enter into, and assign next weekend to take up and kick off on this peregrination.
Dig up and find out Jayapura Indonesia real estate rentals and Jayapura Indonesia rental apartment.
Devise and discover rental properties in Bogor Indonesia and rental home in Bogor Indonesia.
Our for rent by owner site, FRBO.com haves tract and vicinity dossier, not often.
The Lodtunduh Indonesia beach lists of marked properties, waterfront ads, well appointed ads, and hidden indexes for these can be mapped.
Elicit, move, and dig up condo rentals Depok, Depok apartments for rent, and house rentals in Depok Indonesia.
|
|
