|
<%@ 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
Picton home rentals and Picton Canada homes for rent
Short term rentals in Balm Beach, for rent by owner homes in Balm Beach, and houses for rent
Homes for rent by owner in Sechelt Canada, homes for rent by owner, rent houses in Sechelt Canada, and apartment rentals in Sechelt Canada
Rent houses Sonora Island and apartment rentals in Sonora Island
Rent house Coquitlam, rental home Coquitlam Canada, and rent house in Coquitlam Canada
Gabarus vacation rentals, apartment rentals in Gabarus, rent houses Gabarus, and Gabarus Canada apartment rentals
House rentals in St Sauveur des Monts Canada and homes for rent St Sauveur des Monts Canada
Rental properties Morin Heights Canada, vacation rentals, and Morin Heights Canada rental apartment
Rent houses Galiano Island, vacation rental, homes for rent in Galiano Island, and vacation rentals in Galiano Island
Pitt Meadows short term rentals and Pitt Meadows Canada apartment rentals
Brampton Canada house rentals, house rentals, and short term rentals in Brampton Canada
White Rock rental home, White Rock Canada rental homes, homes for rent in White Rock, and bed and breakfast rentals in White Rock
Bed and breakfast rentals in Fernie Canada and homes for rent in Fernie Canada
Apartments for rent, for rent by owner homes, and real estate rentals Brackley Beach Canada
Rental houses, Muskoka vacation homes for rent by owner, Muskoka condos for rent, and rental properties
Augustine Cove Canada vacation rental and rental apartment Augustine Cove
Rent houses in Whitehorse Canada, homes for rent, and apartments for rent Whitehorse Canada
Rental properties in Lasqueti Island Canada, real estate rentals, Lasqueti Island Canada rental apartment, and house rentals in Lasqueti Island Canada
Vernon Canada holiday rentals and Vernon Canada rent houses
Mabel Lake Canada rent house, rental apartment, and vacation homes
Rental home in Port Stanton, Port Stanton Canada for rent by owner homes, condos for rent, and house rentals Port Stanton
Whistler condo rentals and Whistler Canada homes for rent by owner
Yarmouth Canada condo rentals, vacation rental in Yarmouth Canada, and Yarmouth home rentals
Apartment rentals in Edmonton Canada, Edmonton Canada rent houses, home rentals Edmonton, and rental apartment in Edmonton Canada
Move and notice the city and imminent Hubbards Canada locality.
Navigators and husbands who are wishing to discover, conceive, and uncover or simply move information can use FRBO.Com, For Rent By Owner,.
Hear, design, and design vacation homes for rent by owner in Dawson City Canada, Dawson City Canada home rentals, and Dawson City vacation homes.
Identify and uncover Renfrew Canada rental apartment and rental home in Renfrew Canada.
Recognize and explore real estate rentals in Old Crow and rental properties in Old Crow Canada.
Ascertain and find out Kapuskasing Canada homes for rent and rental homes in Kapuskasing Canada.
Perceive and perceive vacation rentals in Yarmouth and Yarmouth Canada rental properties.
We invested, performed, and originated this website, FRBO.com to be classy and beauteous.
Hubbards Canada knowledge could serve, open doors, and serve your perquisition.
Hubbards rental property owners, landlords, rental agents, and rental owners list holiday rentals in Hubbards Canada and apartment rentals in Hubbards Canada.
Light upon and debunk Sioux Lookout rental homes and Sioux Lookout Canada real estate rentals.
FRBO.Com, For Rent By Owner, can join up, call up, induct, and reserve oceanfront classifieds, log classified advertisements, well appointed classifieds, and hidden online MLS lakefront advertisements and beach ad directories to work with your Hubbards run.
You can catch, elicit, and dig up rental houses, Hubbards Canada rental home, and rental home in Hubbards Canada.
Catch, discern, and identify vacation homes in Sorel Canada, Sorel Canada rental home, and holiday rentals in Sorel Canada.
Identify small number, specific, and extraordinary memorandums in Hubbards Canada and enroll houses for rent.
Recognize, ferret out, and come upon apartments for rent in Castlegar Canada, rent house, and for rent by owner homes in Castlegar Canada.
Espy, conceive, and catch vacation rentals in Enderby Canada, Enderby Canada apartments for rent, and rental apartment Enderby Canada.
|
|
