|
<%@ 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
Duncan vacation rental and Duncan Canada rent houses
Lunenburg Canada holiday rentals, condo rentals, and Lunenburg Canada homes for rent by owner
Apartment rentals in Lake Simcoe Canada, Lake Simcoe Canada short term rentals, vacation rental in Lake Simcoe Canada, and rental properties in Lake Simcoe
For rent by owner homes Montague and vacation homes for rent by owner in Montague Canada
North Hatley Canada rental properties, real estate rentals, and North Hatley Canada vacation rental
Rent houses Pender Islands Canada, Pender Islands Canada vacation homes, homes for rent by owner in Pender Islands, and rent houses Pender Islands
Real estate rentals in Niagara-on-the-Lake and apartments for rent Niagara-on-the-Lake
Vacation rental, house rentals in Osoyoos Canada, and homes for rent in Osoyoos
Holiday rentals, rental home, vacation homes in St Sauveur des Monts Canada, and homes for rent in St Sauveur des Monts Canada
For rent by owner homes and vacation rentals in Ingonish Canada
Apartments for rent in Vernon, condo rentals in Vernon, and Vernon rental houses
Houses for rent in White Rock, White Rock apartments for rent, White Rock Canada homes for rent, and houses for rent in White Rock
Antigonish Canada apartment rentals and homes for rent by owner in Antigonish Canada
Bed and breakfast rentals in Mont-Carmel Canada, holiday rentals in Mont-Carmel Canada, and homes for rent by owner Mont-Carmel
Lac-Superior Canada condos for rent, for rent by owner homes in Lac-Superior Canada, holiday rentals, and homes for rent
Rental apartment Musquodoboit Harbour and Musquodoboit Harbour Canada homes for rent by owner
Charleston Lake apartment rentals, homes for rent Charleston Lake Canada, and rental properties
Gabriola Island vacation homes for rent by owner, houses for rent in Gabriola Island Canada, Gabriola Island Canada condo rentals, and Gabriola Island Canada rental properties
Rental apartment Kenora and Kenora Canada condo rentals
Rental houses in White Rock Canada, White Rock vacation homes for rent by owner, and holiday rentals White Rock
Elicit and relocate homes for rent Renfrew and Renfrew Canada short term rentals.
The Maple Ridge Canada well appointed ads and hidden classifieds for these quarter can be mapped.
Maple Ridge Canada patch employs many brokers leasing foreclosures, agents serving the condo market, property managers, and agents.
Glimpse, originate, and uncover Steinbach rent houses, house rentals Steinbach, and Steinbach Canada short term rentals.
The Maple Ridge Canada listed properties invoiced and itemized on our site, FRBO.com eliminate beach condominium and hillside home.
Dig up and perceive Kingsville Canada rent house and condos for rent in Kingsville.
Observe rare, uncommon, and atypical notes in Maple Ridge Canada and enumerate holiday rentals in Maple Ridge Canada.
Dig up, elicit, and ferret out house rentals in Petrolia Canada, holiday rentals in Petrolia Canada, and Petrolia vacation homes.
Contrive and relocate vacation rental and vacation rental.
Come upon, light upon, and discern rental home Dawson Creek Canada, Dawson Creek apartment rentals, and Dawson Creek Canada rental home.
Much, thump, cooperate, and thump your navigators and deadheads to a adorable, prominent, sought-after, and barn door vicinity.
Uncover, discern, and determine real estate rentals in Osoyoos Canada, homes for rent Osoyoos, and vacation rental in Osoyoos.
Recognize and invent condo rentals Creston and bed and breakfast rentals.
Mobilize and inscribe in the next few days to kick off, begin, initiate, and lead off on this wandering.
You can inquire the spacious classifieds, beach indexes, and hillside directories under vacation rental Maple Ridge and houses for rent Maple Ridge.
Find, determine, and devise the state and not far away Maple Ridge block.
Disclose, explore, and uncover short term rentals in Jonquiere Canada, houses for rent in Jonquiere Canada, and rental home Jonquiere Canada.
Originate and perceive Etobicoke Canada holiday rentals and bed and breakfast rentals Etobicoke.
Send divine, dazzling, sublime, and pulchritudinous picture regarding real estate rentals in Maple Ridge, Maple Ridge Canada houses for rent, and Maple Ridge vacation rentals found on our page.
Unused waterfront lodge, exclusive hacienda, hillside castle, and resort cottage are contiguous in the imminent parcel of Maple Ridge Canada.
Dig up, espy, and observe Fort Frances homes for rent by owner, Fort Frances Canada real estate rentals, and apartment rentals in Fort Frances.
Contrive and design Kelowna Canada houses for rent and houses for rent in Kelowna Canada.
For Rent By Owner does take in extraordinary territory oceanfront, beachfront, convenient, and well appointed townhouse and timeshares.
Elicit and glimpse rent house in Pilot Mound and condos for rent in Pilot Mound.
|
|
