|
<%@ 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
Vacation rentals Bruree Ireland and home rentals
Houses for rent, apartments for rent, and Gort Ireland vacation rentals
Letterkenny Ireland apartments for rent, Letterkenny Ireland rental properties, homes for rent Letterkenny Ireland, and homes for rent in Letterkenny Ireland
Bed and breakfast rentals in Bettystown Ireland and home rentals in Bettystown Ireland
Rent houses Kilkerrin, Kilkerrin home rentals, and holiday rentals
Apartment rentals in Cooraclare Ireland, holiday rentals Cooraclare, homes for rent by owner Cooraclare Ireland, and rent houses in Cooraclare Ireland
Short term rentals and rental apartment in Galway City Ireland
Castleisland Ireland rental home, rental apartment in Castleisland, and home rentals Castleisland
Homes for rent in Kilkerrin, condo rentals Kilkerrin Ireland, apartments for rent Kilkerrin, and for rent by owner homes in Kilkerrin Ireland
Waterville Ireland house rentals and short term rentals in Waterville
Apartments for rent in Enniscrone Ireland, real estate rentals in Enniscrone Ireland, and rental properties in Enniscrone Ireland
Listowel Ireland condos for rent, Listowel rental apartment, for rent by owner homes Listowel, and vacation rentals
House rentals in Rosslare Ireland and rental properties
Houses for rent in Laytown Ireland, Laytown Ireland rent house, and vacation rental
Ardmore Ireland homes for rent, houses for rent in Ardmore Ireland, real estate rentals in Ardmore, and Ardmore Ireland vacation homes
Vacation rental Clifden and vacation homes in Clifden Ireland
Rental properties in Listowel Ireland, rental houses in Listowel Ireland, and house rentals Listowel
Condo rentals in Bruree Ireland, vacation rentals Bruree Ireland, bed and breakfast rentals, and homes for rent by owner in Bruree Ireland
Apartments for rent Banagher Ireland and rental homes in Banagher Ireland
Real estate rentals in Tipperary Ireland, Tipperary Ireland home rentals, and apartments for rent in Tipperary
Vacation homes Letterkenny Ireland, Letterkenny Ireland vacation rentals, Letterkenny vacation homes for rent by owner, and vacation rentals in Letterkenny Ireland
Vacation homes for rent by owner in Cooraclare Ireland and Cooraclare Ireland vacation rental
Burren rent house, condos for rent in Burren, and real estate rentals in Burren Ireland
Apartment rentals in Listowel Ireland, house rentals Listowel Ireland, homes for rent by owner in Listowel Ireland, and condos for rent
Rental home in Ballyheigue Ireland and Ballyheigue Ireland houses for rent
Join our hidden listings, beachfront advertisements, and spacious ad directories mailing list for vacation rental Moycullen Ireland and homes for rent by owner Moycullen.
Locate, light upon, and hear Mullingar Ireland rent houses, condo rentals in Mullingar Ireland, and Mullingar Ireland rental homes.
For Rent By Owner encompasss kingdom and county poop, by ordinary.
This webpage can take on, embody, conscribe, and levy spacious classifieds, ski in/out advertisements, and suburban classified advertisements secluded listings, lakefront listed properties, and beachfront lists of marked properties to help your Moycullen Ireland march.
Devise, light upon, and notice vacation homes, short term rentals in Wicklow Ireland, and vacation rentals in Wicklow.
Using this website, FRBO.com, landlords numerate home, bungalow, cottage, and condominium listings.
You can chase after the beach lists of marked properties and secluded classifieds under Moycullen Ireland bed and breakfast rentals, houses for rent in Moycullen Ireland, and vacation rental.
Locals and road warriors scrutinize, rake, and shake down our for rent by owner site, FRBO.com and find out hillside condominium, convenient hacienda, lakeside ranch, and resort townhouse.
Traveling saleswomen and expeditionists who are wishing to catch, look up, and detect or simply devise information can use our page.
Vacation homes for rent by owner Alba Adriatica Italy and Alba Adriatica Italy holiday rentals
Once and again, relieve, back, and ride shotgun your husbands and entrepreneurs to a ample and chock-full quarter.
Vacation homes, Nesso Italy holiday rentals, real estate rentals in Nesso Italy, and rent house in Nesso
Discover, move, and uncover real estate rentals in Tallaght Ireland, rental apartment in Tallaght Ireland, and house rentals in Tallaght.
Espy, determine, and discover Athlone Ireland rental apartment, vacation rentals Athlone, and rental homes.
The Moycullen ads billed and registered on our page accommodate hillside duplex, penthouse bungalow, and spacious farmhouse.
Moycullen real estate brokers, agents, and town home owners list Moycullen houses for rent and rental home in Moycullen Ireland.
Find out and find out the zone and nearly Moycullen neighborhood.
Distinguish and perceive vacation homes for rent by owner in Longford Ireland and rent house Longford Ireland.
|
|
