|
<%@ 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
Vacation homes and vacation homes for rent by owner in Westbrook
Apartments for rent in Augusta Maine, rental properties in Augusta Maine, and vacation rental in Augusta Maine
Homes for rent, Westbrook Maine apartment rentals, Westbrook for rent by owner homes, and Westbrook vacation rentals
House rentals in Scarborough Maine and homes for rent by owner in Scarborough
Rental apartment in Portland, Portland rental homes, and condos for rent in Portland
Vacation rentals, homes for rent in South Portland Maine, rental apartment, and rental houses South Portland Maine
Rental apartment in Lewiston Maine and short term rentals in Lewiston Maine
Brunswick Maine house rentals, rental home, and real estate rentals Brunswick Maine
Waterville Maine short term rentals, rent houses, Waterville Maine rental houses, and condo rentals in Waterville
Biddeford Maine rent house and rental houses Biddeford Maine
Rental properties Falmouth Maine, Falmouth Maine apartment rentals, and Falmouth Maine rent houses
Apartments for rent Scarborough Maine, house rentals in Scarborough Maine, Scarborough Maine homes for rent, and apartments for rent
Holiday rentals in Biddeford Maine and Biddeford Maine condo rentals
Rental apartment in Sanford Maine, vacation rental Sanford, and rent house Sanford
Home rentals Westbrook, houses for rent in Westbrook, Westbrook vacation rental, and rental houses Westbrook Maine
Scarborough Maine rental properties and Scarborough Maine houses for rent
Falmouth Maine homes for rent, apartments for rent in Falmouth Maine, and homes for rent Falmouth
Rental home in Westbrook, houses for rent in Westbrook, apartment rentals, and homes for rent by owner Westbrook Maine
Rental houses in South Portland Maine and for rent by owner homes South Portland
Vacation rentals Scarborough Maine, Scarborough Maine for rent by owner homes, and house rentals Scarborough
Rental apartment Sanford, house rentals Sanford Maine, rental apartment, and vacation rental in Sanford Maine
Rental houses Portland Maine and Portland rental homes
Rental apartment in Gorham Maine, Gorham homes for rent, and rental home in Gorham
Rental apartment in South Portland Maine, vacation homes South Portland, homes for rent by owner, and holiday rentals in South Portland Maine
Condos for rent in York Maine and York vacation rentals
Homes for rent, house rentals Portland Maine, and vacation rentals in Portland
Rental properties in Auburn, Auburn Maine condos for rent, Auburn Maine rental properties, and house rentals Auburn Maine
Light upon and learn Lincoln Maine condos for rent and Lincoln Maine rental apartment.
Elicit and look up condos for rent in Hancock Maine, Hancock Maine holiday rentals, and Hancock Maine vacation homes.
Find out and ascertain Gouldsboro condos for rent and homes for rent in Gouldsboro United States.
Discover, espy, and design vacation rental, real estate rentals Piscataquis, and rental properties in Piscataquis.
Waterville principality employs many property managers, rental owners, and rental agents.
Waterville third party agents, landlords, and real estate investors list Waterville Maine houses for rent, rental apartment Waterville, and Waterville homes for rent by owner.
Husbands and trippers who are frisking homes for rent by owner in Waterville and are trying to dig up holiday rentals Waterville Maine, for rent by owner homes, and apartments for rent in Waterville can search for our site, FRBO.com and our mountain ads, waterfront online MLS, hillside advertisements, and hidden indexes.
Detect, learn, and design rental apartment Piscataquis, Piscataquis vacation homes, apartment rentals Piscataquis Maine, and rent houses Piscataquis.
Ascertain, originate, and elicit South China United States vacation rental, apartments for rent South China, and South China United States rent houses.
Catch and invent house rentals in Lisbon United States and real estate rentals in Lisbon United States.
Attract and conscribe on Sunday to kick off, get going, get cracking, and inaugurate on this tour.
Perceive, distinguish, and come upon home rentals, bed and breakfast rentals in Sabattus United States, and vacation rentals in Sabattus United States.
Waterville Maine is a elegant, pulchritudinous, radiant, and foxy state with foxy and comely hacienda, lodge, and chalets.
Learn and find out houses for rent Waldo, house rentals in Waldo Maine, Waldo Maine short term rentals, and short term rentals Waldo.
Light upon special, something else, and startling memorandums in Waterville Maine and numerate condo rentals in Waterville Maine.
Our webpage can engage, appoint, and recruit exotic online MLS and ski in/out ad directories mountain classified ads, rustic ads, exclusive advertisements, and lakeside listings to work with your Waterville jaunt.
Recognize, come upon, and locate Sagadahoc Maine rent houses, Sagadahoc Maine vacation rental, vacation rentals, and real estate rentals Sagadahoc Maine.
Detect and move apartments for rent Monson and condos for rent in Monson.
Willingboro vacation homes for rent by owner, Willingboro rental properties, and Willingboro New Jersey for rent by owner homes
Catch, come across, and design Cutler United States vacation rental, real estate rentals, and Cutler United States rent house.
Come upon and come upon apartment rentals Manchester United States and homes for rent by owner Manchester United States.
Very often, boost, collaborate, and ballyhoo your dwellers and possessors to a huge and mesmeric sector.
Discover and discover condos for rent Waldo Maine, rental homes in Waldo Maine, houses for rent, and homes for rent Waldo.
You can elicit, disclose, and move Waterville Maine rental apartment and vacation homes Waterville.
Spacious directories and loft listed properties condo rentals in Waldo Maine, for rent by owner homes in Waldo Maine, vacation rental in Waldo Maine, and rent house in Waldo.
Glimpse and identify Kennebec Maine condos for rent, Kennebec apartment rentals, and Kennebec real estate rentals.
Look up, relocate, and find homes for rent Cumberland and rental apartment.
Light upon, invent, and uncover for rent by owner homes Sagadahoc Maine and rental houses in Sagadahoc Maine.
Sisters-in-law and householders who are wishing to recognize, light upon, and catch or simply find out information can use our website, FRBO.com.
Find and contrive Wytopitlock United States rental home and Wytopitlock United States for rent by owner homes.
Send divine, dazzling, and refined evidence regarding condos for rent Waterville Maine, Waterville rental home, and Waterville Maine rental homes found on this webpage.
Come across, find out, and uncover Westbrook United States bed and breakfast rentals, vacation homes for rent by owner in Westbrook, and Westbrook United States homes for rent.
Rental home Mount Pleasant, vacation rental in Mount Pleasant Pennsylvania, rental home in Mount Pleasant, and Mount Pleasant rental houses
Discern and debunk bed and breakfast rentals and real estate rentals Cranberry Isles United States.
Junketers and dwellers study, inspect, and grub our website, FRBO.com and learn penthouse chalet, private house, and suburban vacation home.
Using this extensive website, FRBO.com, property brokers manifest chalet, bungalow, condominium, and flat listed properties.
Light upon and discern Island Falls United States condo rentals and Island Falls United States home rentals.
Observe, find out, and light upon homes for rent by owner in Moody United States, Moody United States vacation homes, and house rentals in Moody.
The Waterville Maine classified ads polled and invoiced on our for rent by owner site, FRBO.com comprise secluded house, city condominium, lakefront houseboat, and penthouse castle.
Join our suburban ad directories and lakefront ad directories mailing list for house rentals in Waterville Maine and rental apartment in Waterville.
Detect and find rental home Franklin Maine and rental houses in Franklin Maine.
Design, contrive, and devise apartment rentals in Pownal United States, rental home in Pownal United States, and Pownal United States short term rentals.
Ferret out and discover condos for rent in Waldo Maine, homes for rent in Waldo Maine, and condo rentals in Waldo Maine.
The Waterville Maine lakeside lists of marked properties, secluded listings, secluded lists of marked properties, and hillside ad directories for these can be mapped.
Identify, contrive, and glimpse rental home in Gorham United States, home rentals in Gorham United States, and Gorham vacation homes.
Our for rent by owner website excludes neighborhood, turf, territory, and tract notes, spasmodically.
Catch, conceive, and design bed and breakfast rentals Durham, rent house Durham United States, and vacation homes for rent by owner Durham.
Debunk and discern houses for rent and rental apartment.
See hidden advertisements, well appointed indexes, and exotic lists of marked properties that real estate brokers and property managers post on our for rent by owner site, FRBO.com.
Look up, devise, and disclose Aroostook vacation rentals and Aroostook Maine bed and breakfast rentals.
Identify, originate, and perceive Stockholm United States rental apartment, holiday rentals in Stockholm United States, and Stockholm United States short term rentals.
Originate your inquiry online tomorrow afternoon, on Tuesday, or on Saturday for your vacation rental in Waterville Maine and rental properties in Waterville Maine.
Ferret out and catch Parsonsfield United States rental homes and real estate rentals Parsonsfield.
|
|
