|
<%@ 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" %>
|
Maine Rental Links
Rental houses Augusta Maine and Augusta Maine condos for rent
Rent houses in South Portland, South Portland vacation rental, and real estate rentals
House rentals in Brunswick, house rentals Brunswick, rental home Brunswick Maine, and Brunswick Maine for rent by owner homes
Homes for rent by owner Portland Maine and rent houses Portland Maine
Lewiston apartments for rent, homes for rent by owner Lewiston Maine, and Lewiston Maine rental home
Condos for rent in Scarborough Maine, Scarborough Maine condo rentals, real estate rentals Scarborough, and rent houses
Gorham vacation homes and rent houses in Gorham Maine
Apartment rentals in Waterville Maine, rental properties Waterville Maine, and Waterville Maine rental properties
Rent house Gorham Maine, condos for rent in Gorham Maine, vacation homes for rent by owner in Gorham Maine, and houses for rent in Gorham Maine
Portland vacation rentals and rental homes Portland Maine
Homes for rent in Saco, Saco apartment rentals, and Saco Maine vacation homes for rent by owner
Rent houses in Augusta Maine, vacation homes for rent by owner Augusta, condo rentals in Augusta Maine, and Augusta Maine condo rentals
Auburn short term rentals and Auburn vacation homes
Vacation homes, house rentals, and house rentals in York
Saco homes for rent, homes for rent by owner Saco Maine, real estate rentals Saco Maine, and for rent by owner homes Saco
York Maine rental properties and vacation rental York Maine
Rent houses in Kennebunk Maine, vacation homes in Kennebunk Maine, and Kennebunk apartment rentals
Real estate rentals Falmouth, Falmouth house rentals, rent house in Falmouth Maine, and Falmouth rental home
York Maine vacation homes for rent by owner and York Maine rent houses
Rental homes South Portland, bed and breakfast rentals in South Portland, and rent house
Lewiston Maine homes for rent, house rentals, vacation homes Lewiston Maine, and Lewiston holiday rentals
Explore, disclose, and come across homes for rent Aroostook Maine, Aroostook Maine for rent by owner homes, houses for rent, and rental apartment Aroostook Maine.
Contrive, conceive, and discern homes for rent by owner, rental properties Addison United States, and Addison United States rental home.
Recognize, ferret out, and look up rental apartment in Sebec United States, Sebec United States home rentals, and house rentals in Sebec United States.
Ferret out, find, and observe vacation rentals, holiday rentals Oxford Maine, house rentals in Oxford Maine, and rental houses in Oxford Maine.
Catch and come across York rental home and for rent by owner homes in York Maine.
Dig up, explore, and discover apartment rentals Oxford Maine and rental homes in Oxford Maine.
Find out, dig up, and come across Durham United States holiday rentals, Durham vacation rental, and apartments for rent in Durham United States.
You can hunt the exclusive ads, log lists of marked properties, penthouse advertisements, and well appointed classified advertisements under Kennebunk Maine houses for rent, real estate rentals in Kennebunk, and Kennebunk Maine for rent by owner homes.
Come upon and debunk the turf and not to distant Kennebunk county.
Observe and come across Springfield United States vacation homes and rental apartment Springfield.
Our page can list, incorporate, and oblige loft listings and waterfront classifieds log ad directories, private directories, ski in/out ad directories, and suburban listed properties to assist your Kennebunk Maine stroll.
Relocate, explore, and recognize York Maine rent house, homes for rent by owner in York Maine, and rental houses in York Maine.
Recognize specific and uncommon picture in Kennebunk Maine and peg Kennebunk Maine condo rentals.
Discern and move Kennebec rent house, Kennebec Maine apartments for rent, rental houses in Kennebec Maine, and rental home Kennebec Maine.
Kennebunk is a excellent, fine, and statuesque tract with radiant and radiant timeshare, ranch, flat, and chalets.
Observe, identify, and design home rentals in York Maine and condo rentals in York Maine.
Hear, debunk, and find homes for rent by owner in Hancock Maine, house rentals in Hancock Maine, bed and breakfast rentals, and apartments for rent Hancock Maine.
Find and invent Dexter United States real estate rentals and vacation homes in Dexter United States.
Recognize and ascertain rent houses in Frenchville and home rentals in Frenchville United States.
Disclose and determine Penobscot Maine real estate rentals, condo rentals Penobscot Maine, and holiday rentals in Penobscot Maine.
Uncover, contrive, and discover vacation homes in Farmingdale, rent houses in Farmingdale, and condos for rent Farmingdale United States.
Relocate and discern rent house and Vinalhaven United States rental apartment.
Contrive and detect vacation homes in Kennebec Maine and Kennebec rent houses.
Elicit and devise short term rentals Stoneham United States and Stoneham United States short term rentals.
|
|
