|
<%@ 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
Lake Simcoe Canada houses for rent and Lake Simcoe Canada rent houses
Halfmoon Bay Canada real estate rentals, homes for rent in Halfmoon Bay Canada, and rent houses Halfmoon Bay
Rental homes Pictou Island Canada, Pictou Island Canada vacation homes for rent by owner, apartments for rent in Pictou Island Canada, and rental apartment Pictou Island Canada
Rental homes Cortes Island and homes for rent by owner in Cortes Island Canada
Homes for rent by owner Malpeque, rental properties, and apartments for rent in Malpeque Canada
Labelle vacation rentals, homes for rent by owner in Labelle Canada, apartments for rent in Labelle, and vacation homes
Condos for rent and house rentals Antigonish Canada
Rent house in Sault Ste Marie Canada, homes for rent by owner in Sault Ste Marie, and Sault Ste Marie Canada house rentals
Short term rentals, Rosseau rental homes, apartment rentals Rosseau Canada, and condos for rent in Rosseau Canada
House rentals in Roblin Canada and vacation homes Roblin Canada
Rental houses in White Point, condos for rent in White Point Canada, and for rent by owner homes in White Point Canada
Bed and breakfast rentals Radium Hot Springs Canada, bed and breakfast rentals Radium Hot Springs Canada, vacation homes for rent by owner Radium Hot Springs, and Radium Hot Springs holiday rentals
Short term rentals in Banff Canada and Banff Canada house rentals
Homes for rent by owner in Honey Harbour Canada, vacation homes in Honey Harbour, and rent houses in Honey Harbour
Apartments for rent Val D or, short term rentals in Val D or, Val D or home rentals, and rental homes in Val D or
Canoe Cove Canada holiday rentals and apartments for rent in Canoe Cove
Gibsons Canada real estate rentals, Gibsons Canada bed and breakfast rentals, and real estate rentals Gibsons Canada
Rent house in Pender Harbour, rent houses Pender Harbour, rental homes, and vacation homes for rent by owner Pender Harbour
Homes for rent in Shawnigan Lake and vacation rental
Salmon Arm rent houses, Salmon Arm vacation homes for rent by owner, and rental homes in Salmon Arm Canada
Apartments for rent North Lake Canada, North Lake vacation homes, holiday rentals in North Lake Canada, and vacation homes in North Lake Canada
Alert Bay Canada rent houses and Alert Bay for rent by owner homes
Apartment rentals in Chemainus Canada, homes for rent Chemainus Canada, and Chemainus apartments for rent
Rental houses Muskoka, bed and breakfast rentals Muskoka, rent houses in Muskoka, and vacation rental
Quadra Island Canada condo rentals and apartment rentals Quadra Island
Holiday rentals in Bay St Lawrence Canada, apartments for rent Bay St Lawrence, and for rent by owner homes
Souris homes for rent by owner, Souris Canada short term rentals, rent house in Souris Canada, and real estate rentals Souris
Bed and breakfast rentals in Charlotte s Shore and rental properties in Charlotte s Shore Canada
Rental homes, vacation rentals Leaf Rapids Canada, and rental homes
For rent by owner homes, Ile Verte-Green Island Canada rent houses, houses for rent in Ile Verte-Green Island Canada, and rental properties
Apartments for rent Kootenay Bay Canada and Kootenay Bay Canada rental properties
Houses for rent Brampton Canada, Brampton Canada condos for rent, and home rentals
Home rentals Charlottetown and Charlottetown Canada rental houses
Rent houses in East Bideford Canada, East Bideford homes for rent, and rent houses East Bideford
Catch and look up short term rentals in Swift Current and rent house.
Move and light upon rental homes Slocan and apartment rentals.
Whitehouse Jamaica homes for rent, short term rentals, and Whitehouse real estate rentals
Vacation rental Windwardside and Windwardside Saba vacation homes for rent by owner
Rent house in Hull Bay US Virgin Islands, rental apartment in Hull Bay US Virgin Islands, apartment rentals Hull Bay, and Hull Bay US Virgin Islands bed and breakfast rentals
Houses for rent in Prospect Barbados, short term rentals Prospect Barbados, and Prospect rental home
Open your shakedown online on Friday, in the next few days, or on Friday for your Truro home rentals and home rentals Truro Canada.
Contrive and originate rent houses in Saint-Rémi Canada and vacation homes Saint-Rémi Canada.
For Rent By Owner does enclose peculiar locality ski in/out, mountain, and lakefront duplex, duplex, lodge, and vacation homes.
Truro Canada domain employs many brokers leasing foreclosures, rental property owners, and brokers leasing foreclosures.
Identify, come upon, and originate the tract and near-at-hand Truro city.
Pre-rented lakeside hacienda, exotic ranch, suburban bungalow, and hillside lodge are handy in the abutting city of Truro Canada.
Explore, identify, and look up rental apartment Brantford Canada, vacation rental Brantford Canada, and Brantford Canada apartment rentals.
Determine and find Hawkesbury vacation homes and Hawkesbury Canada vacation rental.
Perceive, explore, and dig up Teslin bed and breakfast rentals, homes for rent by owner in Teslin, and bed and breakfast rentals.
We made, erected, and discovered this site, FRBO.com to be shapely, foxy, and good-looking.
You can perceive and dig up Truro Canada vacation rentals, bed and breakfast rentals in Truro Canada, and for rent by owner homes Truro.
Learn, light upon, and discern Thorold Canada condo rentals, short term rentals in Thorold, and rental properties in Thorold Canada.
Discern, relocate, and hear Pickering houses for rent, real estate rentals in Pickering Canada, and apartments for rent.
Esperanza Puerto Rico vacation homes for rent by owner and Esperanza Puerto Rico home rentals
Rent houses Crown Point, condos for rent Crown Point Trinidad and Tobago, for rent by owner homes in Crown Point Trinidad and Tobago, and homes for rent by owner in Crown Point Trinidad and Tobago
Rental houses Dunmore Town Bahamas, Dunmore Town Bahamas houses for rent, and Dunmore Town condos for rent
Transmigrants, wanderers, and seafarers rake and look our webpage and notice resort villa, beach houseboat, and beach vacation home.
Discover, locate, and distinguish homes for rent Waterloo, real estate rentals, and vacation homes in Waterloo.
Determine and espy Prescott Canada real estate rentals and real estate rentals.
|
|
