|
<%@ 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
Rusticoville Canada vacation homes for rent by owner and Rusticoville for rent by owner homes
Honey Harbour Canada condos for rent, Honey Harbour for rent by owner homes, and homes for rent Honey Harbour Canada
Canoe Cove for rent by owner homes, Canoe Cove Canada house rentals, Canoe Cove vacation rental, and rental properties in Canoe Cove Canada
Mabel Lake Canada rental houses and Mabel Lake vacation homes
Creekside Canada bed and breakfast rentals, vacation homes Creekside, and houses for rent in Creekside Canada
Apartment rentals Annapolis Royal Canada, vacation rental in Annapolis Royal Canada, rental houses in Annapolis Royal, and vacation homes for rent by owner Annapolis Royal
Homes for rent by owner Whitehorse Canada and Whitehorse Canada for rent by owner homes
North Hatley condo rentals, North Hatley Canada vacation rental, and vacation homes for rent by owner in North Hatley
Duncan Canada rent house, rental houses in Duncan Canada, Duncan Canada bed and breakfast rentals, and rental properties Duncan Canada
Point Prim Canada rent houses and homes for rent by owner in Point Prim Canada
Denman Island Canada for rent by owner homes, vacation homes for rent by owner Denman Island, and for rent by owner homes in Denman Island
Condo rentals, rental apartment Lac-Des-Plages Canada, Lac-Des-Plages Canada house rentals, and rent houses Lac-Des-Plages Canada
Vacation homes and vacation homes for rent by owner in Bowen Island Canada
Parrsboro Canada condo rentals, holiday rentals in Parrsboro Canada, and condo rentals Parrsboro Canada
Leaf Rapids Canada apartment rentals, real estate rentals Leaf Rapids, rental properties Leaf Rapids Canada, and house rentals in Leaf Rapids
Condo rentals in Port Carling Canada and homes for rent in Port Carling Canada
Homes for rent by owner, apartments for rent Orillia Canada, and Orillia Canada vacation rental
Rental homes, Ingonish Canada for rent by owner homes, for rent by owner homes in Ingonish, and Ingonish Canada house rentals
Ste Adele Canada vacation rental and rent houses in Ste Adele Canada
Whistler Canada house rentals, condo rentals, and Whistler Canada rental houses
Vacation rental in Richmond Canada, condo rentals in Richmond Canada, Richmond Canada apartment rentals, and Richmond Canada vacation homes for rent by owner
Victoria condos for rent and homes for rent in Victoria Canada
Bed and breakfast rentals in Bay Fortune, homes for rent by owner in Bay Fortune, and Bay Fortune Canada real estate rentals
Real estate rentals, condos for rent Beach Point Canada, rental houses Beach Point Canada, and Beach Point Canada home rentals
Real estate rentals in Mont Ste-Marie Canada and Mont Ste-Marie rental homes
Red Mountain home rentals, vacation homes for rent by owner, and homes for rent Red Mountain Canada
Rental properties in Eglington, houses for rent, homes for rent by owner in Eglington Canada, and Eglington Canada apartments for rent
Bed and breakfast rentals in Cavendish Canada and rent houses Cavendish Canada
Discern specific, express, specialized, and ad hoc circumstances in Fairmont Hot Springs Canada and inscribe vacation homes for rent by owner Fairmont Hot Springs.
Identify and find out Sault Ste. Marie Canada real estate rentals and apartments for rent Sault Ste. Marie Canada.
Catch and ascertain homes for rent by owner in Moose Jaw Canada and houses for rent Moose Jaw.
Fairmont Hot Springs Canada measurements could collaborate, abet, and relieve your exploration.
Design and dig up Langley Canada vacation homes and Langley Canada rent house.
Originate, glimpse, and dig up houses for rent in Saint-Jovite Canada, rental homes Saint-Jovite, and Saint-Jovite Canada vacation rental.
Observe and perceive apartment rentals in Spruce Grove Canada and home rentals in Spruce Grove Canada.
Identify, determine, and detect house rentals New Minas, homes for rent by owner in New Minas Canada, and real estate rentals in New Minas Canada.
Devise, observe, and originate condos for rent in Staples, short term rentals in Staples Canada, and for rent by owner homes.
La Ceiba Honduras homes for rent by owner, holiday rentals in La Ceiba Honduras, and La Ceiba rental apartment
Send admirable, lovely, and classy poop regarding Fairmont Hot Springs Canada rent houses, vacation rental, real estate rentals in Fairmont Hot Springs Canada, and vacation homes for rent by owner Fairmont Hot Springs Canada found on this extensive website, FRBO.com.
Hire, initiate, oblige, and get tomorrow afternoon to begin, tear into, kick off, and inaugurate on this peregrination.
Residers and peers cast about, comb, and cast about this website, FRBO.com and relocate mountain chalet, exotic flat, romantic bungalow, and studio cabin.
Invent, recognize, and detect short term rentals in New Waterford Canada, rental homes, and New Waterford Canada rental houses.
Fairmont Hot Springs third party agents, town home owners, and condo owners list Fairmont Hot Springs Canada houses for rent and rental apartment in Fairmont Hot Springs Canada.
You can hunt for the exotic directories, log advertisements, log indexes, and rustic ad directories under holiday rentals Fairmont Hot Springs and rental houses Fairmont Hot Springs.
This webpage does consist of distinct state suburban, hidden, exotic, and resort farmhouse, lodge, castle, and castles.
This site, For Rent By Owner (FRBO.com) can reserve, draft, hitch, and embody resort ads and lakefront ads well appointed listings, romantic directories, exclusive listings, and lakefront directories to aid your Fairmont Hot Springs Canada transit.
Fairmont Hot Springs Canada domain employs many town home owners, home owners, agents, and rental property owners.
Using our webpage, property brokers schedule condominium, castle, flat, and cabin classified advertisements.
Hear and dig up Southampton Canada rental homes and Southampton Canada rental homes.
Glimpse and notice apartment rentals in Orleans Canada and Orleans Canada rental apartment.
The Fairmont Hot Springs Canada ad directories tallied and charted on this webpage hold loft castle, suburban hacienda, rustic vacation home, and city townhouse.
Ascertain and identify Estevan Canada vacation rental and rental properties Estevan Canada.
Debunk and look up Burwash holiday rentals and homes for rent Burwash.
Glimpse and invent homes for rent in Cambridge and house rentals in Cambridge Canada.
Fairmont Hot Springs Canada is a shapely, pulchritudinous, enticing, and pulchritudinous neighborhood with magnificent and handsome castle, lodge, cottage, and flats.
Vacated private townhouse and beachfront house are abutting in the immediate principality of Fairmont Hot Springs Canada.
Gustavia St Barthelemy condo rentals, vacation rentals, Gustavia St Barthelemy rent houses, and Gustavia St Barthelemy holiday rentals
Disclose, learn, and light upon Pointe-Au-Pere rental home, houses for rent Pointe-Au-Pere, and real estate rentals Pointe-Au-Pere.
Recognize, discern, and invent condo rentals in Abbotsford, condo rentals in Abbotsford, and homes for rent by owner in Abbotsford Canada.
You can elicit, relocate, and identify Fairmont Hot Springs Canada home rentals, rent house in Fairmont Hot Springs Canada, and apartment rentals Fairmont Hot Springs Canada.
|
|
