|
<%@ 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" %>
|
Canada Rental Links
Vacation homes Roberts Creek and condo rentals in Roberts Creek Canada
Nanaimo Canada condos for rent, short term rentals Nanaimo, and rent house in Nanaimo Canada
Vacation homes for rent by owner, for rent by owner homes Eglington Canada, Eglington Canada houses for rent, and Eglington Canada short term rentals
Vacation rental in Souris Canada and homes for rent by owner Souris Canada
Bay St Lawrence vacation homes, rent house Bay St Lawrence, and rental apartment Bay St Lawrence Canada
Rent houses in White Point Canada, White Point Canada bed and breakfast rentals, rental homes, and homes for rent in White Point Canada
Colchester holiday rentals and vacation rentals in Colchester
Halifax rental houses, Halifax Canada rental apartment, and homes for rent Halifax Canada
Houses for rent in Nanaimo Canada, condo rentals in Nanaimo Canada, rental homes, and Nanaimo Canada for rent by owner homes
Lunenburg Canada apartments for rent and rental houses Lunenburg
Musquodoboit Harbour Canada plot employs many brokers leasing foreclosures, property owners, land owners, and third party listing companies.
Locate, design, and discern Prevost Canada real estate rentals, vacation homes for rent by owner, and homes for rent by owner Prevost Canada.
Musquodoboit Harbour home owners, property managers, agents, and property owners list bed and breakfast rentals Musquodoboit Harbour Canada, Musquodoboit Harbour Canada rental homes, and condo rentals Musquodoboit Harbour.
Join our romantic advertisements and spacious classifieds mailing list for Musquodoboit Harbour Canada rental homes, Musquodoboit Harbour homes for rent, and Musquodoboit Harbour Canada homes for rent by owner.
We effected, set up, and created our page to be delicate, alluring, and divine.
Find out, discern, and find condos for rent in Prescott, vacation homes in Prescott, and rental home Prescott.
Ofttimes, reinforce and cooperate your co-workers and occupiers to a engaging, copious, and brimming quarter.
Gypsies, fellow workers, and soldiers root and grub this site, FRBO.com and recognize beach timeshare, spacious ranch, and beachfront cottage.
Invent and explore rental home in Listowel and rent house Listowel Canada.
Identify, elicit, and explore holiday rentals in Saint-Rémi Canada, rental houses in Saint-Rémi Canada, and vacation homes for rent by owner Saint-Rémi.
Pre-rented ski in/out duplex, studio cottage, loft houseboat, and well appointed hacienda are contiguous in the not remote field of Musquodoboit Harbour.
Renters, globetrotters, and pirates who are rooting condos for rent and are trying to light upon condos for rent in Musquodoboit Harbour and rental houses can chase after our webpage and our beach directories, lakeside listed properties, beachfront lists of marked properties, and convenient indexes.
|
|
