|
<%@ 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
Jordan Ferry vacation homes for rent by owner and rental home in Jordan Ferry Canada
Rental properties in Charlotte s Shore Canada, Charlotte s Shore rental home, and rental homes in Charlotte s Shore
Rent houses, vacation homes for rent by owner in Comox Canada, condos for rent Comox Canada, and vacation homes Comox Canada
Homes for rent by owner in Sidney Canada and Sidney Canada houses for rent
Houses for rent in Savage Harbour Canada, vacation homes in Savage Harbour, and Savage Harbour Canada house rentals
Bed and breakfast rentals in Lakeside, Lakeside Canada short term rentals, homes for rent by owner Lakeside Canada, and vacation homes for rent by owner Lakeside Canada
Short term rentals and holiday rentals
Apartments for rent Oliver, condo rentals, and Oliver Canada vacation homes for rent by owner
For rent by owner homes Orillia Canada, Orillia vacation homes for rent by owner, Orillia Canada rental apartment, and Orillia Canada bed and breakfast rentals
Short term rentals in Fernie and real estate rentals Fernie
Apartments for rent in Cortes Island Canada, Cortes Island Canada rent house, and rental properties
Bonaventure Canada vacation homes for rent by owner, short term rentals Bonaventure Canada, Bonaventure Canada rent house, and Bonaventure rental homes
Vacation rentals in Apex Mountain Canada and homes for rent by owner in Apex Mountain
Vernon Canada condo rentals, Vernon Canada vacation homes for rent by owner, and rental houses
Home rentals in Qualicum Beach, Qualicum Beach vacation homes, holiday rentals Qualicum Beach Canada, and short term rentals in Qualicum Beach Canada
Houses for rent in Golden Canada and rental properties in Golden Canada
Apartments for rent Chemong Lake Canada, rental properties in Chemong Lake Canada, and condo rentals
Rental home in Egmont Canada, houses for rent Egmont Canada, house rentals Egmont, and Egmont bed and breakfast rentals
Truro Canada condo rentals and bed and breakfast rentals in Truro Canada
Rent house Carr s Landing Canada, holiday rentals in Carr s Landing, and Carr s Landing Canada homes for rent by owner
Homes for rent by owner Port Colborne Canada, vacation homes in Port Colborne Canada, apartments for rent Port Colborne Canada, and rental home Port Colborne
Calgary Canada condos for rent and houses for rent Calgary
Condo rentals in Invermere Canada, Invermere rental homes, and vacation rental Invermere
Rental properties Silver Star Mountain Canada, rent houses, apartments for rent in Silver Star Mountain Canada, and Silver Star Mountain Canada house rentals
Windermere Canada rental home and homes for rent Windermere Canada
Vacation rentals Red Mountain, Red Mountain Canada holiday rentals, and apartment rentals in Red Mountain
Osoyoos Canada vacation rental, rental homes in Osoyoos, apartment rentals Osoyoos, and vacation homes for rent by owner
Wreck Cove Canada vacation homes and houses for rent in Wreck Cove Canada
Bed and breakfast rentals Malpeque, Malpeque Canada condos for rent, and bed and breakfast rentals in Malpeque Canada
Rental apartment Mont Tremblant, Mont Tremblant rental homes, rent house Mont Tremblant Canada, and house rentals in Mont Tremblant Canada
Port Maitland Canada bed and breakfast rentals and rental properties Port Maitland
Apartments for rent in Mont-Carmel Canada, Mont-Carmel house rentals, and apartment rentals in Mont-Carmel
Rental home Campbell River Canada and Campbell River for rent by owner homes
Vacation rentals in Boswell, Boswell Canada vacation homes for rent by owner, and house rentals in Boswell Canada
Invent, explore, and discover Keene condos for rent, Keene Canada vacation homes for rent by owner, and Keene houses for rent.
Come upon and originate condos for rent and Langley house rentals.
This webpage can draft and gather romantic ad directories, spacious ads, loft listed properties, and resort classifieds spacious online MLS, spacious ad directories, and suburban listed properties to further your Charleston Lake Canada tour.
You can relocate, conceive, and uncover Charleston Lake Canada condo rentals, houses for rent Charleston Lake Canada, and rental apartment.
Find out and explore Sydney Canada rental houses and Sydney Canada home rentals.
Ferret out, notice, and come across rent house Sarnia Canada, Sarnia Canada holiday rentals, and homes for rent by owner Sarnia.
Perceive and relocate for rent by owner homes in Kananaskis Canada and Kananaskis real estate rentals.
Reserve, call up, and hire on Monday to enter upon, get cracking, and get cracking on this junket.
The Charleston Lake Canada oceanfront advertisements, city classifieds, and exotic classified ads for these county can be mapped.
House rentals in Porlamar and apartment rentals Porlamar
Come upon and identify vacation homes in Gander Canada and rental home in Gander Canada.
Relocate and devise rent houses in Cumberland Canada and condo rentals Cumberland Canada.
Bed and breakfast rentals in Maple Ridge Canada, condos for rent in Maple Ridge Canada, Maple Ridge houses for rent, and house rentals Maple Ridge
Eglington homes for rent by owner, holiday rentals in Eglington Canada, Eglington bed and breakfast rentals, and vacation rentals in Eglington Canada
Identify, explore, and disclose homes for rent Vancouver Canada, rent houses Vancouver, and homes for rent Vancouver.
Recognize, identify, and identify apartment rentals in Grand Forks Canada, Grand Forks Canada rent houses, and Grand Forks bed and breakfast rentals.
Charleston Lake Canada section employs many real estate brokers and real estate agents.
Castries St Lucia houses for rent, Castries St Lucia homes for rent by owner, and holiday rentals in Castries St Lucia
Detect distinct, distinctive, unique, and specific dope in Charleston Lake Canada and chart vacation rentals in Charleston Lake Canada.
Using this site, For Rent By Owner (FRBO.com), land owners enumerate condominium, apartment, houseboat, and cottage online MLS.
Elicit and find out Dolbeau Canada houses for rent and houses for rent in Dolbeau Canada.
Discover, find, and come across holiday rentals in Granby Canada, rental homes in Granby Canada, and vacation homes in Granby Canada.
Recently vacated loft home, secluded hacienda, spacious lodge, and resort home are adjacent in the approaching domain of Charleston Lake Canada.
Condos for rent in Invermere Canada and Invermere Canada vacation homes for rent by owner
Look up, originate, and find out house rentals Shelburne, rental houses in Shelburne Canada, and short term rentals Shelburne Canada.
Debunk, ferret out, and identify Hall Beach Canada house rentals, holiday rentals in Hall Beach Canada, and apartments for rent in Hall Beach Canada.
Join our log classified ads, loft listings, and ski in/out classifieds mailing list for Charleston Lake Canada rent house, home rentals in Charleston Lake Canada, and Charleston Lake Canada rental apartment.
See studio ads, romantic classifieds, resort online MLS, and suburban classifieds that land owners and property owners post on this webpage.
La Romana Dominican Republic apartments for rent and houses for rent
Charleston Lake property managers and rental agents list for rent by owner homes in Charleston Lake Canada, condo rentals Charleston Lake, rental properties, and Charleston Lake Canada home rentals.
You can comb the well appointed indexes, mountain listed properties, and well appointed listed properties under homes for rent Charleston Lake, Charleston Lake Canada rent houses, and apartments for rent in Charleston Lake Canada.
Better halves, sorority sisters, and drifters who are looking for homes for rent Charleston Lake and are trying to identify rental houses Charleston Lake Canada and apartments for rent in Charleston Lake Canada can run down our for rent by owner site, FRBO.com and our beach listed properties and hillside ads.
Subordinates and brides quest and shake down this extensive website, FRBO.com and look up waterfront timeshare, private villa, and hidden cottage.
Our site, FRBO.com does take in startling vicinity beach, city, and exotic vacation home, villa, ranch, and apartments.
The Charleston Lake Canada listed properties manifested and indexed on For Rent By Owner hold well appointed bungalow, lakefront house, oceanfront farmhouse, and rustic townhouse.
Explore, learn, and look up rental houses, homes for rent by owner Port Hawksbury, and houses for rent in Port Hawksbury Canada.
Journeyers, tenants, and professors who are wishing to come upon, disclose, and ferret out or simply come across information can use this site, FRBO.com.
Devise and light upon rental homes in Baltimore and rent house Baltimore.
Invent and distinguish homes for rent by owner in Duncan Canada and for rent by owner homes Duncan.
Find out and debunk vacation rental in Cowansville and home rentals.
Come across, locate, and devise Tillsonburg bed and breakfast rentals, rental homes in Tillsonburg Canada, and rent houses in Tillsonburg.
Observe, come upon, and explore short term rentals in Brampton Canada, vacation rentals Brampton, and rental houses in Brampton Canada.
Disclose and espy rental home La Tuque Canada and La Tuque Canada apartment rentals.
Light upon, devise, and discern bed and breakfast rentals Hamilton Canada, houses for rent in Hamilton, and Hamilton rental properties.
Glimpse, explore, and glimpse bed and breakfast rentals in Dauphin Canada, apartments for rent Dauphin Canada, and rental apartment Dauphin Canada.
Condos for rent Beacon Hill St Maarten, Beacon Hill St Maarten rent houses, and houses for rent in Beacon Hill St Maarten
Find out, discover, and hear Saint-Basile Canada rental apartment, Saint-Basile real estate rentals, and vacation rental Saint-Basile.
|
|
