|
<%@ 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" %>
|
Ireland Rental Links
Rent house in Clonakilty and condo rentals in Clonakilty Ireland
Houses for rent in Laytown, Laytown condos for rent, and Laytown Ireland rental apartment
Rental properties in Dunmore East Ireland, homes for rent in Dunmore East Ireland, Dunmore East Ireland apartment rentals, and Dunmore East Ireland bed and breakfast rentals
Apartment rentals Mullingar and rent house Mullingar
Apartments for rent Dingle Ireland, condos for rent, and Dingle Ireland homes for rent by owner
Rental homes in Clifden Ireland, condos for rent in Clifden Ireland, Clifden Ireland rental houses, and Clifden Ireland home rentals
Riverstown Ireland condo rentals and homes for rent in Riverstown
Homes for rent in Mullingar Ireland, rental houses in Mullingar Ireland, and condo rentals Mullingar
Rent houses in Liscannor Ireland, house rentals in Liscannor, rental home in Liscannor, and apartments for rent in Liscannor Ireland
Rental homes and vacation rental in Listowel
Riverstown Ireland houses for rent, rent house in Riverstown Ireland, and Riverstown apartment rentals
For rent by owner homes in Tipperary, for rent by owner homes in Tipperary Ireland, rent house in Tipperary, and homes for rent in Tipperary Ireland
House rentals in Kilkerrin Ireland and Kilkerrin Ireland condo rentals
Cloyne Ireland short term rentals, real estate rentals in Cloyne Ireland, and house rentals Cloyne
Home rentals Birr, rent houses in Birr Ireland, Birr Ireland vacation homes, and houses for rent in Birr
Durrus Ireland short term rentals and Durrus condo rentals
Bed and breakfast rentals in Bettystown Ireland, homes for rent by owner, and Bettystown Ireland house rentals
Rent house Doolin, real estate rentals, rent house Doolin Ireland, and vacation rental in Doolin Ireland
Bed and breakfast rentals Wicklow and vacation rental
Bruree vacation homes for rent by owner, Bruree for rent by owner homes, and home rentals in Bruree
Locate, glimpse, and disclose short term rentals in Wicklow Ireland, condos for rent in Wicklow, and Wicklow rent houses.
Glimpse and observe Waterford Ireland rental apartment and Waterford Ireland condos for rent.
Journeyers, rent payers, and roomers who are wishing to perceive and identify or simply conceive information can use For Rent By Owner.
Find out, perceive, and observe bed and breakfast rentals in Limerick, rent houses in Limerick, and rental houses.
You can glimpse and uncover real estate rentals in Ballydehob Ireland, homes for rent by owner in Ballydehob Ireland, and rental home Ballydehob.
Observe and identify Galway Ireland real estate rentals and homes for rent by owner Galway Ireland.
Elicit and disclose for rent by owner homes in Leixlip Ireland and vacation rentals in Leixlip Ireland.
Ballydehob Ireland details could reinforce, aid, cooperate, and serve your exploration.
Invent and uncover Kilkenny Ireland holiday rentals and condos for rent in Kilkenny.
Our for rent by owner website does except specific studio and lake villa and cottages.
Come across, catch, and discover real estate rentals Sligo Ireland, Sligo Ireland for rent by owner homes, and apartment rentals in Sligo Ireland.
Sisters-in-law and subordinates who are chasing after house rentals Ballydehob Ireland and are trying to relocate Ballydehob vacation rentals and Ballydehob Ireland condos for rent can ransack FRBO.Com, For Rent By Owner, and our waterfront advertisements and beachfront classified ads.
Ballydehob precinct employs many property owners and property brokers.
Our website, FRBO.com can serve and obtain beach classifieds, oceanfront ads, and lake classified ads exotic ad directories, lake advertisements, mountain advertisements, and resort classified advertisements to root for your Ballydehob Ireland travel.
Using FRBO.com, agents serving the condo market catalogue ranch and home ad directories.
Ballydehob property brokers, rental property owners, and town home owners list rental homes Ballydehob and house rentals in Ballydehob.
Espy and conceive for rent by owner homes Tralee Ireland and for rent by owner homes Tralee Ireland.
Light upon, devise, and explore Edgeworthstown rental homes, real estate rentals in Edgeworthstown, and condos for rent Edgeworthstown Ireland.
Move, design, and discern Athboy holiday rentals, Athboy Ireland holiday rentals, and vacation homes for rent by owner in Athboy Ireland.
Disclose, observe, and perceive condos for rent in Limerick Ireland, homes for rent in Limerick Ireland, and Limerick Ireland holiday rentals.
|
|
