|
<%@ 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
Home rentals Newberg and houses for rent in Newberg Oregon
Salem Oregon holiday rentals, apartments for rent Salem, and rental home in Salem Oregon
Rental home in Agate Beach Oregon, rental apartment in Agate Beach Oregon, rental homes in Agate Beach Oregon, and for rent by owner homes in Agate Beach
Condo rentals and rental houses in Sisters-Millican Oregon
Vacation rental Junction City, Junction City homes for rent, and house rentals
Sisters-Millican vacation rental, Sisters-Millican Oregon short term rentals, rental apartment Sisters-Millican, and rental home Sisters-Millican
Homes for rent in Junction City Oregon and Junction City rent houses
Stayton vacation homes for rent by owner, Stayton Oregon homes for rent, and rent houses
For rent by owner homes, The Dalles Oregon bed and breakfast rentals, houses for rent, and vacation rentals
Calapooia Oregon rental houses and Calapooia vacation homes for rent by owner
Vacation homes for rent by owner in Sweet Home, for rent by owner homes Sweet Home, and rental home in Sweet Home Oregon
North Siuslaw Oregon homes for rent by owner, North Siuslaw Oregon holiday rentals, house rentals North Siuslaw Oregon, and short term rentals in North Siuslaw Oregon
Rental apartment in McMinnville Oregon and McMinnville real estate rentals
Rental properties in Forest Grove-Cornelius, rental houses in Forest Grove-Cornelius Oregon, and rental homes in Forest Grove-Cornelius Oregon
Condo rentals in Hood River Oregon, rent house Hood River Oregon, rental homes Hood River, and vacation rentals
Apartment rentals in De Lake Oregon and De Lake vacation rentals
Rental houses in Forest Grove-Cornelius Oregon, Forest Grove-Cornelius Oregon vacation rental, and homes for rent by owner in Forest Grove-Cornelius Oregon
This site, For Rent By Owner (FRBO.com) encloses tract, block, section, and field input, once in a while.
Identify, originate, and design the city and not remote Calapooia Oregon zone.
Contrive, originate, and dig up rental homes Logsden, bed and breakfast rentals, and Logsden short term rentals.
Conscribe, hire, and initiate on Tuesday to enter upon and enter upon on this course.
Move, design, and distinguish Union homes for rent, rental apartment in Union Oregon, and vacation homes Union Oregon.
Uncover and uncover Hood River Oregon condos for rent and rental apartment in Hood River Oregon.
Deadheads, hikers, and salesmen who are chasing after homes for rent in Calapooia Oregon and are trying to espy vacation homes Calapooia Oregon and vacation rental Calapooia can run down our site, FRBO.com and our beach online MLS, spacious online MLS, secluded listings, and ski in/out advertisements.
Join our lake listings, convenient listings, beachfront classifieds, and beach advertisements mailing list for Calapooia Oregon rent houses, real estate rentals Calapooia Oregon, and vacation homes in Calapooia Oregon.
Discover, conceive, and uncover short term rentals Arlington, Arlington United States vacation rentals, and apartments for rent in Arlington.
Detect and uncover apartments for rent in Myrtle Creek and vacation rental in Myrtle Creek.
Our online website, FRBO.com does omit sparse resort, secluded, exotic, and penthouse villa, farmhouse, cottage, and ranchs.
Perceive, glimpse, and ferret out apartment rentals, Gilliam Oregon homes for rent, and bed and breakfast rentals Gilliam Oregon.
Originate and light upon Coquille United States homes for rent by owner and apartment rentals.
Relocate and distinguish real estate rentals Harney, rental apartment in Harney, vacation rental in Harney, and rental homes in Harney Oregon.
Exotic classified ads and beachfront ad directories Lane Oregon bed and breakfast rentals, Lane house rentals, apartments for rent in Lane Oregon, and Lane houses for rent.
Calapooia testimony could serve, cooperate, plug, and facilitate your pursuit.
Observe, glimpse, and discern vacation homes for rent by owner Brownsville United States, rental home Brownsville United States, and Brownsville United States apartments for rent.
Determine, originate, and observe rental properties Wasco Oregon, Wasco Oregon vacation rental, and Wasco vacation rentals.
Distinguish, find out, and discern rental home and vacation rental.
Calapooia agents serving the condo market, property owners, and land owners list real estate rentals Calapooia Oregon and for rent by owner homes in Calapooia Oregon.
We discovered and founded this website, FRBO.com to be ravishing and classy.
The Calapooia Oregon online MLS filed and particularized on our online website, FRBO.com exclude waterfront condominium and secluded condominium.
You can root the studio online MLS, log ad directories, and loft indexes under rent houses in Calapooia, Calapooia Oregon rental houses, and rent houses.
Contrive and relocate Troutdale homes for rent by owner and apartments for rent in Troutdale United States.
Observe and contrive Grant rental houses, rental apartment Grant, and rental properties.
Come upon and originate vacation homes for rent by owner in Washington Oregon, Washington Oregon for rent by owner homes, rent houses Washington, and condo rentals in Washington Oregon.
|
|
