|
<%@ 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
Home rentals in Lewiston and rental properties Lewiston
South Portland Maine bed and breakfast rentals, vacation rental, and short term rentals
Real estate rentals in Sanford Maine, rental homes, bed and breakfast rentals in Sanford Maine, and Sanford vacation homes for rent by owner
Waterville Maine rental apartment and homes for rent by owner Waterville Maine
Falmouth Maine home rentals, rental homes in Falmouth Maine, and homes for rent Falmouth
Rental homes in Westbrook Maine, rent houses Westbrook, houses for rent, and house rentals
Apartment rentals Gorham and homes for rent by owner in Gorham Maine
Condo rentals, for rent by owner homes, and rent house in Bangor Maine
Windham Maine vacation rentals, Windham Maine rental homes, holiday rentals, and Windham Maine condo rentals
Scarborough Maine rental homes and Scarborough Maine condo rentals
Rental apartment in Brunswick Maine, Brunswick Maine homes for rent by owner, and Brunswick Maine apartment rentals
Falmouth Maine rent house, Falmouth Maine real estate rentals, home rentals in Falmouth Maine, and rental houses
Homes for rent by owner Saco Maine and Saco apartments for rent
Sanford Maine vacation rental, vacation homes for rent by owner Sanford, and bed and breakfast rentals in Sanford Maine
Apartments for rent, bed and breakfast rentals Lewiston Maine, vacation rentals in Lewiston Maine, and vacation rentals in Lewiston Maine
Vacation rental in Brunswick Maine and Brunswick Maine vacation homes for rent by owner
York Maine rental home, home rentals, and rental properties York
Apartment rentals in Waterville Maine, Waterville Maine vacation rentals, vacation homes in Waterville Maine, and rental homes
Brunswick Maine bed and breakfast rentals and rental houses
Sanford for rent by owner homes, apartment rentals in Sanford Maine, and Sanford Maine vacation rental
Vacation rentals in Bangor Maine, homes for rent by owner in Bangor Maine, rent house Bangor, and houses for rent in Bangor Maine
Kennebunk bed and breakfast rentals and holiday rentals in Kennebunk Maine
Westbrook Maine vacation rentals, short term rentals in Westbrook Maine, and homes for rent by owner Westbrook
Sanford rent houses, rental apartment, vacation homes Sanford Maine, and Sanford Maine condos for rent
Windham Maine for rent by owner homes and apartments for rent
Apartment rentals, holiday rentals, and for rent by owner homes Westbrook
Bangor real estate investors and brokers leasing foreclosures list rental properties Bangor and Bangor rental properties.
Identify, recognize, and catch Small Point apartments for rent, Small Point United States for rent by owner homes, and rent house in Small Point.
Debunk and come upon Lambert Lake United States vacation homes for rent by owner and Lambert Lake United States for rent by owner homes.
Ascertain, ascertain, and identify rent houses in Waldo Maine, Waldo Maine bed and breakfast rentals, condo rentals in Waldo Maine, and Waldo Maine real estate rentals.
Disclose, debunk, and detect rental apartment in Piscataquis Maine, rental properties Piscataquis, and rental homes.
Conceive and invent Canton United States apartment rentals and condo rentals in Canton United States.
Discover, locate, and learn homes for rent by owner, rent house Waldo Maine, and apartments for rent in Waldo.
Ascertain, notice, and find vacation rentals in Hancock Maine, real estate rentals Hancock Maine, Hancock Maine homes for rent, and vacation homes for rent by owner Hancock Maine.
Serve, enter, and join now to originate and originate on this tramp.
Identify, debunk, and hear New Sharon United States condo rentals, house rentals in New Sharon United States, and New Sharon United States condos for rent.
Glimpse and espy apartment rentals, apartment rentals in Piscataquis Maine, and condo rentals Piscataquis.
Discover, devise, and find out Brownville Junction condo rentals, apartments for rent Brownville Junction United States, and Brownville Junction rent houses.
Ascertain, debunk, and ferret out condo rentals in Livermore Falls United States, for rent by owner homes Livermore Falls, and Livermore Falls United States condo rentals.
Using For Rent By Owner, rental owners manifest chalet, home, and ranch lists of marked properties.
Come upon and light upon real estate rentals in Chamberlain United States and Chamberlain United States rental apartment.
Send delicate and ideal conclusions regarding Bangor Maine condo rentals, houses for rent in Bangor Maine, vacation homes Bangor, and Bangor rental apartment found on FRBO.Com, For Rent By Owner,.
Disclose, originate, and identify Cumberland Maine real estate rentals, rental home, and Cumberland real estate rentals.
Schoolmates, citizens, and renters who are wishing to discover, originate, and disclose or simply find information can use this site, For Rent By Owner (FRBO.com).
Ascertain, identify, and come across vacation homes for rent by owner in Andover United States, bed and breakfast rentals in Andover United States, and Andover United States for rent by owner homes.
Discern and catch Belfast United States homes for rent by owner and holiday rentals in Belfast United States.
Dig up, discern, and uncover the dominion and not far away Bangor Maine patch.
The Bangor Maine ads charted and recorded on this extensive website, FRBO.com incorporate beach timeshare, hidden cabin, oceanfront bungalow, and exclusive vacation home.
The Bangor Maine private indexes, hidden listings, oceanfront advertisements, and mountain directories for these patch can be mapped.
Observe and devise Washington vacation rentals, bed and breakfast rentals Washington, Washington Maine for rent by owner homes, and Washington Maine homes for rent by owner.
Espy, notice, and discern for rent by owner homes, rent houses in Gorham, and apartments for rent Gorham.
Relocate and recognize short term rentals Franklin, Franklin Maine homes for rent, and holiday rentals.
Perceive and catch home rentals York Maine, York Maine vacation homes, and house rentals in York Maine.
You can dig up, discern, and uncover Bangor Maine bed and breakfast rentals, condo rentals in Bangor, and apartment rentals in Bangor Maine.
Greenville apartments for rent, rental houses in Greenville North Carolina, short term rentals in Greenville, and homes for rent Greenville North Carolina
Explore and learn home rentals in Saint Francis United States and Saint Francis short term rentals.
|
|
