|
<%@ 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" %>
|
Washington Rental Links
Rent houses in Richland-Kennewick Washington and vacation rentals Richland-Kennewick
House rentals in Deer Park Washington, house rentals in Deer Park, and condo rentals in Deer Park Washington
Vashon Island condo rentals, Vashon Island condos for rent, Vashon Island Washington for rent by owner homes, and Vashon Island Washington condo rentals
Rental homes in Clarkston Washington and rental houses in Clarkston Washington
Seattle real estate rentals, condo rentals in Seattle Washington, and rental home Seattle Washington
Issaquah Plateau vacation homes, Issaquah Plateau Washington homes for rent by owner, homes for rent in Issaquah Plateau Washington, and real estate rentals in Issaquah Plateau Washington
House rentals and house rentals Lynden
Bed and breakfast rentals, Vashon Island Washington vacation rentals, and rental home in Vashon Island Washington
Vacation homes for rent by owner, home rentals in Lynden Washington, apartment rentals Lynden, and apartment rentals in Lynden Washington
Rental homes in Castle Rock Washington and Castle Rock vacation homes for rent by owner
Richland-Kennewick houses for rent, apartments for rent in Richland-Kennewick Washington, and real estate rentals in Richland-Kennewick
Houses for rent in Port Angeles, Port Angeles Washington homes for rent, for rent by owner homes, and bed and breakfast rentals Port Angeles Washington
Rent houses in Battle Ground Washington and vacation homes for rent by owner Battle Ground
Vacation rental, Orchards Washington rental apartment, and house rentals in Orchards Washington
Discern and uncover real estate rentals Skagit, Skagit Washington bed and breakfast rentals, and bed and breakfast rentals in Skagit Washington.
Debunk, explore, and glimpse houses for rent Yakima, Yakima United States vacation rentals, and condo rentals.
Invent and recognize vacation homes for rent by owner in Benton Washington and Benton Washington homes for rent by owner.
Occasionally, ballyhoo and work for your townies, sailors, and deadheads to a run after, in favor, fetching, and huge square.
Using our for rent by owner website, property agents inscribe houseboat, duplex, lodge, and duplex listed properties.
Join our beach listed properties, loft lists of marked properties, and studio lists of marked properties mailing list for vacation rentals in Lower Peninsula Washington, rental homes in Lower Peninsula Washington, and for rent by owner homes Lower Peninsula.
Lower Peninsula real estate investors, home owners, and property managers list vacation homes for rent by owner Lower Peninsula Washington, rental properties in Lower Peninsula, Lower Peninsula Washington vacation rental, and vacation rentals in Lower Peninsula.
Lower Peninsula goods could root for and do for your expedition.
Come across, disclose, and come upon Lyman United States bed and breakfast rentals, home rentals in Lyman, and Lyman United States rental apartment.
Find, perceive, and contrive Pend Oreille Washington rent house, Pend Oreille bed and breakfast rentals, Pend Oreille Washington houses for rent, and vacation homes for rent by owner in Pend Oreille Washington.
Detect and ascertain houses for rent in Whitman Washington, condo rentals Whitman, and house rentals Whitman.
The Lower Peninsula Washington indexes invoiced and inserted on our online website, FRBO.com have convenient lodge, rustic house, studio timeshare, and lakeside chalet.
Find and identify the area and proximate Lower Peninsula Washington patch.
You can explore the studio advertisements, spacious directories, and convenient classifieds under vacation rental and rental houses in Lower Peninsula.
Lower Peninsula Washington is a fine and marvelous field with charming, gorgeous, and fair apartment, castle, and duplexs.
Light upon and identify homes for rent by owner in Fairfield United States and homes for rent Fairfield.
Hear, come across, and come across Cowlitz rental houses and Cowlitz Washington house rentals.
See city advertisements, beach indexes, hillside classifieds, and private listed properties that agents serving the condo market and property managers post on our online website, FRBO.com.
Determine and conceive for rent by owner homes in East Pasco United States and vacation homes for rent by owner in East Pasco United States.
Our for rent by owner site, FRBO.com can sign on, hitch, join, and hire penthouse lists of marked properties, beach directories, ski in/out listed properties, and hillside classified ads log online MLS, oceanfront ad directories, oceanfront ads, and lakefront advertisements to expedite your Lower Peninsula Washington sally.
Come upon, recognize, and light upon houses for rent, Matlock United States vacation homes for rent by owner, and Matlock United States rental apartment.
Uncover and contrive East Pasco United States home rentals and vacation rental in East Pasco United States.
Send fascinating, ravishing, magnificent, and good-looking materials regarding Lower Peninsula Washington houses for rent and Lower Peninsula Washington home rentals found on FRBO.Com, For Rent By Owner,.
Elicit and ferret out apartment rentals Kittitas, condos for rent in Kittitas, apartments for rent, and Kittitas Washington bed and breakfast rentals.
Tenants, soldiers, and opportunists who are seeking houses for rent Lower Peninsula and are trying to catch Lower Peninsula rental homes and short term rentals in Lower Peninsula Washington can look our for rent by owner website and our rustic classified advertisements and romantic online MLS.
Identify and explore apartment rentals Bellevue and vacation homes in Bellevue United States.
Natives and indwellers who are wishing to disclose, recognize, and ascertain or simply look up information can use FRBO.com.
|
|
