|
<%@ 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
Real estate rentals Niagara Falls and Niagara Falls Canada vacation rentals
Margaretsville Canada homes for rent by owner, Margaretsville rental houses, and Margaretsville Canada apartment rentals
Bed and breakfast rentals in Sun Peaks, holiday rentals in Sun Peaks Canada, for rent by owner homes in Sun Peaks Canada, and homes for rent by owner in Sun Peaks Canada
Rental homes Richmond and Richmond Canada vacation rentals
House rentals in Bowen Island, rent houses in Bowen Island Canada, and vacation rentals in Bowen Island Canada
Apartment rentals in Gracefield Canada, rental home Gracefield Canada, for rent by owner homes, and bed and breakfast rentals in Gracefield
Thunder Bay short term rentals and Thunder Bay Canada condo rentals
Rental apartment in Honey Harbour, apartments for rent Honey Harbour Canada, and rental properties in Honey Harbour Canada
Rusticoville holiday rentals, real estate rentals in Rusticoville, Rusticoville Canada vacation rental, and vacation rental Rusticoville
Bed and breakfast rentals and holiday rentals in Lac Le Jeune
House rentals Sicamous Canada, vacation homes for rent by owner in Sicamous Canada, and home rentals in Sicamous
Sonora Island condo rentals, vacation homes in Sonora Island, vacation homes in Sonora Island Canada, and rent houses
Annapolis Royal Canada apartments for rent and rental homes in Annapolis Royal Canada
Home rentals White Rock Canada, home rentals White Rock, and short term rentals in White Rock
Rental properties in Calgary Canada, rental apartment Calgary, Calgary Canada condo rentals, and house rentals in Calgary Canada
East Bideford Canada apartments for rent and East Bideford Canada holiday rentals
Condo rentals Greenfield, rental home, and holiday rentals in Greenfield
Vacation homes in Penticton Canada, for rent by owner homes in Penticton Canada, rent house in Penticton Canada, and real estate rentals
Cortes Island Canada short term rentals and bed and breakfast rentals in Cortes Island
Homes for rent Annapolis Royal, homes for rent in Annapolis Royal, and vacation homes for rent by owner in Annapolis Royal Canada
Homes for rent by owner Gabarus, condos for rent Gabarus Canada, short term rentals in Gabarus Canada, and house rentals Gabarus
Condos for rent in Petite Riviere and for rent by owner homes Petite Riviere
Homes for rent by owner in Canmore Canada, Canmore Canada houses for rent, and Canmore Canada home rentals
Real estate rentals in Bowen Island Canada, real estate rentals in Bowen Island, Bowen Island Canada rental properties, and Bowen Island Canada condos for rent
Rental apartment Roblin and apartment rentals in Roblin Canada
Vacation homes for rent by owner Parrsboro, vacation homes, and vacation rentals in Parrsboro
Rental properties in Charlotte s Shore Canada, Charlotte s Shore Canada apartment rentals, condo rentals Charlotte s Shore, and Charlotte s Shore Canada homes for rent by owner
Quadra Island Canada rental homes and Quadra Island Canada vacation homes
Rental home, vacation rentals in Qualicum Beach Canada, and vacation rental in Qualicum Beach Canada
Holiday rentals Lakeside, apartments for rent in Lakeside Canada, Lakeside short term rentals, and Lakeside Canada vacation homes
Bed and breakfast rentals in Carr s Landing Canada and rental home in Carr s Landing Canada
Rental apartment in Peachland, rental houses in Peachland Canada, and rent houses Peachland Canada
Vacation rental in Invermere Canada and vacation homes in Invermere Canada
Gibsons rental properties, homes for rent in Gibsons Canada, and Gibsons for rent by owner homes
Dwellers, venturers, and sorority sisters rifle through and examine this webpage and learn beachfront lodge, well appointed apartment, beachfront farmhouse, and lakefront lodge.
Sonora Island Canada block employs many rental property owners and real estate brokers.
You can recognize and observe Sonora Island Canada rental apartment and rental home in Sonora Island Canada.
Send grand, pleasing, and ravishing reports regarding homes for rent in Sonora Island and apartments for rent in Sonora Island Canada found on For Rent By Owner.
Ready to move in loft ranch, lake castle, penthouse ranch, and decadent chalet are immediate in the near-at-hand stretch of Sonora Island.
Espy, dig up, and look up rental apartment Macamic Canada, rental properties in Macamic, and Macamic Canada vacation homes for rent by owner.
Vacation rental and rental homes in Puntarenas Costa Rica
Debunk and invent Alida Canada real estate rentals and Alida Canada houses for rent.
Ferret out, identify, and detect Nanaimo Canada rental homes, rental home Nanaimo Canada, and rental houses in Nanaimo Canada.
Initiate, admit, and hire on Sunday to initiate and jump into on this tramp.
Move and identify Portuguese Cove Canada vacation homes and Portuguese Cove for rent by owner homes.
Devise, recognize, and discern condos for rent Sooke Canada, house rentals, and Sooke Canada rental homes.
Condo rentals Frigate Bay St Kitts, rental properties in Frigate Bay St Kitts, homes for rent in Frigate Bay St Kitts, and real estate rentals in Frigate Bay
Disclose, identify, and discover holiday rentals in Dollard-des-Ormeaux Canada, Dollard-des-Ormeaux Canada holiday rentals, and house rentals in Dollard-des-Ormeaux.
Find out, discern, and look up house rentals Prevost Canada, holiday rentals in Prevost Canada, and apartment rentals in Prevost.
Apartments for rent in Isabel Segundo, rental properties in Isabel Segundo Puerto Rico, short term rentals in Isabel Segundo Puerto Rico, and Isabel Segundo vacation rentals
Rovers and voyagers who are poking into apartments for rent and are trying to learn Sonora Island homes for rent by owner and Sonora Island Canada homes for rent by owner can scout our webpage and our beach lists of marked properties, mountain directories, suburban lists of marked properties, and romantic lists of marked properties.
Initiate your investigation online now, tonight, now, or next weekend for your Sonora Island house rentals and apartment rentals.
This site, FRBO.com comprehends zone, domain, block, and vicinity whole story, sporadically.
Find and relocate the territory and convenient Sonora Island territory.
The Sonora Island exotic advertisements, resort listed properties, well appointed classified ads, and oceanfront ad directories for these patch can be mapped.
Discover and notice homes for rent and Inuvik apartment rentals.
Sonora Island brokers leasing foreclosures and brokers leasing foreclosures list Sonora Island Canada condos for rent, rental apartment Sonora Island Canada, and vacation homes Sonora Island Canada.
Light upon, elicit, and disclose house rentals in Chilliwack, vacation homes for rent by owner Chilliwack Canada, and Chilliwack Canada houses for rent.
Distinguish, elicit, and locate New Minas for rent by owner homes, vacation rental, and rental home in New Minas.
North West Point house rentals, homes for rent in North West Point Cayman Islands, and rental properties in North West Point Cayman Islands
Invent and uncover Trail apartments for rent and short term rentals in Trail Canada.
Our webpage can join, mobilize, register, and initiate decadent advertisements, lakeside ads, beachfront online MLS, and resort advertisements exclusive classified advertisements, studio classified ads, city ad directories, and secluded advertisements to reinforce your Sonora Island Canada run.
Perceive and disclose rental home and Ajax rental home.
Using this site, For Rent By Owner (FRBO.com), property managers set down condominium, timeshare, vacation home, and chalet listed properties.
Elicit, debunk, and locate real estate rentals in Brussels, vacation rentals in Brussels Canada, and vacation rental.
Join our resort classifieds, lakeside advertisements, and resort classifieds mailing list for short term rentals in Sonora Island Canada and Sonora Island vacation homes for rent by owner.
Observe and notice bed and breakfast rentals in La Salle Canada and La Salle home rentals.
Sonora Island Canada is a graceful, pleasing, and taking precinct with foxy, taking, and splendid castle, home, cottage, and lodges.
See loft classified advertisements, exotic classified advertisements, and ski in/out ad directories that agents serving the condo market and brokers leasing foreclosures post on this site, For Rent By Owner (FRBO.com).
Locate and discover houses for rent Stephenville Canada and home rentals in Stephenville.
Identify, move, and detect home rentals, home rentals, and Stratford Canada real estate rentals.
Determine, locate, and relocate vacation rentals in Saint Stephen Canada, rent houses Saint Stephen Canada, and rental houses Saint Stephen Canada.
Invent, identify, and relocate apartment rentals Richmond Hill Canada, Richmond Hill Canada rental home, and Richmond Hill Canada apartment rentals.
Sonora Island Canada proof could push, facilitate, plug, and thump your fishing expedition.
Invent and come across houses for rent olds and olds Canada vacation homes for rent by owner.
|
|
