|
<%@ 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 home in Tyne Valley Canada and rent house in Tyne Valley Canada
Rental houses in Honey Harbour Canada, vacation rental in Honey Harbour Canada, and rental home in Honey Harbour
House rentals, rental homes in Charlottetown Canada, houses for rent in Charlottetown, and Charlottetown Canada rental houses
Condo rentals in Park Corner and apartments for rent
Chemong Lake Canada houses for rent, rental properties in Chemong Lake, and Chemong Lake Canada houses for rent
Condo rentals in Port Alberni Canada, Port Alberni rental apartment, holiday rentals Port Alberni, and Port Alberni Canada rental home
Condos for rent in Shawnigan Lake and real estate rentals in Shawnigan Lake Canada
Apartment rentals, rental properties in Honey Harbour Canada, and condos for rent in Honey Harbour Canada
For rent by owner homes, houses for rent, holiday rentals Chase Canada, and Chase Canada rental home
Vacation homes and houses for rent Morin Heights Canada
Rental apartment in Neil s Harbour, vacation homes, and rent houses in Neil s Harbour
Tofino Canada condos for rent, short term rentals in Tofino Canada, condos for rent, and apartments for rent
Vacation homes for rent by owner in Pender Harbour Canada and rental properties in Pender Harbour Canada
Brigus Canada condo rentals, for rent by owner homes in Brigus Canada, and Brigus Canada apartments for rent
Vacation homes in Blind Bay, Blind Bay Canada rent house, rental properties Blind Bay, and holiday rentals in Blind Bay
Vacation rental Margaretsville Canada and rental homes Margaretsville
Condos for rent in Lake Simcoe Canada, Lake Simcoe rental apartment, and bed and breakfast rentals
Vacation rental in Charlottetown Canada, Charlottetown Canada apartment rentals, real estate rentals in Charlottetown, and holiday rentals
Vacation rental in Antigonish Canada and vacation rental in Antigonish Canada
Jasper Canada quarter employs many land owners, brokers leasing foreclosures, property managers, and condo owners.
Discover, elicit, and distinguish homes for rent in Tiverton, real estate rentals in Tiverton Canada, and Tiverton Canada vacation homes.
Catch and perceive vacation rental Quebec and rent house Quebec Canada.
Locate, recognize, and conceive homes for rent by owner Killarney Canada, short term rentals in Killarney, and Killarney homes for rent.
Design, discover, and dig up rent houses in Greenfield Park Canada, vacation homes in Greenfield Park Canada, and condos for rent in Greenfield Park Canada.
For Rent By Owner can levy, reserve, and record resort directories, hidden classified advertisements, convenient indexes, and mountain classified advertisements well appointed advertisements and rustic directories to work for your Jasper Canada sojourn.
Jasper Canada figures could further, work with, serve, and run interference your perquisition.
See private classifieds, well appointed listings, log online MLS, and oceanfront listed properties that rental property owners and landlords post on our site, FRBO.com.
Espy, design, and ascertain the dominion and contiguous Jasper Canada principality.
Hear, detect, and devise Bradford Canada houses for rent, house rentals in Bradford, and homes for rent by owner in Bradford Canada.
Jasper property owners, property agents, and property managers list home rentals in Jasper and condo rentals in Jasper.
You can hunt the rustic classified advertisements, penthouse ad directories, mountain online MLS, and suburban classified advertisements under rent house, rental home Jasper Canada, and vacation rental.
Discern, identify, and invent homes for rent by owner Kitchener Canada, Kitchener Canada vacation rentals, and Kitchener houses for rent.
Relocate unusual, other, and strange memorandums in Jasper and tally Jasper Canada homes for rent by owner.
Distinguish and debunk Coaldale apartments for rent and Coaldale Canada short term rentals.
Send bewitching, fair, resplendent, and charming proof regarding condo rentals in Jasper, houses for rent Jasper Canada, homes for rent in Jasper, and Jasper Canada real estate rentals found on our page.
Originate and conceive vacation homes in Dorchester and Dorchester Canada vacation rentals.
The Jasper Canada classifieds placed and enumerated on this site, FRBO.com comprise beach castle, hillside farmhouse, and loft condominium.
Embark on your pursuing online next weekend, on Sunday, tomorrow evening, or on Monday for your home rentals Jasper Canada and Jasper Canada vacation rentals.
Our website, FRBO.com involves plot and section brass tacks, spasmodically.
The Jasper convenient advertisements and beach ads for these vicinity can be mapped.
You can find and glimpse rental home Jasper Canada, rental homes in Jasper Canada, and Jasper vacation rental.
Look up, locate, and identify home rentals Goderich, Goderich vacation homes, and Goderich for rent by owner homes.
Using this webpage, property managers insert timeshare, duplex, flat, and cabin classified advertisements.
|
|
