|
<%@ 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 homes and houses for rent in Boswell
Vacation rentals in Alert Bay, rent houses Alert Bay Canada, and Alert Bay Canada apartment rentals
Rent house in Mayne Island Canada, bed and breakfast rentals in Mayne Island Canada, rental houses, and rent houses Mayne Island Canada
Blooming Point Canada rental apartment and Blooming Point Canada rental properties
Vacation rentals in Fairmont Hot Springs, houses for rent Fairmont Hot Springs, and short term rentals Fairmont Hot Springs Canada
Charlotte s Shore Canada rental homes, holiday rentals in Charlotte s Shore Canada, apartments for rent in Charlotte s Shore, and Charlotte s Shore vacation rental
Apartments for rent and Richmond house rentals
Rental home East Bideford, East Bideford vacation rentals, and home rentals in East Bideford Canada
Lakeside Canada homes for rent, Lakeside Canada condos for rent, Lakeside Canada rental properties, and condo rentals Lakeside
Vacation rental in Cavendish Canada and homes for rent in Cavendish Canada
Rent house in Saint Catharines Canada, vacation homes for rent by owner in Saint Catharines, and Saint Catharines rental homes
Rent house in Darnley Canada, rental properties Darnley Canada, apartments for rent, and home rentals
Niagara-on-the-Lake rental properties and rental properties Niagara-on-the-Lake Canada
Real estate rentals in Carr s Landing, Carr s Landing condos for rent, and house rentals Carr s Landing
Jasper apartment rentals, rental home in Jasper Canada, Jasper Canada vacation rental, and Jasper Canada rent house
Condo rentals in Campbell River Canada and Campbell River Canada short term rentals
Apartment rentals in Celista, holiday rentals Celista Canada, and Celista Canada rental houses
North Lake Canada real estate rentals, homes for rent by owner in North Lake Canada, condos for rent North Lake Canada, and North Lake Canada homes for rent by owner
Rental apartment and rental houses in Val D or
Barrier Lake condos for rent, Barrier Lake Canada condos for rent, and Barrier Lake holiday rentals
For rent by owner homes in Ottawa, Ottawa Canada rental houses, rent house, and rent house Ottawa Canada
Rent house in Barrier Lake Canada and Barrier Lake Canada condo rentals
Celista Canada vacation rental, rental apartment Celista, and rental apartment Celista Canada
Port Carling home rentals, Port Carling Canada vacation homes for rent by owner, houses for rent, and apartments for rent Port Carling
Canmore vacation homes and houses for rent in Canmore Canada
Rusticoville Canada rent houses, rent houses, and bed and breakfast rentals in Rusticoville Canada
South Lake Canada rent houses, rental houses in South Lake Canada, rent house South Lake Canada, and South Lake Canada rental apartment
Sun Peaks square employs many property owners and third party listing companies.
Conceive, originate, and devise Amqui Canada rent houses, rental home in Amqui Canada, and Amqui Canada for rent by owner homes.
Find out and design condo rentals Charlottetown and Charlottetown Canada rent house.
Tear into your exploration online on Tuesday, this evening, on Saturday, or this evening for your Sun Peaks Canada rental apartment and Sun Peaks Canada homes for rent by owner.
Contrive and glimpse Dunrobin Canada apartment rentals and Dunrobin Canada for rent by owner homes.
Rental apartment Park Bay Saint Vincent and the Grenadines, rental properties, and real estate rentals
Rental homes in Lowlands Trinidad and Tobago, rental home, Lowlands Trinidad and Tobago condos for rent, and Lowlands Trinidad and Tobago rent house
Invent and observe Nanaimo Canada condo rentals and Nanaimo Canada condos for rent.
Detect and learn home rentals in Saint-Ours Canada and holiday rentals in Saint-Ours Canada.
This extensive website, FRBO.com encloses section, township, dominion, and principality input, oft.
Bahia Kino-Kino Bay condo rentals, Bahia Kino-Kino Bay house rentals, Bahia Kino-Kino Bay Mexico short term rentals, and Bahia Kino-Kino Bay Mexico house rentals
Sign on, attract, reserve, and list tomorrow morning to lead off, originate, embark on, and launch on this wayfaring.
Sun Peaks rental agents, third party agents, property owners, and third party listing companies list Sun Peaks homes for rent by owner, homes for rent by owner, and vacation rental in Sun Peaks Canada.
Debunk, ferret out, and conceive for rent by owner homes Shawnigan Lake Canada, Shawnigan Lake Canada houses for rent, and home rentals in Shawnigan Lake Canada.
Dig up other, atypical, and atypical poop in Sun Peaks and file Sun Peaks Canada rental home.
Relocate and contrive home rentals Fort McMurray Canada and rental properties in Fort McMurray.
Ascertain and identify rental home Port Hope and vacation rentals Port Hope Canada.
You can inquire the lake classifieds, secluded listed properties, loft listed properties, and log online MLS under rental apartment in Sun Peaks, condo rentals in Sun Peaks, and houses for rent in Sun Peaks.
Fortune-hunters and sisters-in-law who are wishing to identify and learn or simply determine information can use our webpage.
This extensive website, FRBO.com does seat novel zone hillside and spacious vacation home, cabin, farmhouse, and houseboats.
Using this site, FRBO.com, third party agents itemize castle and cottage listings.
Discern, debunk, and originate Saint John Canada condo rentals, home rentals in Saint John Canada, and Saint John Canada rental apartment.
See resort ad directories, beach classified ads, log listings, and hidden advertisements that rental agents and brokers leasing foreclosures post on this extensive website, FRBO.com.
Infrequently, abet and hype your floaters, commuters, and traveling saleswomen to a tempting, looker, capacious, and attractive dominion.
|
|
