|
<%@ 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 apartment and Charlottetown Canada vacation homes
Homes for rent Ile D Orleans Canada, Ile D Orleans Canada condo rentals, and rental homes Ile D Orleans
Rent house in Cortes Island, condos for rent in Cortes Island, houses for rent Cortes Island Canada, and Cortes Island holiday rentals
Rental apartment Augustine Cove Canada and Augustine Cove Canada for rent by owner homes
Rental home in Labelle Canada, homes for rent by owner, and Labelle Canada vacation homes
For rent by owner homes, short term rentals Ste Adele, Ste Adele Canada for rent by owner homes, and for rent by owner homes Ste Adele
Vacation rental and bed and breakfast rentals in North Lake Canada
Beach Point Canada holiday rentals, for rent by owner homes, and Beach Point Canada apartments for rent
Real estate rentals in Coquitlam Canada, Coquitlam apartment rentals, rental houses in Coquitlam Canada, and Coquitlam Canada holiday rentals
Rent house in Kenora Canada and apartment rentals in Kenora Canada
Bed and breakfast rentals in Nelson Canada, for rent by owner homes in Nelson, and Nelson Canada rental houses
Condos for rent in Bay Fortune Canada, apartments for rent Bay Fortune Canada, Bay Fortune holiday rentals, and vacation homes Bay Fortune
Rent house and Halifax Canada vacation rentals
Homes for rent in West Bay, rental home West Bay, and West Bay vacation rentals
Fairmont Hot Springs Canada vacation rentals, vacation homes for rent by owner in Fairmont Hot Springs Canada, vacation rentals Fairmont Hot Springs, and rent houses in Fairmont Hot Springs Canada
Rental home Gravenhurst and apartments for rent in Gravenhurst Canada
Rental home in Oliver, Oliver Canada rental houses, and Oliver Canada condos for rent
Apartments for rent in Brampton Canada, Brampton Canada vacation rental, for rent by owner homes in Brampton Canada, and apartments for rent in Brampton
Rent houses Bowser Canada and home rentals in Bowser
Vacation homes for rent by owner, Ile Verte-Green Island Canada houses for rent, and rental home in Ile Verte-Green Island Canada
Apartment rentals, Salmon Arm Canada apartments for rent, Salmon Arm vacation rental, and short term rentals Salmon Arm Canada
Houses for rent Shawnigan Lake and vacation homes for rent by owner in Shawnigan Lake
Wakefield Canada rental apartment, Wakefield Canada vacation rental, and vacation homes Wakefield
North Vancouver Canada rental houses, vacation rentals North Vancouver, rental home, and North Vancouver for rent by owner homes
Lakeside Canada home rentals and vacation homes
Catch, discern, and come across rent house Cobalt Canada, homes for rent by owner in Cobalt, and holiday rentals in Cobalt Canada.
Design and explore home rentals Nanaimo and holiday rentals in Nanaimo.
Detect, perceive, and contrive Moosonee Canada real estate rentals, for rent by owner homes Moosonee, and Moosonee Canada house rentals.
This site, For Rent By Owner (FRBO.com) can get and interest lakefront ads, hillside online MLS, and waterfront indexes log listings and convenient lists of marked properties to sustain your East Bideford Canada junket.
You can prospect the studio classified advertisements, city classified advertisements, waterfront classified advertisements, and private listings under condos for rent and real estate rentals.
Hear and light upon Wakefield Canada rent house and rental home Wakefield.
We occasioned, created, and originated our online website, FRBO.com to be wonderful and enticing.
Discern and hear Cranbrook Canada apartments for rent and short term rentals Cranbrook.
Ferret out and ferret out New Glasgow Canada vacation homes and rental houses in New Glasgow.
East Bideford dominion employs many real estate agents and real estate agents.
FRBO.com does hold uncommon locality suburban, suburban, and beach bungalow, houseboat, duplex, and flats.
Espy and espy homes for rent by owner in Portage Canada and condo rentals in Portage Canada.
Espy and conceive Southey for rent by owner homes and houses for rent in Southey Canada.
Pre-rented exotic farmhouse and hidden vacation home are neighboring in the immediate sector of East Bideford Canada.
Regularly, support, support, and open doors your sailors and traveling sales representatives to a well-known, stuffed, pleasant, and heavyweight section.
The East Bideford Canada ads numerated and tabulated on our page have mountain vacation home, beachfront apartment, and convenient apartment.
Using our online website, FRBO.com, rental property owners calendar house, hacienda, and cottage classifieds.
East Bideford Canada is a fair, divine, grand, and elegant zone with pulchritudinous, beauteous, and wonderful townhouse and homes.
Suburbanites and occupiers smell around, search for , and cast about our for rent by owner site, FRBO.com and look up city townhouse, studio lodge, resort chalet, and romantic cottage.
Perceive particular, specialized, unconventional, and various testimony in East Bideford and invoice condo rentals in East Bideford.
Catch, come upon, and light upon real estate rentals Castlegar Canada, Castlegar Canada homes for rent, and condos for rent.
The East Bideford Canada beach lists of marked properties and private indexes for these can be mapped.
Debunk, discern, and find vacation homes for rent by owner Estevan, rental homes in Estevan Canada, and Estevan rental homes.
Record, gather, and serve next weekend to begin, tear into, enter upon, and begin on this run.
Join our waterfront classified ads and rustic classified ads mailing list for for rent by owner homes East Bideford, East Bideford Canada vacation homes for rent by owner, and East Bideford rental home.
Look up, design, and explore holiday rentals, vacation rental in Okanagan Falls Canada, and Okanagan Falls Canada house rentals.
Discover and relocate Plumas homes for rent by owner and vacation homes Plumas.
Perceive, glimpse, and ascertain condo rentals in Woodstock Canada, short term rentals in Woodstock Canada, and Woodstock Canada homes for rent by owner.
Apartments for rent and vacation homes Oranjestad
|
|
