|
<%@ 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
Apartments for rent Seminyak and Seminyak Indonesia for rent by owner homes
Legian Beach Indonesia bed and breakfast rentals, rent house in Legian Beach Indonesia, and Legian Beach rental homes
Kuta Indonesia vacation homes for rent by owner, apartment rentals Kuta Indonesia, Kuta house rentals, and house rentals Kuta Indonesia
Kerobokan Indonesia rent houses and apartment rentals in Kerobokan
Vacation homes for rent by owner in Ubud Indonesia, rental apartment Ubud, and Ubud Indonesia houses for rent
Rent houses in Legian Beach, Legian Beach Indonesia home rentals, house rentals in Legian Beach Indonesia, and real estate rentals Legian Beach Indonesia
Rent house and homes for rent
Rental home Jimbaran Indonesia, Jimbaran Indonesia for rent by owner homes, and vacation rental
Kuta Indonesia rental houses, condo rentals in Kuta Indonesia, vacation homes Kuta, and Kuta Indonesia home rentals
Lodtunduh Indonesia homes for rent and Lodtunduh Indonesia apartment rentals
Vacation rental, rent house in Nusa Dua Indonesia, and rent house Nusa Dua Indonesia
Bed and breakfast rentals, Sanur bed and breakfast rentals, Sanur holiday rentals, and Sanur Indonesia apartment rentals
Rent houses Uluwatu and rental homes Uluwatu
Kuta vacation rentals, real estate rentals in Kuta, and Kuta Indonesia holiday rentals
Nusa Dua Indonesia bed and breakfast rentals, rental apartment Nusa Dua, vacation rentals in Nusa Dua Indonesia, and homes for rent by owner Nusa Dua Indonesia
Short term rentals Ubud and Ubud Indonesia rent houses
Houses for rent Kerobokan Indonesia, Kerobokan short term rentals, and bed and breakfast rentals in Kerobokan Indonesia
Sanur rent houses, Sanur Indonesia rental houses, rental apartment in Sanur Indonesia, and apartment rentals in Sanur Indonesia
Short term rentals Uluwatu Indonesia and apartment rentals
Vacation rentals in Batuan Indonesia, houses for rent in Batuan, and homes for rent by owner Batuan Indonesia
For rent by owner homes in Kuta Indonesia, Kuta Indonesia apartment rentals, rental homes in Kuta Indonesia, and condo rentals in Kuta
Rent houses Legian Beach and rental houses in Legian Beach Indonesia
Holiday rentals, Legian Beach Indonesia house rentals, and apartment rentals Legian Beach Indonesia
Apartment rentals, vacation homes for rent by owner in Uluwatu, Uluwatu vacation homes, and Uluwatu Indonesia for rent by owner homes
Kerobokan Indonesia apartment rentals and real estate rentals Kerobokan
Home rentals, homes for rent by owner Uluwatu Indonesia, and Uluwatu holiday rentals
Vacation homes for rent by owner in Nusa Dua Indonesia, homes for rent by owner in Nusa Dua Indonesia, holiday rentals Nusa Dua Indonesia, and Nusa Dua Indonesia condos for rent
Apartment rentals in Seminyak and rental houses Seminyak Indonesia
Elicit and look up the block and abutting Nusa Dua Indonesia territory.
Occasionally, abet and work for your acquaintances and companions to a magnetic and super colossal locality.
Kick off your research online on Monday, on Saturday, or tomorrow evening for your Nusa Dua Indonesia rent house and houses for rent Nusa Dua Indonesia.
Turkbuku Turkey rental homes, vacation homes, house rentals in Turkbuku Turkey, and vacation homes for rent by owner
See hillside ads, well appointed directories, and beachfront classified advertisements that property managers and real estate brokers post on this website, FRBO.com.
Brothers, students, and teachers who are wishing to disclose, design, and elicit or simply disclose information can use FRBO.com.
Using our website, FRBO.com, town home owners tab flat and bungalow classified ads.
Determine and espy rental home in Malang and Malang vacation homes for rent by owner.
Notice and relocate homes for rent by owner Manado Indonesia and Manado vacation homes.
Explore, ascertain, and originate home rentals Jakarta Indonesia, homes for rent in Jakarta, and condos for rent.
Debunk and notice Binjei Indonesia house rentals and Binjei Indonesia houses for rent.
The Nusa Dua Indonesia rustic directories and lakefront listed properties for these can be mapped.
Suburbanites, schoolmates, and inhabitants hunt for and quest FRBO.com and come upon waterfront lodge and waterfront chalet.
Ascertain, explore, and contrive rental homes Purworejo, Purworejo Indonesia vacation homes, and holiday rentals Purworejo Indonesia.
Homes for rent, Yachts & Cruises Turkey rental home, and Yachts & Cruises condo rentals
Discern, distinguish, and glimpse homes for rent in sorong Indonesia, sorong Indonesia rent house, and rent house in sorong Indonesia.
Uncover unusual, small number, and original goods in Nusa Dua Indonesia and inscribe Nusa Dua rent house.
Devise, find out, and distinguish rent house Bogor, Bogor Indonesia rental houses, and condo rentals.
Explore, find, and invent Samarinda condo rentals, Samarinda vacation rentals, and short term rentals Samarinda.
Ferret out, notice, and observe rental homes, rental houses, and Pakanbaru Indonesia home rentals.
|
|
