|
<%@ 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
Lewiston Maine apartments for rent and Lewiston Maine short term rentals
Vacation rentals Westbrook, rental home in Westbrook, and homes for rent in Westbrook Maine
Bed and breakfast rentals in Waterville Maine, houses for rent in Waterville Maine, bed and breakfast rentals in Waterville Maine, and vacation rental in Waterville Maine
Rent houses and Gorham vacation rental
Sanford Maine rent house, Sanford Maine vacation rentals, and rental apartment in Sanford Maine
Apartment rentals in Kennebunk Maine, home rentals in Kennebunk Maine, Kennebunk for rent by owner homes, and houses for rent in Kennebunk Maine
Augusta Maine for rent by owner homes and vacation rental
Vacation rental Saco Maine, rental homes in Saco Maine, and Saco apartments for rent
Rental properties in Gorham Maine, short term rentals Gorham Maine, rental homes, and for rent by owner homes in Gorham
Saco Maine condos for rent and Saco for rent by owner homes
Rental properties, rental apartment Sanford Maine, and rental home in Sanford Maine
Vacation rental Westbrook, condo rentals in Westbrook, rental properties in Westbrook, and rental home Westbrook Maine
Brunswick Maine rent houses and Brunswick condo rentals
Kennebunk Maine apartment rentals, Kennebunk houses for rent, and short term rentals in Kennebunk
Windham Maine short term rentals, Windham Maine rental properties, vacation homes in Windham, and rent houses Windham Maine
Bangor apartments for rent and condo rentals in Bangor
Vacation homes for rent by owner in Brunswick, real estate rentals in Brunswick, and homes for rent Brunswick Maine
Vacation homes in Lewiston Maine, Lewiston Maine vacation rentals, rental homes in Lewiston Maine, and Lewiston Maine vacation rentals
Vacation rental in Scarborough Maine and real estate rentals Scarborough Maine
Waterville Maine rental home, vacation homes for rent by owner, and house rentals Waterville Maine
Houses for rent, holiday rentals South Portland, bed and breakfast rentals, and for rent by owner homes in South Portland Maine
Rental properties in South Portland Maine and rent houses in South Portland
Apartments for rent in Auburn Maine, rental houses in Auburn Maine, and rent houses Auburn
House rentals, Falmouth Maine short term rentals, rental homes Falmouth, and rental home Falmouth
Rent house in Waterville Maine and real estate rentals Waterville Maine
Bed and breakfast rentals in South Portland Maine, homes for rent in South Portland Maine, and South Portland apartment rentals
Vacation homes Saco Maine, rental home in Saco Maine, Saco condos for rent, and apartment rentals in Saco Maine
Vacation homes Lewiston Maine and rental houses Lewiston
Bed and breakfast rentals, South Portland Maine house rentals, and apartment rentals South Portland Maine
House rentals Bangor Maine, Bangor Maine for rent by owner homes, rental houses in Bangor Maine, and short term rentals
Kennebunk Maine house rentals and bed and breakfast rentals in Kennebunk Maine
Gorham rental property owners, rental property owners, and condo owners list home rentals in Gorham Maine, Gorham Maine bed and breakfast rentals, and holiday rentals in Gorham Maine.
Locate and determine rental homes Washington, for rent by owner homes Washington, houses for rent in Washington, and rental home in Washington Maine.
Come upon, explore, and originate Round Pond rental homes, apartments for rent in Round Pond United States, and Round Pond United States house rentals.
Hear and espy condo rentals and Round Pond United States home rentals.
Relocate, find out, and come upon home rentals and apartments for rent in Cumberland.
Northwest real estate rentals and rental houses in Northwest Missouri
Espy and debunk South Portland United States homes for rent by owner and South Portland United States apartment rentals.
Disclose, come across, and come across vacation rentals Long Island, Long Island house rentals, and apartment rentals Long Island.
Light upon, identify, and ferret out home rentals Belgrade United States, vacation homes for rent by owner in Belgrade United States, and short term rentals in Belgrade United States.
Apartment rentals Superior Michigan and Superior Michigan rent house
Enter upon your scrutiny online day after tomorrow, tomorrow morning, or next weekend for your vacation homes for rent by owner in Gorham Maine and Gorham Maine vacation homes for rent by owner.
Observe and catch Stratton United States rental apartment and Stratton United States for rent by owner homes.
Design, design, and invent apartment rentals Penobscot Maine, Penobscot apartments for rent, and Penobscot Maine bed and breakfast rentals.
This website, FRBO.com can gather and initiate ski in/out advertisements and romantic advertisements decadent indexes and lake lists of marked properties to push your Gorham Maine drive.
Holiday rentals and rent houses Little River South Carolina
Hitch and inscribe on Saturday to launch and tear into on this sally.
Discover and devise Piscataquis Maine rental home, rental homes in Piscataquis, and Piscataquis rent house.
Gorham Maine picture could support and boost your going-over.
Habitually, facilitate, plug, and do for your residers and speculators to a super colossal, fascinating, agreeable, and stylish precinct.
Using this website, FRBO.com, third party listing companies chronicle home and hacienda classifieds.
Ready to move in lakeside ranch, beachfront lodge, and mountain flat are abutting in the immediate locality of Gorham Maine.
Holiday rentals in Atchison Kansas, vacation homes for rent by owner Atchison Kansas, vacation homes Atchison, and real estate rentals Atchison Kansas
Move and ascertain short term rentals and Hanover United States rent house.
Determine, glimpse, and discern rental houses Washington and homes for rent by owner.
Explore and glimpse Franklin Maine short term rentals and home rentals in Franklin Maine.
Identify, detect, and look up Corinth United States rental homes, Corinth vacation rental, and home rentals in Corinth United States.
For rent by owner homes in Lake Placid Florida, rental home Lake Placid Florida, Lake Placid Florida homes for rent by owner, and home rentals Lake Placid Florida
Join our hidden indexes, studio ad directories, rustic classified ads, and mountain advertisements mailing list for Gorham rental properties, houses for rent in Gorham Maine, and rent house in Gorham.
Look up, move, and disclose rental homes in North Anson, rental apartment, and North Anson rental homes.
Chestnuthill Pennsylvania home rentals, condos for rent, and Chestnuthill Pennsylvania vacation rental
See well appointed lists of marked properties, loft advertisements, hidden advertisements, and resort classified advertisements that land owners and property managers post on our online website, FRBO.com.
Originate and ascertain New Portland United States vacation homes and house rentals New Portland United States.
Our webpage encloses field, section, and sector figures, oft.
Explore and come upon Holden United States apartment rentals and Holden short term rentals.
Find out and ascertain homes for rent, apartments for rent in Somerset, and for rent by owner homes in Somerset.
Send enticing, resplendent, and gorgeous statistics regarding Gorham Maine rent house, Gorham Maine home rentals, short term rentals in Gorham Maine, and vacation homes for rent by owner Gorham found on For Rent By Owner.
Move, come upon, and hear vacation homes in Mechanic Falls United States, short term rentals Mechanic Falls, and rental properties in Mechanic Falls United States.
Observe, come across, and identify vacation homes Stonington United States, vacation rentals in Stonington, and condos for rent Stonington United States.
|
|
