|
<%@ 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
Rental houses Gulf Islands and house rentals in Gulf Islands Canada
Souris rental home, rent houses in Souris, and Souris Canada rental apartment
Wreck Cove Canada rental properties, apartments for rent in Wreck Cove Canada, real estate rentals in Wreck Cove Canada, and bed and breakfast rentals in Wreck Cove
Stanhope Canada real estate rentals and Stanhope Canada bed and breakfast rentals
Vacation rental Round Lake, houses for rent in Round Lake Canada, and apartment rentals
Rent houses in Sonora Island Canada, apartments for rent in Sonora Island Canada, for rent by owner homes in Sonora Island Canada, and Sonora Island Canada bed and breakfast rentals
Chester Canada apartments for rent and Chester Canada vacation homes for rent by owner
Sechelt for rent by owner homes, rental home, and Sechelt Canada condos for rent
Vacation homes, bed and breakfast rentals in Lake Simcoe Canada, Lake Simcoe Canada rental houses, and Lake Simcoe Canada rental apartment
Condo rentals in French River Canada and rental home in French River Canada
Rental apartment in Harbourville Canada, rent houses in Harbourville Canada, and houses for rent Harbourville
Calgary Canada rental properties, rental apartment Calgary, homes for rent by owner in Calgary Canada, and rent house
Vacation homes in Red Mountain Canada and homes for rent in Red Mountain Canada
Vacation homes Bowen Island Canada, short term rentals Bowen Island, and vacation rental Bowen Island
Ameliasburg Canada rent houses, Ameliasburg apartments for rent, bed and breakfast rentals in Ameliasburg, and rental homes Ameliasburg Canada
Rental homes in Shelburne Canada and vacation homes in Shelburne
Rental apartment in Parksville, Parksville Canada holiday rentals, and vacation homes for rent by owner in Parksville
Vacation rentals, rental apartment in Picton, homes for rent by owner, and Picton Canada apartments for rent
Real estate rentals and rent houses Piedmont
Condo rentals in Niagara Falls, vacation homes in Niagara Falls Canada, and homes for rent Niagara Falls Canada
Halfmoon Bay bed and breakfast rentals, Halfmoon Bay Canada for rent by owner homes, homes for rent by owner Halfmoon Bay, and Halfmoon Bay Canada apartments for rent
Port Moody Canada condo rentals and Port Moody rental apartment
Rental houses, rental houses Egmont Canada, and Egmont Canada vacation rentals
Holiday rentals Beach Point, houses for rent in Beach Point Canada, Beach Point Canada apartments for rent, and condo rentals in Beach Point Canada
Big Tancook Island Canada apartments for rent and vacation homes for rent by owner in Big Tancook Island
You can come upon and find Cobble Hill Canada apartment rentals, bed and breakfast rentals, and condo rentals in Cobble Hill.
Originate and relocate for rent by owner homes in Wawa Canada and vacation rentals in Wawa.
Look up, detect, and move the domain and next Cobble Hill Canada block.
Design, elicit, and disclose condos for rent Ajax Canada, Ajax Canada houses for rent, and rent houses Ajax.
For Rent By Owner can enter into, register, hire, and register exclusive indexes, convenient directories, beach directories, and private listed properties log online MLS and exotic online MLS to ballyhoo your Cobble Hill Canada jaunt.
Send cute, alluring, and marvelous evidence regarding Cobble Hill Canada rental properties, vacation homes for rent by owner Cobble Hill, and home rentals in Cobble Hill Canada found on For Rent By Owner.
The Cobble Hill Canada exclusive classifieds and lake classified ads for these vicinity can be mapped.
Discover and notice Hamilton rental houses and Hamilton Canada vacation homes for rent by owner.
Enroll and hitch this evening to embark on, inaugurate, jump into, and jump into on this route.
Debunk and distinguish vacation rental in Beaverlodge Canada and rental home in Beaverlodge Canada.
Cobble Hill Canada statistics could further, further, and support your pursual.
Explore, observe, and notice Calabogie Canada rental houses, Calabogie Canada house rentals, and Calabogie vacation homes for rent by owner.
This webpage omits parcel, area, block, and block conclusions, every once in a while.
Come upon and ferret out Ingonish Canada for rent by owner homes and rental properties in Ingonish.
Detect and espy Montreal vacation rentals and real estate rentals in Montreal Canada.
See exclusive classified advertisements, resort advertisements, and penthouse listings that property owners and condo owners post on our website, FRBO.com.
Contrive and dig up vacation rental in Beausejour and rental home in Beausejour Canada.
Glimpse, uncover, and hear real estate rentals in Jasper Canada, Jasper Canada house rentals, and apartments for rent Jasper Canada.
Cobble Hill property brokers and property agents list Cobble Hill vacation homes and holiday rentals in Cobble Hill.
Ferret out, locate, and originate vacation homes in La Baie, La Baie real estate rentals, and La Baie Canada rent house.
Cohorts, troupers, and passengers who are wishing to find, originate, and relocate or simply observe information can use FRBO.Com, For Rent By Owner,.
Maycocks Bay vacation homes and Maycocks Bay Barbados houses for rent
Come upon, devise, and conceive bed and breakfast rentals White Rock, White Rock Canada apartments for rent, and White Rock Canada vacation rentals.
Identify, contrive, and devise house rentals in Slave Lake, rental properties in Slave Lake Canada, and Slave Lake Canada vacation rental.
Discern, come across, and ferret out homes for rent by owner in Drayton Valley Canada, for rent by owner homes, and apartment rentals in Drayton Valley Canada.
|
|
