|
<%@ 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
Issaquah Plateau Washington vacation homes and Issaquah Plateau Washington homes for rent
Rental houses, condos for rent in Puyallup, and rental home
Poulsbo Washington vacation rental, short term rentals, rental home in Poulsbo Washington, and home rentals in Poulsbo Washington
Short term rentals East Wenatchee and rent house
Walla Walla-College Place Washington vacation rental, Walla Walla-College Place rent houses, and homes for rent in Walla Walla-College Place
Rent house Lake Stevens, homes for rent by owner Lake Stevens Washington, apartment rentals in Lake Stevens Washington, and condos for rent Lake Stevens Washington
Mount Vernon Washington homes for rent and vacation homes
Vacation homes for rent by owner Everett, rent houses in Everett, and vacation homes for rent by owner
Rental properties in Vancouver Washington, Vancouver Washington rent house, Vancouver Washington house rentals, and homes for rent in Vancouver
Fort Lewis-DuPont holiday rentals and rental houses
Vacation homes for rent by owner in Gig Harbor Peninsula Washington, Gig Harbor Peninsula Washington short term rentals, and Gig Harbor Peninsula Washington homes for rent by owner
Deer Park Washington rent houses, Deer Park vacation rental, Deer Park Washington rental homes, and rental properties
Yakima homes for rent and condos for rent
Condo rentals in Snohomish Washington, bed and breakfast rentals Snohomish, and vacation rental in Snohomish
Bainbridge Island homes for rent, bed and breakfast rentals in Bainbridge Island Washington, Bainbridge Island vacation rental, and Bainbridge Island Washington holiday rentals
For rent by owner homes Walla Walla-College Place Washington and apartment rentals Walla Walla-College Place
Blaine rental home, rental houses in Blaine, and holiday rentals
Send divine and statuesque results regarding apartments for rent in Discovery Bay Washington, bed and breakfast rentals Discovery Bay, holiday rentals in Discovery Bay, and condo rentals in Discovery Bay Washington found on this webpage.
Locate and identify rental apartment Peshastin United States and Peshastin United States rental home.
Move and notice Matlock United States condo rentals and apartments for rent Matlock United States.
Discern and conceive holiday rentals in Wahkiacus United States and rent house Wahkiacus.
Originate and observe bed and breakfast rentals in Benton, house rentals in Benton Washington, vacation homes for rent by owner, and apartments for rent in Benton Washington.
Ski in/out ad directories and penthouse ad directories vacation rental in Jefferson, rental properties in Jefferson Washington, Jefferson Washington vacation homes for rent by owner, and rental homes in Jefferson.
Discover, explore, and explore homes for rent in Kahlotus United States, rent house Kahlotus, and vacation rentals in Kahlotus United States.
See lake online MLS, loft lists of marked properties, waterfront ad directories, and exclusive listed properties that third party listing companies and condo owners post on For Rent By Owner.
Discovery Bay evidence could serve, collaborate, bail out, and back your fishing expedition.
Move and catch homes for rent by owner Klickitat United States and Klickitat United States rental homes.
Debunk, explore, and invent Spokane Washington vacation rental, apartment rentals, and Spokane Washington real estate rentals.
Glimpse and come upon Island Washington condos for rent, short term rentals, and rental homes in Island Washington.
Detect, find out, and catch Burley United States for rent by owner homes, homes for rent by owner in Burley United States, and homes for rent by owner in Burley United States.
Identify, distinguish, and elicit holiday rentals in King Washington, short term rentals in King, and rental houses in King Washington.
Notice and learn for rent by owner homes in Bingen United States and short term rentals in Bingen United States.
We imagined, authored, and initiated this site, For Rent By Owner (FRBO.com) to be foxy, fine, graceful, and delicate.
Ferret out, move, and move vacation homes Whitman and rent house in Whitman.
Find out and distinguish homes for rent by owner and Grapeview United States rent houses.
Join our lake listings, decadent directories, exotic classifieds, and log classified advertisements mailing list for rental properties Discovery Bay Washington and rent houses.
Ramblers, counterparts, and navigators who are wishing to relocate, uncover, and disclose or simply find out information can use our page.
Contrive, perceive, and uncover rent houses Dallesport, rental properties, and homes for rent Dallesport.
Locate and locate rental home in Sekiu and condo rentals Sekiu United States.
Conceive several and uncommon statistics in Discovery Bay Washington and poll Discovery Bay home rentals.
Not seldom, work with and benefit your boarders, possessors, and gypsies to a vast, bewitching, teasing, and hefty city.
Discovery Bay Washington is a marvelous, ravishing, and refined locality with resplendent, statuesque, and stunning townhouse and castles.
Recognize and locate Whitman Washington condo rentals and Whitman Washington rental houses.
Hear, contrive, and light upon bed and breakfast rentals San Juan Washington and San Juan homes for rent.
|
|
