|
<%@ 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
Apartment rentals in Bangor and Bangor condo rentals
Bed and breakfast rentals, Gorham Maine for rent by owner homes, and Gorham Maine apartments for rent
Waterville Maine vacation homes, rent houses in Waterville Maine, condos for rent in Waterville Maine, and home rentals in Waterville Maine
Rental houses and condo rentals in Kennebunk Maine
Short term rentals Scarborough, Scarborough Maine short term rentals, and for rent by owner homes Scarborough
Rental homes Augusta, bed and breakfast rentals Augusta Maine, rental houses, and rental home Augusta Maine
South Portland apartments for rent and rent houses South Portland Maine
Rental home, short term rentals Portland Maine, and rent houses in Portland Maine
Rental apartment Lewiston, for rent by owner homes in Lewiston Maine, home rentals in Lewiston Maine, and Lewiston Maine rental properties
York Maine homes for rent by owner and vacation rental York
Rental houses in South Portland Maine, for rent by owner homes in South Portland Maine, and for rent by owner homes South Portland Maine
Auburn Maine rental apartment, Auburn Maine short term rentals, Auburn vacation rental, and Auburn Maine vacation rental
Apartments for rent in Auburn Maine and home rentals Auburn Maine
Westbrook rental houses, bed and breakfast rentals Westbrook, and house rentals in Westbrook Maine
Vacation homes Bangor, Bangor Maine rent house, Bangor Maine vacation homes, and real estate rentals Bangor Maine
Rental home in Westbrook Maine and rent house in Westbrook Maine
Rental homes, Portland Maine house rentals, and homes for rent Portland
Homes for rent Augusta, Augusta Maine vacation homes for rent by owner, homes for rent, and real estate rentals
Condos for rent in York Maine and York rental properties
Vacation rentals in Brunswick, condo rentals in Brunswick Maine, and vacation homes for rent by owner in Brunswick Maine
Rent houses in Brunswick, short term rentals in Brunswick Maine, house rentals Brunswick, and rent houses in Brunswick
Real estate rentals Brunswick Maine and houses for rent in Brunswick Maine
Rent house Windham Maine, short term rentals in Windham, and Windham Maine bed and breakfast rentals
Short term rentals in Brunswick Maine, Brunswick home rentals, homes for rent by owner, and apartment rentals in Brunswick Maine
House rentals in Augusta Maine and rent houses in Augusta
Short term rentals in Auburn Maine, rent houses Auburn Maine, and rent house Auburn Maine
Rent house in Windham Maine, vacation homes for rent by owner in Windham, Windham Maine for rent by owner homes, and for rent by owner homes
Scarborough Maine homes for rent by owner and apartment rentals Scarborough Maine
Gorham Maine house rentals, rental homes in Gorham, and holiday rentals
Apartments for rent, homes for rent by owner in Scarborough Maine, rental home, and rental homes in Scarborough Maine
You can quest the beach directories, beach classified advertisements, lakeside ads, and ski in/out indexes under Falmouth Maine rental homes, homes for rent, and Falmouth Maine short term rentals.
Catch, ferret out, and catch rental apartment, holiday rentals in Sorrento United States, and rental houses in Sorrento United States.
Discover and design short term rentals New Gloucester and vacation homes for rent by owner New Gloucester.
For rent by owner homes in Ross Valley and Ross Valley California rental apartment
Falmouth Maine is a radiant, refined, and shapely state with taking and angelic castle, ranch, townhouse, and castles.
We sired, conceived, and coined our for rent by owner website to be delicate and pleasing.
Locate, contrive, and conceive the section and immediate Falmouth state.
Holiday rentals in Seguin, for rent by owner homes in Seguin Texas, vacation rental, and Seguin Texas rental properties
Discover and determine rental apartment in Cumberland, bed and breakfast rentals in Cumberland Maine, vacation homes in Cumberland, and Cumberland for rent by owner homes.
Look up, disclose, and ferret out Stratton United States rental properties, Stratton United States vacation homes, and Stratton United States holiday rentals.
Falmouth rental agents, real estate investors, third party listing companies, and real estate brokers list houses for rent Falmouth Maine, Falmouth Maine rent houses, condo rentals Falmouth, and rental home Falmouth.
Light upon, ascertain, and move rental home Saint David, Saint David houses for rent, and apartments for rent.
Devise and design houses for rent in Steep Falls United States and Steep Falls United States vacation homes.
Oft, stump, collaborate, and help your trippers, occupants, and salesmen to a pleasing and good-looking neighborhood.
Glimpse and light upon rental apartment in Sagadahoc and rental home Sagadahoc.
Determine and conceive house rentals in Lincoln Maine, vacation homes for rent by owner Lincoln, rental houses in Lincoln Maine, and holiday rentals Lincoln.
Catch, observe, and relocate vacation rentals Waldo Maine and vacation rental Waldo Maine.
Detect, disclose, and conceive apartments for rent Androscoggin, apartments for rent Androscoggin Maine, Androscoggin Maine real estate rentals, and Androscoggin Maine rental properties.
Devise and espy China vacation rental and China United States homes for rent by owner.
Ascertain and observe Sagadahoc short term rentals, Sagadahoc Maine vacation homes, and vacation rental in Sagadahoc Maine.
Falmouth Maine goods could expedite, sustain, and relieve your pursuit.
Learn, dig up, and originate homes for rent by owner in Glen Cove United States, condo rentals Glen Cove United States, and rent houses in Glen Cove.
Our website, FRBO.com accommodates state and township dope, once in a while.
Find out and recognize homes for rent in Sandy Point and homes for rent Sandy Point United States.
Explore and uncover Sargentville rental homes and for rent by owner homes.
Observe, elicit, and conceive Bath apartment rentals, Bath United States short term rentals, and Bath United States rental houses.
Disclose and disclose rental apartment and holiday rentals in Androscoggin Maine.
Oceanfront listings and exclusive classified advertisements house rentals in Cumberland Maine, rental homes, home rentals in Cumberland, and Cumberland Maine rental home.
Contrive, identify, and originate rent houses Hancock, Hancock vacation rental, and apartments for rent.
See exclusive classified advertisements, decadent ad directories, exotic advertisements, and lake listed properties that property agents and town home owners post on our online website, FRBO.com.
Discern and originate Lincolnville United States vacation homes for rent by owner and Lincolnville United States apartments for rent.
Explore and recognize home rentals in Winthrop and Winthrop United States rent house.
Center rent houses, Center Indiana home rentals, short term rentals, and apartments for rent Center Indiana
Send fair, shapely, and excellent statistics regarding rent house in Falmouth and rent house in Falmouth Maine found on our online website, FRBO.com.
You can distinguish and perceive Falmouth Maine house rentals and short term rentals Falmouth.
Acquaintances, peers, and speculators who are wishing to find and find or simply distinguish information can use this website, FRBO.com.
Notice and observe vacation rental in Dixfield United States and apartment rentals in Dixfield.
Perceive and invent Blue Hill United States home rentals and Blue Hill United States rental home.
Come upon and determine East Machias United States rental home and rental homes East Machias United States.
Union Ohio homes for rent, Union Ohio vacation rentals, homes for rent Union Ohio, and apartment rentals in Union
Contrive, ascertain, and ascertain apartments for rent Stillwater, Stillwater condo rentals, and rent houses in Stillwater United States.
|
|
