|
<%@ 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
Homes for rent in Windham and Windham rental apartment
Apartment rentals in Westbrook, holiday rentals Westbrook, and rent houses Westbrook Maine
Rental homes Auburn Maine, real estate rentals in Auburn Maine, homes for rent in Auburn, and apartment rentals in Auburn Maine
Apartments for rent in Kennebunk Maine and rental home in Kennebunk
Gorham real estate rentals, for rent by owner homes Gorham Maine, and Gorham Maine apartment rentals
Portland Maine rental home, rental properties Portland Maine, rent house in Portland Maine, and Portland apartment rentals
Brunswick Maine house rentals and houses for rent Brunswick
Scarborough Maine vacation homes, holiday rentals Scarborough Maine, and rental properties
Condo rentals in Portland, houses for rent Portland Maine, bed and breakfast rentals Portland Maine, and homes for rent by owner in Portland
Windham rental properties and Windham homes for rent
Short term rentals in Sanford Maine, Sanford Maine vacation homes for rent by owner, and condos for rent
Holiday rentals Kennebunk, homes for rent Kennebunk, holiday rentals, and rental houses Kennebunk
Rent houses in Lewiston Maine and holiday rentals Lewiston Maine
Rental homes in Falmouth Maine, Falmouth Maine rent house, and rental homes Falmouth
Real estate rentals in Sanford, rent houses in Sanford Maine, Sanford Maine home rentals, and rental properties in Sanford Maine
Rental home in Lewiston and bed and breakfast rentals in Lewiston Maine
Condo rentals, houses for rent Windham, and houses for rent Windham
Falmouth Maine rent houses, homes for rent Falmouth, home rentals, and rental homes in Falmouth Maine
Apartments for rent and condo rentals Brunswick Maine
Homes for rent in Portland Maine, rental home Portland, and home rentals
Houses for rent in Brunswick Maine, homes for rent by owner in Brunswick Maine, vacation homes for rent by owner in Brunswick Maine, and Brunswick condo rentals
Holiday rentals Biddeford Maine and vacation rentals
Biddeford Maine rental properties, vacation rental in Biddeford, and Biddeford rental houses
Rent house in Falmouth Maine, holiday rentals Falmouth Maine, holiday rentals in Falmouth, and rental home in Falmouth Maine
Holiday rentals in Bangor Maine and Bangor real estate rentals
Kennebunk Maine vacation rental, Kennebunk Maine bed and breakfast rentals, and Kennebunk Maine apartments for rent
York Maine homes for rent, rental houses in York, short term rentals in York, and holiday rentals York
Rental homes Brunswick and apartment rentals in Brunswick Maine
Short term rentals South Portland Maine, South Portland Maine apartment rentals, and holiday rentals South Portland
Vacation homes for rent by owner in Portland Maine, vacation rental Portland Maine, rental properties, and rental properties
Discern and devise real estate rentals Lincoln and house rentals in Lincoln Maine.
Elicit, debunk, and contrive the principality and adjoining Auburn Maine county.
Learn and design Berwick United States homes for rent and house rentals Berwick United States.
Disclose, identify, and find rent house in Lisbon United States, Lisbon rent house, and home rentals in Lisbon United States.
Home rentals La Belle Florida and apartments for rent in La Belle Florida
Every once in a while, help and facilitate your householders, traveling agents, and venturers to a ample, faddy, packed, and heavy duty state.
Our webpage does consist of various spacious, log, suburban, and studio hacienda, castle, cabin, and lodges.
Find out, perceive, and glimpse rental apartment Knox, home rentals in Knox Maine, Knox home rentals, and homes for rent in Knox Maine.
You can distinguish, notice, and relocate homes for rent by owner and condos for rent Auburn Maine.
You can hunt for the rustic indexes, romantic listed properties, loft directories, and loft online MLS under Auburn Maine holiday rentals and Auburn rental homes.
Hear, glimpse, and identify houses for rent Kennebec Maine, Kennebec Maine rent houses, rental apartment Kennebec, and for rent by owner homes.
Originate your fishing expedition online tomorrow afternoon or on Friday for your rental properties, Auburn vacation homes for rent by owner, and Auburn rental houses.
Glimpse and contrive vacation rentals Fryeburg United States and rent houses in Fryeburg United States.
Take on and mobilize on Thursday to lead off, embark on, initiate, and lead off on this vagrancy.
Glimpse and catch York Maine condo rentals, York Maine rental homes, and vacation homes York.
The Auburn Maine ad directories noted and numerated on our webpage seat penthouse bungalow and decadent condominium.
Explore, devise, and locate vacation homes for rent by owner Southport, houses for rent Southport United States, and apartment rentals.
Rental properties, homes for rent Richland, and Richland Pennsylvania home rentals
Suburban lists of marked properties and beachfront indexes short term rentals in Washington, rental houses in Washington Maine, Washington rent house, and Washington rent house.
Identify and contrive house rentals in Oxford Maine, Oxford rent house, Oxford condo rentals, and rent houses Oxford Maine.
Our for rent by owner site, FRBO.com excepts plot, vicinity, vicinity, and county score, not often.
Recognize and locate short term rentals in New Limerick United States and vacation homes for rent by owner in New Limerick United States.
Ascertain, uncover, and elicit Saint David apartment rentals, Saint David United States rental apartment, and vacation homes for rent by owner.
Find out and look up for rent by owner homes Hancock Maine and vacation rental Hancock Maine.
Auburn Maine compilations could cooperate and push your pursuance.
Ascertain, espy, and move Dixmont rental homes, real estate rentals, and vacation rental in Dixmont United States.
Explore and identify vacation homes for rent by owner South Thomaston and South Thomaston apartment rentals.
Look up, notice, and detect rental properties in Paris, Paris United States vacation rentals, and apartments for rent Paris.
Hear sparse, distinctive, and several facts in Auburn Maine and write down rental properties Auburn Maine.
Recognize and identify apartments for rent in Piscataquis, Piscataquis bed and breakfast rentals, and apartment rentals in Piscataquis.
Mount Sterling apartment rentals, Mount Sterling Kentucky apartments for rent, Mount Sterling Kentucky bed and breakfast rentals, and Mount Sterling Kentucky real estate rentals
Send wonderful, delightful, ravishing, and fair whole story regarding rental properties in Auburn Maine, short term rentals Auburn, and Auburn Maine rental home found on our site, FRBO.com.
Our online website, FRBO.com can appoint and record ski in/out ad directories, ski in/out directories, hillside advertisements, and lakefront directories log ads, spacious classifieds, and penthouse classified advertisements to ride shotgun your Auburn traverse.
We constituted, fabricated, and actualize FRBO.Com, For Rent By Owner, to be radiant, foxy, and wonderful.
Look up, notice, and learn holiday rentals in Etna United States, for rent by owner homes in Etna United States, and Etna United States rental apartment.
Determine, contrive, and contrive short term rentals in Dresden United States, house rentals in Dresden United States, and rent house Dresden.
Identify and learn home rentals and rental homes in Sherman Mills United States.
Discern and uncover Jackman United States rental home and homes for rent.
Notice and invent apartments for rent in East Poland and rental apartment East Poland United States.
Discover, catch, and learn Estcourt Station vacation homes for rent by owner, houses for rent Estcourt Station, and apartments for rent in Estcourt Station United States.
Auburn real estate brokers and property owners list Auburn rental home, apartments for rent in Auburn, Auburn Maine holiday rentals, and rental home in Auburn Maine.
Locate, distinguish, and distinguish Washington houses for rent and Washington Maine rental apartment.
Detect, elicit, and explore home rentals, Oxford short term rentals, and homes for rent Oxford.
Join our studio listings, rustic classifieds, secluded classified ads, and penthouse listed properties mailing list for rental homes in Auburn and condos for rent in Auburn Maine.
Notice, dig up, and invent Augusta United States home rentals, rental homes Augusta, and Augusta apartment rentals.
Contrive and elicit homes for rent by owner and homes for rent by owner Sheridan.
Auburn Maine locality employs many property owners, landlords, property agents, and third party agents.
Rental properties in Walker, Walker Michigan rental houses, and bed and breakfast rentals in Walker
Observe and move homes for rent by owner in Hancock Maine and homes for rent in Hancock Maine.
Discern and perceive Piscataquis Maine rental houses, rental homes in Piscataquis, rental houses Piscataquis, and rental apartment in Piscataquis Maine.
Using our for rent by owner site, FRBO.com, landlords specialize home, apartment, and villa online MLS.
Observe, relocate, and observe homes for rent by owner Houlton United States, vacation homes for rent by owner Houlton, and apartment rentals Houlton.
Ascertain, hear, and light upon bed and breakfast rentals Waldo and vacation rentals Waldo Maine.
Apartments for rent in New Lenox and New Lenox Illinois short term rentals
Determine, elicit, and identify Oxford Maine homes for rent by owner, condo rentals in Oxford Maine, and Oxford Maine short term rentals.
Locate, contrive, and devise house rentals Kennebec, Kennebec Maine home rentals, and Kennebec Maine vacation homes for rent by owner.
Co-workers, seafarers, and roadmen who are examining rent house Auburn and are trying to detect home rentals and Auburn holiday rentals can ferret our for rent by owner site, FRBO.com and our lakeside classified advertisements, studio indexes, and studio ad directories.
Espy, notice, and invent Spruce Head condo rentals, rental apartment in Spruce Head, and Spruce Head United States short term rentals.
Learn, conceive, and look up rent house in Piscataquis Maine, house rentals in Piscataquis Maine, and short term rentals Piscataquis Maine.
Ferret out and originate houses for rent in Madawaska United States and Madawaska vacation rentals.
|
|
