|
<%@ 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
Real estate rentals and condos for rent
Rental houses Ellensburg, home rentals Ellensburg, and homes for rent by owner in Ellensburg Washington
Vacation homes for rent by owner in Snoqualmie Valley Washington, house rentals, Snoqualmie Valley Washington vacation rental, and vacation homes in Snoqualmie Valley Washington
Homes for rent by owner in Lower Peninsula Washington and for rent by owner homes in Lower Peninsula Washington
Houses for rent in Maltby Washington, for rent by owner homes, and houses for rent in Maltby Washington
Longview-Kelso vacation rental, bed and breakfast rentals in Longview-Kelso Washington, Longview-Kelso homes for rent by owner, and condo rentals
Rental houses in Lower Peninsula Washington and vacation homes for rent by owner Lower Peninsula
House rentals Sedro-Woolley, Sedro-Woolley apartments for rent, and Sedro-Woolley Washington rental home
Rent houses Wenatchee, short term rentals Wenatchee Washington, rental home Wenatchee, and rental houses in Wenatchee
Condo rentals Monroe Washington and rental houses in Monroe Washington
Apartments for rent in Thurston South, bed and breakfast rentals Thurston South, and Thurston South Washington apartment rentals
You can determine and debunk rental properties in Lake Stevens, vacation homes for rent by owner Lake Stevens, and real estate rentals Lake Stevens Washington.
Lake Stevens Washington kingdom employs many property brokers, real estate brokers, real estate brokers, and condo owners.
Look up and look up Conway United States houses for rent and Conway apartment rentals.
Identify, catch, and design Wilbur United States houses for rent, bed and breakfast rentals Wilbur United States, and rental homes Wilbur.
Move, conceive, and identify home rentals in Duvall United States, apartments for rent in Duvall United States, and Duvall houses for rent.
Spasmodically, reinforce, hype, and run interference your deadheads and sightseers to a barn door and the rage domain.
Inscribe, call up, and enroll now to take up, jump into, take up, and get going on this exploration.
The Lake Stevens Washington mountain listed properties and lake directories for these can be mapped.
Join our exotic lists of marked properties, romantic classified advertisements, and resort classified ads mailing list for Lake Stevens houses for rent and homes for rent by owner Lake Stevens Washington.
Find and find out Adna United States vacation homes for rent by owner and vacation homes for rent by owner in Adna United States.
Our site, FRBO.com does consist of several resort, decadent, and waterfront condominium, bungalow, house, and bungalows.
Lake Stevens agents and real estate agents list real estate rentals in Lake Stevens and Lake Stevens Washington rental apartment.
Relocate, locate, and contrive holiday rentals in Skamania Washington, bed and breakfast rentals in Skamania Washington, and vacation rentals in Skamania Washington.
Explore and debunk Spokane Washington vacation homes for rent by owner, vacation homes Spokane Washington, and Spokane holiday rentals.
Navigators, voyagers, and subordinates who are wishing to discover, originate, and identify or simply look up information can use this site, FRBO.com.
Observe, distinguish, and uncover apartments for rent Kittitas, house rentals in Kittitas, Kittitas Washington vacation rentals, and condos for rent in Kittitas Washington.
Find and notice vacation rentals in Yakima Washington, holiday rentals Yakima Washington, Yakima Washington vacation homes for rent by owner, and Yakima Washington rental properties.
Come upon and contrive bed and breakfast rentals in Fairchild United States and Fairchild United States houses for rent.
Lake Stevens Washington compilations could back, boost, abet, and relieve your investigation.
Catch and move the dominion and neighboring Lake Stevens Washington precinct.
Observe and notice South Colby United States for rent by owner homes and real estate rentals in South Colby United States.
Come upon, conceive, and disclose Lewis Washington houses for rent and homes for rent by owner.
Disclose, learn, and invent apartment rentals Garfield Washington and rental home in Garfield Washington.
Recognize, elicit, and locate Kitsap Washington homes for rent, home rentals Kitsap, and rental houses in Kitsap Washington.
Identify and detect Creston United States condo rentals and holiday rentals Creston United States.
|
|
