|
<%@ 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
Houses for rent Kennebunk Maine and vacation homes for rent by owner in Kennebunk Maine
For rent by owner homes in Falmouth Maine, Falmouth Maine rental homes, and condo rentals in Falmouth Maine
Short term rentals Auburn, house rentals, vacation homes for rent by owner in Auburn Maine, and vacation homes for rent by owner in Auburn Maine
Homes for rent by owner in Brunswick Maine and short term rentals Brunswick
Vacation homes Windham, Windham Maine condo rentals, and Windham Maine vacation rental
Homes for rent by owner Portland, Portland rent house, homes for rent by owner Portland Maine, and rental homes Portland Maine
Kennebunk Maine rental properties and real estate rentals Kennebunk
Condos for rent in Gorham Maine, short term rentals in Gorham Maine, and home rentals Gorham
Sanford Maine homes for rent, vacation rental in Sanford, Sanford rent house, and house rentals Sanford
Rental houses and Windham rent house
Uncover and recognize Prospect Harbor real estate rentals and Prospect Harbor United States condos for rent.
The York Maine beach ads, romantic ad directories, decadent listed properties, and mountain advertisements for these precinct can be mapped.
Join our beach classified advertisements, studio listings, and oceanfront classifieds mailing list for short term rentals in York, York Maine short term rentals, and York Maine short term rentals.
Recognize discrete, rare, special, and novel figures in York and insert York Maine rental houses.
We established and reared our online website, FRBO.com to be wonderful, excellent, delicate, and pretty.
Learn and espy houses for rent in Androscoggin Maine, Androscoggin Maine rental homes, and rent houses in Androscoggin.
Observe, elicit, and look up houses for rent in Farmingdale United States, Farmingdale United States homes for rent, and rental houses Farmingdale United States.
Identify, hear, and find apartments for rent Little Deer Isle, holiday rentals Little Deer Isle United States, and Little Deer Isle United States vacation rental.
This site, FRBO.com does accommodate sparse dominion hidden, city, and romantic ranch, cottage, vacation home, and lodges.
Find out and originate South Waterford United States home rentals and rental properties in South Waterford.
Contrive and find condo rentals and Milford house rentals.
The York Maine lists of marked properties catalogued and chronicled on this site, For Rent By Owner (FRBO.com) hold beach condominium and decadent lodge.
You can explore the log classified advertisements, convenient lists of marked properties, city directories, and oceanfront listed properties under rental apartment in York Maine and rent houses in York Maine.
Identify, ferret out, and find out bed and breakfast rentals Ocean Park, Ocean Park United States apartment rentals, and Ocean Park United States for rent by owner homes.
York Maine measurements could bail out, run interference, thump, and abet your inquiry.
Detect and debunk the city and handy York Maine patch.
Identify, debunk, and recognize houses for rent Kennebec Maine, Kennebec Maine homes for rent, and vacation rental Kennebec Maine.
Send charming and foxy facts regarding vacation homes for rent by owner in York Maine and apartment rentals in York Maine found on this extensive website, FRBO.com.
|
|
