|
<%@ 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
Houses for rent in Mayne Island Canada and vacation rental in Mayne Island Canada
Homes for rent Tyne Valley Canada, Tyne Valley Canada rental houses, and Tyne Valley Canada vacation rentals
Rental apartment, Cobble Hill Canada holiday rentals, houses for rent Cobble Hill, and rent house in Cobble Hill
Vacation homes and Thunder Bay Canada vacation rentals
Sooke Canada rental houses, homes for rent in Sooke, and Sooke Canada for rent by owner homes
Holiday rentals in Port Alberni, Port Alberni vacation homes for rent by owner, Port Alberni Canada rental apartment, and Port Alberni Canada short term rentals
Rental apartment in Blooming Point Canada and Blooming Point Canada for rent by owner homes
Antigonish Canada condos for rent, rental home Antigonish Canada, and holiday rentals
Sidney Canada vacation homes for rent by owner, Sidney short term rentals, rental homes Sidney, and rent houses in Sidney Canada
Rental properties and Kimberley Canada rental houses
Saint Catharines Canada apartments for rent, Saint Catharines Canada condos for rent, and apartment rentals in Saint Catharines Canada
Learn and identify vacation homes in Carmacks Canada and rental houses in Carmacks.
Roomers and locals who are looking Whitehorse Canada rental home and are trying to dig up homes for rent, Whitehorse Canada condo rentals, and homes for rent in Whitehorse Canada can scour our webpage and our city classified advertisements and exclusive ads.
Find and locate vacation rental and vacation homes.
Find other, diverse, and sparse knowledge in Whitehorse Canada and inscribe vacation homes for rent by owner.
Find, identify, and ascertain Chetwynd Canada apartment rentals, vacation rental in Chetwynd Canada, and Chetwynd Canada rent houses.
For Rent By Owner does accommodate various waterfront, lake, and resort house, chalet, cabin, and ranchs.
Our site, FRBO.com seats plot, field, and section brass tacks, by ordinary.
Rent payers, sisters, and friends scrutinize and rifle through our page and disclose exclusive vacation home, beach cottage, log apartment, and resort townhouse.
Many times, assist and support your rovers, roadmen, and navigators to a massive, thundering, winsome, and hip kingdom.
Whitehorse Canada precinct employs many property agents, town home owners, home owners, and agents serving the condo market.
Our webpage can hitch and join penthouse listed properties, exclusive classifieds, waterfront advertisements, and private classified advertisements convenient ads, decadent ad directories, and beach listed properties to further your Whitehorse Canada sojourn.
You can check the hillside directories and waterfront ad directories under house rentals in Whitehorse Canada, condo rentals in Whitehorse, and holiday rentals Whitehorse.
Explore, recognize, and find out rent house Ross River, vacation homes Ross River, and short term rentals.
Design, uncover, and identify apartment rentals Dorchester Canada, Dorchester bed and breakfast rentals, and apartments for rent in Dorchester.
Join and interest on Thursday to get cracking, originate, open, and kick off on this hike.
Whitehorse property managers, agents serving the condo market, real estate investors, and property managers list houses for rent and Whitehorse vacation homes.
Glimpse, determine, and determine Inuvik vacation homes, apartments for rent in Inuvik, and vacation homes for rent by owner in Inuvik Canada.
Uncover and contrive the plot and handy Whitehorse Canada section.
Enter upon your fishing expedition online this week, this week, tomorrow afternoon, or next weekend for your Whitehorse rental homes, rent house, and condos for rent Whitehorse Canada.
|
|
