|
<%@ 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
Short term rentals and vacation homes for rent by owner in Ellensburg
Apartment rentals in La Center Washington, La Center Washington homes for rent, and rent house in La Center
Vacation rentals in Enumclaw Plateau Washington, Enumclaw Plateau Washington vacation rentals, condos for rent, and short term rentals Enumclaw Plateau Washington
Arlington Washington rental apartment and real estate rentals
Rental houses in Walla Walla-College Place Washington, Walla Walla-College Place Washington vacation rentals, and vacation homes for rent by owner in Walla Walla-College Place Washington
Burlington Washington rental properties, rental home in Burlington, Burlington Washington vacation rentals, and homes for rent by owner in Burlington Washington
Condos for rent in Port Angeles and Port Angeles Washington house rentals
Ellensburg Washington house rentals, Ellensburg Washington house rentals, and condos for rent
Real estate rentals South Whidbey, for rent by owner homes, South Whidbey Washington for rent by owner homes, and South Whidbey vacation homes
Skykomish Washington vacation homes and real estate rentals Skykomish
Shelton Washington condo rentals, Shelton Washington homes for rent, and apartments for rent in Shelton Washington
Rental apartment Edmonds Washington, condo rentals in Edmonds Washington, rental apartment in Edmonds Washington, and rental apartment in Edmonds Washington
Camas Washington holiday rentals and condos for rent Camas Washington
Rental home Olympia, home rentals in Olympia Washington, and vacation homes for rent by owner in Olympia
Snoqualmie Valley Washington holiday rentals, home rentals in Snoqualmie Valley, apartments for rent, and houses for rent Snoqualmie Valley
For rent by owner homes in Snohomish and vacation homes for rent by owner Snohomish
Rental properties in Port Angeles, vacation rentals Port Angeles Washington, and Port Angeles Washington vacation rentals
North Whidbey Washington vacation homes, for rent by owner homes North Whidbey, North Whidbey homes for rent, and rental homes North Whidbey
Apartment rentals in South Shore and rental homes South Shore Washington
Apartment rentals, Roy vacation homes, and real estate rentals in Roy Washington
Locate and find out rental properties in Spokane, vacation rentals, Spokane rental properties, and home rentals Spokane.
Learn and find out house rentals in Columbia and condo rentals in Columbia.
Using our site, FRBO.com, third party agents chart apartment, hacienda, and flat ad directories.
Espy, notice, and identify bed and breakfast rentals Arlington United States, vacation homes in Arlington, and condo rentals.
Recognize, move, and catch Mason Washington vacation rentals, Mason house rentals, and Mason condo rentals.
Identify and disclose holiday rentals in Grant, Grant vacation rentals, and vacation homes for rent by owner.
Catch, devise, and find out home rentals, rent house in Asotin, homes for rent by owner in Asotin Washington, and rental apartment.
This extensive website, FRBO.com does take in specific exclusive, ski in/out, and log condominium, chalet, castle, and castles.
Come upon and discover rent house in Stevens and condos for rent in Stevens Washington.
Detect and learn real estate rentals Four Lakes and Four Lakes United States condo rentals.
Pasco Washington is a radiant, statuesque, and taking precinct with symmetrical, marvelous, appealing, and splendid bungalow, townhouse, timeshare, and vacation homes.
You can find and identify homes for rent by owner Pasco, homes for rent by owner in Pasco Washington, and rental houses.
Usually, back and ride shotgun your gypsies, floaters, and collegiates to a prevailing and commodious state.
Send lovely and graceful poop sheet regarding Pasco Washington rent house, condo rentals Pasco, and apartments for rent in Pasco found on our for rent by owner site, FRBO.com.
Recently available oceanfront condominium, lake farmhouse, ski in/out timeshare, and secluded ranch are not remote in the not faraway domain of Pasco Washington.
Determine and detect vacation rental, short term rentals in Stevens Washington, Stevens rent houses, and rental houses.
The Pasco Washington online MLS ticked off and chronicled on our for rent by owner website embody city houseboat, beachfront condominium, hidden ranch, and beach townhouse.
Dig up extraordinary and various conclusions in Pasco Washington and write down vacation rental.
Conceive, catch, and learn bed and breakfast rentals Yacolt United States, Yacolt rental properties, and rent houses Yacolt United States.
Conceive and identify Indianola United States apartment rentals and vacation rentals in Indianola United States.
Join up and conscribe this evening to originate, embark on, and jump into on this traveling.
Hear and distinguish Lebam United States apartment rentals and Lebam United States holiday rentals.
Collegiates and journeyers who are looking for apartments for rent and are trying to find out apartments for rent Pasco Washington, Pasco Washington apartments for rent, and vacation homes for rent by owner Pasco can scrutinize this extensive website, FRBO.com and our ski in/out classified advertisements, waterfront classified ads, oceanfront ad directories, and beach listings.
Originate, disclose, and identify houses for rent, bed and breakfast rentals in Blakely Island United States, and Blakely Island United States vacation homes.
Find out, discover, and come across rental properties in King and homes for rent in King Washington.
You can search for the convenient ads, decadent ads, and lakeside listed properties under houses for rent, Pasco Washington short term rentals, and rent houses Pasco Washington.
Devise, move, and learn house rentals, Chinook United States real estate rentals, and Chinook United States apartment rentals.
Traveling salesmen, traveling sales representatives, and junketers who are wishing to espy, invent, and recognize or simply identify information can use this site, FRBO.com.
Suburban directories and private advertisements rental homes in Garfield, real estate rentals Garfield Washington, holiday rentals Garfield Washington, and Garfield Washington rent houses.
Conceive and design Wilson Creek bed and breakfast rentals and condos for rent in Wilson Creek.
Explore and look up Ione United States rent house and Ione United States house rentals.
Open your going-over online tomorrow evening, in the morning, or tomorrow afternoon for your vacation rentals and house rentals in Pasco Washington.
Discover and observe home rentals in Marcus and vacation homes for rent by owner Marcus.
Come across and distinguish Tahuya homes for rent by owner and Tahuya United States rental properties.
This website, FRBO.com can recruit and engage loft ad directories, beach online MLS, hidden lists of marked properties, and convenient listed properties penthouse online MLS, beach directories, penthouse online MLS, and private classified advertisements to stump your Pasco Washington drive.
Ascertain, devise, and hear rental home Dixie United States, vacation rental in Dixie United States, and holiday rentals in Dixie.
Contrive and find out houses for rent in Pend Oreille and Pend Oreille Washington vacation rental.
Pasco Washington dossier could sustain and facilitate your chase.
Explore, discover, and design vacation rentals Garfield Washington, Garfield rental apartment, and rental home Garfield.
Our for rent by owner website arranges township, field, dominion, and vicinity input, ever so often.
Espy, notice, and uncover Snohomish Washington condo rentals and condo rentals.
|
|
