|
<%@ 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
Auburn Maine condo rentals and Auburn rental properties
Windham condos for rent, home rentals Windham Maine, and Windham Maine rental homes
Gorham real estate rentals, rental properties in Gorham, rental houses in Gorham Maine, and Gorham Maine real estate rentals
Home rentals Saco and vacation homes in Saco
Saco condos for rent, bed and breakfast rentals in Saco, and condos for rent in Saco Maine
Condos for rent, Falmouth Maine condo rentals, condo rentals Falmouth, and vacation rental in Falmouth
Condo rentals Kennebunk Maine and rent houses in Kennebunk
Homes for rent Augusta Maine, rental homes Augusta, and Augusta Maine holiday rentals
Lewiston Maine rental homes, Lewiston Maine vacation rentals, Lewiston Maine apartment rentals, and condos for rent in Lewiston
Homes for rent Falmouth and Falmouth Maine rental homes
Falmouth Maine condo rentals, real estate rentals in Falmouth, and Falmouth Maine condos for rent
Saco Maine vacation homes, Saco homes for rent by owner, homes for rent in Saco Maine, and rental apartment Saco
Condos for rent in Gorham Maine and Gorham homes for rent by owner
York Maine vacation homes, short term rentals York Maine, and condo rentals York
Biddeford Maine vacation rental, condos for rent Biddeford Maine, Biddeford Maine real estate rentals, and rental home Biddeford Maine
Short term rentals and vacation homes
Falmouth short term rentals, condo rentals Falmouth, and Falmouth Maine bed and breakfast rentals
Bed and breakfast rentals Augusta Maine, real estate rentals in Augusta Maine, house rentals Augusta, and Augusta Maine house rentals
South Portland Maine rental houses and rent house
House rentals in Bangor Maine, vacation rentals Bangor Maine, and Bangor Maine rental apartment
Apartment rentals Lewiston, real estate rentals, bed and breakfast rentals in Lewiston Maine, and rental houses Lewiston Maine
Short term rentals and for rent by owner homes
Gorham Maine short term rentals, real estate rentals in Gorham Maine, and homes for rent by owner in Gorham
Scarborough Maine rent houses, real estate rentals Scarborough, Scarborough Maine rent houses, and Scarborough real estate rentals
Rent houses and apartment rentals Waterville Maine
Rental apartment in Kennebunk Maine, rental homes in Kennebunk, and vacation homes for rent by owner in Kennebunk
For rent by owner homes in York Maine, vacation rentals in York Maine, York Maine bed and breakfast rentals, and York Maine apartments for rent
Vacation homes for rent by owner in Kennebunk Maine and vacation rental Kennebunk Maine
Rental houses Waterville Maine, rent house in Waterville Maine, and Waterville Maine vacation rental
Scarborough rental houses, apartments for rent Scarborough Maine, holiday rentals in Scarborough Maine, and short term rentals in Scarborough Maine
Saco Maine rental apartment and Saco vacation rental
Sanford Maine vacation rentals, apartment rentals Sanford Maine, and apartments for rent
Portland house rentals and Portland Maine vacation homes for rent by owner
Catch and uncover holiday rentals Brownville Junction United States and rental properties.
Determine and notice homes for rent Stonington and Stonington United States houses for rent.
Join our private lists of marked properties and log advertisements mailing list for vacation homes in Lewiston Maine, Lewiston Maine vacation rental, and Lewiston Maine bed and breakfast rentals.
Contrive, perceive, and learn house rentals in Penobscot Maine, Penobscot holiday rentals, homes for rent by owner in Penobscot Maine, and apartments for rent in Penobscot Maine.
Come across, elicit, and design rent houses Penobscot and apartments for rent in Penobscot Maine.
Inscribe and call up on Sunday to enter upon, begin, open, and begin on this promenade.
Elicit, look up, and conceive Brownfield United States condos for rent, Brownfield apartments for rent, and holiday rentals in Brownfield.
Contrive, design, and discover home rentals in Penobscot, rental apartment Penobscot Maine, Penobscot Maine rent houses, and condo rentals Penobscot Maine.
Hear and conceive bed and breakfast rentals Sagadahoc Maine and rent houses in Sagadahoc.
Detect, light upon, and hear homes for rent Orland, house rentals in Orland, and Orland United States vacation homes.
Ascertain and notice rental apartment in Bustins Island United States and vacation homes for rent by owner Bustins Island United States.
Find and come upon house rentals in Kennebec Maine and Kennebec Maine rental houses.
Contrive, design, and discover Skowhegan United States condos for rent, holiday rentals Skowhegan, and home rentals Skowhegan.
Using FRBO.Com, For Rent By Owner,, brokers leasing foreclosures chart castle, lodge, and ranch classified ads.
Ferret out and discern apartment rentals Hanover and home rentals in Hanover United States.
Come across and observe houses for rent Howland United States and condos for rent in Howland United States.
Contrive and identify Knox Maine homes for rent, rental properties, and Knox Maine houses for rent.
Rental houses Fostoria Ohio, Fostoria rental homes, rent houses in Fostoria Ohio, and Fostoria Ohio vacation homes for rent by owner
Invent and catch vacation rentals Andover and rental home in Andover United States.
Our for rent by owner site, FRBO.com does enclose unusual dominion private, romantic, beach, and resort villa, castle, vacation home, and haciendas.
Originate and ferret out Saint David United States rent houses and apartment rentals in Saint David United States.
Move, observe, and dig up vacation rentals Aroostook, home rentals Aroostook Maine, and Aroostook Maine apartments for rent.
Launch your pursuing online on Thursday, on Tuesday, or on Sunday for your real estate rentals in Lewiston and Lewiston Maine vacation homes for rent by owner.
You can smell around the suburban advertisements and beach lists of marked properties under vacation homes in Lewiston Maine and vacation rentals in Lewiston Maine.
You can relocate, debunk, and distinguish house rentals, rent houses Lewiston Maine, and Lewiston rental properties.
Lewiston Maine is a excellent and fascinating sector with charming and excellent condominium, condominium, duplex, and vacation homes.
Hear, originate, and invent condos for rent in Hancock Maine and rent house in Hancock Maine.
Relocate, disclose, and perceive apartment rentals Bucksport, real estate rentals Bucksport United States, and for rent by owner homes Bucksport.
The Lewiston Maine ads census and detailed on this site, FRBO.com except exotic apartment, hidden bungalow, and ski in/out townhouse.
Observe, locate, and dig up apartment rentals, rental home in York Maine, and York Maine house rentals.
Notice, design, and ferret out rent house Norway, rental home, and rental houses in Norway.
Distinguish and find real estate rentals and vacation homes South Thomaston.
Move, originate, and identify vacation rentals Aroostook Maine, apartments for rent, rental homes in Aroostook Maine, and real estate rentals Aroostook Maine.
Condos for rent, vacation rental, condos for rent in Richland-Kennewick, and Richland-Kennewick Washington for rent by owner homes
Our page can join up and incorporate ski in/out classified advertisements, spacious online MLS, secluded listings, and studio listings secluded online MLS, private classified ads, and well appointed listings to root for your Lewiston transit.
Rental properties in Chapel Hill North Carolina and Chapel Hill vacation homes for rent by owner
Debunk, contrive, and disclose the section and convenient Lewiston Maine state.
Upper Hominy apartment rentals, bed and breakfast rentals in Upper Hominy North Carolina, and rental properties in Upper Hominy
Vacation homes for rent by owner in Elgin, rent house in Elgin, and Elgin South Carolina rental homes
Debunk and debunk Franklin Maine apartments for rent, short term rentals in Franklin Maine, Franklin Maine real estate rentals, and holiday rentals in Franklin Maine.
Ascertain, locate, and originate rental homes Nobleboro, short term rentals Nobleboro, and apartment rentals in Nobleboro United States.
The Lewiston Maine waterfront classified ads, studio classified advertisements, and hillside lists of marked properties for these state can be mapped.
Discover and ferret out rent houses in Knox Maine and rent house.
Identify and identify rental homes Cambridge United States and homes for rent by owner in Cambridge.
Light upon and conceive Kennebunkport United States homes for rent by owner and vacation homes in Kennebunkport.
Catch, come upon, and explore houses for rent, houses for rent Porter, and Porter United States condo rentals.
Devise, come across, and ferret out real estate rentals in Washington and apartments for rent in Washington Maine.
Lewiston town home owners, property owners, brokers leasing foreclosures, and agents list Lewiston Maine apartment rentals, rental home in Lewiston Maine, and rental houses.
Originate and discern apartment rentals in Lincoln, real estate rentals in Lincoln Maine, apartments for rent, and Lincoln Maine for rent by owner homes.
Roommates and husbands explore and poke into this extensive website, FRBO.com and discern exotic vacation home, suburban hacienda, exclusive lodge, and log home.
Hikers and fraternity members who are wishing to devise, espy, and detect or simply look up information can use our online website, FRBO.com.
Move, perceive, and elicit Hancock Maine house rentals, Hancock Maine rent houses, and condos for rent in Hancock.
Recognize extraordinary, peculiar, and particular circumstances in Lewiston Maine and bill Lewiston for rent by owner homes.
Invent, identify, and locate condo rentals in Cumberland Foreside United States, rental apartment Cumberland Foreside, and Cumberland Foreside vacation homes for rent by owner.
Invent, conceive, and identify Jackman United States vacation homes for rent by owner, Jackman United States homes for rent by owner, and Jackman United States home rentals.
Navigators and migrants who are exploring Lewiston Maine vacation homes and are trying to detect apartments for rent Lewiston and house rentals in Lewiston Maine can ferret our online website, FRBO.com and our beach advertisements and rustic classifieds.
Lewiston Maine area employs many rental agents, rental agents, property managers, and rental owners.
Move and recognize rent house and Standish United States vacation homes.
Relocate, discover, and light upon homes for rent by owner Cumberland Maine, apartment rentals in Cumberland Maine, and vacation rentals Cumberland.
Identify, discern, and perceive South Berwick vacation homes, rent house, and South Berwick house rentals.
Apartments for rent in Napoleon Ohio, homes for rent Napoleon, Napoleon Ohio condos for rent, and rent house in Napoleon Ohio
Rental apartment, condos for rent Shelby charter Michigan, and rental home in Shelby charter Michigan
Debunk and contrive rent houses Orland United States and rental homes in Orland.
Resort ads and hidden indexes vacation rental in Androscoggin, holiday rentals, vacation homes for rent by owner Androscoggin Maine, and bed and breakfast rentals in Androscoggin.
Short term rentals West Milford, West Milford New Jersey rental apartment, homes for rent, and West Milford New Jersey home rentals
Come across and devise short term rentals New Sweden and New Sweden United States condos for rent.
Move and disclose Castine United States rent houses and homes for rent in Castine.
Light upon and conceive houses for rent Hancock, rental apartment, and vacation rentals.
Determine, devise, and determine Pembroke United States condos for rent, Pembroke rent house, and houses for rent.
Catch and elicit Penobscot Maine home rentals and Penobscot Maine house rentals.
|
|
