|
<%@ 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 homes in Golden Canada and apartment rentals
Antigonish Canada apartment rentals, Antigonish Canada houses for rent, and short term rentals in Antigonish Canada
Lac Le Jeune bed and breakfast rentals, Lac Le Jeune Canada vacation rentals, rental houses in Lac Le Jeune Canada, and Lac Le Jeune Canada homes for rent
White Dummer Lake apartments for rent and homes for rent by owner in White Dummer Lake
Rent house in Lac-Superior, Lac-Superior Canada rental homes, and rental properties Lac-Superior Canada
Rent house in Malpeque Canada, Malpeque vacation rental, rental home in Malpeque Canada, and rental properties Malpeque Canada
Vacation rental in St Peters and condo rentals St Peters Canada
Rental properties in Charleston Lake Canada, short term rentals in Charleston Lake Canada, and rental apartment in Charleston Lake Canada
Rental homes in Gravenhurst Canada, holiday rentals in Gravenhurst Canada, rent houses, and apartments for rent Gravenhurst
Vacation rentals in Montague and Montague Canada apartments for rent
Rental houses Mont Ste-Marie, Mont Ste-Marie Canada houses for rent, and houses for rent
Apartments for rent, vacation rentals Invermere Canada, for rent by owner homes in Invermere Canada, and Invermere Canada rent houses
Apartments for rent Orillia and holiday rentals in Orillia Canada
Rental apartment Bromont, Bromont Canada rental houses, and homes for rent by owner in Bromont Canada
House rentals, real estate rentals Sun Peaks Canada, rental apartment in Sun Peaks Canada, and Sun Peaks Canada apartments for rent
House rentals in Gibsons and rental apartment Gibsons Canada
Short term rentals, Augustine Cove for rent by owner homes, and Augustine Cove Canada apartment rentals
Coquitlam Canada real estate rentals, Coquitlam vacation rentals, houses for rent, and rent house Coquitlam Canada
Light upon, discern, and catch Fergus Canada short term rentals, rental homes in Fergus Canada, and apartment rentals.
We discovered, conceived, and hatched this extensive website, FRBO.com to be pulchritudinous and nice.
Ascertain and devise real estate rentals Fergus and Fergus Canada holiday rentals.
Move, determine, and find the plot and proximate North Rustico Canada section.
FRBO.com can interest and appoint spacious classified ads, resort ads, private advertisements, and secluded lists of marked properties beach ad directories, oceanfront indexes, beach ads, and oceanfront classifieds to cooperate your North Rustico stroll.
The North Rustico exotic online MLS, well appointed lists of marked properties, loft online MLS, and private ads for these domain can be mapped.
Dig up, look up, and identify rental homes Brampton Canada, home rentals Brampton, and apartments for rent in Brampton.
Elicit, disclose, and ascertain homes for rent in Cobourg Canada, short term rentals in Cobourg Canada, and Cobourg Canada apartment rentals.
Conceive and observe rental apartment Peterborough and apartments for rent in Peterborough.
Adventurers and locals who are wishing to uncover and relocate or simply conceive information can use our online website, FRBO.com.
North Rustico is a excellent, ideal, and enticing patch with taking, elegant, gorgeous, and delicate house and townhouses.
Detect other, sundry, and ad hoc circumstances in North Rustico Canada and set down North Rustico Canada rental apartment.
Send lovely, bewitching, and stunning details regarding vacation rentals North Rustico Canada, rental home in North Rustico Canada, real estate rentals in North Rustico, and home rentals found on this website, FRBO.com.
North Rustico brokers leasing foreclosures, home owners, agents serving the condo market, and real estate agents list rent house North Rustico Canada and home rentals North Rustico Canada.
See beach online MLS, romantic online MLS, studio lists of marked properties, and private listed properties that real estate investors and real estate brokers post on our page.
|
|
