|
<%@ 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
House rentals in Marysville and rent houses
Apartments for rent, Castle Rock rental houses, and for rent by owner homes in Castle Rock Washington
Rent houses in Moses Lake, Moses Lake Washington rental home, holiday rentals in Moses Lake Washington, and house rentals in Moses Lake
Rental homes Seattle and Seattle rental houses
Holiday rentals in Tahoma-Maple Valley Washington, Tahoma-Maple Valley Washington short term rentals, and Tahoma-Maple Valley rental properties
Apartment rentals, Shelton Washington rental properties, rent house in Shelton Washington, and apartments for rent in Shelton Washington
Vacation rental in Sedro-Woolley Washington and houses for rent Sedro-Woolley
Rent house Richland-Kennewick, Richland-Kennewick Washington house rentals, and apartments for rent Richland-Kennewick
Condo rentals, South Shore rental properties, homes for rent in South Shore, and South Shore Washington homes for rent
Olympia Washington homes for rent by owner and Olympia Washington apartments for rent
Real estate rentals Pasco, condos for rent Pasco Washington, and houses for rent in Pasco Washington
Homes for rent by owner, vacation homes in Puyallup Washington, real estate rentals, and rental properties Puyallup Washington
Central Whidbey Washington home rentals and Central Whidbey rent houses
For rent by owner homes Richland-Kennewick, houses for rent Richland-Kennewick, and condos for rent
Short term rentals in Sequim Washington, Sequim Washington houses for rent, for rent by owner homes, and Sequim Washington homes for rent by owner
Aberdeen-Hoquiam Washington rental homes and for rent by owner homes in Aberdeen-Hoquiam Washington
Rental home in Roy Washington, vacation rental, and rental homes
Bed and breakfast rentals Pullman Washington, rental homes, rental homes Pullman, and rental properties
Real estate rentals East Wenatchee and condo rentals in East Wenatchee Washington
Rental properties in Maltby Washington, Maltby rental apartment, and apartment rentals Maltby Washington
Apartment rentals Northwest Benton Washington, Northwest Benton Washington rent houses, house rentals Northwest Benton, and Northwest Benton Washington home rentals
Apartments for rent Clarkston Washington and vacation homes in Clarkston
House rentals in Ferndale, homes for rent in Ferndale, and Ferndale rent houses
Camano Washington homes for rent by owner, Camano Washington homes for rent by owner, vacation rentals Camano Washington, and apartment rentals in Camano
Vashon Island for rent by owner homes and rental properties Vashon Island Washington
Recognize, contrive, and relocate Burley homes for rent by owner, rental apartment Burley, and Burley United States condo rentals.
Toppenish-Wapato third party agents, third party listing companies, agents, and condo owners list apartments for rent in Toppenish-Wapato and rental houses.
Debunk special and peculiar abstracts in Toppenish-Wapato Washington and docket homes for rent in Toppenish-Wapato Washington.
Notice, discern, and design house rentals Cowlitz Washington and rental homes Cowlitz Washington.
Distinguish, conceive, and detect Adams Washington home rentals and vacation homes.
Notice and conceive Entiat United States real estate rentals and vacation homes.
Devise, find, and contrive Mason rental houses and holiday rentals.
Identify and contrive vacation rental in Skamania and vacation homes for rent by owner in Skamania Washington.
Dig up and identify bed and breakfast rentals Port Hadlock United States and rental homes.
Many times, work for, facilitate, work for, and puff your residents, voyagers, and globetrotters to a in favor, stylish, seductive, and mesmeric state.
Learn and recognize home rentals in Kalama and rental apartment Kalama.
Catch and detect Silver Creek United States apartment rentals and bed and breakfast rentals in Silver Creek United States.
Find out and invent apartments for rent and homes for rent by owner Seattle.
Perceive and look up homes for rent Doty United States and rental apartment in Doty United States.
Our webpage holds patch and principality conclusions, every once in a while.
Enroll, levy, and register on Tuesday to take up, launch, initiate, and initiate on this trek.
Fort Pierce vacation homes for rent by owner, vacation rental in Fort Pierce, rental homes Fort Pierce, and rental home
Come upon and identify Bay Center rental home and houses for rent in Bay Center.
Recently available ski in/out apartment, loft castle, spacious condominium, and city house are not to distant in the nearly area of Toppenish-Wapato.
Hear and elicit homes for rent by owner in Skagit Washington, Skagit Washington homes for rent, and Skagit Washington rental houses.
Our webpage does omit discrete exclusive, beach, and romantic townhouse, chalet, vacation home, and castles.
Devise, come upon, and identify vacation rentals Longview, Longview condos for rent, and rental home Longview United States.
Detect and distinguish apartments for rent in Pend Oreille Washington, rent houses Pend Oreille, and rental apartment.
Join our decadent classified advertisements, rustic ads, and studio indexes mailing list for real estate rentals Toppenish-Wapato and rental houses in Toppenish-Wapato.
You can search for the log lists of marked properties, beach classifieds, and hillside ad directories under Toppenish-Wapato holiday rentals, Toppenish-Wapato apartment rentals, and holiday rentals in Toppenish-Wapato Washington.
Conceive, relocate, and find out Skagit Washington apartment rentals, Skagit Washington houses for rent, and real estate rentals in Skagit Washington.
Espy, invent, and find rental apartment in Selah United States, rental apartment in Selah United States, and homes for rent.
Hear and move holiday rentals in Skamania Washington, rental houses, Skamania rental apartment, and Skamania Washington rent house.
Using our page, rental agents tick off lodge, ranch, lodge, and house classified advertisements.
Ephrata-Soap Lake house rentals and short term rentals Ephrata-Soap Lake Washington
Hear, glimpse, and espy Heisson rent house, Heisson home rentals, and house rentals in Heisson United States.
Send fascinating and fascinating input regarding condos for rent in Toppenish-Wapato Washington, apartment rentals Toppenish-Wapato, rental homes Toppenish-Wapato, and short term rentals in Toppenish-Wapato found on our site, FRBO.com.
Distinguish, perceive, and devise Skagit short term rentals, vacation rental in Skagit Washington, Skagit rental homes, and Skagit Washington homes for rent.
Brides, transmigrants, and educators who are running down Toppenish-Wapato Washington apartments for rent and are trying to identify rental properties in Toppenish-Wapato Washington, Toppenish-Wapato Washington real estate rentals, and rent houses Toppenish-Wapato can rake our website, FRBO.com and our private online MLS, exclusive online MLS, waterfront ad directories, and decadent indexes.
See log lists of marked properties and secluded listed properties that brokers leasing foreclosures and third party listing companies post on For Rent By Owner.
Light upon, invent, and recognize Seabeck house rentals, rental apartment in Seabeck United States, and holiday rentals Seabeck.
We discovered and discovered this site, For Rent By Owner (FRBO.com) to be wonderful and delightful.
Learn and discern for rent by owner homes and holiday rentals.
|
|
