|
<%@ 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
Rental properties in Boswell Canada and vacation rental in Boswell
Mont Ste-Marie Canada condos for rent, for rent by owner homes Mont Ste-Marie Canada, and Mont Ste-Marie vacation rentals
House rentals Penetanguishene Canada, home rentals in Penetanguishene Canada, Penetanguishene rent houses, and vacation rental in Penetanguishene Canada
Yarmouth homes for rent and homes for rent by owner in Yarmouth Canada
Rental houses in Chemainus Canada, holiday rentals in Chemainus Canada, and rental properties
Homes for rent by owner in Mont Ste-Marie Canada, vacation rental in Mont Ste-Marie Canada, Mont Ste-Marie Canada rent houses, and apartments for rent
Hubbards Canada vacation rentals and short term rentals in Hubbards Canada
Apartments for rent, condo rentals Picton Canada, and home rentals Picton Canada
Gabarus vacation homes for rent by owner, condos for rent in Gabarus, rental apartment Gabarus Canada, and for rent by owner homes
Vacation rental in Musquodoboit Harbour and Musquodoboit Harbour Canada home rentals
Vacation rental, holiday rentals Comox, and Comox Canada houses for rent
Homes for rent in Qualicum Beach, condo rentals in Qualicum Beach Canada, Qualicum Beach Canada house rentals, and Qualicum Beach short term rentals
St Peters Canada short term rentals and bed and breakfast rentals in St Peters Canada
Real estate rentals Egmont, condo rentals in Egmont Canada, and real estate rentals in Egmont
Condo rentals in Okanagan Centre, Okanagan Centre vacation homes, apartments for rent in Okanagan Centre, and rental homes in Okanagan Centre
Homes for rent by owner Lasqueti Island and home rentals in Lasqueti Island
Apartments for rent in Duncan Canada, Duncan Canada rent house, and vacation rental Duncan Canada
Gabarus Canada rental home, vacation rental in Gabarus Canada, Gabarus vacation rental, and vacation rentals in Gabarus Canada
Houses for rent in Port Moody Canada and homes for rent by owner in Port Moody
Vacation homes for rent by owner in Mill Bay Canada, vacation rentals in Mill Bay Canada, and vacation rentals in Mill Bay Canada
Houses for rent Piedmont, Piedmont Canada houses for rent, houses for rent Piedmont Canada, and houses for rent
Rental properties in Port Moody Canada and Port Moody Canada apartment rentals
Truro vacation rentals, Truro Canada vacation homes, and Truro rental houses
Houses for rent Cobble Hill, rent houses in Cobble Hill Canada, Cobble Hill Canada vacation homes, and rental properties
Vacation homes for rent by owner in Halfmoon Bay Canada and condo rentals in Halfmoon Bay
Light upon, dig up, and learn the precinct and handy Brigus area.
Devise, identify, and espy vacation homes for rent by owner in Winona Canada, rental houses Winona Canada, and Winona Canada house rentals.
Traveling saleswomen and pilgrims who are examining Brigus Canada vacation rentals and are trying to perceive real estate rentals Brigus Canada and apartment rentals in Brigus can examine our for rent by owner site, FRBO.com and our studio listings, loft lists of marked properties, hillside online MLS, and log classified ads.
Our webpage does except various township mountain, beach, lakefront, and penthouse vacation home, flat, and chalets.
Notice and catch Crowsnest Pass Canada for rent by owner homes and for rent by owner homes in Crowsnest Pass Canada.
Discover, come upon, and come across vacation rental in Brockville Canada, apartment rentals Brockville, and rent houses in Brockville Canada.
The Brigus Canada studio ads, well appointed ads, beachfront lists of marked properties, and hidden classified ads for these domain can be mapped.
Discover, disclose, and recognize condo rentals in Saskatoon Canada, apartments for rent in Saskatoon Canada, and apartments for rent Saskatoon.
Discover and glimpse Cambridge Canada vacation homes for rent by owner and rental home Cambridge.
Uncover special and unusual scoop in Brigus and catalogue Brigus Canada homes for rent.
See convenient classifieds, penthouse advertisements, city advertisements, and exotic ad directories that rental owners and brokers leasing foreclosures post on our site, FRBO.com.
Relocate and come upon apartments for rent Watson Lake and Watson Lake Canada condos for rent.
Determine and catch apartments for rent Oakville and real estate rentals.
Discern, notice, and find out Kenora Canada condos for rent, homes for rent by owner Kenora, and rental homes in Kenora Canada.
This site, For Rent By Owner (FRBO.com) can join up, obtain, mobilize, and attract log directories, loft lists of marked properties, and beachfront directories hidden classified advertisements, convenient directories, loft listings, and beachfront advertisements to abet your Brigus Canada transit.
Houses for rent in West Bay and rental houses
You can come across and learn rental homes in Brigus and for rent by owner homes in Brigus Canada.
Pre-rented private home and mountain duplex are adjacent in the nearby territory of Brigus.
Perceive and explore houses for rent in Richibucto Canada and short term rentals Richibucto.
Rental home, Port Alberni Canada rent house, rental home Port Alberni Canada, and Port Alberni Canada homes for rent by owner
Join our ski in/out ad directories, log advertisements, decadent ad directories, and beachfront listings mailing list for real estate rentals, vacation homes Brigus, and Brigus Canada homes for rent by owner.
Recruit and sign on on Wednesday to open, embark on, embark on, and jump into on this wandering.
|
|
