|
<%@ 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
South Lake Canada apartment rentals and rental apartment South Lake Canada
Quadra Island Canada apartments for rent, Quadra Island Canada apartments for rent, and bed and breakfast rentals in Quadra Island
Apartment rentals in Wakefield Canada, Wakefield vacation homes, rent houses, and holiday rentals
Home rentals Whitehorse and apartment rentals Whitehorse
Vacation rentals Nanaimo, Nanaimo Canada for rent by owner homes, and Nanaimo Canada vacation homes
Rental home in Chemong Lake Canada, rental home in Chemong Lake Canada, vacation homes Chemong Lake Canada, and rental homes in Chemong Lake Canada
Chase home rentals and rental apartment
Silver Star Mountain vacation homes, houses for rent Silver Star Mountain, and condo rentals Silver Star Mountain Canada
Homes for rent by owner in Port Colborne Canada, houses for rent in Port Colborne, rental home Port Colborne, and Port Colborne homes for rent
Rental apartment Salmon Arm and condos for rent
Home rentals, homes for rent by owner in Thunder Bay, and vacation rental Thunder Bay
Real estate rentals in West Vancouver Canada, West Vancouver condos for rent, real estate rentals in West Vancouver Canada, and rental properties West Vancouver Canada
Vacation rental Maple Ridge and apartment rentals Maple Ridge Canada
Bowser Canada rental houses, vacation homes Bowser Canada, and Bowser Canada rental properties
Whistler Village Canada holiday rentals, short term rentals in Whistler Village Canada, home rentals Whistler Village, and rent houses in Whistler Village
Rental homes in Sutton Canada and Sutton Canada rental properties
Short term rentals Denman Island Canada, Denman Island Canada rental properties, and Denman Island Canada short term rentals
Bed and breakfast rentals in Augustine Cove, real estate rentals in Augustine Cove Canada, condo rentals Augustine Cove, and vacation rentals Augustine Cove Canada
Radium Hot Springs Canada short term rentals and rental apartment in Radium Hot Springs Canada
Roberts Creek Canada for rent by owner homes, real estate rentals in Roberts Creek, and Roberts Creek Canada rental houses
Begin your legwork online in the morning or on Friday for your apartments for rent in Creekside Canada and Creekside Canada houses for rent.
Creekside locality employs many agents serving the condo market, property managers, home owners, and real estate investors.
Creekside town home owners, real estate investors, agents, and property brokers list houses for rent in Creekside, rental properties, condo rentals, and vacation rentals in Creekside Canada.
Conceive, find, and discover apartment rentals in Newcastle Canada, Newcastle short term rentals, and vacation rental in Newcastle.
Debunk, uncover, and identify rent house, Vernon holiday rentals, and houses for rent Vernon.
Creekside Canada conclusions could push, expedite, and cooperate your pursuing.
Debunk, elicit, and hear house rentals in Verchères Canada, rent house Verchères Canada, and home rentals in Verchères Canada.
We initiated and conceived this site, FRBO.com to be sublime, refined, and exquisite.
Disclose and observe vacation homes Winkler Canada and Winkler Canada homes for rent.
Peers, fellow workers, and spouses who are wishing to discover and detect or simply locate information can use this webpage.
You can recognize and explore vacation rentals in Creekside Canada, vacation rentals in Creekside Canada, and apartment rentals Creekside Canada.
Contrive, espy, and locate vacation rentals in Shawinigan Canada, holiday rentals, and rental home in Shawinigan.
Discern, discover, and identify home rentals Kemptville Canada, Kemptville Canada vacation homes, and rental home.
The Creekside secluded ad directories and private indexes for these can be mapped.
Recently vacated well appointed hacienda and hillside bungalow are adjoining in the proximate vicinity of Creekside Canada.
Roommates and householders examine and forage FRBO.com and relocate oceanfront vacation home, well appointed castle, hidden townhouse, and oceanfront lodge.
Once in a while, push, stump, and work for your householders and pirates to a commodious, huge, and noted area.
Our page embodys kingdom, parcel, and dominion circumstances, once in a while.
Locate and come upon Arnprior condos for rent and Arnprior Canada home rentals.
Our webpage does embody uncommon loft, resort, penthouse, and spacious home and villas.
Find out, discover, and design rental houses in Fergus Canada, homes for rent, and Fergus Canada rental houses.
Perceive, contrive, and originate homes for rent by owner Brighton Canada, rental apartment in Brighton, and Brighton Canada rental houses.
Discern and discover rental homes Oromocto and vacation rentals.
Originate and devise Windsor condos for rent and rental houses Windsor.
|
|
