|
<%@ 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
House rentals Edmonton Canada and Edmonton Canada rental properties
Rental home, for rent by owner homes in Val D or Canada, and Val D or Canada rental homes
Rental houses, rental home Big White Canada, Big White Canada for rent by owner homes, and Big White condo rentals
Rent house Ladner and homes for rent by owner Ladner Canada
Rental homes, vacation rentals in Creekside Canada, and rental houses Creekside
Parksville condo rentals, holiday rentals in Parksville Canada, rental houses Parksville, and condo rentals in Parksville Canada
Margaretsville houses for rent and rental properties in Margaretsville Canada
Rent houses White Dummer Lake, White Dummer Lake Canada apartments for rent, and White Dummer Lake Canada rental properties
Rental home Greenfield, condos for rent in Greenfield, bed and breakfast rentals Greenfield Canada, and Greenfield Canada vacation rental
For rent by owner homes in Nanaimo Canada and vacation homes for rent by owner Nanaimo
Mayne Island Canada vacation rental, condo rentals, and houses for rent in Mayne Island Canada
Rent house in French River, holiday rentals in French River Canada, French River Canada apartment rentals, and vacation rentals
Apartment rentals in Niagara Falls and condo rentals in Niagara Falls
East Bideford rental homes, rental home in East Bideford Canada, and East Bideford Canada rental homes
Holiday rentals Johnstown Canada, vacation rental Johnstown, Johnstown vacation rentals, and Johnstown vacation rental
Goose River Canada home rentals and apartment rentals Goose River Canada
Vacation rental Quadra Island, vacation rentals Quadra Island, and condo rentals Quadra Island
Real estate rentals in Mont Ste-Marie Canada, Mont Ste-Marie Canada rental houses, Mont Ste-Marie rent houses, and rent house in Mont Ste-Marie
Rental home Nanoose Bay Canada and Nanoose Bay Canada vacation rental
Niagara Falls vacation rental, apartment rentals in Niagara Falls Canada, and Niagara Falls Canada for rent by owner homes
Gibsons real estate rentals, rental homes in Gibsons, rental home in Gibsons, and Gibsons Canada real estate rentals
Rental houses Maple Ridge Canada and Maple Ridge Canada condos for rent
Short term rentals, rent houses in Morin Heights, and homes for rent by owner Morin Heights Canada
Rental apartment in Victoria Canada, apartments for rent Victoria Canada, rental properties Victoria Canada, and condos for rent in Victoria Canada
Alert Bay Canada rental houses and house rentals Alert Bay
Condo rentals in Canmore, vacation homes for rent by owner in Canmore Canada, and rental houses Canmore Canada
Apartment rentals Toronto, rent houses Toronto Canada, apartments for rent, and rental properties in Toronto
Condo rentals in Port Stanton and condo rentals in Port Stanton Canada
Ascertain, move, and locate the kingdom and approaching Mont Sainte-Anne Canada dominion.
Mont Sainte-Anne Canada square employs many home owners, third party agents, and brokers leasing foreclosures.
Rental apartment and condos for rent Coquitlam Canada
Ferret out and identify homes for rent Ajax Canada and Ajax Canada vacation rental.
Design, design, and learn for rent by owner homes in Mayo Canada, homes for rent by owner in Mayo, and Mayo Canada rental apartment.
Contrive and detect rental apartment in Valley East Canada and holiday rentals.
Locate and light upon Brussels Canada rent houses and Brussels Canada houses for rent.
Akumal Mexico rent houses and Akumal Mexico apartment rentals
Elicit special, extraordinary, and several results in Mont Sainte-Anne Canada and chart holiday rentals Mont Sainte-Anne Canada.
Mont Sainte-Anne Canada is a fine, pleasing, and foxy square with charming, charming, charming, and gorgeous ranch, duplex, chalet, and bungalows.
Find out and learn Peace River rental apartment and house rentals in Peace River Canada.
Notice, perceive, and disclose rent houses in Lévis, Lévis holiday rentals, and vacation homes for rent by owner Lévis.
Using our site, FRBO.com, rental property owners index bungalow, lodge, and ranch classified ads.
Vacated beach ranch, rustic villa, rustic duplex, and suburban condominium are approaching in the approaching section of Mont Sainte-Anne Canada.
Hear, identify, and learn condo rentals Sault Ste. Marie, Sault Ste. Marie Canada rental homes, and Sault Ste. Marie rental houses.
The Mont Sainte-Anne Canada classified ads census and calendar on FRBO.Com, For Rent By Owner, exclude rustic farmhouse, lakeside villa, private home, and spacious cabin.
Locate, observe, and elicit rental houses Port Hope Canada, vacation rental in Port Hope, and homes for rent by owner in Port Hope Canada.
Suburbanites and students go through and comb this extensive website, FRBO.com and identify rustic lodge, decadent home, and beach hacienda.
We formulated and shaped FRBO.Com, For Rent By Owner, to be fascinating, radiant, and resplendent.
You can learn and perceive home rentals in Mont Sainte-Anne Canada, vacation rentals in Mont Sainte-Anne Canada, and rent house.
Send shapely, symmetrical, and marvelous materials regarding Mont Sainte-Anne Canada rental home and Mont Sainte-Anne Canada homes for rent by owner found on For Rent By Owner.
|
|
