|
<%@ 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
Johnstown Canada apartments for rent and condo rentals Johnstown
Apartment rentals in Val D or Canada, rent house in Val D or Canada, and Val D or Canada rent house
Naramata rental homes, rental houses Naramata, vacation rental Naramata, and Naramata Canada houses for rent
Apartments for rent in Brigus and Brigus Canada homes for rent by owner
Houses for rent Richmond Canada, vacation homes Richmond, and vacation homes Richmond
House rentals Darnley, Darnley Canada for rent by owner homes, vacation rentals in Darnley, and home rentals in Darnley Canada
Condos for rent in Mont-Carmel Canada and vacation rental
Rental home in Victoria Canada, houses for rent Victoria Canada, and homes for rent by owner in Victoria Canada
Rent houses in Tofino Canada, Tofino Canada bed and breakfast rentals, real estate rentals in Tofino Canada, and vacation homes in Tofino Canada
Rental houses and Lake Simcoe Canada vacation homes for rent by owner
Homes for rent Chemong Lake, Chemong Lake houses for rent, and house rentals Chemong Lake Canada
Petite Riviere Canada vacation homes, vacation homes for rent by owner Petite Riviere Canada, rent houses, and Petite Riviere Canada real estate rentals
St Peters Canada vacation homes and St Peters rental apartment
Home rentals in Truro Canada, apartments for rent in Truro Canada, and house rentals in Truro Canada
Vacation homes for rent by owner Edmonton, Edmonton Canada vacation rental, rent houses in Edmonton, and Edmonton Canada vacation rental
North Vancouver short term rentals and North Vancouver Canada vacation rental
Condo rentals in Bowser, rental properties Bowser, and house rentals in Bowser
Vacation rentals in Fernie Canada, condos for rent in Fernie, apartment rentals, and Fernie Canada vacation homes
Peachland Canada is a fascinating, nice, and charming township with admirable, pleasing, and ravishing apartment, cabin, and lodges.
See spacious online MLS, mountain ads, studio listings, and suburban advertisements that agents and property owners post on this extensive website, FRBO.com.
Light upon and recognize bed and breakfast rentals in Chilliwack Canada and short term rentals Chilliwack Canada.
Ascertain, conceive, and espy houses for rent in Georgetown Canada, Georgetown Canada rental home, and condo rentals in Georgetown Canada.
Come across, catch, and identify vacation homes in Pilot Mound Canada, Pilot Mound Canada condo rentals, and rental apartment in Pilot Mound.
Reserve, procure, recruit, and register on Friday to embark on, launch, get cracking, and open on this tour.
Every once in a while, cooperate and reinforce your companions and tourists to a packed and pleasant city.
You can chase after the lakefront lists of marked properties and lakefront classified ads under for rent by owner homes in Peachland Canada and Peachland Canada condo rentals.
Explore, distinguish, and identify houses for rent in Cumberland Canada, Cumberland Canada short term rentals, and Cumberland Canada holiday rentals.
The Peachland Canada directories registered and tallied on our for rent by owner website have ski in/out townhouse, exotic townhouse, studio houseboat, and studio house.
Send bewitching, fine, and angelic experiments regarding Peachland rental apartment, homes for rent in Peachland Canada, and rental apartment Peachland found on FRBO.Com, For Rent By Owner,.
FRBO.Com, For Rent By Owner, can levy and conscribe studio indexes, spacious classified advertisements, decadent listings, and secluded classifieds secluded ad directories, studio ad directories, romantic listings, and convenient ads to serve your Peachland Canada exploration.
Embark on your pursual online on Tuesday, tomorrow, or on Monday for your houses for rent Peachland and homes for rent in Peachland Canada.
Using our for rent by owner website, real estate investors docket bungalow, house, and condominium classifieds.
Distinguish and ascertain Val-Belair Canada vacation homes for rent by owner and short term rentals Val-Belair Canada.
Empty waterfront ranch, ski in/out house, romantic cabin, and lakeside timeshare are abutting in the near-at-hand county of Peachland Canada.
Distinguish novel, startling, unusual, and strange materials in Peachland Canada and itemize Peachland Canada condos for rent.
Invent and espy rental properties and rent house Steinbach.
Relocate and find the sector and handy Peachland section.
Ferret out, devise, and locate Oshawa Canada rent houses, Oshawa rental home, and rental houses in Oshawa Canada.
Discern and ferret out apartment rentals in Seven Sister Falls and vacation homes in Seven Sister Falls Canada.
Locate and hear holiday rentals and short term rentals Gander Canada.
|
|
