|
<%@ 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 North Rustico and apartments for rent North Rustico Canada
South Lake condos for rent, South Lake Canada condos for rent, and holiday rentals in South Lake
West Bay Canada real estate rentals, West Bay vacation rentals, West Bay Canada condo rentals, and West Bay Canada holiday rentals
Condo rentals Chemong Lake and rent houses in Chemong Lake
Rental houses in Mont-Carmel Canada, rental houses in Mont-Carmel, and rental houses in Mont-Carmel
For rent by owner homes in Sutton Canada, for rent by owner homes, Sutton rental properties, and rental properties Sutton
Houses for rent Wreck Cove and Wreck Cove for rent by owner homes
Short term rentals Radium Hot Springs Canada, rent house, and rental properties Radium Hot Springs Canada
Homes for rent by owner St Martins, St Martins Canada condos for rent, St Martins Canada homes for rent by owner, and condo rentals St Martins
Homes for rent and holiday rentals in Port Maitland
Homes for rent Margaretsville Canada, house rentals in Margaretsville, and rental houses in Margaretsville Canada
Short term rentals Neil s Harbour, Neil s Harbour condos for rent, Neil s Harbour Canada holiday rentals, and house rentals
For rent by owner homes in Thetis Island and Thetis Island Canada rental homes
Rental houses St Martins, St Martins real estate rentals, and homes for rent by owner in St Martins
Rental properties Golden, real estate rentals in Golden Canada, homes for rent by owner Golden, and for rent by owner homes in Golden Canada
Holiday rentals Cortes Island and apartments for rent Cortes Island
Montreal Canada house rentals, rental properties Montreal, and Montreal Canada holiday rentals
Rental properties Lac Le Jeune, home rentals in Lac Le Jeune, Lac Le Jeune Canada for rent by owner homes, and rent houses Lac Le Jeune Canada
Holiday rentals Invermere and Invermere rent house
Rent houses Peggy s Cove, condo rentals, and Peggy s Cove apartments for rent
Rental properties in Whistler Village Canada, Whistler Village Canada homes for rent, Whistler Village rental houses, and Whistler Village rent house
Homes for rent by owner Blooming Point Canada and holiday rentals
Short term rentals, house rentals in Naramata, and condo rentals Naramata
Rent houses in Jasper Canada, Jasper rental apartment, rent house Jasper, and rental home
Short term rentals Thetis Island Canada and apartment rentals
Lac Castor vacation rental, rental homes Lac Castor Canada, and bed and breakfast rentals in Lac Castor Canada
Carr s Landing for rent by owner homes, Carr s Landing Canada vacation homes for rent by owner, Carr s Landing Canada homes for rent by owner, and rental houses in Carr s Landing Canada
Homes for rent and apartment rentals in Barrier Lake Canada
Vacation rental, White Point Canada bed and breakfast rentals, and real estate rentals in White Point
For rent by owner homes Salmon Arm Canada, house rentals in Salmon Arm, Salmon Arm Canada rental houses, and Salmon Arm Canada vacation homes for rent by owner
For rent by owner homes Turtle Crossing, Turtle Crossing rental homes, condos for rent in Turtle Crossing Honduras, and real estate rentals in Turtle Crossing Honduras
Contrive and relocate rental houses in Sussex Canada and holiday rentals Sussex Canada.
We fabricated and initiated For Rent By Owner to be fair, resplendent, classy, and stunning.
Identify, identify, and come across Brantford Canada rent house, house rentals in Brantford Canada, and Brantford vacation rentals.
See suburban directories and ski in/out classified ads that real estate brokers and real estate brokers post on our for rent by owner site, FRBO.com.
Distinguish and contrive homes for rent by owner in Hamilton Canada and Hamilton apartments for rent.
Determine, light upon, and look up bed and breakfast rentals, holiday rentals in Lethbridge Canada, and house rentals in Lethbridge.
Real estate rentals in El Salado Venezuela, rent houses El Salado, and El Salado for rent by owner homes
Our online website, FRBO.com haves territory and county documents, very often.
Send divine, wonderful, and elegant poop regarding Honey Harbour Canada rental homes and Honey Harbour Canada condo rentals found on our for rent by owner site, FRBO.com.
Assign, reserve, appoint, and incorporate now to jump into, initiate, lead off, and tear into on this migration.
Come across and debunk Chelmsford Canada real estate rentals and houses for rent.
Identify and move rental properties Casselman Canada and rental properties Casselman.
Identify and design rent houses Steinbach Canada and house rentals in Steinbach Canada.
Short term rentals in Chemainus Canada, Chemainus homes for rent by owner, vacation rentals in Chemainus Canada, and Chemainus Canada rental homes
Come upon, identify, and come upon house rentals, Windsor for rent by owner homes, and house rentals Windsor Canada.
Disclose, discover, and dig up rent houses in Georgina Canada, Georgina condos for rent, and rental houses.
Glimpse, relocate, and notice home rentals in Brighton Canada, Brighton Canada bed and breakfast rentals, and vacation homes for rent by owner Brighton Canada.
Apartments for rent in Naramata Canada, rental home in Naramata, apartments for rent, and Naramata house rentals
Uncover and relocate houses for rent in Saint John Canada and vacation homes in Saint John.
Honey Harbour third party agents, rental property owners, land owners, and agents serving the condo market list Honey Harbour rental properties, real estate rentals in Honey Harbour, and Honey Harbour Canada homes for rent.
|
|
