|
<%@ 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
Ottawa Canada apartment rentals and Ottawa Canada condo rentals
Rental houses in Labelle Canada, rent house Labelle Canada, and real estate rentals in Labelle Canada
Rental houses Chemainus, Chemainus Canada vacation rentals, rental properties in Chemainus Canada, and condos for rent in Chemainus
Condo rentals in Gravenhurst Canada and Gravenhurst real estate rentals
Rental homes Niagara Falls, Niagara Falls Canada holiday rentals, and rental home in Niagara Falls Canada
For rent by owner homes in Mont Sainte-Anne, condo rentals, Mont Sainte-Anne Canada homes for rent, and apartment rentals Mont Sainte-Anne
Truro Canada condo rentals and vacation rental Truro Canada
Apartment rentals in Big White, rental houses Big White Canada, and rent house in Big White
House rentals in Parrsboro Canada, rental properties in Parrsboro Canada, apartment rentals Parrsboro, and apartments for rent in Parrsboro Canada
Rental homes Chase Canada and real estate rentals in Chase
Rent house Kelowna Canada, Kelowna Canada rental properties, and homes for rent Kelowna
Apartments for rent Lac Castor Canada, vacation rental in Lac Castor Canada, Lac Castor apartment rentals, and apartments for rent in Lac Castor
Sechelt Canada homes for rent by owner and houses for rent
Vacation rentals Maple Ridge Canada, real estate rentals Maple Ridge, and condos for rent in Maple Ridge
Courtenay Canada holiday rentals, vacation homes in Courtenay, rental homes, and vacation rentals Courtenay
Real estate rentals Denman Island Canada and homes for rent by owner Denman Island
Condos for rent, bed and breakfast rentals, and vacation rentals Bonaventure
Kinmount Canada rental apartment, vacation homes in Kinmount Canada, rental home in Kinmount, and houses for rent Kinmount Canada
Condo rentals in Halfmoon Bay and Halfmoon Bay vacation rental
Ascertain, contrive, and glimpse holiday rentals in Neilburg Canada, Neilburg Canada houses for rent, and vacation rental in Neilburg.
Join our beach ad directories, ski in/out ad directories, and ski in/out indexes mailing list for rental houses Victoria West and condo rentals in Victoria West.
Victoria West Canada reports could work for, further, and work for your pursuing.
Victoria West property brokers and property owners list rent house, vacation rentals Victoria West Canada, and houses for rent Victoria West.
Our online website, FRBO.com can procure and admit romantic lists of marked properties, waterfront classified ads, and romantic ad directories resort advertisements, well appointed classified ads, hillside lists of marked properties, and rustic online MLS to do for your Victoria West Canada passage.
Identify and find out house rentals in Comber Canada and Comber Canada house rentals.
Detect, glimpse, and recognize real estate rentals Cambridge Bay, bed and breakfast rentals Cambridge Bay, and rent house in Cambridge Bay Canada.
Victoria West Canada tract employs many property brokers, condo owners, and agents.
Observe and debunk vacation rentals in Lac-Mégantic Canada and short term rentals in Lac-Mégantic Canada.
Come upon and explore houses for rent Pointe-Au-Pere and Pointe-Au-Pere Canada real estate rentals.
You can scrutinize the romantic online MLS and lakeside listings under apartments for rent in Victoria West, condos for rent in Victoria West Canada, and for rent by owner homes.
Learn and discover Alert condo rentals and Alert Canada apartment rentals.
Find out, notice, and perceive homes for rent by owner in Les Méchins, short term rentals Les Méchins Canada, and Les Méchins vacation rental.
Inhabitants, venturers, and fellow workers who are wishing to notice and invent or simply debunk information can use For Rent By Owner.
Our for rent by owner website does enclose specialized county beach, city, and studio cottage, chalet, villa, and houseboats.
Glimpse and observe apartment rentals in Saint-Hippolyte-de-Kilkenny and Saint-Hippolyte-de-Kilkenny short term rentals.
Using our webpage, condo owners set down flat, farmhouse, hacienda, and farmhouse classified ads.
Send comely, pulchritudinous, and appealing evidence regarding Victoria West Canada rental houses, houses for rent, rent houses, and vacation rentals found on FRBO.com.
|
|
