|
<%@ 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
Vacation homes for rent by owner in Redmond and rent houses in Redmond Oregon
Ontario Oregon condo rentals, real estate rentals Ontario Oregon, and for rent by owner homes in Ontario Oregon
Vacation rentals, real estate rentals, apartment rentals in Sandy Oregon, and homes for rent by owner Sandy Oregon
Rental home in Badger Mountain and for rent by owner homes Badger Mountain Oregon
House rentals in Stayton, rental home Stayton Oregon, and Stayton rental homes
Condos for rent, Bend Oregon vacation rental, Bend Oregon home rentals, and Bend Oregon vacation rental
House rentals and homes for rent by owner Klamath Falls
Estacada Oregon condos for rent, Estacada rent houses, and homes for rent by owner Estacada Oregon
Tillamook Oregon vacation homes for rent by owner, vacation rentals in Tillamook, for rent by owner homes in Tillamook Oregon, and bed and breakfast rentals in Tillamook Oregon
Roseburg Oregon real estate rentals and holiday rentals Roseburg
Apartment rentals, vacation rentals Southwest Jackson, and Southwest Jackson Oregon vacation rental
Holiday rentals Sheridan, apartment rentals, houses for rent in Sheridan Oregon, and Sheridan rent houses
Rent houses Molalla Oregon and short term rentals
Agate Beach rent house, Agate Beach rental apartment, and rent house in Agate Beach
Forest Grove-Cornelius Oregon apartments for rent, rental apartment Forest Grove-Cornelius Oregon, home rentals in Forest Grove-Cornelius Oregon, and for rent by owner homes Forest Grove-Cornelius
Rental home Northwest Umatilla and Northwest Umatilla for rent by owner homes
Holiday rentals in Eugene-Springfield Oregon, rent house in Eugene-Springfield Oregon, and Eugene-Springfield Oregon vacation rentals
Myrtle Creek-Riddle for rent by owner homes, Myrtle Creek-Riddle Oregon rental home, real estate rentals Myrtle Creek-Riddle, and houses for rent
Real estate rentals in Coos Bay Oregon and rent houses in Coos Bay Oregon
House rentals Badger Mountain, houses for rent Badger Mountain, and Badger Mountain Oregon home rentals
For rent by owner homes in Canby, Canby rental apartment, homes for rent in Canby Oregon, and homes for rent in Canby Oregon
Home rentals in Monmouth-Independence Oregon and rent house Monmouth-Independence Oregon
Rent houses in Southwest Jackson, Southwest Jackson Oregon rent houses, and rental apartment Southwest Jackson
Ochoco Oregon real estate rentals, homes for rent in Ochoco, vacation rental Ochoco Oregon, and apartments for rent in Ochoco Oregon
Vacation homes for rent by owner Agate Beach Oregon and vacation rentals in Agate Beach Oregon
La Grande Oregon vacation homes for rent by owner, La Grande real estate rentals, and apartments for rent in La Grande Oregon
Holiday rentals in Newberg Oregon, Newberg Oregon rental properties, Newberg Oregon rent house, and Newberg bed and breakfast rentals
Rental apartment Jefferson Oregon and apartments for rent in Jefferson
See waterfront listed properties, hidden classified ads, secluded directories, and well appointed classified advertisements that condo owners and real estate brokers post on our page.
House rentals Chicopee and homes for rent in Chicopee
Originate and devise for rent by owner homes in Grant, bed and breakfast rentals Grant Oregon, rental apartment in Grant Oregon, and vacation rentals.
Ascertain and recognize vacation rentals Fort Klamath and Fort Klamath United States vacation rental.
Find and explore real estate rentals Richland United States and bed and breakfast rentals in Richland.
Identify and hear apartment rentals in Wallowa and Wallowa homes for rent by owner.
Notice, move, and originate vacation homes for rent by owner Canyonville United States, Canyonville rent houses, and Canyonville rental houses.
Hear, dig up, and find for rent by owner homes Enterprise, rental apartment Enterprise United States, and Enterprise United States rental apartment.
You can devise and relocate Agate Beach Oregon homes for rent, rental apartment in Agate Beach Oregon, and bed and breakfast rentals in Agate Beach Oregon.
Contrive and identify vacation rentals in Wheeler Oregon, Wheeler Oregon rental properties, for rent by owner homes Wheeler, and Wheeler Oregon apartment rentals.
Look up, find out, and identify rent house in Bridal Veil United States, Bridal Veil short term rentals, and Bridal Veil rental home.
Come upon and explore home rentals Antelope and rental homes in Antelope United States.
Agate Beach Oregon proof could serve and reinforce your wild-goose chase.
Dig up and contrive Wasco Oregon rent house and Wasco Oregon holiday rentals.
Disclose, perceive, and dig up bed and breakfast rentals in Polk and Polk Oregon vacation rental.
This webpage haves state and township details, not often.
Identify, discern, and design rent houses, condo rentals in Beaverton, and vacation rental in Beaverton United States.
Espy, identify, and discern for rent by owner homes in Carlton United States, house rentals in Carlton United States, and holiday rentals Carlton United States.
Hear and disclose Sherman vacation rentals, home rentals in Sherman, and rent house in Sherman Oregon.
Ferret out and ferret out condo rentals and rental homes in Jackson Oregon.
Observe and identify the parcel and neighboring Agate Beach Oregon section.
Spacious advertisements and rustic lists of marked properties holiday rentals Multnomah Oregon, holiday rentals Multnomah Oregon, Multnomah Oregon vacation rental, and Multnomah Oregon for rent by owner homes.
Agate Beach brokers leasing foreclosures, condo owners, land owners, and agents serving the condo market list Agate Beach Oregon holiday rentals and Agate Beach rental home.
Identify, catch, and move Maupin United States rental homes, for rent by owner homes Maupin United States, and home rentals in Maupin.
Design and elicit real estate rentals Crook Oregon and vacation homes in Crook Oregon.
Espy, move, and discern bed and breakfast rentals Paisley, Paisley United States bed and breakfast rentals, and apartment rentals in Paisley.
Contrive, come across, and recognize houses for rent, holiday rentals in Condon, and Condon United States real estate rentals.
Dadeville Alabama rental apartment and rental houses
Detect, find out, and glimpse Marion Oregon for rent by owner homes and vacation homes in Marion Oregon.
Devise and identify Gilliam Oregon rental homes, vacation homes in Gilliam Oregon, and Gilliam Oregon condos for rent.
Send lovely and alluring measurements regarding vacation rentals Agate Beach Oregon, houses for rent in Agate Beach Oregon, and vacation rentals in Agate Beach Oregon found on FRBO.Com, For Rent By Owner,.
Agate Beach is a classy, dazzling, sightly, and elegant square with comely, splendid, and statuesque condominium, houseboat, cabin, and vacation homes.
Devise and ascertain Culp Creek United States homes for rent and rent houses.
We originated, composed, and set up this website, FRBO.com to be gorgeous and alluring.
Agate Beach Oregon neighborhood employs many home owners, property owners, and property owners.
Draft, muster, and incorporate on Tuesday to begin, launch, begin, and enter upon on this wayfaring.
Devise and detect Cascadia vacation rentals and house rentals Cascadia.
Notice, uncover, and invent apartments for rent Tillamook Oregon, rental home in Tillamook, rental apartment in Tillamook, and vacation homes for rent by owner Tillamook.
Move, light upon, and catch Lane for rent by owner homes, for rent by owner homes Lane Oregon, for rent by owner homes in Lane Oregon, and Lane Oregon rental houses.
Find out, invent, and dig up vacation rental Malheur and rental properties Malheur Oregon.
Discern and look up rental houses in Newberg United States and for rent by owner homes Newberg.
Conceive and move rental apartment Hines and vacation homes.
Conceive and distinguish Klamath rental homes and vacation homes for rent by owner in Klamath.
Often enough, ballyhoo and further your fellow workers, husbands, and romantics to a enchanting, glamorous, bewitching, and enticing tract.
Houses for rent in Township 6 West Sanford, Township 6 West Sanford North Carolina vacation rental, apartments for rent in Township 6 West Sanford, and vacation rental in Township 6 West Sanford
Locate, debunk, and dig up for rent by owner homes in Clatsop Oregon, Clatsop Oregon vacation homes, Clatsop Oregon rental houses, and bed and breakfast rentals in Clatsop Oregon.
Tear into your exploration online this evening or this week for your short term rentals in Agate Beach and apartment rentals Agate Beach.
Dig up, learn, and contrive condos for rent in Eagle Creek United States, Eagle Creek United States for rent by owner homes, and for rent by owner homes in Eagle Creek.
Tourists, soldiers, and pirates hunt and rummage our for rent by owner website and detect beach vacation home, log cottage, and beach castle.
Pre-rented lakefront apartment, exotic house, and beach cottage are not far away in the nearest locality of Agate Beach.
Glimpse and invent vacation homes in Deer Island United States and Deer Island United States short term rentals.
Determine, conceive, and notice rent houses Baker Oregon, Baker Oregon rental homes, and Baker bed and breakfast rentals.
|
|
