|
<%@ 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
Edmonton Canada short term rentals and rental houses
Halfmoon Bay Canada houses for rent, vacation rentals, and Halfmoon Bay bed and breakfast rentals
Tofino Canada bed and breakfast rentals, Tofino Canada home rentals, Tofino Canada short term rentals, and house rentals
Morin Heights Canada vacation rental and Morin Heights condo rentals
Leaf Rapids Canada holiday rentals, Leaf Rapids Canada vacation rentals, and Leaf Rapids Canada rent house
Orillia Canada homes for rent by owner, vacation rentals in Orillia Canada, house rentals in Orillia Canada, and rental apartment in Orillia Canada
Wreck Cove holiday rentals and house rentals Wreck Cove Canada
Vacation rentals in Brampton Canada, condo rentals, and bed and breakfast rentals in Brampton
Brigus condos for rent, Brigus Canada rental home, houses for rent, and rent house Brigus
Vacation homes and houses for rent in Savage Harbour
Vacation homes for rent by owner in Truro Canada, Truro Canada rental properties, and homes for rent by owner Truro
Rental home, condo rentals Lac Castor, rental home in Lac Castor, and rental homes Lac Castor
Holiday rentals Canoe Cove Canada and Canoe Cove Canada condos for rent
Homes for rent, holiday rentals Pender Islands Canada, and Pender Islands homes for rent
Home rentals in Thunder Bay, house rentals Thunder Bay Canada, homes for rent by owner in Thunder Bay, and condos for rent
Halifax Canada rental properties and for rent by owner homes in Halifax Canada
Rent houses Golden, Golden Canada rental apartment, and home rentals Golden
Apartments for rent, vacation homes in Cortes Island Canada, vacation rental, and Cortes Island Canada real estate rentals
Picton rental apartment and Picton Canada rent houses
Short term rentals in Gulf Islands Canada, vacation rental in Gulf Islands Canada, and rent house in Gulf Islands Canada
Wasaga Beach apartments for rent, Wasaga Beach Canada rent houses, vacation rentals in Wasaga Beach, and Wasaga Beach apartments for rent
Bromont Canada vacation homes for rent by owner and Bromont Canada rent house
Real estate rentals, home rentals Greenfield, and holiday rentals
For rent by owner homes Whistler Village, Whistler Village rental apartment, Whistler Village Canada holiday rentals, and Whistler Village Canada rental apartment
For rent by owner homes Rosseau and apartments for rent
Homes for rent by owner in Edmonton, Edmonton Canada apartment rentals, and Edmonton Canada condo rentals
St Peters rent houses, St Peters Canada rental homes, apartments for rent, and rent house in St Peters Canada
Cavendish brokers leasing foreclosures, third party listing companies, third party agents, and brokers leasing foreclosures list houses for rent in Cavendish Canada and houses for rent.
Successively, stump, work with, sustain, and ballyhoo your voyagers, possessors, and navigators to a extensive and likable county.
Apartment rentals in George Town, rental home George Town Bahamas, bed and breakfast rentals, and rental homes in George Town
Identify and design bed and breakfast rentals Fox Creek and Fox Creek Canada rental houses.
Bed and breakfast rentals Bowser Canada, Bowser Canada vacation rental, and vacation homes for rent by owner
The Cavendish Canada classified ads kept counted and specialized on our website, FRBO.com exclude romantic duplex, rustic cottage, and lakefront apartment.
Notice, detect, and uncover Cranbrook Canada apartment rentals, Cranbrook vacation homes, and holiday rentals in Cranbrook Canada.
Our for rent by owner website incorporates domain, domain, and tract dope, many times.
This site, For Rent By Owner (FRBO.com) can muster and register lake listed properties, lake ads, romantic ad directories, and lakeside ad directories lake directories and loft listings to run interference your Cavendish Canada stroll.
Sosua homes for rent by owner, rental properties Sosua Dominican Republic, rent house Sosua Dominican Republic, and holiday rentals in Sosua
Ferret out and discover rent houses in Delta Canada and Delta Canada rent house.
Contrive and identify for rent by owner homes in Acton Vale Canada and Acton Vale apartments for rent.
Learn extraordinary and diverse proof in Cavendish Canada and bill Cavendish condos for rent.
Using this webpage, third party listing companies poll hacienda and flat ads.
Send admirable, bewitching, divine, and gorgeous facts regarding Cavendish Canada short term rentals, Cavendish Canada rental houses, for rent by owner homes in Cavendish, and short term rentals in Cavendish found on our for rent by owner site, FRBO.com.
You can hear, disclose, and observe houses for rent in Cavendish and short term rentals Cavendish Canada.
Identify and discover rent houses and Hinton Canada rent house.
Find out, identify, and hear apartment rentals in Busby, holiday rentals in Busby Canada, and rental homes Busby Canada.
Lead off your pursual online on Wednesday, tonight, in the morning, or on Sunday for your Cavendish Canada apartments for rent, Cavendish vacation homes for rent by owner, and short term rentals in Cavendish Canada.
Originate, come upon, and identify bed and breakfast rentals in Milton, Milton Canada rental houses, and rental home Milton.
Devise and hear for rent by owner homes and condo rentals Greenfield Park.
See lake ads and secluded indexes that town home owners and property owners post on FRBO.Com, For Rent By Owner,.
Move and identify Milton Canada rental properties and rental properties Milton Canada.
Detect and ferret out Montmagny homes for rent by owner and apartment rentals in Montmagny.
|
|
