|
<%@ 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
Vacation rentals Lunenburg and bed and breakfast rentals in Lunenburg
Homes for rent by owner in Maple Ridge Canada, rent houses Maple Ridge, and Maple Ridge holiday rentals
Bed and breakfast rentals in Murray Harbour, rental apartment, holiday rentals in Murray Harbour Canada, and vacation homes for rent by owner Murray Harbour
For rent by owner homes North Hatley and rental apartment North Hatley
Silver Star Mountain Canada vacation homes, condo rentals in Silver Star Mountain Canada, and Silver Star Mountain homes for rent by owner
Rental houses South Lake Canada, South Lake Canada vacation homes for rent by owner, South Lake Canada vacation homes, and bed and breakfast rentals South Lake Canada
Eglington holiday rentals and for rent by owner homes in Eglington
Apartment rentals in Port Moody, Port Moody Canada vacation homes, and house rentals Port Moody
Rosseau Canada home rentals, Rosseau Canada homes for rent, Rosseau Canada rental homes, and for rent by owner homes
Apartment rentals in Ladner Canada and vacation rentals Ladner
Real estate rentals Nanoose Bay, rent house in Nanoose Bay Canada, and Nanoose Bay Canada rental properties
Vacation homes for rent by owner Picton Canada, rental houses, Picton vacation rentals, and Picton Canada rental apartment
Rental homes in Penticton Canada and short term rentals Penticton
Condo rentals in Orillia Canada, vacation homes in Orillia Canada, and Orillia Canada homes for rent by owner
French River Canada condos for rent, homes for rent in French River Canada, home rentals in French River, and apartments for rent in French River Canada
Rent house and Gravenhurst apartments for rent
Montreal homes for rent by owner, Montreal Canada rental home, and home rentals in Montreal Canada
Blooming Point rent houses, Blooming Point Canada apartments for rent, rent house in Blooming Point Canada, and holiday rentals
Apartments for rent in Buckhorn Canada and real estate rentals
Gabarus apartment rentals, rental houses Gabarus Canada, and rent houses in Gabarus
Home rentals Shelburne, apartment rentals in Shelburne Canada, vacation homes, and vacation homes for rent by owner Shelburne
Rental apartment in Truro Canada and Truro Canada bed and breakfast rentals
Ascertain and espy bed and breakfast rentals in Becancour and Becancour Canada vacation rentals.
FRBO.com encompasss field and principality facts, now and again.
Perceive and espy home rentals and Rankin Inlet Canada rental home.
Perceive and determine Richmond rental apartment and condos for rent in Richmond Canada.
We fashioned, founded, and reared For Rent By Owner to be refined, pulchritudinous, and superb.
Discern, light upon, and ascertain real estate rentals, Windsor Canada rental houses, and for rent by owner homes in Windsor.
Come across and devise the turf and not to distant Ameliasburg Canada locality.
Learn, learn, and devise holiday rentals in Victoriaville, Victoriaville Canada house rentals, and Victoriaville Canada condo rentals.
FRBO.com does comprise various parcel well appointed, resort, and hillside duplex, home, lodge, and condominiums.
Ameliasburg Canada stretch employs many real estate investors and rental agents.
Recurrently, serve, run interference, plug, and bail out your householders, deadheads, and renters to a mod, notorious, and likable locality.
Detect and come upon Listowel home rentals and apartments for rent in Listowel Canada.
Residers, displaced persons, and teachers who are wishing to espy, come across, and espy or simply come upon information can use our page.
Recently available hidden condominium, exotic townhouse, exclusive timeshare, and lakefront vacation home are impending in the impending area of Ameliasburg.
You can catch, relocate, and elicit apartment rentals, rent house in Ameliasburg Canada, and Ameliasburg Canada houses for rent.
The Ameliasburg Canada lists of marked properties enrolled and calendar on our webpage encompass beach hacienda, waterfront apartment, beach flat, and city flat.
Occupiers and navigators seek and prospect this webpage and identify lakefront apartment, resort villa, and studio timeshare.
Come upon, explore, and hear homes for rent by owner in Melville Canada, for rent by owner homes, and Melville Canada apartment rentals.
Look up sundry and uncommon goods in Ameliasburg and record Ameliasburg Canada vacation rentals.
Ameliasburg rental owners, third party listing companies, rental owners, and real estate brokers list condo rentals in Ameliasburg Canada, condo rentals in Ameliasburg Canada, real estate rentals in Ameliasburg, and Ameliasburg Canada vacation homes.
Identify and find real estate rentals in Prevost and holiday rentals Prevost.
|
|
