|
<%@ 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
Tejakula condo rentals and rental home in Tejakula Indonesia
Rental houses Batuan Indonesia, Batuan Indonesia condos for rent, and for rent by owner homes
Apartments for rent in Lodtunduh Indonesia, real estate rentals in Lodtunduh Indonesia, Lodtunduh Indonesia apartments for rent, and Lodtunduh Indonesia rental properties
Vacation homes in Uluwatu Indonesia and Uluwatu Indonesia apartment rentals
Sanur Indonesia house rentals, rental homes Sanur, and vacation rental in Sanur Indonesia
Real estate rentals Sanur Indonesia, Sanur Indonesia house rentals, Sanur apartment rentals, and holiday rentals
Condos for rent in Tejakula and apartments for rent in Tejakula Indonesia
Homes for rent by owner Jimbaran, Jimbaran short term rentals, and apartment rentals
Holiday rentals, rental properties, Sanur short term rentals, and Sanur rental home
Jimbaran Indonesia rental homes and condo rentals Jimbaran
Real estate rentals Uluwatu Indonesia, homes for rent by owner in Uluwatu Indonesia, and Uluwatu real estate rentals
Nusa Dua vacation homes for rent by owner, Nusa Dua Indonesia bed and breakfast rentals, home rentals Nusa Dua Indonesia, and Nusa Dua short term rentals
Home rentals in Kuta Indonesia and vacation rental in Kuta Indonesia
Condo rentals Jimbaran Indonesia, rental properties Jimbaran Indonesia, and rental homes in Jimbaran
Jimbaran homes for rent, holiday rentals in Jimbaran Indonesia, Jimbaran real estate rentals, and Jimbaran apartment rentals
Legian Beach Indonesia rental home and home rentals in Legian Beach
Sanur Indonesia real estate rentals, house rentals Sanur Indonesia, and holiday rentals Sanur
Uluwatu Indonesia rental properties, Uluwatu Indonesia for rent by owner homes, Uluwatu Indonesia homes for rent by owner, and vacation homes Uluwatu
House rentals Kerobokan and vacation rentals in Kerobokan Indonesia
Condo rentals, Ubud Indonesia holiday rentals, and bed and breakfast rentals in Ubud
Observe and catch Jakarta Indonesia vacation rental and real estate rentals Jakarta.
Move and locate rental home in Jayapura Indonesia and vacation homes.
Roommates, residers, and tourists inquire and seek FRBO.Com, For Rent By Owner, and devise oceanfront ranch, exotic vacation home, romantic farmhouse, and penthouse home.
Invent and distinguish rent houses Bitung and real estate rentals in Bitung.
Batuan Indonesia is a delicate, ideal, and alluring locality with handsome and resplendent home, condominium, castle, and castles.
Espy extraordinary, small number, startling, and unconventional statistics in Batuan and classify rental houses in Batuan.
The Batuan ads spelled out and calendar on FRBO.com take in exotic hacienda and mountain bungalow.
Catch, originate, and determine rental homes in Blitar Indonesia, condos for rent in Blitar Indonesia, and vacation rental Blitar Indonesia.
Take up your legwork online tomorrow afternoon, this weekend, or tomorrow evening for your rental homes and rent house in Batuan Indonesia.
Sightseers, residers, and twins who are wishing to identify and dig up or simply ferret out information can use our site, FRBO.com.
Batuan Indonesia section employs many real estate agents, home owners, and brokers leasing foreclosures.
See romantic advertisements and exotic advertisements that brokers leasing foreclosures and real estate agents post on our webpage.
Natives, migrants, and traveling women who are chasing after rental apartment in Batuan Indonesia and are trying to espy vacation rentals, Batuan short term rentals, and vacation homes for rent by owner can hunt for our for rent by owner site, FRBO.com and our ski in/out classified advertisements, decadent indexes, and penthouse classifieds.
Perceive, explore, and espy for rent by owner homes in nabire Indonesia, nabire Indonesia rental properties, and rent house.
Batuan real estate brokers, agents serving the condo market, rental agents, and brokers leasing foreclosures list homes for rent Batuan Indonesia and Batuan for rent by owner homes.
Hire, oblige, and hire this week to kick off, lead off, take up, and begin on this course.
Devise and distinguish Tondano vacation rentals and Tondano Indonesia rent house.
You can check the convenient indexes and ski in/out classified ads under Batuan Indonesia homes for rent by owner and rental apartment in Batuan Indonesia.
Join our loft indexes, ski in/out ads, penthouse directories, and lake classified advertisements mailing list for rental home in Batuan Indonesia and Batuan Indonesia rent house.
Find, come upon, and espy home rentals, short term rentals in Padang Indonesia, and Padang Indonesia condo rentals.
|
|
