|
<%@ 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
Apartment rentals in Round Lake Canada and rental houses Round Lake Canada
Short term rentals in Annapolis Royal Canada, rental houses Annapolis Royal, and home rentals
Ile Verte-Green Island Canada vacation homes for rent by owner, apartments for rent in Ile Verte-Green Island Canada, homes for rent by owner, and rent houses Ile Verte-Green Island
Rent house and rent house in Creekside Canada
Vacation rentals, apartment rentals Parksville Canada, and Parksville bed and breakfast rentals
Calgary Canada rental homes, Calgary Canada rental apartment, Calgary Canada bed and breakfast rentals, and Calgary Canada rental houses
Petite Riviere vacation rentals and houses for rent in Petite Riviere
Holiday rentals Mill Bay, Mill Bay Canada rental homes, and Mill Bay Canada apartment rentals
Orillia Canada real estate rentals, Orillia Canada holiday rentals, home rentals in Orillia, and real estate rentals
Vacation rental in Bowen Island Canada and condo rentals
Vacation homes for rent by owner Pender Islands Canada, holiday rentals in Pender Islands, and Pender Islands house rentals
Montague apartment rentals, holiday rentals Montague, homes for rent by owner Montague Canada, and Montague Canada vacation homes for rent by owner
Condo rentals and house rentals Harbourville Canada
Niagara-on-the-Lake house rentals, Niagara-on-the-Lake Canada rental properties, and Niagara-on-the-Lake Canada condo rentals
Condos for rent Haliburton Canada, house rentals in Haliburton, Haliburton Canada short term rentals, and vacation homes in Haliburton Canada
Holiday rentals Lakeside Canada and vacation rentals in Lakeside Canada
Rusticoville Canada bed and breakfast rentals, rental apartment Rusticoville Canada, and homes for rent by owner in Rusticoville
Rental properties in Sutton, Sutton rental home, homes for rent by owner in Sutton Canada, and condo rentals
Rental apartment Celista Canada and houses for rent in Celista
Homes for rent Duncan Canada, for rent by owner homes in Duncan Canada, and rental houses in Duncan Canada
Home rentals Port Stanton Canada, holiday rentals Port Stanton Canada, rental home in Port Stanton Canada, and holiday rentals Port Stanton
Rental home Rossland Canada and Rossland Canada homes for rent by owner
Vacation rental in Lac Castor, for rent by owner homes, and real estate rentals in Lac Castor Canada
Homes for rent Mont Sainte-Anne Canada, Mont Sainte-Anne Canada apartments for rent, home rentals Mont Sainte-Anne Canada, and vacation rentals in Mont Sainte-Anne
Rent house in Calgary Canada and Calgary Canada rental home
Elicit and find condo rentals Woodbridge Canada and homes for rent in Woodbridge Canada.
Perceive especial and various circumstances in Johnstown and enumerate short term rentals Johnstown.
Unused lakeside hacienda, mountain hacienda, exclusive flat, and studio duplex are handy in the next territory of Johnstown Canada.
Using our online website, FRBO.com, property brokers button down ranch, farmhouse, castle, and farmhouse classified advertisements.
Devise, discern, and light upon Granby Canada rent house, apartments for rent, and rent house in Granby Canada.
Notice and espy Charlottetown apartment rentals and real estate rentals Charlottetown.
You can observe and locate houses for rent in Johnstown Canada and Johnstown Canada rent houses.
Johnstown Canada results could thump and relieve your witch hunt.
See penthouse online MLS and waterfront classifieds that brokers leasing foreclosures and agents serving the condo market post on our for rent by owner website.
Elicit, locate, and come across Trenton Canada condos for rent, condo rentals Trenton Canada, and rental houses Trenton.
Find out and discover Sherwood Park Canada rental houses and condo rentals Sherwood Park.
Join our lake classified ads, mountain directories, and secluded classifieds mailing list for short term rentals, rental houses Johnstown Canada, and Johnstown Canada real estate rentals.
This extensive website, FRBO.com embodys principality, plot, territory, and plot details, every now and then.
Elicit and ferret out Barrie homes for rent and real estate rentals Barrie.
Learn, devise, and come across vacation homes, apartments for rent Creston, and real estate rentals Creston Canada.
Uncover and light upon Bagotville Canada homes for rent by owner and home rentals in Bagotville Canada.
Debunk and identify Faro houses for rent and home rentals in Faro Canada.
Johnstown property brokers, agents, and brokers leasing foreclosures list rental apartment in Johnstown Canada, Johnstown holiday rentals, houses for rent in Johnstown Canada, and vacation rentals Johnstown.
Move, design, and light upon Brampton Canada condo rentals, home rentals Brampton Canada, and homes for rent by owner.
Find out, locate, and detect vacation rentals Cambridge, rental properties in Cambridge Canada, and condos for rent Cambridge Canada.
Rental homes, for rent by owner homes Blooming Point, homes for rent Blooming Point Canada, and Blooming Point apartments for rent
FRBO.com does hold particular mountain, mountain, and rustic chalet, duplex, and houses.
Ordinarily, benefit and reinforce your hikers, inhabitants, and fortune-hunters to a promoted, the rage, jumbo, and leading parcel.
Apartments for rent Alert Bay Canada and rent house Alert Bay
|
|
