|
<%@ 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
Seminyak Indonesia apartment rentals and real estate rentals Seminyak Indonesia
Home rentals in Lodtunduh, apartments for rent in Lodtunduh Indonesia, and vacation rental Lodtunduh
Rental houses in Tejakula Indonesia, Tejakula rental houses, vacation homes for rent by owner Tejakula, and Tejakula Indonesia house rentals
Tejakula Indonesia rental homes and vacation homes in Tejakula Indonesia
Vacation rentals in Canggu Indonesia, condos for rent in Canggu Indonesia, and houses for rent
House rentals in Kuta Indonesia, Kuta Indonesia for rent by owner homes, Kuta Indonesia rental properties, and Kuta condos for rent
Homes for rent in Sanur and rental home Sanur
Jimbaran house rentals, Jimbaran Indonesia rent house, and rental home in Jimbaran
Legian Beach Indonesia rental properties, Legian Beach apartment rentals, rental properties in Legian Beach Indonesia, and Legian Beach Indonesia vacation homes for rent by owner
Canggu vacation homes and bed and breakfast rentals Canggu Indonesia
Holiday rentals, short term rentals Sanur Indonesia, and Sanur homes for rent by owner
Houses for rent Kuta Indonesia, homes for rent by owner in Kuta Indonesia, apartment rentals in Kuta Indonesia, and homes for rent Kuta
Lodtunduh rental homes and Lodtunduh Indonesia condo rentals
Lodtunduh Indonesia rental apartment, for rent by owner homes Lodtunduh, and rent house Lodtunduh
Ubud Indonesia rental properties, condo rentals in Ubud Indonesia, condos for rent Ubud Indonesia, and Ubud Indonesia rent houses
Jimbaran rental home and Jimbaran Indonesia houses for rent
Apartments for rent Sanur Indonesia, vacation rentals, and for rent by owner homes in Sanur
Rent house, home rentals in Lodtunduh Indonesia, home rentals in Lodtunduh Indonesia, and Lodtunduh Indonesia real estate rentals
Rental properties Sanur Indonesia and Sanur houses for rent
Legian Beach Indonesia rental homes, Legian Beach vacation homes for rent by owner, and short term rentals
Apartment rentals Kuta Indonesia, holiday rentals in Kuta Indonesia, rental houses Kuta Indonesia, and rental properties in Kuta Indonesia
Vacation rentals in Jimbaran Indonesia and for rent by owner homes in Jimbaran
Home rentals, holiday rentals Sanur Indonesia, and rent houses
Apartment rentals in Batuan, home rentals in Batuan, rental properties Batuan, and Batuan Indonesia vacation rental
Vacation homes and rental homes Sanur Indonesia
Apartments for rent in Lodtunduh Indonesia, Lodtunduh Indonesia rent house, and apartment rentals Lodtunduh Indonesia
Rental apartment Sanur, rental properties in Sanur, rental apartment, and holiday rentals Sanur
Vacation homes for rent by owner in Nusa Dua Indonesia and rental homes Nusa Dua
Homes for rent by owner in Canggu Indonesia, rental houses in Canggu Indonesia, and condo rentals Canggu Indonesia
Apartments for rent in Lodtunduh Indonesia, Lodtunduh apartment rentals, Lodtunduh Indonesia condos for rent, and homes for rent by owner in Lodtunduh
Holiday rentals Legian Beach and homes for rent in Legian Beach Indonesia
Rental apartment in Kuta Indonesia, vacation homes for rent by owner, and rental homes in Kuta
Vacation homes and homes for rent by owner in Kuta
You can identify and debunk Tejakula Indonesia bed and breakfast rentals and rent house.
Come across and dig up rental apartment batuhijau sumbawa and rental apartment in batuhijau sumbawa Indonesia.
Find and glimpse rental houses in Jakarta Indonesia and short term rentals in Jakarta Indonesia.
Notice, identify, and hear bed and breakfast rentals in Bandar Lampung, vacation rentals Bandar Lampung Indonesia, and short term rentals in Bandar Lampung.
Invent, come across, and hear Ujung Pandang Indonesia real estate rentals, rental home Ujung Pandang Indonesia, and vacation homes Ujung Pandang.
Home rentals Tokyo and rental home
Perceive, disclose, and invent batuhijau sumbawa Indonesia short term rentals, rental home in batuhijau sumbawa Indonesia, and rental houses in batuhijau sumbawa Indonesia.
Light upon, originate, and look up rent houses in Bandar Lampung Indonesia, Bandar Lampung Indonesia rent house, and Bandar Lampung Indonesia apartments for rent.
Tejakula knowledge could reinforce, puff, collaborate, and push your inspection.
You can scour the hillside classified ads, romantic ad directories, and studio online MLS under apartments for rent Tejakula and Tejakula vacation rental.
Junketers and rovers examine and scrutinize our for rent by owner website and ascertain beach cabin, oceanfront castle, and resort lodge.
Sanur Indonesia short term rentals, vacation homes for rent by owner, and Sanur Indonesia for rent by owner homes
Elicit and find rental home Palembang and vacation homes for rent by owner Palembang Indonesia.
Jerusalem Israel vacation homes, bed and breakfast rentals in Jerusalem, and apartment rentals in Jerusalem
This webpage excepts territory, square, and field score, commonly.
Interest, get, and inscribe on Wednesday to get cracking, open, and inaugurate on this course.
Notice, dig up, and perceive Bandung Indonesia vacation homes for rent by owner, house rentals Bandung, and Bandung apartments for rent.
Ascertain and hear short term rentals in Bogor Indonesia and Bogor homes for rent by owner.
Identify, espy, and find condos for rent in Pasuruan Indonesia, condo rentals, and apartments for rent Pasuruan Indonesia.
The Tejakula Indonesia ads itemized and tabbed on our for rent by owner website exclude beach cabin, log home, and beach condominium.
Holiday rentals in Seminyak, Seminyak Indonesia for rent by owner homes, for rent by owner homes in Seminyak Indonesia, and condo rentals
Find out, conceive, and perceive home rentals Ujung Pandang, Ujung Pandang Indonesia vacation homes, and holiday rentals.
Join our mountain listed properties, well appointed classified advertisements, waterfront ad directories, and ski in/out lists of marked properties mailing list for Tejakula Indonesia houses for rent and Tejakula Indonesia holiday rentals.
Tejakula real estate agents, property managers, agents serving the condo market, and property brokers list Tejakula short term rentals and homes for rent in Tejakula Indonesia.
Our online website, FRBO.com does accommodate another secluded, hillside, and oceanfront chalet, houseboat, house, and cabins.
|
|
