|
<%@ 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
Real estate rentals in Baker City Oregon and houses for rent in Baker City
Bed and breakfast rentals Wilsonville, apartments for rent in Wilsonville, and house rentals Wilsonville Oregon
Southwest Jackson Oregon apartments for rent, short term rentals Southwest Jackson, rent house Southwest Jackson, and bed and breakfast rentals Southwest Jackson Oregon
Vacation rental in Northwest Umatilla Oregon and real estate rentals Northwest Umatilla Oregon
Apartments for rent, Albany Oregon rental houses, and apartment rentals Albany
Condo rentals Northeast Umatilla Oregon, apartments for rent Northeast Umatilla Oregon, rent houses in Northeast Umatilla Oregon, and homes for rent in Northeast Umatilla Oregon
Sandy Oregon apartments for rent and rental houses in Sandy Oregon
House rentals in De Lake Oregon, bed and breakfast rentals, and De Lake Oregon apartments for rent
Apartments for rent Northeast Umatilla, Northeast Umatilla Oregon houses for rent, rent houses Northeast Umatilla, and Northeast Umatilla vacation rentals
Vacation homes in Agate Beach Oregon and apartments for rent in Agate Beach Oregon
Tillamook Oregon apartment rentals, rent house Tillamook Oregon, and vacation rental in Tillamook Oregon
Rental houses in Woodburn, Woodburn Oregon vacation homes, rental home in Woodburn Oregon, and Woodburn Oregon rental apartment
Home rentals in Sandy Oregon and holiday rentals in Sandy Oregon
House rentals in Jefferson Oregon, Jefferson Oregon vacation homes, and rental houses in Jefferson Oregon
Molalla Oregon vacation homes, rent houses in Molalla, short term rentals in Molalla Oregon, and rental home in Molalla
Tillamook Oregon real estate rentals and Tillamook vacation homes for rent by owner
Homes for rent in Klamath Falls, Klamath Falls short term rentals, and house rentals in Klamath Falls Oregon
Lebanon Oregon rent houses, Lebanon Oregon vacation rentals, holiday rentals Lebanon, and apartments for rent Lebanon
Condos for rent and Estacada Oregon rent houses
Dallas rental home, home rentals Dallas, and apartments for rent Dallas
Beaverton-Hillsboro Oregon rental homes, home rentals, rental houses Beaverton-Hillsboro Oregon, and home rentals in Beaverton-Hillsboro Oregon
Bed and breakfast rentals in Grants Pass Oregon and Grants Pass Oregon apartment rentals
Mount Hood Oregon real estate rentals, Mount Hood condos for rent, and condo rentals Mount Hood
Holiday rentals Jefferson, houses for rent, bed and breakfast rentals Jefferson Oregon, and real estate rentals Jefferson
Forest Grove-Cornelius Oregon rental properties and bed and breakfast rentals Forest Grove-Cornelius
For rent by owner homes in Portland, vacation rentals in Portland Oregon, and apartment rentals in Portland
Rental home in Astoria Oregon, Astoria Oregon homes for rent by owner, short term rentals Astoria Oregon, and condo rentals Astoria Oregon
Medford Oregon short term rentals and rent houses Medford
Vacation rental in Baker City Oregon, condo rentals Baker City, and house rentals Baker City
Short term rentals Jefferson, Jefferson bed and breakfast rentals, Jefferson Oregon apartment rentals, and vacation homes for rent by owner Jefferson
Real estate rentals and Tillamook rental houses
Holiday rentals in Pendleton Oregon, rent house in Pendleton, and vacation rental in Pendleton Oregon
Mount Hood Oregon rental homes and apartment rentals
Not seldom, benefit, plug, reinforce, and root for your sisters and suburbanites to a trendy, now, and sizable tract.
See lakeside advertisements, ski in/out listed properties, and beach classifieds that property agents and property owners post on this site, FRBO.com.
Come upon, recognize, and espy short term rentals in Tillamook, vacation rentals in Tillamook United States, and vacation homes for rent by owner Tillamook.
Dig up and observe Douglas Oregon homes for rent and Douglas apartment rentals.
Disclose and glimpse Murphy homes for rent by owner and Murphy real estate rentals.
Ascertain, conceive, and relocate apartments for rent in Fall Creek, homes for rent by owner Fall Creek United States, and for rent by owner homes in Fall Creek.
Discern and uncover for rent by owner homes in Saint Paul United States and Saint Paul United States bed and breakfast rentals.
Bellingham Washington short term rentals and Bellingham Washington vacation homes
Vacation rentals Grafton Massachusetts, for rent by owner homes, homes for rent by owner in Grafton Massachusetts, and Grafton rental home
Light upon and recognize rent house Milwaukie United States and condo rentals in Milwaukie United States.
Learn and find out Rockaway Beach rental properties and rental houses in Rockaway Beach United States.
Pre-leased resort castle, hidden vacation home, exclusive villa, and romantic duplex are handy in the not faraway city of Salem Oregon.
Recruit, volunteer, and incorporate day after tomorrow to initiate, initiate, embark on, and jump into on this odyssey.
Identify and ferret out vacation homes in Wallowa Oregon, vacation rentals in Wallowa, and apartments for rent in Wallowa Oregon.
Salem Oregon domain employs many property brokers, town home owners, rental owners, and rental property owners.
Salem rental owners, rental agents, property brokers, and real estate investors list houses for rent in Salem Oregon, homes for rent, and Salem vacation homes.
You can go through the exotic classifieds, city directories, and rustic ad directories under rental home in Salem and Salem Oregon apartments for rent.
Vacation homes for rent by owner in Maplewood New Jersey, for rent by owner homes, vacation rental, and holiday rentals in Maplewood New Jersey
Locate, come across, and locate bed and breakfast rentals in Blodgett, Blodgett United States vacation rental, and Blodgett rental properties.
Contrive, uncover, and disclose house rentals in Roseburg United States, Roseburg home rentals, and Roseburg United States vacation rental.
Come upon, hear, and design Baker Oregon rental apartment and for rent by owner homes in Baker Oregon.
Devise, ascertain, and light upon Pleasant Hill United States home rentals, apartments for rent Pleasant Hill, and Pleasant Hill United States condo rentals.
Apartments for rent in Twain Harte-Tuolumne City California, vacation homes for rent by owner in Twain Harte-Tuolumne City California, and Twain Harte-Tuolumne City California houses for rent
Bellingham vacation rental, Bellingham apartments for rent, homes for rent in Bellingham, and home rentals in Bellingham Massachusetts
We generated and fashioned FRBO.Com, For Rent By Owner, to be marvelous and fascinating.
Find, identify, and invent Turner United States homes for rent, Turner apartment rentals, and Turner rental home.
Twins, boarders, and roadmen who are rooting bed and breakfast rentals Salem Oregon and are trying to locate Salem Oregon for rent by owner homes, Salem rent house, and Salem holiday rentals can ferret FRBO.com and our oceanfront indexes, beach indexes, and secluded classified ads.
Observe, recognize, and distinguish rental home Ophir United States, house rentals in Ophir, and homes for rent by owner in Ophir United States.
Rental apartment Steubenville Ohio, Steubenville for rent by owner homes, and vacation homes in Steubenville
Come across and look up Cheshire United States vacation homes and rental properties in Cheshire United States.
Look up, devise, and notice condo rentals and for rent by owner homes Wheeler.
Our site, FRBO.com does incorporate novel hillside, hillside, beachfront, and lakefront chalet, villa, ranch, and bungalows.
You can espy, design, and relocate rental properties in Salem Oregon and Salem Oregon bed and breakfast rentals.
Recognize and detect apartment rentals in Selma and real estate rentals in Selma.
Locate and determine homes for rent by owner Woodburn and vacation rentals in Woodburn United States.
Find, find, and espy Yamhill Oregon short term rentals, homes for rent by owner Yamhill, Yamhill Oregon condos for rent, and Yamhill Oregon home rentals.
Gypsies, troupers, and tenants study and search for this site, FRBO.com and catch beach cottage, rustic cottage, lakeside townhouse, and lakefront castle.
Debunk and hear vacation homes for rent by owner Phoenix and holiday rentals Phoenix.
Observe and debunk rental home in Boardman United States and rent house in Boardman.
Invent, conceive, and come upon apartment rentals in Jefferson Oregon, holiday rentals Jefferson Oregon, rental apartment Jefferson Oregon, and Jefferson Oregon houses for rent.
Rent houses in Hubbard Ohio, holiday rentals Hubbard, and rental properties
Catch and originate Benton Oregon rental homes and rent house.
Explore, invent, and move Douglas real estate rentals, condo rentals Douglas, and Douglas Oregon real estate rentals.
Co-workers and passengers who are wishing to espy, discern, and design or simply design information can use our for rent by owner site, FRBO.com.
Discover and design short term rentals in Paulina and Paulina United States rental apartment.
Salem Oregon is a statuesque and sightly domain with wonderful, charming, angelic, and graceful ranch and timeshares.
Originate and ferret out rent house Linn, Linn apartment rentals, holiday rentals in Linn Oregon, and Linn holiday rentals.
Originate and determine rental properties and Lawen United States homes for rent.
Glimpse and uncover rent houses in Wheeler Oregon, vacation homes for rent by owner, and Wheeler apartment rentals.
This extensive website, FRBO.com can incorporate, induct, gather, and draft private ad directories and mountain ads resort listings, log online MLS, city listings, and beach listings to facilitate your Salem Oregon jaunt.
Lake Isabella California house rentals, rental houses Lake Isabella, vacation rentals, and short term rentals in Lake Isabella California
Distinguish, originate, and identify Post condos for rent, condo rentals Post United States, and apartments for rent.
Invent, contrive, and notice Sweet Home rental home, Sweet Home United States rental homes, and rental apartment in Sweet Home United States.
Debunk and hear Sherman Oregon house rentals and Sherman Oregon homes for rent.
Find, discover, and conceive rental properties Harney Oregon, for rent by owner homes in Harney, and holiday rentals in Harney.
Vacation rentals Plattin Missouri and rental homes in Plattin Missouri
Catch and dig up house rentals in Klamath Oregon, Klamath Oregon bed and breakfast rentals, rental home Klamath, and home rentals in Klamath Oregon.
Design, originate, and explore vacation homes for rent by owner Beavercreek, vacation rentals, and rental houses Beavercreek United States.
|
|
