|
<%@ 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 home in Mayne Island Canada and short term rentals in Mayne Island Canada
Gulf Islands Canada house rentals, Gulf Islands Canada bed and breakfast rentals, and Gulf Islands bed and breakfast rentals
Rent houses Chester, Chester Canada rental properties, vacation homes for rent by owner, and Chester Canada house rentals
Vacation rentals and Toronto Canada house rentals
Gibsons Canada rent house, homes for rent, and Gibsons apartment rentals
For rent by owner homes, rental homes Creekside Canada, Creekside Canada holiday rentals, and apartments for rent Creekside
Rental houses Penetanguishene Canada and Penetanguishene Canada condo rentals
Picton home rentals, apartments for rent in Picton, and condo rentals Picton
Vacation rental, rental home in Charleston Lake Canada, real estate rentals, and Charleston Lake Canada condos for rent
Rental apartment in Panorama and condo rentals
For rent by owner homes in Thunder Bay Canada, house rentals in Thunder Bay, and Thunder Bay Canada for rent by owner homes
Homes for rent Gibsons, vacation rental in Gibsons Canada, holiday rentals Gibsons, and holiday rentals in Gibsons Canada
Distinguish, catch, and glimpse Port Hardy rental home, short term rentals in Port Hardy Canada, and Port Hardy Canada vacation homes for rent by owner.
You can glimpse and dig up Penetanguishene home rentals and Penetanguishene for rent by owner homes.
For Rent By Owner does eliminate rare well appointed and private townhouse and cabins.
The Penetanguishene mountain classifieds, studio classified ads, resort ads, and hidden classified advertisements for these patch can be mapped.
Glimpse and devise rent house in Summerland Canada and Summerland Canada houses for rent.
Jump into your quest online this week, on Wednesday, or on Friday for your homes for rent by owner in Penetanguishene Canada and homes for rent.
Perceive, devise, and look up vacation rentals in Boucherville, Boucherville Canada condos for rent, and Boucherville condo rentals.
Penetanguishene tract employs many condo owners, rental owners, and real estate investors.
Penetanguishene Canada is a gorgeous, pleasing, marvelous, and classy parcel with nice and grand home and townhouses.
Penetanguishene condo owners and town home owners list rental home in Penetanguishene Canada, holiday rentals, and home rentals Penetanguishene Canada.
Come upon and learn the plot and impending Penetanguishene Canada block.
See hidden classified ads, resort classified ads, decadent online MLS, and exotic classified ads that brokers leasing foreclosures and agents serving the condo market post on FRBO.Com, For Rent By Owner,.
We composed, parented, and planned our for rent by owner website to be divine, exquisite, and lovely.
Procure, record, hitch, and reserve in the morning to inaugurate, lead off, enter upon, and kick off on this itinerary.
This website, FRBO.com can reserve and engage mountain classified ads, secluded ads, and resort lists of marked properties well appointed classifieds and well appointed classified ads to back your Penetanguishene outing.
Send splendid, superb, and gorgeous knowledge regarding apartment rentals in Penetanguishene Canada, apartment rentals in Penetanguishene Canada, and Penetanguishene vacation rentals found on our website, FRBO.com.
Traveling men, ramblers, and brothers who are wishing to uncover, ferret out, and come across or simply relocate information can use FRBO.com.
This website, FRBO.com eliminates area, section, area, and territory reports, every now and then.
Relocate and relocate Kincardine rent houses and home rentals.
|
|
