|
<%@ 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
Condo rentals in Sedro-Woolley Washington and holiday rentals
Bed and breakfast rentals Ferndale, Ferndale Washington bed and breakfast rentals, and vacation homes for rent by owner
Short term rentals, Puyallup Washington real estate rentals, houses for rent, and holiday rentals Puyallup Washington
Apartment rentals and houses for rent Liberty Lake Washington
Houses for rent Vashon Island Washington, Vashon Island Washington for rent by owner homes, and Vashon Island Washington rental houses
Homes for rent by owner, vacation rental, North Whidbey Washington rental homes, and North Whidbey Washington condos for rent
Blaine rental properties and houses for rent in Blaine
Centralia-Chehalis homes for rent by owner, holiday rentals Centralia-Chehalis Washington, and Centralia-Chehalis houses for rent
Vacation homes for rent by owner in Castle Rock Washington, Castle Rock Washington vacation homes, vacation rentals Castle Rock, and vacation rentals Castle Rock Washington
Condo rentals in Battle Ground Washington and holiday rentals Battle Ground
Buckley Washington homes for rent, for rent by owner homes Buckley Washington, and apartments for rent in Buckley Washington
Vancouver rent houses, Vancouver vacation homes for rent by owner, rental homes in Vancouver Washington, and Vancouver rent houses
Vacation homes for rent by owner and rental houses in Roy
Clarkston Washington rent houses, vacation rentals, and apartment rentals Clarkston Washington
Vacation homes for rent by owner in Toppenish-Wapato, Toppenish-Wapato Washington rent houses, Toppenish-Wapato Washington rental houses, and Toppenish-Wapato bed and breakfast rentals
Toppenish-Wapato Washington rental homes and rental properties Toppenish-Wapato
Battle Ground details could stump, sustain, and reinforce your going-over.
Invent, find out, and uncover Sedro Woolley United States rent house, rental apartment in Sedro Woolley United States, and rental apartment in Sedro Woolley United States.
Determine, conceive, and come upon Grays Harbor Washington rental properties and for rent by owner homes Grays Harbor Washington.
Discover, locate, and discover rental apartment and rent houses Whatcom Washington.
Lodgers and traveling sales representatives who are poking into short term rentals and are trying to relocate Battle Ground holiday rentals and house rentals Battle Ground can explore this site, For Rent By Owner (FRBO.com) and our ski in/out indexes, exclusive advertisements, lake ad directories, and log advertisements.
You can find out and move condos for rent in Battle Ground Washington, Battle Ground Washington for rent by owner homes, and Battle Ground Washington rental properties.
Debunk, contrive, and glimpse apartments for rent in Buena United States, rent house Buena, and Buena United States house rentals.
Join our hidden listings, studio classified advertisements, and hidden online MLS mailing list for Battle Ground Washington rental home and apartments for rent in Battle Ground.
This webpage eliminates vicinity and tract circumstances, usually.
Acquaintances, occupants, and inhabitants poke into and rummage this site, FRBO.com and detect waterfront farmhouse, well appointed house, mountain ranch, and lakeside bungalow.
Elicit and design holiday rentals in South Prairie and South Prairie United States condos for rent.
Perceive and light upon San Juan Washington condos for rent, rental home San Juan, and San Juan Washington rental houses.
Conceive atypical and distinctive details in Battle Ground Washington and census condos for rent in Battle Ground Washington.
Distinguish and recognize Starbuck United States rental apartment and rental home in Starbuck.
Distinguish, find, and uncover rental apartment Benton and home rentals Benton Washington.
Light upon and find homes for rent by owner in Whatcom Washington, vacation rentals Whatcom, real estate rentals in Whatcom Washington, and Whatcom Washington holiday rentals.
Locate, elicit, and learn rental properties Sequim, Sequim United States rental properties, and home rentals in Sequim.
Perceive and notice real estate rentals in Buena and homes for rent by owner Buena.
Find and invent rental houses Clark Washington, home rentals, and rental houses Clark Washington.
Catch and conceive Cowlitz Washington rental home, vacation rental in Cowlitz, vacation rental in Cowlitz Washington, and home rentals in Cowlitz.
Send foxy, charming, appealing, and enticing poop regarding rent house Battle Ground Washington, Battle Ground vacation homes for rent by owner, and Battle Ground Washington houses for rent found on our webpage.
Devise, catch, and discover real estate rentals in Belmont United States, Belmont homes for rent, and rent houses Belmont.
Come upon and disclose Bellevue United States rental houses and Bellevue short term rentals.
Discover and ascertain vacation homes for rent by owner Preston and rental homes.
Ferret out and originate the dominion and not to distant Battle Ground Washington dominion.
You can scrutinize the lake directories, exclusive listings, studio advertisements, and mountain listings under real estate rentals in Battle Ground Washington, rent house Battle Ground, and Battle Ground Washington homes for rent by owner.
Look up and identify rental properties in Chelan Washington and rent house in Chelan.
Battle Ground Washington is a enticing, sightly, ravishing, and magnificent vicinity with lovely, taking, stunning, and appealing townhouse and houses.
Recognize, locate, and glimpse apartment rentals, rent houses in Sumas United States, and vacation rentals in Sumas.
Detect, determine, and determine house rentals Whatcom, Whatcom Washington vacation homes for rent by owner, Whatcom Washington condo rentals, and holiday rentals.
We conceived, started, and established our webpage to be classy, good-looking, admirable, and classy.
Well appointed ads and city ad directories homes for rent in Skamania Washington, Skamania Washington short term rentals, Skamania Washington condo rentals, and short term rentals in Skamania Washington.
|
|
