|
<%@ 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 in Qualicum Beach Canada and Qualicum Beach Canada for rent by owner homes
Vacation homes in Summerside Canada, rental home in Summerside Canada, and for rent by owner homes in Summerside
Vacation rental in Brampton Canada, real estate rentals in Brampton Canada, Brampton Canada condos for rent, and real estate rentals Brampton Canada
For rent by owner homes in Creekside Canada and houses for rent in Creekside Canada
Rental homes in Blooming Point Canada, Blooming Point rental apartment, and Blooming Point rent houses
Sicamous Canada rental apartment, rental apartment in Sicamous, condo rentals in Sicamous Canada, and apartments for rent in Sicamous
Rent house Calabogie Canada and Calabogie home rentals
Big Tancook Island Canada homes for rent by owner, house rentals Big Tancook Island Canada, and houses for rent in Big Tancook Island Canada
Rent house in White Rock, White Rock short term rentals, vacation homes in White Rock Canada, and rental apartment
Short term rentals Whistler Village and holiday rentals in Whistler Village
Condos for rent in Carr s Landing, Carr s Landing Canada real estate rentals, and rental homes in Carr s Landing Canada
Short term rentals in Antigonish Canada, bed and breakfast rentals in Antigonish Canada, rental apartment Antigonish, and Antigonish Canada apartments for rent
Bowser Canada home rentals and rent house Bowser Canada
Rent houses, apartments for rent in Morin Heights Canada, and rent houses Morin Heights Canada
Vacation rentals in Shelburne Canada, vacation rental Shelburne Canada, bed and breakfast rentals in Shelburne Canada, and vacation homes for rent by owner in Shelburne Canada
Holiday rentals Gibsons Canada and rent house
Round Lake apartments for rent, vacation rental in Round Lake Canada, and homes for rent in Round Lake Canada
Homes for rent Montague, holiday rentals in Montague Canada, condo rentals Montague Canada, and Montague rent houses
North Vancouver Canada rent house and North Vancouver Canada apartment rentals
Collingwood Canada apartments for rent, rent houses Collingwood, and Collingwood Canada vacation homes
Rent houses Pender Islands Canada, house rentals in Pender Islands Canada, Pender Islands Canada rental homes, and vacation homes Pender Islands
House rentals in Leaf Rapids and condos for rent Leaf Rapids Canada
Halfmoon Bay Canada condos for rent, apartments for rent Halfmoon Bay, and bed and breakfast rentals in Halfmoon Bay
Home rentals, apartment rentals in Nanoose Bay Canada, real estate rentals in Nanoose Bay Canada, and rent houses in Nanoose Bay Canada
Real estate rentals Sonora Island Canada and Sonora Island Canada home rentals
Rent houses in Ladner Canada, Ladner apartments for rent, and homes for rent by owner Ladner Canada
French River Canada rental home, homes for rent by owner in French River, home rentals, and rental home French River Canada
Oliver property brokers, home owners, property agents, and real estate brokers list condo rentals in Oliver Canada, apartment rentals in Oliver, vacation homes for rent by owner Oliver Canada, and Oliver Canada bed and breakfast rentals.
Hear and locate the neighborhood and not to distant Oliver Canada zone.
Begin your chase online on Friday or on Tuesday for your vacation rental Oliver Canada, for rent by owner homes in Oliver Canada, and Oliver Canada rent houses.
Our site, FRBO.com does consist of diverse city rustic, romantic, lakeside, and studio cottage, villa, apartment, and vacation homes.
You can ferret out and hear vacation rentals in Oliver, homes for rent in Oliver Canada, and condos for rent in Oliver.
Originate specific, individual, original, and unusual evidence in Oliver Canada and chart Oliver Canada home rentals.
Find out, come across, and perceive Beaverlodge Canada rental houses, apartment rentals in Beaverlodge, and apartments for rent.
The Oliver Canada listed properties invoiced and set down on our for rent by owner website consist of lakefront flat, exclusive timeshare, beachfront chalet, and lake bungalow.
Real estate rentals Honey Harbour Canada, Honey Harbour Canada homes for rent by owner, and apartments for rent
Dig up and dig up homes for rent by owner in Kitimat Canada and apartments for rent in Kitimat Canada.
Dig up and detect vacation homes Prince Albert Canada and short term rentals.
Apartments for rent in Rancho Leonero, Rancho Leonero Mexico homes for rent, holiday rentals in Rancho Leonero Mexico, and Rancho Leonero house rentals
Come upon, learn, and debunk Antrim Canada condo rentals, rental apartment Antrim, and short term rentals in Antrim Canada.
Hear, identify, and perceive rental properties in Bellefeuille Canada, for rent by owner homes Bellefeuille, and rental apartment.
Elicit and glimpse real estate rentals and Grand Forks home rentals.
Oliver Canada principality employs many property agents and rental owners.
Our site, FRBO.com omits township, section, and territory info, sometimes.
Move, distinguish, and recognize rental home, Wabush Canada bed and breakfast rentals, and vacation rental in Wabush Canada.
Glimpse, identify, and catch vacation homes for rent by owner Saint Stephen Canada, house rentals, and Saint Stephen real estate rentals.
Dig up and discern rental properties in Dundalk and Dundalk Canada homes for rent.
At times, help and facilitate your locals and travelers to a preferred, well-known, sought, and gorgeous territory.
Observe, invent, and glimpse condo rentals in Morinville Canada, vacation homes, and house rentals in Morinville.
FRBO.Com, For Rent By Owner, can muster and hire secluded classified ads, log online MLS, romantic listed properties, and hidden classified advertisements oceanfront advertisements, resort advertisements, and mountain classified ads to bail out your Oliver tour.
Fraternity members and townies who are wishing to contrive and find or simply hear information can use this website, FRBO.com.
Find out and ascertain Digby homes for rent by owner and vacation rental Digby Canada.
Espy and come across short term rentals in Caronport Canada and Caronport Canada rental properties.
Jet-setters, students, and lodgers who are searching Oliver for rent by owner homes and are trying to learn apartments for rent in Oliver Canada and vacation rentals in Oliver Canada can rifle through For Rent By Owner and our mountain classified advertisements, suburban classifieds, spacious classified advertisements, and ski in/out advertisements.
|
|
