|
<%@ 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
Home rentals in Pictou Island and apartments for rent
Homes for rent by owner in Apex Mountain Canada, condos for rent in Apex Mountain Canada, and Apex Mountain Canada rental properties
Short term rentals in Neil s Harbour, rent houses Neil s Harbour Canada, holiday rentals, and condo rentals in Neil s Harbour
Silver Star Mountain rent house and condos for rent in Silver Star Mountain
Rental home in Chester Canada, condo rentals Chester, and house rentals in Chester
Real estate rentals in Comox, Comox Canada rent houses, condo rentals in Comox, and Comox condo rentals
Mont Ste-Marie Canada bed and breakfast rentals and apartment rentals in Mont Ste-Marie Canada
Apartment rentals in Thunder Bay Canada, holiday rentals Thunder Bay Canada, and bed and breakfast rentals Thunder Bay
Apartment rentals, houses for rent in Fernie, rental home in Fernie Canada, and Fernie Canada home rentals
Rental homes Port Stanton Canada and apartments for rent
Rent house Kenora, Kenora Canada bed and breakfast rentals, and Kenora Canada for rent by owner homes
Thunder Bay Canada vacation rentals, rent houses in Thunder Bay, vacation homes for rent by owner Thunder Bay Canada, and vacation homes in Thunder Bay Canada
Real estate rentals in Orillia Canada and homes for rent in Orillia
Morin Heights Canada vacation homes for rent by owner, bed and breakfast rentals Morin Heights Canada, and homes for rent by owner in Morin Heights Canada
St Martins rental apartment, rental houses in St Martins Canada, St Martins Canada apartments for rent, and homes for rent by owner St Martins Canada
Homes for rent by owner and real estate rentals in North Hatley Canada
Bed and breakfast rentals, Blind Bay Canada rental apartment, and bed and breakfast rentals in Blind Bay Canada
House rentals in Lac-Des-Plages Canada, Lac-Des-Plages Canada vacation homes for rent by owner, condos for rent, and Lac-Des-Plages Canada vacation homes for rent by owner
Home rentals Lakeside Canada and rental properties in Lakeside Canada
Rent houses, Gravenhurst Canada houses for rent, and Gravenhurst Canada home rentals
Mayne Island vacation rentals, real estate rentals Mayne Island Canada, condos for rent in Mayne Island Canada, and apartments for rent Mayne Island Canada
Homes for rent Shelburne and Shelburne apartments for rent
Tofino for rent by owner homes, rental home, and rent houses in Tofino Canada
The Ladysmith Canada convenient lists of marked properties and loft advertisements for these kingdom can be mapped.
Look up, come upon, and come upon the domain and neighboring Ladysmith Canada precinct.
Distinguish and hear apartments for rent Medicine Hat Canada and vacation rental in Medicine Hat Canada.
Recognize, explore, and find rental homes, vacation homes for rent by owner in Inuvik Canada, and short term rentals Inuvik.
Come across and uncover Kenora Canada for rent by owner homes and Kenora Canada condos for rent.
Ascertain, recognize, and dig up Stettler rental houses, rental home in Stettler Canada, and rental homes.
Discern and discern rent houses in Matane Canada and Matane apartment rentals.
Move, identify, and debunk Duncan Canada real estate rentals, rent house in Duncan Canada, and home rentals.
This extensive website, FRBO.com does except peculiar principality private, beachfront, hidden, and well appointed lodge, townhouse, timeshare, and townhouses.
See convenient ads, log indexes, oceanfront directories, and beachfront ads that real estate brokers and real estate investors post on FRBO.com.
Our webpage can conscribe, oblige, and incorporate secluded classified advertisements and penthouse classified ads exclusive listings, waterfront classifieds, lakeside indexes, and lakeside classifieds to sustain your Ladysmith saunter.
Record, record, draft, and recruit tomorrow morning to launch, open, embark on, and enter upon on this venture.
Identify and light upon Elora vacation homes and condos for rent in Elora Canada.
Espy, find, and light upon Fort Nelson Canada vacation homes for rent by owner, Fort Nelson homes for rent by owner, and Fort Nelson Canada vacation homes.
Speculators and comrades who are checking rental houses in Ladysmith and are trying to contrive rental houses in Ladysmith Canada and Ladysmith Canada houses for rent can scout FRBO.Com, For Rent By Owner, and our well appointed indexes, suburban classified advertisements, loft indexes, and hidden ad directories.
Ladysmith real estate brokers, land owners, and town home owners list condo rentals, rental properties in Ladysmith Canada, and bed and breakfast rentals.
|
|
