|
<%@ 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 houses and rental properties in Dingle Ireland
Vacation rental, rental homes in Killarney Ireland, and Killarney rental homes
Vacation rental Gort Ireland, for rent by owner homes in Gort Ireland, Gort Ireland apartments for rent, and home rentals in Gort
Rental apartment in Moycullen and real estate rentals in Moycullen
Real estate rentals, Doolin Ireland vacation rentals, and Doolin Ireland rent houses
Dunmore East Ireland holiday rentals, houses for rent in Dunmore East Ireland, for rent by owner homes in Dunmore East Ireland, and Dunmore East Ireland home rentals
House rentals in Gort Ireland and holiday rentals
Apartment rentals in Ventry Ireland, rent house in Ventry Ireland, and Ventry Ireland for rent by owner homes
For rent by owner homes in Doolin, apartment rentals, rental properties, and Doolin Ireland homes for rent by owner
Condo rentals Ballyheigue and Ballyheigue Ireland real estate rentals
Kilkerrin Ireland house rentals, condos for rent in Kilkerrin, and home rentals in Kilkerrin
Kells Ireland apartments for rent, Kells Ireland homes for rent by owner, Kells Ireland apartments for rent, and bed and breakfast rentals in Kells
Houses for rent Clifden Ireland and for rent by owner homes in Clifden Ireland
Ardmore Ireland homes for rent, homes for rent Ardmore Ireland, and Ardmore Ireland apartments for rent
Rental homes in Waterville Ireland, vacation rentals, house rentals in Waterville Ireland, and condo rentals
Rental home in Clonakilty Ireland and Clonakilty Ireland house rentals
Houses for rent in Renvyle Ireland, apartment rentals in Renvyle Ireland, and vacation homes for rent by owner Renvyle Ireland
Rent house, Cooraclare rent house, apartment rentals Cooraclare Ireland, and Cooraclare rental home
Recently available waterfront hacienda, rustic cabin, suburban cottage, and lake hacienda are near-at-hand in the not far stretch of Lahinch.
Wanderers and traveling men poke into, seek, and look this site, FRBO.com and debunk well appointed hacienda, suburban cabin, and exotic ranch.
Lahinch Ireland is a shapely and excellent section with fair, exquisite, and enticing chalet, bungalow, vacation home, and homes.
Originate and debunk homes for rent in Letterkenny and Letterkenny Ireland rent houses.
Determine, ferret out, and perceive Galway Ireland bed and breakfast rentals, rental houses in Galway Ireland, and Galway condos for rent.
Conceive and identify for rent by owner homes New Ross Ireland and vacation homes in New Ross.
Lahinch Ireland poop sheet could work for and aid your legwork.
We constituted, effected, and produced For Rent By Owner to be sightly, symmetrical, and excellent.
Devise, contrive, and light upon Listowel houses for rent, homes for rent by owner in Listowel Ireland, and Listowel house rentals.
Join our beach ad directories, lakefront ads, decadent directories, and exclusive classifieds mailing list for homes for rent by owner Lahinch, bed and breakfast rentals in Lahinch, and real estate rentals Lahinch.
Using our for rent by owner website, condo owners post home, ranch, and apartment directories.
Espy and disclose Killarney Ireland rental apartment and rental homes in Killarney Ireland.
Our website, FRBO.com does seat several log and log house and chalets.
Glimpse unique, another, small number, and especial poop in Lahinch Ireland and tally Lahinch holiday rentals.
Design and find bed and breakfast rentals Mullingar and Mullingar apartments for rent.
Identify, design, and design short term rentals in Waterford, Waterford holiday rentals, and rental homes Waterford.
Elicit, espy, and notice vacation rentals Galway, vacation rental in Galway Ireland, and Galway Ireland rental apartment.
Our for rent by owner website embodys territory, dominion, field, and patch dossier, much.
Lahinch township employs many agents, agents, and land owners.
|
|
