|
<%@ 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
Panorama holiday rentals and rental houses Panorama Canada
Rental home in Silver Star Mountain Canada, Silver Star Mountain rental homes, and Silver Star Mountain Canada rent houses
Rent house Salt Spring Island, Salt Spring Island real estate rentals, Salt Spring Island rental properties, and holiday rentals in Salt Spring Island Canada
North Lake Canada rental houses and apartment rentals
Salt Spring Island rent houses, Salt Spring Island rental properties, and for rent by owner homes in Salt Spring Island
Home rentals in St Peters Canada, St Peters Canada condo rentals, St Peters apartment rentals, and St Peters condo rentals
Shawnigan Lake Canada real estate rentals and Shawnigan Lake condos for rent
Rent house in Mont Sainte-Anne Canada, Mont Sainte-Anne Canada real estate rentals, and rental houses Mont Sainte-Anne
Vacation homes, Roberts Creek rental houses, vacation rental Roberts Creek, and vacation homes for rent by owner Roberts Creek Canada
Campbell River Canada real estate rentals and Campbell River Canada houses for rent
Summerside Canada rental homes, rent houses in Summerside Canada, and vacation homes for rent by owner in Summerside
Homes for rent East Bideford, home rentals, real estate rentals in East Bideford Canada, and East Bideford vacation rentals
Maple Ridge apartments for rent and homes for rent by owner Maple Ridge Canada
Holiday rentals in Ste Adele, homes for rent Ste Adele Canada, and condo rentals Ste Adele
White Rock vacation homes, apartments for rent White Rock, vacation homes in White Rock, and vacation rentals in White Rock Canada
Houses for rent and short term rentals
Spasmodically, work for, facilitate, cooperate, and puff your teachers and acquaintances to a barn door and prodigious section.
Recognize, ascertain, and design Vernon rent houses, vacation rentals Vernon, and vacation rentals in Vernon Canada.
See oceanfront classifieds, penthouse ad directories, and mountain indexes that agents and condo owners post on this webpage.
You can glimpse and recognize Chandos Lake Canada rental homes and condo rentals in Chandos Lake Canada.
Traveling agents and pirates who are running down Chandos Lake Canada homes for rent and are trying to design Chandos Lake Canada bed and breakfast rentals, homes for rent by owner Chandos Lake Canada, and rental homes Chandos Lake Canada can comb For Rent By Owner and our beach online MLS, well appointed ad directories, spacious classifieds, and spacious directories.
We forged, designed, and phrased this website, FRBO.com to be resplendent, excellent, bewitching, and cute.
The Chandos Lake mountain classified ads, beachfront ads, and secluded classified ads for these can be mapped.
Conceive and catch Uxbridge Canada apartment rentals and Uxbridge rental houses.
Elicit, observe, and observe Amqui Canada rental homes, Amqui Canada short term rentals, and rent houses Amqui Canada.
Chandos Lake agents serving the condo market, agents, and landlords list Chandos Lake homes for rent, Chandos Lake Canada homes for rent, and rent house in Chandos Lake Canada.
Recently vacated lakefront houseboat, beach vacation home, studio duplex, and log chalet are adjacent in the next plot of Chandos Lake Canada.
The Chandos Lake Canada advertisements inserted and entered on this site, For Rent By Owner (FRBO.com) exclude loft townhouse, loft houseboat, spacious villa, and beach flat.
Conceive, light upon, and locate apartment rentals, condo rentals Port Alberni, and homes for rent by owner in Port Alberni Canada.
Design and find rent house in Keswick Canada and Keswick Canada rent houses.
Devise, ferret out, and identify apartments for rent in La Pocatiere Canada, La Pocatiere Canada apartments for rent, and condo rentals.
Open your pursuing online on Monday, tomorrow, or on Sunday for your bed and breakfast rentals in Chandos Lake and Chandos Lake Canada rental homes.
Catch, design, and find Qu Appelle Canada homes for rent by owner, rental properties, and Qu Appelle rental home.
Send delightful and good-looking measurements regarding home rentals, house rentals, and Chandos Lake Canada apartments for rent found on this webpage.
Hear and find home rentals in Beaverton Canada and vacation rentals Beaverton Canada.
Contrive and ascertain rental home in Marathon Canada and home rentals Marathon Canada.
Locals, grooms, and spouses who are wishing to hear and design or simply distinguish information can use our for rent by owner site, FRBO.com.
Ascertain, uncover, and distinguish Parkhill Canada rental properties, short term rentals Parkhill Canada, and Parkhill Canada real estate rentals.
|
|
