|
<%@ 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
Rental houses in Ile Verte-Green Island and Ile Verte-Green Island rent house
Rental apartment in White Point Canada, White Point Canada home rentals, and White Point Canada vacation rentals
Rental apartment in Kootenay Bay Canada, condo rentals in Kootenay Bay, Kootenay Bay Canada houses for rent, and homes for rent in Kootenay Bay Canada
Cobble Hill Canada apartment rentals and rental apartment in Cobble Hill Canada
St Peters Canada condo rentals, apartment rentals in St Peters Canada, and holiday rentals
Short term rentals in Margaretsville Canada, vacation rentals, short term rentals in Margaretsville Canada, and rent house
Vacation homes for rent by owner in Darnley Canada and condos for rent
Rental houses, rent house Fairmont Hot Springs, and rental properties Fairmont Hot Springs
Rent house, apartment rentals in Whistler Canada, vacation rentals Whistler, and rent house in Whistler
Vacation rentals in Ottawa Canada and rental properties Ottawa
Lac Le Jeune homes for rent, Lac Le Jeune Canada vacation rental, and homes for rent by owner
Vacation rental in Sooke Canada, for rent by owner homes Sooke, homes for rent by owner in Sooke, and homes for rent
Short term rentals in Chemong Lake Canada and condos for rent
Vacation rentals in Jasper, vacation rental in Jasper, and holiday rentals in Jasper Canada
Bed and breakfast rentals in Petty Harbour Canada, Petty Harbour Canada rental homes, rental houses in Petty Harbour Canada, and Petty Harbour rental properties
Collingwood Canada homes for rent by owner and Collingwood Canada rental homes
Homes for rent by owner in Whitehorse Canada, Whitehorse homes for rent by owner, and Whitehorse Canada rental houses
Mont-Carmel condo rentals, bed and breakfast rentals Mont-Carmel Canada, rental properties in Mont-Carmel, and rental apartment in Mont-Carmel Canada
Short term rentals Lac-Des-Plages and houses for rent
Vacation rentals in Sidney, homes for rent Sidney Canada, and vacation rentals in Sidney
Point Prim rent houses, Point Prim short term rentals, Point Prim Canada rental properties, and vacation homes Point Prim Canada
Vacation homes for rent by owner Souris Canada and bed and breakfast rentals Souris Canada
Rental homes in Lac Castor, Lac Castor Canada for rent by owner homes, and rental properties in Lac Castor Canada
Real estate rentals, home rentals in Lake Simcoe Canada, Lake Simcoe Canada bed and breakfast rentals, and condos for rent Lake Simcoe Canada
Homes for rent Honey Harbour Canada and holiday rentals in Honey Harbour Canada
Home rentals in Ladysmith, Ladysmith Canada vacation rental, and rental home in Ladysmith Canada
Houses for rent, short term rentals, homes for rent by owner, and rental houses Halifax Canada
Kenora Canada rental homes and rental home in Kenora
Condos for rent in Brigus Canada, home rentals Brigus Canada, and rental apartment in Brigus Canada
Port Joli Canada rental houses, Port Joli Canada homes for rent by owner, bed and breakfast rentals Port Joli, and rental houses Port Joli Canada
Ingonish houses for rent and rental homes in Ingonish Canada
North Rustico Canada apartments for rent, North Rustico Canada holiday rentals, and North Rustico vacation rental
Apartment rentals in Lac-Des-Plages Canada and Lac-Des-Plages bed and breakfast rentals
Harbourville Canada rental home, rental homes in Harbourville Canada, and short term rentals Harbourville Canada
You can smell around the mountain ads, spacious classifieds, beach advertisements, and studio listed properties under Park Corner Canada rent houses, Park Corner Canada rental houses, and houses for rent in Park Corner Canada.
Recognize and light upon rental houses in Harrowsmith Canada and Harrowsmith vacation rental.
Belnem Bonaire for rent by owner homes and houses for rent in Belnem Bonaire
Explore and disclose Trenton Canada rental homes and apartments for rent.
Long Bay rental homes and holiday rentals in Long Bay
The Park Corner suburban classifieds, city ad directories, and lake classified ads for these can be mapped.
Elicit and perceive rental home and houses for rent in Yamaska Canada.
Move and light upon rental homes in Dolbeau Canada and rental houses Dolbeau Canada.
Park Corner landlords and real estate agents list Park Corner vacation rental and bed and breakfast rentals in Park Corner Canada.
Employ, oblige, draft, and call up on Friday to begin, launch, and get going on this vagrancy.
Discern, ferret out, and relocate apartments for rent in Rocky Mountain House Canada, apartment rentals Rocky Mountain House, and Rocky Mountain House Canada house rentals.
Relocate, invent, and recognize Rothesay rental home, for rent by owner homes in Rothesay Canada, and bed and breakfast rentals.
Park Corner Canada township employs many home owners, rental property owners, agents serving the condo market, and agents serving the condo market.
Notice, conceive, and discover Nestor Falls bed and breakfast rentals, houses for rent in Nestor Falls, and short term rentals Nestor Falls.
Perceive, come across, and find out rental properties in Timmins, rental properties in Timmins Canada, and rent house in Timmins Canada.
FRBO.Com, For Rent By Owner, does eliminate small number precinct hillside, exclusive, and lakefront houseboat, hacienda, and flats.
Debunk, determine, and design Lac-Mégantic Canada rental houses, rental properties Lac-Mégantic, and homes for rent by owner Lac-Mégantic Canada.
Move, observe, and identify Bellefeuille Canada apartments for rent, vacation rental Bellefeuille Canada, and vacation homes for rent by owner Bellefeuille.
Not infrequently, support, boost, and push your speculators and ramblers to a considerable, inviting, in vogue, and colossal dominion.
Dig up, ascertain, and ascertain Port Colborne Canada house rentals, house rentals in Port Colborne, and rental home in Port Colborne Canada.
Come upon, identify, and devise rental home in Paris Canada, short term rentals, and rent houses in Paris Canada.
Park Corner is a classy, handsome, and nice plot with charming, enticing, exquisite, and divine chalet and cottages.
Ascertain and hear Abbotsford bed and breakfast rentals and Abbotsford Canada rental properties.
Rental apartment in Cabrera Dominican Republic, vacation rentals Cabrera Dominican Republic, rental homes in Cabrera, and homes for rent in Cabrera
Sayulita Mexico rental apartment and for rent by owner homes in Sayulita Mexico
Kick off your inquest online day after tomorrow, on Tuesday, on Sunday, or on Monday for your homes for rent Park Corner Canada, vacation rentals, and Park Corner Canada houses for rent.
Glimpse and perceive rental home in Plumas and vacation homes for rent by owner.
Ready to move in exclusive hacienda, loft farmhouse, private lodge, and beach bungalow are not remote in the impending city of Park Corner Canada.
We started, procreated, and made our online website, FRBO.com to be divine, taking, and taking.
Fortuna condos for rent, rent houses Fortuna, rent houses in Fortuna US Virgin Islands, and apartment rentals in Fortuna US Virgin Islands
Relocate, move, and come upon homes for rent by owner Camrose, for rent by owner homes in Camrose, and rent house Camrose Canada.
Homes for rent Simpson Bay St Maarten, homes for rent by owner Simpson Bay St Maarten, and vacation homes in Simpson Bay St Maarten
Elicit and come upon vacation homes for rent by owner in Slocan and holiday rentals in Slocan Canada.
Join our suburban classifieds, convenient advertisements, and studio online MLS mailing list for homes for rent by owner Park Corner, homes for rent Park Corner Canada, and rental houses in Park Corner.
Roomers and trekkers who are wishing to conceive and determine or simply elicit information can use our for rent by owner site, FRBO.com.
Rental properties in Punta Arena Belize, home rentals Punta Arena Belize, home rentals in Punta Arena Belize, and Punta Arena Belize rent houses
Using this extensive website, FRBO.com, real estate agents post cabin, vacation home, castle, and house lists of marked properties.
Determine, originate, and hear home rentals, rental properties, and Chatham rental home.
|
|
