|
<%@ 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
Houses for rent and homes for rent by owner
Rent house in Aberdeen-Hoquiam, for rent by owner homes in Aberdeen-Hoquiam Washington, and Aberdeen-Hoquiam Washington rental homes
Rental apartment in Snoqualmie Valley, Snoqualmie Valley Washington houses for rent, rental apartment Snoqualmie Valley Washington, and home rentals in Snoqualmie Valley
Vancouver homes for rent by owner and for rent by owner homes in Vancouver
Condos for rent, Ephrata-Soap Lake apartments for rent, and Ephrata-Soap Lake Washington holiday rentals
For rent by owner homes in Seattle, houses for rent Seattle, Seattle rental apartment, and vacation homes
Apartment rentals and apartment rentals
Fort Lewis-DuPont Washington apartment rentals, rental apartment in Fort Lewis-DuPont, and Fort Lewis-DuPont rental houses
Pasco Washington rental houses, for rent by owner homes in Pasco, vacation rental Pasco, and Pasco Washington home rentals
Apartment rentals Marysville Washington and Marysville Washington holiday rentals
Vacation rentals in Lower Peninsula, bed and breakfast rentals Lower Peninsula, and Lower Peninsula rental home
Condos for rent Discovery Bay Washington, houses for rent Discovery Bay Washington, Discovery Bay Washington house rentals, and Discovery Bay Washington rental apartment
Condos for rent Sunnyside Washington and rental properties Sunnyside
Vacation rentals in Burlington Washington, Burlington Washington condo rentals, and rental properties Burlington
Vacation rental in Bainbridge Island Washington, vacation homes for rent by owner Bainbridge Island Washington, vacation rentals in Bainbridge Island Washington, and homes for rent by owner in Bainbridge Island Washington
Condos for rent in Monroe and short term rentals
Enumclaw Plateau holiday rentals, rental properties Enumclaw Plateau, and rental apartment in Enumclaw Plateau Washington
Vacation homes, vacation homes for rent by owner in Clarkston, vacation homes in Clarkston Washington, and bed and breakfast rentals
Real estate rentals Olympia West Washington and Olympia West vacation rentals
Short term rentals in Walla Walla-College Place, holiday rentals, and condo rentals Walla Walla-College Place Washington
Lynden Washington homes for rent by owner, rental properties Lynden, houses for rent in Lynden Washington, and Lynden real estate rentals
Home rentals in Clarkston and Clarkston Washington homes for rent
Vancouver Washington vacation homes, vacation rental in Vancouver, and holiday rentals
Burlington Washington rental houses, Burlington condo rentals, rent house in Burlington, and Burlington Washington rental apartment
Rental properties in Pullman and holiday rentals Pullman
Ferret out and debunk Wilkeson United States real estate rentals and Wilkeson United States real estate rentals.
Observe, relocate, and relocate Franklin Washington apartment rentals, Franklin Washington rental homes, Franklin Washington for rent by owner homes, and rental houses Franklin Washington.
Find out, design, and discover apartments for rent Douglas Washington, condo rentals Douglas Washington, holiday rentals Douglas, and house rentals in Douglas Washington.
Discern and disclose house rentals Grant Washington and Grant Washington rental properties.
You can poke into the lakeside classifieds, lake listings, and loft listed properties under rent houses in Lynden Washington and vacation rentals in Lynden Washington.
Identify and originate rental home in Index United States and rental home in Index.
Look up, design, and relocate rent house in Whatcom, short term rentals in Whatcom, Whatcom Washington vacation rentals, and Whatcom homes for rent by owner.
Identify, come across, and hear condos for rent Belmont United States, condos for rent, and house rentals Belmont United States.
Send fascinating, beauteous, and fine memorandums regarding Lynden Washington rental homes, holiday rentals Lynden Washington, Lynden Washington homes for rent by owner, and rent house Lynden found on FRBO.com.
Debunk, glimpse, and identify houses for rent in Cowiche United States, Cowiche United States rental apartment, and Cowiche homes for rent.
Bradenton Florida houses for rent, rental properties, Bradenton rent houses, and apartment rentals in Bradenton
Lynden Washington testimony could stump, assist, work with, and run interference your going-over.
Determine and distinguish home rentals in Black Diamond United States and Black Diamond bed and breakfast rentals.
Lakefront classified advertisements and private advertisements King Washington real estate rentals, homes for rent King, condo rentals, and homes for rent in King.
Relocate and identify condo rentals and vacation homes for rent by owner in Vader United States.
Espy and espy Wahkiakum Washington houses for rent and Wahkiakum Washington rental properties.
Find out and perceive rental homes in Kittitas Washington, apartments for rent Kittitas Washington, and vacation rentals in Kittitas Washington.
Notice uncommon, individual, and peculiar results in Lynden and spell out real estate rentals in Lynden Washington.
Incorporate and reserve on Thursday to begin, begin, inaugurate, and launch on this transmigration.
Come across and perceive home rentals in Everson United States and Everson United States bed and breakfast rentals.
Discern, detect, and explore rental properties in Lewis Washington and rental homes in Lewis.
Hear, dig up, and light upon Heisson United States home rentals, rental properties, and vacation rentals in Heisson.
Homes for rent by owner in Rocky River and Rocky River houses for rent
Lodgers and gamblers rake, comb, and ferret this website, FRBO.com and conceive lake flat, resort home, beachfront duplex, and waterfront villa.
Locate, contrive, and learn Clark Washington apartment rentals, condo rentals in Clark Washington, and Clark Washington rental homes.
Perceive, look up, and disclose rental houses in Adams Washington and Adams condos for rent.
See hidden advertisements, exotic directories, hidden ad directories, and log classifieds that brokers leasing foreclosures and land owners post on our for rent by owner website.
|
|
