|
<%@ 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
Oliver rental houses and Oliver house rentals
Rental houses Coquitlam, rental properties Coquitlam, and short term rentals
Rental home in Sun Peaks, vacation rental in Sun Peaks Canada, rental properties Sun Peaks Canada, and apartments for rent Sun Peaks
Homes for rent French River Canada and houses for rent in French River Canada
Apartments for rent, rent houses Okanagan Falls Canada, and Okanagan Falls Canada bed and breakfast rentals
Rental apartment, Round Lake Canada bed and breakfast rentals, Round Lake vacation homes for rent by owner, and rental homes in Round Lake Canada
Rental homes Leaf Rapids Canada and rent houses Leaf Rapids Canada
Saint Catharines vacation rental, bed and breakfast rentals in Saint Catharines Canada, and for rent by owner homes in Saint Catharines Canada
Petite Riviere Canada for rent by owner homes, rental houses in Petite Riviere Canada, Petite Riviere Canada bed and breakfast rentals, and Petite Riviere apartments for rent
House rentals in St Martins Canada and St Martins Canada vacation rentals
Vacation rentals Port Alberni Canada, Port Alberni Canada rent house, and rental houses in Port Alberni
Holiday rentals Port Carling Canada, apartment rentals Port Carling, Port Carling rental apartment, and rental home Port Carling
Petite Riviere Canada rental houses and Petite Riviere Canada homes for rent by owner
Rent houses West Vancouver Canada, vacation homes in West Vancouver Canada, and West Vancouver Canada condos for rent
Apartment rentals in Nelson Canada, Nelson Canada rental houses, homes for rent by owner, and vacation homes for rent by owner in Nelson Canada
Vacation rental Thetis Island Canada and Thetis Island Canada condo rentals
Vacation rental in Denman Island Canada, Denman Island homes for rent by owner, and Denman Island vacation rentals
For rent by owner homes in Sechelt Canada, rent houses Sechelt Canada, Sechelt Canada vacation rentals, and Sechelt Canada real estate rentals
Rental properties in Port Maitland Canada and apartments for rent
Houses for rent Duncan Canada, homes for rent by owner in Duncan, and homes for rent
Colchester Canada rent houses, condo rentals in Colchester, rent house in Colchester Canada, and houses for rent Colchester Canada
Short term rentals Lac-Superior and condo rentals in Lac-Superior
Rental home Stanhope, real estate rentals Stanhope, and apartment rentals
Road warriors, spouses, and husbands who are wishing to glimpse and identify or simply distinguish information can use our website, FRBO.com.
Richmond Canada is a sightly, wonderful, delicate, and beauteous precinct with fascinating, admirable, and radiant townhouse and castles.
Join our lake ads, rustic listed properties, log classifieds, and resort lists of marked properties mailing list for vacation homes for rent by owner Richmond Canada, houses for rent in Richmond, and short term rentals Richmond Canada.
Conceive, observe, and observe Southey vacation homes, Southey Canada bed and breakfast rentals, and Southey apartments for rent.
For Rent By Owner omits state, domain, state, and zone memorandums, customarily.
The Richmond Canada advertisements docketed and posted on this website, FRBO.com comprehend studio ranch and decadent ranch.
Find out, detect, and uncover for rent by owner homes in Casselman Canada, Casselman condos for rent, and Casselman Canada bed and breakfast rentals.
Recognize, locate, and identify rent houses in High Level, High Level Canada vacation rental, and vacation homes High Level Canada.
Richmond rental agents, brokers leasing foreclosures, agents, and third party listing companies list Richmond Canada real estate rentals, Richmond Canada rental apartment, and condos for rent in Richmond.
Relocate, design, and determine Delta Canada rental properties, apartment rentals Delta Canada, and apartments for rent in Delta Canada.
Identify, move, and devise holiday rentals in Kelowna Canada, rental home in Kelowna, and rental homes in Kelowna.
You can glimpse and identify real estate rentals Richmond and home rentals in Richmond.
Explore and disclose Bradford vacation homes for rent by owner and Bradford Canada houses for rent.
Our for rent by owner site, FRBO.com can hire, secure, conscribe, and recruit ski in/out directories, spacious listings, loft ad directories, and mountain directories ski in/out listings, lake online MLS, and romantic classifieds to cooperate your Richmond pilgrimage.
Elicit and ascertain apartment rentals and vacation homes for rent by owner New Maryland Canada.
For Rent By Owner does incorporate unusual area beach, lakeside, and spacious duplex, cottage, hacienda, and lodges.
Find and relocate condo rentals in Heriot Bay Canada and rent house Heriot Bay Canada.
Send fair and enticing statistics regarding Richmond Canada apartments for rent and Richmond apartments for rent found on FRBO.Com, For Rent By Owner,.
|
|
