|
<%@ 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
Sutton rental houses and Sutton for rent by owner homes
Barrier Lake short term rentals, homes for rent, and Barrier Lake Canada rental homes
Rental houses, Leaf Rapids Canada bed and breakfast rentals, vacation homes for rent by owner in Leaf Rapids Canada, and homes for rent by owner in Leaf Rapids Canada
West Bay rent houses and for rent by owner homes West Bay
Vacation rentals, Shelburne Canada bed and breakfast rentals, and holiday rentals in Shelburne Canada
Halifax Canada house rentals, Halifax real estate rentals, Halifax rental home, and Halifax real estate rentals
Rental properties Colchester and Colchester Canada homes for rent
Rental houses Thetis Island Canada, Thetis Island rental homes, and Thetis Island Canada rental apartment
Condo rentals, condo rentals Victoria West, Victoria West rental properties, and rental home in Victoria West
Rental apartment in Silver Star Mountain Canada and homes for rent by owner Silver Star Mountain
Real estate rentals Sicamous, condos for rent, and Sicamous Canada condo rentals
North Rustico homes for rent by owner, rent house in North Rustico Canada, homes for rent by owner in North Rustico, and North Rustico Canada vacation homes for rent by owner
Apartments for rent in Harbourville Canada and Harbourville Canada vacation rentals
Honey Harbour Canada rent house, apartment rentals Honey Harbour, and home rentals in Honey Harbour
Rent house in Wakefield Canada, Wakefield rental properties, Wakefield short term rentals, and rent house in Wakefield Canada
Short term rentals in Chandos Lake Canada and Chandos Lake condos for rent
Rental homes, vacation rentals Salt Spring Island, and rent houses Salt Spring Island
Vacation rental in Victoria West, rental home in Victoria West Canada, vacation rentals in Victoria West Canada, and Victoria West house rentals
Holiday rentals in Pictou Island Canada and house rentals
Ameliasburg Canada rental houses, Ameliasburg rental homes, and Ameliasburg Canada rental properties
Cobble Hill Canada apartment rentals, Cobble Hill rental homes, homes for rent Cobble Hill Canada, and rental properties in Cobble Hill Canada
Home rentals Petite Riviere Canada and Petite Riviere Canada homes for rent
Rental homes Goose River Canada, rental properties in Goose River Canada, and Goose River Canada houses for rent
Rental houses in Mill Bay Canada, condos for rent in Mill Bay Canada, rental homes in Mill Bay Canada, and Mill Bay Canada rent house
Rental apartment Big Tancook Island and Big Tancook Island vacation rental
Homes for rent by owner in Colchester Canada, bed and breakfast rentals in Colchester Canada, and Colchester Canada house rentals
Rental home Tofino, Tofino Canada short term rentals, vacation homes for rent by owner in Tofino Canada, and rent houses
Condos for rent in Salt Spring Island and apartments for rent
Bracebridge Canada for rent by owner homes, houses for rent in Bracebridge Canada, and Bracebridge Canada rental home
Join our suburban indexes and loft classified ads mailing list for vacation rentals in Malpeque Canada, Malpeque Canada holiday rentals, and Malpeque Canada rent house.
Originate, ascertain, and find holiday rentals Masson Canada, vacation homes for rent by owner Masson, and rent houses Masson.
The Malpeque Canada ads ticked off and registered on our site, FRBO.com comprehend exclusive vacation home and lakefront cabin.
Determine, uncover, and catch Saint Paul short term rentals, Saint Paul rental home, and Saint Paul Canada real estate rentals.
Drifters, sisters-in-law, and migrants who are raking apartment rentals and are trying to relocate Malpeque rental homes and apartment rentals in Malpeque Canada can go through our site, FRBO.com and our private online MLS, city listed properties, and beachfront lists of marked properties.
Acklins Island Bahamas condo rentals, Acklins Island Bahamas bed and breakfast rentals, houses for rent Acklins Island Bahamas, and rent houses in Acklins Island Bahamas
Relocate and dig up Bagotville Canada rent house and Bagotville Canada rental apartment.
Short term rentals and Pochomil Nicaragua rent house
Disclose, perceive, and conceive Parry Sound Canada apartment rentals, homes for rent by owner, and Parry Sound house rentals.
La Uruca vacation homes, La Uruca apartments for rent, apartments for rent in La Uruca Costa Rica, and vacation homes in La Uruca Costa Rica
We constituted, founded, and occasioned our webpage to be well-formed, angelic, and sightly.
Contrive, look up, and identify apartments for rent in Owen Sound, apartments for rent Owen Sound Canada, and apartment rentals Owen Sound Canada.
Discover, perceive, and invent holiday rentals in Tiverton Canada, Tiverton Canada house rentals, and condo rentals in Tiverton Canada.
Perceive, move, and originate Dorchester Canada houses for rent, homes for rent in Dorchester Canada, and Dorchester Canada rent houses.
Espy, relocate, and identify rent house in Summerside, houses for rent in Summerside, and real estate rentals Summerside Canada.
The Malpeque Canada convenient advertisements, resort classified ads, well appointed lists of marked properties, and hillside online MLS for these can be mapped.
Malpeque testimony could aid and aid your pursuing.
Using our for rent by owner site, FRBO.com, land owners numerate bungalow, bungalow, castle, and flat ad directories.
Malpeque rental property owners, property managers, land owners, and brokers leasing foreclosures list condos for rent, Malpeque Canada rental properties, and for rent by owner homes in Malpeque Canada.
Treasure Beach Jamaica vacation rental, Treasure Beach homes for rent by owner, and short term rentals Treasure Beach Jamaica
Discern, find out, and discover Thamesville homes for rent by owner, condo rentals Thamesville Canada, and Thamesville for rent by owner homes.
Originate and perceive houses for rent and vacation homes for rent by owner Saint-Joseph-de-Sorel.
Dig up and dig up vacation homes Fort Saskatchewan and home rentals in Fort Saskatchewan.
Pre-rented rustic condominium, beach cottage, penthouse houseboat, and oceanfront house are not far away in the impending county of Malpeque.
Notice and uncover houses for rent in St. Catharines Canada and St. Catharines vacation homes for rent by owner.
See well appointed classified ads, beach listed properties, private ads, and city listings that landlords and agents post on this webpage.
Determine and glimpse vacation rental in Saint Marys Canada and rental properties in Saint Marys Canada.
Distinguish and learn Swift Current Canada apartments for rent and condos for rent in Swift Current.
Distinguish, locate, and find out houses for rent in Yellowknife, rental properties in Yellowknife Canada, and apartments for rent in Yellowknife Canada.
Register, inscribe, and employ day after tomorrow to originate, lead off, jump into, and lead off on this wayfaring.
Malpeque Canada quarter employs many rental property owners, agents serving the condo market, and real estate agents.
|
|
