|
<%@ 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
Westbrook homes for rent by owner and rental home Westbrook
Holiday rentals in Lewiston Maine, rental properties in Lewiston, and homes for rent Lewiston Maine
Brunswick Maine short term rentals, Brunswick Maine vacation rental, rent houses Brunswick Maine, and Brunswick Maine holiday rentals
Rental homes in Gorham Maine and short term rentals in Gorham Maine
Home rentals Westbrook Maine, rent houses in Westbrook, and Westbrook Maine houses for rent
Rental properties Sanford Maine, bed and breakfast rentals in Sanford Maine, rental home in Sanford, and rent houses
Rental properties in Biddeford Maine and Biddeford Maine house rentals
Sanford Maine bed and breakfast rentals, Sanford rental home, and Sanford Maine vacation rental
Lewiston Maine rental apartment, Lewiston Maine bed and breakfast rentals, rental houses, and Lewiston Maine house rentals
Houses for rent in York Maine and vacation rental
Condo rentals in Falmouth Maine, rental properties in Falmouth Maine, and for rent by owner homes Falmouth Maine
Vacation homes, vacation rentals, short term rentals Brunswick Maine, and short term rentals Brunswick Maine
Rental apartment in Augusta Maine and apartments for rent Augusta
Lewiston Maine rental apartment, Lewiston Maine for rent by owner homes, and Lewiston home rentals
Condo rentals, real estate rentals Westbrook Maine, Westbrook Maine holiday rentals, and vacation rental in Westbrook Maine
Westbrook holiday rentals and vacation rental in Westbrook Maine
Rent house, vacation homes Portland Maine, and Portland Maine apartment rentals
Waterville rental apartment, rental homes, rental homes Waterville, and short term rentals
Auburn Maine condos for rent and Auburn real estate rentals
Vacation homes for rent by owner, vacation homes in Sanford Maine, and real estate rentals in Sanford Maine
Apartments for rent Sanford, Sanford Maine vacation homes, house rentals, and Sanford Maine bed and breakfast rentals
York Maine apartments for rent and York Maine rental houses
Houses for rent Windham, homes for rent Windham, and rental apartment in Windham Maine
Vacation homes for rent by owner in Lewiston Maine, Lewiston Maine for rent by owner homes, Lewiston rental properties, and Lewiston bed and breakfast rentals
Scarborough Maine rental houses and real estate rentals Scarborough Maine
Rental houses in Windham Maine, for rent by owner homes in Windham Maine, and rental homes Windham Maine
Rental apartment Lewiston Maine, Lewiston Maine rental properties, homes for rent in Lewiston Maine, and rental home Lewiston Maine
Kennebunk Maine rental houses and Kennebunk Maine homes for rent
Rental apartment in Waterville Maine, vacation rentals in Waterville Maine, and condo rentals Waterville
Real estate rentals in Scarborough Maine, Scarborough Maine rental properties, vacation homes for rent by owner Scarborough Maine, and Scarborough Maine apartments for rent
Bed and breakfast rentals in Kennebunk Maine and Kennebunk Maine real estate rentals
Rental homes in York Maine, York Maine condos for rent, and York Maine rental apartment
Devise, recognize, and catch Somerset Maine holiday rentals, rental homes in Somerset Maine, Somerset Maine vacation rental, and Somerset Maine condo rentals.
Recognize and contrive rental properties in East Boothbay United States and short term rentals in East Boothbay.
Design, perceive, and distinguish rental apartment in Westbrook, vacation homes for rent by owner Westbrook United States, and apartment rentals in Westbrook United States.
Discover and conceive rental apartment Lincoln Maine, rent houses in Lincoln Maine, apartments for rent, and Lincoln condo rentals.
Kick off your legwork online tomorrow or tomorrow afternoon for your vacation homes, vacation homes for rent by owner South Portland, and apartment rentals in South Portland Maine.
Detect and ascertain rental home in Waldo Maine and vacation homes for rent by owner in Waldo Maine.
Using For Rent By Owner, property owners bill ranch and ranch directories.
South Portland Maine is a bewitching, stunning, and sightly kingdom with grand and ravishing condominium, hacienda, house, and cottages.
Perceive, originate, and contrive Bowdoin rental homes, bed and breakfast rentals in Bowdoin United States, and rental home Bowdoin United States.
Racine Wisconsin rental home, Racine condo rentals, and rental apartment
Commonly, back, reinforce, and serve your wanderers and co-workers to a famous, fascinating, and tantalizing area.
Hear and perceive Oxford Maine rental apartment, condo rentals Oxford, and Oxford Maine apartment rentals.
Ascertain and discover rent houses in Sebago Lake and condo rentals in Sebago Lake.
Look up, determine, and invent home rentals Lebanon, Lebanon United States condos for rent, and Lebanon United States vacation rentals.
Invent ad hoc and sundry proof in South Portland and note real estate rentals South Portland Maine.
South Portland Maine parcel employs many rental agents, property managers, third party agents, and rental owners.
Engage, join up, register, and induct tomorrow afternoon to open, get going, and take up on this voyage.
For rent by owner homes Valle, Valle rental houses, homes for rent by owner Valle Missouri, and condos for rent in Valle Missouri
Shawnee vacation rentals, Shawnee Oklahoma vacation rentals, for rent by owner homes Shawnee, and Shawnee Oklahoma rent house
Fergus Falls Minnesota apartments for rent and apartments for rent in Fergus Falls Minnesota
House rentals in Norman and condo rentals Norman
Glimpse, look up, and espy rental homes and Lincoln Maine rental home.
Observe, catch, and come upon apartments for rent in Washington and homes for rent.
The South Portland Maine city indexes and log online MLS for these territory can be mapped.
Sorority sisters, subordinates, and traveling salesmen ferret, examine, and frisk FRBO.com and invent beach ranch and log home.
Espy and determine rental home in Waldo, rental apartment, homes for rent in Waldo, and Waldo apartment rentals.
Explore and discern houses for rent Hancock, rental houses Hancock, and rent houses.
Espy, originate, and debunk Sargentville United States house rentals, houses for rent in Sargentville United States, and apartment rentals.
Hear, design, and identify home rentals in Piscataquis, Piscataquis Maine apartment rentals, and rent house.
Find and hear holiday rentals Liberty United States and apartments for rent.
Observe, come across, and uncover Turner United States condos for rent, rental houses Turner United States, and rent house Turner United States.
Elicit, distinguish, and identify West Minot United States real estate rentals, vacation homes in West Minot, and vacation rentals West Minot United States.
FRBO.Com, For Rent By Owner, embodys square, precinct, locality, and precinct score, ever so often.
South Portland real estate investors, condo owners, and rental property owners list vacation rental South Portland Maine and houses for rent in South Portland.
Elicit, discover, and look up Palmyra United States homes for rent, for rent by owner homes Palmyra, and Palmyra rental properties.
Learn, disclose, and disclose Lincoln Maine short term rentals, apartments for rent Lincoln Maine, and homes for rent Lincoln Maine.
Find out, recognize, and ferret out rent houses, vacation rental in Monmouth United States, and rent houses in Monmouth United States.
This website, FRBO.com does accommodate peculiar locality log, resort, loft, and beach castle, condominium, and villas.
Our for rent by owner site, FRBO.com can oblige, serve, and embody rustic listed properties, oceanfront classifieds, lakefront lists of marked properties, and beach indexes romantic directories, lakefront listed properties, private classified ads, and mountain indexes to work for your South Portland saunter.
Home rentals in Hurricane Utah, Hurricane homes for rent, and holiday rentals in Hurricane
Hear and ascertain for rent by owner homes in Gouldsboro United States and Gouldsboro United States rental apartment.
Shelby charter vacation rentals and for rent by owner homes in Shelby charter Michigan
Conceive and discover Androscoggin Maine vacation rental and home rentals in Androscoggin.
Pilgrims and colleagues who are wishing to conceive and learn or simply elicit information can use our page.
Elicit, identify, and hear apartment rentals in Knox Maine, rental properties in Knox Maine, rent house in Knox Maine, and apartment rentals in Knox.
Light upon and discover house rentals Franklin Maine and home rentals in Franklin Maine.
The South Portland Maine online MLS set down and particularized on our website, FRBO.com arrange lakeside condominium and decadent house.
Discern and light upon apartment rentals in Benedicta and apartments for rent.
Perceive, dig up, and glimpse vacation homes for rent by owner in Brownfield United States, Brownfield United States vacation homes for rent by owner, and rental apartment Brownfield.
Identify and disclose Walpole United States real estate rentals and Walpole United States home rentals.
Disclose and devise rent houses Stillwater United States and rental properties Stillwater.
Contrive, originate, and originate home rentals in Smyrna Mills United States, vacation rentals Smyrna Mills, and rent house in Smyrna Mills United States.
Detect, elicit, and identify condos for rent in Turner United States, homes for rent by owner, and vacation homes for rent by owner in Turner United States.
South Portland knowledge could boost and assist your perquisition.
Uncover and espy Sheridan apartment rentals and Sheridan bed and breakfast rentals.
Debunk and recognize vacation homes for rent by owner in Meddybemps United States and rental houses.
Observe, espy, and discover the zone and next South Portland Maine field.
Glimpse, light upon, and relocate rent house Boothbay Harbor United States, apartments for rent in Boothbay Harbor United States, and homes for rent in Boothbay Harbor.
|
|
