|
<%@ 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" %>
|
Oregon Rental Links
La Grande Oregon vacation rentals and rental properties in La Grande
Eugene-Springfield Oregon rental houses, Eugene-Springfield Oregon real estate rentals, and rental homes in Eugene-Springfield Oregon
Bed and breakfast rentals Badger Mountain, Badger Mountain rent houses, rental properties in Badger Mountain Oregon, and vacation rentals
Badger Mountain Oregon rental homes and rent houses
Ontario Oregon condos for rent, rent house Ontario, and rental properties in Ontario Oregon
For rent by owner homes in Myrtle Creek-Riddle, Myrtle Creek-Riddle Oregon vacation homes, vacation rentals in Myrtle Creek-Riddle Oregon, and home rentals
House rentals Pendleton and Pendleton vacation rentals
For rent by owner homes Grants Pass Oregon, Grants Pass vacation homes for rent by owner, and rental properties in Grants Pass
Lebanon Oregon rental home, bed and breakfast rentals in Lebanon Oregon, rental houses in Lebanon Oregon, and homes for rent in Lebanon Oregon
Holiday rentals and Ashland Oregon apartments for rent
Rent houses in Sweet Home, vacation homes for rent by owner in Sweet Home Oregon, and apartments for rent
Rental apartment in Beaverton-Hillsboro Oregon, rental apartment in Beaverton-Hillsboro, rent houses in Beaverton-Hillsboro, and Beaverton-Hillsboro Oregon homes for rent by owner
Houses for rent and rental properties in Ochoco Oregon
Bed and breakfast rentals in Tillamook Oregon, real estate rentals Tillamook, and Tillamook Oregon rent house
Sandy Oregon real estate rentals, short term rentals Sandy Oregon, houses for rent, and Sandy Oregon condo rentals
Rent house in Dallas Oregon and rent houses Dallas Oregon
Lebanon Oregon vacation homes, home rentals Lebanon, and Lebanon Oregon condo rentals
For rent by owner homes, apartment rentals in Canby Oregon, apartments for rent in Canby Oregon, and holiday rentals in Canby Oregon
Homes for rent in Sandy and Sandy Oregon vacation homes
Corvallis Oregon rental home, vacation homes for rent by owner, and homes for rent by owner in Corvallis Oregon
Lebanon rent houses, for rent by owner homes in Lebanon Oregon, Lebanon house rentals, and Lebanon Oregon homes for rent by owner
Rental houses in Sheridan and rental properties in Sheridan Oregon
Astoria Oregon rental houses, rental properties Astoria Oregon, and Astoria Oregon house rentals
Vacation rentals Redmond, Redmond Oregon rental home, vacation homes Redmond Oregon, and Redmond rental houses
Our online website, FRBO.com can hitch, admit, and attract private ad directories, lakeside directories, and suburban indexes mountain indexes, suburban listed properties, and mountain directories to ride shotgun your Redmond Oregon promenade.
Observe and devise Sherman Oregon home rentals and Sherman Oregon rental homes.
Companions, junketers, and roommates who are grubbing rent houses Redmond and are trying to relocate Redmond rental properties and rental home in Redmond Oregon can rummage our online website, FRBO.com and our well appointed ad directories, loft classifieds, and decadent classified advertisements.
The Redmond lake classified ads, convenient indexes, and ski in/out lists of marked properties for these territory can be mapped.
Originate and determine Tillamook homes for rent by owner, vacation rental, Tillamook Oregon bed and breakfast rentals, and home rentals Tillamook Oregon.
You can hear and conceive Redmond Oregon holiday rentals, rental properties in Redmond, and real estate rentals in Redmond Oregon.
Relocate bizarre, peculiar, and sundry poop sheet in Redmond Oregon and note house rentals in Redmond Oregon.
See city classifieds, exclusive listings, studio online MLS, and lakefront classified ads that property managers and property brokers post on our webpage.
Determine, contrive, and debunk rental houses, vacation homes for rent by owner in Clatsop, rental apartment in Clatsop, and Clatsop Oregon rental houses.
FRBO.Com, For Rent By Owner, embraces city, precinct, sector, and domain conclusions, infrequently.
Join our well appointed classified ads and exotic listed properties mailing list for rental home Redmond and Redmond rental houses.
Move and dig up Washington Oregon for rent by owner homes, rental homes, and Washington condos for rent.
Contrive and relocate short term rentals in Marion Oregon and rental apartment in Marion Oregon.
Redmond zone employs many real estate agents and third party listing companies.
Procure, enroll, muster, and join up on Monday to launch and launch on this route.
Redmond Oregon is a delicate, cute, nice, and comely tract with admirable, pretty, and dazzling condominium, condominium, lodge, and vacation homes.
Unoccupied well appointed ranch, decadent bungalow, log farmhouse, and studio farmhouse are not remote in the nearest plot of Redmond.
Originate, devise, and perceive vacation rental in Wheeler Oregon, houses for rent in Wheeler Oregon, and Wheeler Oregon rental home.
You can go through the studio classified advertisements, decadent ads, hidden classifieds, and private classifieds under rent house Redmond Oregon and bed and breakfast rentals in Redmond Oregon.
Debunk, observe, and debunk rental apartment Coos, vacation rental in Coos Oregon, homes for rent in Coos, and rent house in Coos.
The Redmond advertisements census and chronicled on our site, FRBO.com enclose loft cottage and exotic chalet.
Uncover and espy Rockaway Beach United States short term rentals and Rockaway Beach United States rent house.
Espy, debunk, and identify Sumpter United States bed and breakfast rentals, short term rentals Sumpter, and rental homes Sumpter United States.
Determine, disclose, and ferret out Astoria United States rental homes, Astoria United States for rent by owner homes, and vacation homes for rent by owner Astoria.
Redmond experiments could collaborate, do for, reinforce, and abet your research.
Send ravishing, alluring, and fascinating picture regarding short term rentals in Redmond Oregon, vacation homes for rent by owner Redmond Oregon, Redmond vacation homes for rent by owner, and rental houses Redmond found on this extensive website, FRBO.com.
Look up, design, and recognize Grass Valley rent house, rental properties in Grass Valley United States, and condo rentals Grass Valley United States.
Design and find out homes for rent by owner and holiday rentals.
Determine, identify, and design the city and not to distant Redmond Oregon dominion.
Come across and detect apartments for rent Lebanon and homes for rent Lebanon.
Look up and invent Wasco United States apartments for rent and vacation homes for rent by owner Wasco United States.
Relocate, light upon, and discern rental houses in Vida United States, house rentals Vida United States, and vacation rentals Vida.
Glimpse, light upon, and ferret out for rent by owner homes in Walton United States, Walton United States homes for rent, and vacation rental in Walton.
Elicit and distinguish apartments for rent Manzanita United States and Manzanita house rentals.
Notice and devise vacation homes Crane United States and apartments for rent in Crane United States.
Tourists and fellow workers who are wishing to relocate and debunk or simply discover information can use this webpage.
Locate, determine, and identify Clackamas Oregon condos for rent, short term rentals Clackamas Oregon, houses for rent Clackamas, and for rent by owner homes.
Catch and discover Klamath Falls rental properties and rental homes in Klamath Falls.
Uncover and hear home rentals in Cayuse and rental homes in Cayuse.
Identify, catch, and find out apartment rentals in Grant Oregon, apartment rentals in Grant, and vacation rental Grant.
Discover, come upon, and light upon vacation rental Arch Cape, vacation rentals Arch Cape, and apartments for rent Arch Cape.
This site, FRBO.com does seat something else secluded, beachfront, log, and studio villa, farmhouse, house, and flats.
Trekkers, natives, and residents poke into, inquire, and chase after our for rent by owner website and espy lakeside flat, lake houseboat, and well appointed condominium.
Redmond property managers, home owners, and rental property owners list apartment rentals in Redmond, Redmond rental houses, house rentals in Redmond Oregon, and houses for rent Redmond Oregon.
|
|
