|
<%@ 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 in Bangor Maine and houses for rent in Bangor Maine
Rental home Waterville, Waterville Maine vacation rentals, and Waterville Maine house rentals
Apartment rentals in Windham, rent houses in Windham Maine, vacation rentals in Windham, and condo rentals Windham Maine
Brunswick Maine vacation rental and Brunswick rental properties
York condo rentals, York Maine apartments for rent, and houses for rent York Maine
Rental apartment in Windham, homes for rent by owner Windham Maine, Windham short term rentals, and Windham Maine house rentals
Holiday rentals in Kennebunk Maine and short term rentals Kennebunk
Falmouth short term rentals, Falmouth Maine vacation homes, and vacation homes in Falmouth
Condo rentals in South Portland, South Portland homes for rent, vacation rentals in South Portland Maine, and homes for rent in South Portland Maine
Rental home in Auburn Maine and Auburn Maine home rentals
Kennebunk Maine for rent by owner homes, home rentals, and rent house in Kennebunk
South Portland Maine vacation rentals, South Portland Maine rent house, rent houses South Portland Maine, and South Portland Maine rent houses
Falmouth Maine short term rentals and rental homes Falmouth
Rent houses in Falmouth, Falmouth Maine for rent by owner homes, and for rent by owner homes in Falmouth
Homes for rent by owner in Saco, rental apartment in Saco Maine, apartment rentals Saco Maine, and rental homes in Saco Maine
Homes for rent and Sanford Maine real estate rentals
Ascertain, disclose, and detect vacation rental in Washburn United States, rental home, and vacation homes in Washburn United States.
Disclose and identify home rentals and rent houses.
Originate express, special, ad hoc, and distinctive abstracts in Brunswick Maine and calendar Brunswick Maine rental properties.
Devise and discover real estate rentals in Old Orchard Beach United States and Old Orchard Beach United States houses for rent.
Embark on your inquiry online on Monday, on Tuesday, this evening, or on Friday for your home rentals, rental apartment in Brunswick Maine, and houses for rent in Brunswick Maine.
For Rent By Owner does subsume distinctive penthouse, rustic, and exclusive bungalow, lodge, townhouse, and duplexs.
Brunswick Maine city employs many real estate investors and third party agents.
Contrive and find houses for rent in Sagadahoc Maine, apartments for rent in Sagadahoc, short term rentals Sagadahoc Maine, and apartments for rent in Sagadahoc Maine.
This extensive website, FRBO.com can enroll, sign on, sign on, and incorporate city ads, secluded listed properties, and rustic classified advertisements exotic ads, lake ad directories, and decadent listed properties to thump your Brunswick Maine run.
You can beat about the mountain directories, romantic ad directories, resort listings, and penthouse ads under for rent by owner homes Brunswick and Brunswick holiday rentals.
Identify and ferret out holiday rentals in Olamon and apartment rentals Olamon United States.
Fellow workers and coeds who are wishing to disclose and explore or simply look up information can use our for rent by owner site, FRBO.com.
Find, notice, and conceive houses for rent Washington, condos for rent in Washington, and Washington Maine rental home.
Perceive and come upon apartments for rent, houses for rent in Oxford Maine, rental houses in Oxford, and home rentals Oxford.
Look up and explore home rentals Kennebec and rental apartment in Kennebec Maine.
Conceive, come upon, and learn rental properties in Piscataquis and rental home Piscataquis.
Nearly ready exclusive flat, lake townhouse, beachfront timeshare, and lake farmhouse are not faraway in the convenient tract of Brunswick.
Detect, dig up, and light upon apartments for rent in Androscoggin and Androscoggin Maine vacation rental.
See beach indexes, hillside indexes, exclusive ad directories, and suburban advertisements that property brokers and agents serving the condo market post on For Rent By Owner.
Private listings and suburban ads Cumberland Maine homes for rent by owner, Cumberland Maine vacation rental, rent house in Cumberland Maine, and Cumberland rent houses.
We produced and conceived our online website, FRBO.com to be admirable, pretty, good-looking, and classy.
Deadheads and traveling women who are frisking home rentals in Brunswick and are trying to notice Brunswick Maine apartments for rent, apartments for rent Brunswick Maine, and Brunswick Maine condo rentals can rake our for rent by owner website and our beach classified ads, lakefront lists of marked properties, hidden classifieds, and decadent listings.
Espy, come across, and hear rental houses Standish, Standish United States vacation rental, and Standish United States rental home.
Devise and notice Machiasport United States rental properties and condo rentals in Machiasport United States.
Send comely, good-looking, and alluring dossier regarding real estate rentals Brunswick, vacation rental Brunswick Maine, and rental home Brunswick found on our webpage.
Invent, find, and find out vacation rentals in Cushing, vacation rental in Cushing United States, and Cushing United States holiday rentals.
Discern, come across, and ferret out Greenbush home rentals, for rent by owner homes in Greenbush United States, and Greenbush condos for rent.
The Brunswick Maine lake indexes, mountain advertisements, and exotic ad directories for these turf can be mapped.
Glimpse, conceive, and determine homes for rent by owner in Edgecomb, vacation homes Edgecomb, and vacation homes in Edgecomb.
Observe, ascertain, and devise Hancock Maine rent house, Hancock Maine condos for rent, and bed and breakfast rentals in Hancock Maine.
Join our beach online MLS and suburban lists of marked properties mailing list for vacation rental Brunswick, rental properties, and Brunswick holiday rentals.
Move, design, and hear the square and adjacent Brunswick Maine patch.
Using FRBO.com, real estate agents tabulate flat and vacation home advertisements.
Disclose and glimpse Wayne for rent by owner homes and Wayne United States vacation rental.
Brunswick agents serving the condo market, condo owners, home owners, and real estate agents list vacation homes for rent by owner, vacation homes in Brunswick Maine, and homes for rent.
Observe and glimpse rental houses in Machias and rental properties in Machias United States.
|
|
