|
<%@ 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 rentals York and rental houses York Maine
Homes for rent by owner Saco Maine, condo rentals in Saco Maine, and condos for rent in Saco Maine
Brunswick Maine rent house, apartment rentals Brunswick Maine, bed and breakfast rentals Brunswick Maine, and Brunswick apartments for rent
Rental home Westbrook Maine and homes for rent by owner Westbrook
Houses for rent in Bangor, rental properties in Bangor Maine, and real estate rentals Bangor Maine
Vacation homes Falmouth Maine, vacation homes Falmouth, Falmouth holiday rentals, and home rentals Falmouth
Vacation homes for rent by owner in Gorham and Gorham Maine vacation rentals
Scarborough Maine for rent by owner homes, Scarborough Maine vacation homes for rent by owner, and Scarborough Maine rental homes
House rentals Gorham Maine, rental home in Gorham Maine, rental home Gorham, and condo rentals
Falmouth Maine apartment rentals and Falmouth Maine condos for rent
Auburn Maine vacation homes for rent by owner, homes for rent by owner Auburn, and Auburn Maine homes for rent
House rentals Bangor Maine, Bangor Maine house rentals, Bangor Maine home rentals, and rental apartment Bangor
Vacation homes in Scarborough Maine and vacation rentals in Scarborough
House rentals, York rental apartment, and rental houses
Home rentals, rent houses in Sanford Maine, Sanford for rent by owner homes, and rent houses Sanford
Brunswick Maine condo rentals and bed and breakfast rentals in Brunswick Maine
Rental properties Lewiston, rental properties Lewiston Maine, and vacation rentals in Lewiston
Gorham Maine short term rentals, Gorham condos for rent, rental apartment Gorham, and Gorham Maine homes for rent by owner
Vacation homes and rental apartment
Rental properties Falmouth Maine, rental properties in Falmouth Maine, and rent houses Falmouth
Rent house Waterville Maine, home rentals, rental apartment in Waterville Maine, and condo rentals Waterville Maine
Short term rentals in Portland Maine and rental apartment
York Maine apartments for rent, York Maine vacation rentals, and homes for rent in York
Rent house in Gorham Maine, Gorham bed and breakfast rentals, rental properties Gorham, and Gorham Maine real estate rentals
Falmouth Maine vacation homes and Falmouth vacation homes
Rental home, Scarborough Maine vacation homes for rent by owner, and houses for rent in Scarborough Maine
Vacation homes for rent by owner in Bangor, apartment rentals Bangor, Bangor house rentals, and apartments for rent in Bangor Maine
Rent house Brunswick and Brunswick Maine homes for rent
Rental properties Bangor, apartment rentals in Bangor Maine, and Bangor Maine vacation rental
Houses for rent in Augusta Maine, Augusta Maine homes for rent, home rentals in Augusta Maine, and vacation rental in Augusta Maine
Saco Maine memorandums could facilitate, collaborate, and puff your hunt.
Conceive, elicit, and move Washington home rentals, house rentals in Washington Maine, Washington home rentals, and Washington Maine for rent by owner homes.
Seminole North for rent by owner homes, rent house in Seminole North Oklahoma, and vacation rental Seminole North Oklahoma
We organized, set up, and hatched this webpage to be divine, pleasing, and delightful.
Learn, look up, and come upon York houses for rent, homes for rent in York Maine, and York rental home.
Distinguish and ascertain vacation homes Penobscot Maine, vacation rental Penobscot Maine, rental apartment Penobscot, and apartments for rent in Penobscot Maine.
Dig up and identify rental houses in Piscataquis Maine and rental homes Piscataquis.
Ferret out and learn house rentals in Jefferson United States and Jefferson United States rental home.
Catch and identify house rentals Penobscot Maine and Penobscot rent houses.
Saco Maine is a superb, elegant, and marvelous kingdom with exquisite, shapely, taking, and splendid hacienda, chalet, lodge, and cabins.
Find, espy, and perceive rental homes in Wytopitlock United States, houses for rent in Wytopitlock United States, and Wytopitlock United States rental home.
Identify and elicit East Dixfield United States holiday rentals and vacation rentals in East Dixfield United States.
Saco real estate investors, rental agents, brokers leasing foreclosures, and condo owners list homes for rent Saco, condo rentals, and Saco apartments for rent.
Send fine, refined, and pretty goods regarding apartments for rent in Saco, holiday rentals Saco Maine, for rent by owner homes in Saco, and Saco Maine homes for rent by owner found on this webpage.
Habitants and hikers go through, hunt, and chase after our online website, FRBO.com and conceive romantic townhouse and beach cabin.
Saco Maine neighborhood employs many landlords, home owners, agents, and agents serving the condo market.
Join our beachfront indexes, hidden classified ads, and mountain online MLS mailing list for rental apartment and home rentals in Saco Maine.
For rent by owner homes in Interior County Florida, Interior County Florida apartment rentals, and rental properties in Interior County Florida
Dig up and catch homes for rent in Oquossoc United States and short term rentals in Oquossoc United States.
Find and recognize rental homes Northeast Harbor and for rent by owner homes Northeast Harbor United States.
Mountain online MLS and hillside online MLS York Maine condos for rent, vacation rental in York Maine, York Maine condos for rent, and rent houses in York Maine.
Boarders and traveling sales representatives who are wishing to design, recognize, and come upon or simply disclose information can use our webpage.
Uncover, detect, and detect rental apartment Knox, rental homes in Knox, condo rentals Knox, and rental home in Knox Maine.
Devise and dig up apartments for rent in Franklin Maine, vacation homes Franklin, and Franklin vacation homes for rent by owner.
Learn and look up East Boothbay rental home and vacation homes in East Boothbay United States.
Debunk, find out, and determine Aroostook rent houses, real estate rentals in Aroostook, rental homes, and rental homes in Aroostook.
Light upon and discern rent house Standish and Standish homes for rent.
Discover, uncover, and recognize rent houses Hancock Maine, rental homes, and Hancock Maine apartments for rent.
Relocate and invent rent house in Bar Mills United States and Bar Mills United States vacation homes.
Debunk, elicit, and identify home rentals and Hancock Maine bed and breakfast rentals.
Explore and learn apartment rentals in Shirley Mills United States and Shirley Mills United States for rent by owner homes.
Embark on your investigation online next weekend, tomorrow morning, this weekend, or on Sunday for your house rentals, vacation rental Saco Maine, and Saco Maine condos for rent.
Espy, notice, and detect rental properties in Raymond United States, Raymond apartments for rent, and rental houses Raymond United States.
Find and ferret out Shawmut United States real estate rentals and houses for rent in Shawmut.
Hear, perceive, and elicit rental home Westbrook, Westbrook United States rental home, and holiday rentals Westbrook.
Houses for rent in Arcadia East Florida, holiday rentals, rental homes Arcadia East, and rental properties in Arcadia East Florida
Conceive, disclose, and discover Blue Hill Falls United States apartments for rent, homes for rent Blue Hill Falls United States, and rental houses Blue Hill Falls United States.
Contrive, catch, and notice rental properties in Kents Hill United States, Kents Hill United States rental properties, and Kents Hill vacation homes.
You can scour the well appointed classified ads and resort listed properties under holiday rentals Saco Maine and real estate rentals in Saco Maine.
|
|
