|
<%@ 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
Brigus condo rentals and Brigus Canada houses for rent
Condo rentals Niagara-on-the-Lake Canada, Niagara-on-the-Lake Canada rent house, and rent houses in Niagara-on-the-Lake Canada
Honey Harbour Canada homes for rent by owner, vacation rental Honey Harbour Canada, real estate rentals Honey Harbour, and homes for rent by owner in Honey Harbour
Rental homes Halfmoon Bay and Halfmoon Bay Canada rental home
Banff vacation rentals, Banff Canada homes for rent, and for rent by owner homes
Ste Adele vacation rentals, Ste Adele Canada for rent by owner homes, condos for rent in Ste Adele, and Ste Adele homes for rent by owner
Vacation rentals in Lake Cowichan Canada and apartment rentals in Lake Cowichan
Holiday rentals in Murray Harbour Canada, Murray Harbour homes for rent by owner, and Murray Harbour apartments for rent
House rentals in Cape Sable Island, vacation rentals in Cape Sable Island Canada, apartment rentals in Cape Sable Island, and house rentals in Cape Sable Island Canada
Gravenhurst rental home and rental apartment in Gravenhurst Canada
Vacation homes in Edmonton Canada, for rent by owner homes, and homes for rent in Edmonton
Blooming Point apartment rentals, rental homes in Blooming Point, rental properties in Blooming Point Canada, and Blooming Point apartment rentals
Homes for rent in Eglington Canada and holiday rentals
Sidney Canada home rentals, rental apartment in Sidney, and Sidney Canada vacation homes for rent by owner
Rent house Haliburton Canada, short term rentals, short term rentals, and Haliburton Canada condo rentals
Kenora Canada apartments for rent and apartment rentals Kenora Canada
For rent by owner homes in Peachland Canada, rental properties Peachland, and rental apartment Peachland
Real estate rentals in Petite Riviere, apartments for rent Petite Riviere, holiday rentals, and home rentals in Petite Riviere Canada
Vacation homes Collingwood Canada and Collingwood Canada real estate rentals
Vacation homes for rent by owner in North Rustico Canada, North Rustico Canada condos for rent, and homes for rent in North Rustico
Cape Sable Island Canada rental apartment, vacation rentals in Cape Sable Island Canada, Cape Sable Island Canada rental apartment, and Cape Sable Island for rent by owner homes
Cape Sable Island Canada condos for rent and rental homes
Holiday rentals in North Lake Canada, condos for rent, and house rentals North Lake Canada
Bed and breakfast rentals in Bromont Canada, Bromont Canada homes for rent, Bromont Canada apartments for rent, and holiday rentals Bromont Canada
Mont Tremblant homes for rent by owner and Mont Tremblant rental houses
Tofino Canada vacation rentals, vacation rental in Tofino Canada, and vacation homes Tofino Canada
Lake Simcoe Canada rental apartment, house rentals in Lake Simcoe, condo rentals Lake Simcoe, and Lake Simcoe Canada condo rentals
Home rentals in Chase Canada and homes for rent by owner in Chase Canada
Bed and breakfast rentals in Wasaga Beach Canada, Wasaga Beach Canada short term rentals, and holiday rentals Wasaga Beach
Rent houses, Annapolis Royal Canada short term rentals, Annapolis Royal condos for rent, and Annapolis Royal Canada rental apartment
Pictou Island vacation homes and vacation rental in Pictou Island Canada
Homes for rent by owner in Courtenay Canada, rental houses Courtenay Canada, and Courtenay rental properties
Invermere apartments for rent and rental properties in Invermere
Darnley house rentals, Darnley rental apartment, and condo rentals Darnley Canada
Lake Simcoe Canada is a enticing, well-formed, and nice area with exquisite, good-looking, enticing, and pretty timeshare, hacienda, hacienda, and vacation homes.
Detect, locate, and design real estate rentals in Saanichton Canada, bed and breakfast rentals in Saanichton Canada, and Saanichton Canada home rentals.
Homes for rent in Pelican Beach US Virgin Islands, houses for rent in Pelican Beach US Virgin Islands, Pelican Beach vacation homes for rent by owner, and rent house in Pelican Beach US Virgin Islands
Debunk, light upon, and uncover apartments for rent Moosonee, houses for rent in Moosonee Canada, and Moosonee condo rentals.
Ferret out and disclose rent houses Port Elgin Canada and short term rentals.
Venturers, tourists, and roommates who are grubbing short term rentals in Lake Simcoe Canada and are trying to look up vacation rentals in Lake Simcoe, Lake Simcoe Canada real estate rentals, and Lake Simcoe Canada vacation rental can seek this site, For Rent By Owner (FRBO.com) and our beachfront classifieds, exclusive directories, and romantic listed properties.
Hear and uncover house rentals in Happy Valley-Goose Bay and Happy Valley-Goose Bay Canada rental homes.
Determine extraordinary, specialized, specific, and specific abstracts in Lake Simcoe and docket apartments for rent in Lake Simcoe.
Conceive and notice apartment rentals in Milton and house rentals Milton.
Muster, initiate, incorporate, and initiate on Wednesday to originate, get cracking, originate, and open on this peregrination.
Send excellent, classy, radiant, and symmetrical poop sheet regarding Lake Simcoe Canada homes for rent and vacation homes Lake Simcoe found on our site, FRBO.com.
The Lake Simcoe spacious classified advertisements and well appointed listed properties for these domain can be mapped.
Displaced persons, troupers, and expeditionists who are wishing to devise, hear, and recognize or simply uncover information can use our online website, FRBO.com.
This website, FRBO.com does seat unconventional square convenient, spacious, and lake cottage and homes.
Come upon and devise vacation homes for rent by owner North York and North York homes for rent.
Learn, conceive, and disclose rental apartment, homes for rent Parksville Canada, and rental homes in Parksville Canada.
Hear, dig up, and come across Saint-Basile Canada homes for rent, Saint-Basile condos for rent, and condo rentals in Saint-Basile.
Dig up, disclose, and look up Val-Belair Canada rental apartment, Val-Belair Canada home rentals, and homes for rent by owner.
Join our waterfront lists of marked properties, resort lists of marked properties, and beach ad directories mailing list for rent house in Lake Simcoe, Lake Simcoe Canada homes for rent, and apartment rentals in Lake Simcoe.
Ferret out, discern, and determine Saint-Hippolyte-de-Kilkenny rent houses, for rent by owner homes Saint-Hippolyte-de-Kilkenny, and Saint-Hippolyte-de-Kilkenny Canada homes for rent by owner.
See convenient classified ads, beach ads, private indexes, and lakeside indexes that real estate investors and property owners post on this site, FRBO.com.
Discern and catch rental apartment in Lindsay Canada and homes for rent by owner Lindsay Canada.
Detect and identify Fort Nelson Canada rental home and apartment rentals in Fort Nelson.
Detect, devise, and notice rent houses Squamish Canada, Squamish Canada homes for rent, and real estate rentals in Squamish Canada.
Perceive and glimpse rent house Swift Current and apartment rentals in Swift Current Canada.
Find out and ferret out rental homes in Edson Canada and short term rentals Edson.
|
|
