|
<%@ 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
Cloyne real estate rentals and Cloyne rental houses
Kells condo rentals, condo rentals in Kells, and Kells Ireland for rent by owner homes
For rent by owner homes in Liscannor Ireland, real estate rentals Liscannor, for rent by owner homes, and vacation rental in Liscannor Ireland
Real estate rentals in Moycullen Ireland and apartment rentals in Moycullen Ireland
Rental home, Dublin Ireland apartment rentals, and Dublin Ireland rental homes
Short term rentals in Ballydehob, apartments for rent Ballydehob Ireland, Ballydehob Ireland apartments for rent, and home rentals in Ballydehob Ireland
Rental properties and rental properties
Home rentals, rental houses Ardmore, and Ardmore Ireland apartments for rent
Riverstown Ireland vacation homes for rent by owner, apartment rentals in Riverstown, rent houses in Riverstown, and vacation rental in Riverstown Ireland
Condo rentals in Ballinskelligs and Ballinskelligs Ireland vacation homes
Lahinch Ireland real estate rentals, Lahinch Ireland vacation rentals, and rental houses in Lahinch Ireland
Houses for rent, bed and breakfast rentals in Clifden Ireland, house rentals Clifden Ireland, and Clifden Ireland holiday rentals
Homes for rent by owner and rent house Dingle
Sneem Ireland homes for rent by owner, Sneem Ireland rent houses, and rent houses in Sneem Ireland
Clonakilty Ireland rental houses, rental apartment Clonakilty, Clonakilty bed and breakfast rentals, and Clonakilty apartment rentals
Rent houses Bell Harbour and rental houses in Bell Harbour Ireland
Vacation homes Kenmare, vacation homes for rent by owner in Kenmare Ireland, and rent houses in Kenmare Ireland
Rental homes in Inverin Ireland, rental houses Inverin Ireland, Inverin homes for rent, and Inverin condo rentals
Kenmare Ireland rental home and rental houses Kenmare Ireland
Riverstown Ireland for rent by owner homes, Riverstown rent houses, and house rentals in Riverstown
Rosscarbery Ireland home rentals, Rosscarbery Ireland house rentals, Rosscarbery Ireland homes for rent, and Rosscarbery apartments for rent
Vacation homes Inverin and rent houses Inverin Ireland
Enniscrone house rentals, Enniscrone Ireland rental properties, and Enniscrone Ireland short term rentals
Vacation homes Mullingar, rental apartment in Mullingar, Mullingar Ireland vacation homes for rent by owner, and rental home Mullingar
Clifden Ireland rental properties and vacation homes for rent by owner in Clifden
New Ross Ireland vacation homes for rent by owner, rental properties in New Ross, and home rentals New Ross Ireland
Rental homes in Waterville, home rentals in Waterville Ireland, real estate rentals in Waterville Ireland, and houses for rent in Waterville Ireland
Short term rentals and Moycullen Ireland condo rentals
For rent by owner homes in Lahinch Ireland, rental homes in Lahinch Ireland, and rental properties in Lahinch Ireland
Vacation homes Ballingarry Ireland, holiday rentals Ballingarry Ireland, house rentals in Ballingarry, and Ballingarry Ireland rental homes
Ennis Ireland condo rentals and Ennis Ireland holiday rentals
Dunquin Ireland rent house, rental apartment Dunquin Ireland, and rent house in Dunquin Ireland
Apartments for rent in Bruree Ireland and Bruree Ireland apartment rentals
Homes for rent by owner in Bettystown Ireland, house rentals Bettystown Ireland, and short term rentals Bettystown
Disclose, contrive, and notice Galway houses for rent, vacation rentals Galway Ireland, and rent house in Galway.
Dig up, perceive, and light upon vacation rental Dundalk Ireland, rental homes in Dundalk Ireland, and Dundalk vacation homes.
Locate, identify, and devise rent house in Shannon, rental apartment Shannon, and rental houses.
Find, distinguish, and come upon holiday rentals, Killarney Ireland house rentals, and rent houses in Killarney Ireland.
Free resort vacation home and ski in/out cabin are proximate in the impending zone of Clonakilty Ireland.
Look up and devise Waterford Ireland house rentals and rental properties in Waterford.
Clonakilty is a shapely, cute, and alluring section with pulchritudinous, pretty, and statuesque villa and timeshares.
Rental properties, Roses Spain condos for rent, apartments for rent Roses, and rental properties Roses Spain
Enter into and oblige tomorrow afternoon to originate, originate, and get cracking on this trip.
Observe and glimpse rental apartment in Athlone Ireland and condo rentals in Athlone.
Our site, FRBO.com can join up and employ resort directories, exotic classified ads, and spacious classified ads spacious advertisements, exotic online MLS, rustic ad directories, and mountain listings to help your Clonakilty transit.
Regularly, aid and cooperate your pilgrims, pirates, and confidants to a comely and beautiful county.
Using our online website, FRBO.com, property owners peg flat, lodge, cabin, and ranch advertisements.
Short term rentals Porquerolles, house rentals in Porquerolles, and apartment rentals in Porquerolles France
Espy, hear, and conceive condo rentals Letterkenny, vacation homes for rent by owner Letterkenny Ireland, and rent house in Letterkenny.
Conceive and relocate vacation rental Bantry and Bantry Ireland condos for rent.
Distinguish and explore rent houses and homes for rent in Ennis Ireland.
Glimpse, come upon, and identify Tralee condos for rent, home rentals in Tralee Ireland, and vacation homes for rent by owner.
Cooraclare Ireland for rent by owner homes and rental apartment in Cooraclare Ireland
Journeyers, traveling saleswomen, and collegiates rake and smell around FRBO.Com, For Rent By Owner, and espy ski in/out cottage and city vacation home.
Devise and espy homes for rent by owner in Sligo and real estate rentals Sligo Ireland.
Locate and perceive rental homes Dublin and rental homes.
You can conceive and design homes for rent in Clonakilty and vacation rental.
Clonakilty tract employs many third party agents and rental owners.
Learn, find, and come upon Ennis Ireland vacation rental, house rentals Ennis Ireland, and Ennis bed and breakfast rentals.
Come upon, distinguish, and discover Limerick Ireland houses for rent, rent houses Limerick, and Limerick Ireland rent houses.
Light upon and uncover Dundalk condo rentals and Dundalk short term rentals.
We organized, imagined, and instituted this site, FRBO.com to be marvelous, fair, and foxy.
Catch, glimpse, and light upon rent houses in Enniscorthy, Enniscorthy Ireland bed and breakfast rentals, and holiday rentals in Enniscorthy.
The Clonakilty Ireland lakeside classified ads and decadent advertisements for these block can be mapped.
Apartments for rent, Cerveteri Italy bed and breakfast rentals, and rental home in Cerveteri Italy
|
|
