|
<%@ 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 and house rentals Monroe
For rent by owner homes in Camano Washington, Camano Washington rental apartment, and homes for rent in Camano
Rental apartment in Enumclaw Plateau Washington, bed and breakfast rentals in Enumclaw Plateau, rental houses in Enumclaw Plateau Washington, and Enumclaw Plateau Washington homes for rent
Homes for rent by owner Tahoma-Maple Valley Washington and rent houses Tahoma-Maple Valley Washington
Clarkston homes for rent, Clarkston Washington homes for rent by owner, and Clarkston Washington rent houses
Rent houses Blaine Washington, homes for rent by owner Blaine, for rent by owner homes, and apartments for rent Blaine Washington
East Wenatchee Washington rental home and homes for rent in East Wenatchee Washington
Rental apartment Everett, rental homes Everett Washington, and vacation rentals Everett Washington
For rent by owner homes in Olympia East, bed and breakfast rentals, Olympia East Washington homes for rent by owner, and Olympia East Washington rent houses
Holiday rentals Central Whidbey and rental home
Apartments for rent, Deer Park rental home, and Deer Park houses for rent
House rentals Southern Slopes, condos for rent in Southern Slopes Washington, vacation homes for rent by owner Southern Slopes Washington, and Southern Slopes Washington condos for rent
Short term rentals in Aberdeen-Hoquiam Washington and Aberdeen-Hoquiam Washington vacation homes
Real estate rentals Walla Walla-College Place, Walla Walla-College Place Washington bed and breakfast rentals, and Walla Walla-College Place vacation homes for rent by owner
Ferndale rent house, condos for rent Ferndale Washington, homes for rent by owner Ferndale Washington, and houses for rent Ferndale Washington
Houses for rent Castle Rock and Castle Rock Washington house rentals
Home rentals in Olympia West Washington, Olympia West Washington homes for rent by owner, and rent house in Olympia West Washington
Rental home in South Whidbey Washington, South Whidbey Washington apartment rentals, South Whidbey Washington rent houses, and South Whidbey home rentals
Northwest Benton vacation homes for rent by owner and Northwest Benton Washington rent house
Bed and breakfast rentals, homes for rent in Poulsbo Washington, and Poulsbo Washington condos for rent
Distinguish and devise real estate rentals Inchelium United States and apartments for rent in Inchelium United States.
Ferret out, move, and light upon Walla Walla houses for rent, apartment rentals in Walla Walla, Walla Walla vacation homes, and holiday rentals in Walla Walla Washington.
Move and debunk Adams Washington vacation rentals and rent house in Adams.
Perceive, distinguish, and debunk Cowlitz Washington vacation rental and rental properties in Cowlitz Washington.
The Castle Rock Washington lists of marked properties census and inserted on FRBO.com take in beach castle, oceanfront timeshare, mountain bungalow, and resort cabin.
Light upon, distinguish, and locate Wilson Creek United States for rent by owner homes, bed and breakfast rentals in Wilson Creek, and rent house.
Find, catch, and detect rent houses, home rentals in Chelan Washington, and rental apartment in Chelan Washington.
Distinguish and recognize homes for rent by owner Grandview United States and homes for rent by owner in Grandview.
Learn and light upon house rentals and Auburn homes for rent.
Locate and observe vacation homes Pacific, rent houses, and Pacific Washington short term rentals.
Light upon and move vacation homes in Mason Washington and Mason Washington condo rentals.
Join our lakefront directories, rustic listed properties, and beachfront classified advertisements mailing list for vacation rentals Castle Rock, for rent by owner homes Castle Rock Washington, and bed and breakfast rentals in Castle Rock.
Our website, FRBO.com does encompass another lakeside and exclusive home, apartment, and villas.
Look up and contrive Grant Washington homes for rent, Grant rental properties, and vacation rentals.
Light upon, debunk, and invent Lincoln United States condo rentals, homes for rent Lincoln, and Lincoln United States homes for rent by owner.
Originate and devise rent house Okanogan, Okanogan Washington rental houses, rental apartment Okanogan Washington, and apartment rentals Okanogan.
Hear, learn, and learn rental homes in Twisp United States, Twisp for rent by owner homes, and condos for rent Twisp United States.
Elicit and relocate vacation homes for rent by owner in Cougar United States and apartment rentals Cougar.
Observe and come across homes for rent by owner in Spokane and Spokane United States holiday rentals.
Explore another, specific, and diverse input in Castle Rock Washington and enumerate homes for rent by owner.
Send radiant, divine, and ravishing picture regarding rental homes in Castle Rock Washington, short term rentals in Castle Rock, and Castle Rock Washington apartments for rent found on our for rent by owner site, FRBO.com.
Uncover, look up, and relocate apartment rentals, homes for rent by owner in Rock Island United States, and Rock Island United States apartments for rent.
Castle Rock Washington stretch employs many third party listing companies and rental property owners.
Subordinates and tenants who are wishing to come upon and come across or simply elicit information can use our page.
Distinguish, design, and espy Grays Harbor Washington holiday rentals, rent houses in Grays Harbor Washington, and Grays Harbor Washington homes for rent by owner.
Our online website, FRBO.com can enter and register exclusive ad directories, secluded classifieds, secluded classifieds, and lakeside classified ads log advertisements, secluded listings, and decadent classified ads to ballyhoo your Castle Rock Washington junket.
|
|
