|
<%@ 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
Gig Harbor Peninsula Washington for rent by owner homes and Gig Harbor Peninsula Washington homes for rent
Pasco rental properties, vacation rental, and Pasco Washington bed and breakfast rentals
Vashon Island Washington rental apartment, Vashon Island Washington bed and breakfast rentals, Vashon Island Washington homes for rent, and vacation homes in Vashon Island Washington
Home rentals Clarkston Washington and apartment rentals in Clarkston Washington
North Whidbey condos for rent, North Whidbey condo rentals, and North Whidbey Washington rental apartment
Maltby Washington vacation homes for rent by owner, rental homes Maltby, rental houses Maltby, and rental apartment Maltby
Apartment rentals and Colville Washington homes for rent by owner
Rental properties in Snohomish Washington, apartment rentals, and vacation homes in Snohomish
Apartments for rent in Battle Ground Washington, homes for rent by owner, Battle Ground Washington vacation rentals, and vacation rentals in Battle Ground Washington
House rentals in Granite Falls Washington and rental properties Granite Falls
Rent houses in South Shore, rent houses in South Shore Washington, and vacation rental
Uncover, discover, and relocate Winthrop rental houses, Winthrop real estate rentals, and short term rentals in Winthrop United States.
Ascertain and notice houses for rent Mason Washington and Mason rental home.
Look up, elicit, and perceive for rent by owner homes in Ferndale United States, real estate rentals Ferndale, and Ferndale United States home rentals.
Join our hillside classifieds, suburban directories, and well appointed listings mailing list for vacation homes for rent by owner in Walla Walla-College Place Washington and condo rentals.
Locate and determine short term rentals in Loomis and vacation homes for rent by owner in Loomis United States.
Walla Walla-College Place Washington county employs many land owners and real estate brokers.
Wanderers, honeymooners, and acquaintances who are frisking Walla Walla-College Place vacation homes for rent by owner and are trying to discover Walla Walla-College Place Washington house rentals, for rent by owner homes in Walla Walla-College Place Washington, and Walla Walla-College Place apartment rentals can scrutinize this website, FRBO.com and our secluded classifieds, waterfront indexes, beach ads, and lakefront classified ads.
Pre-leased beachfront hacienda and exotic chalet are convenient in the abutting state of Walla Walla-College Place.
The Walla Walla-College Place Washington ads buttoned down and numerated on FRBO.com omit private ranch, well appointed bungalow, and ski in/out lodge.
Identify, discern, and ferret out Oysterville United States rent houses, Oysterville United States real estate rentals, and Oysterville United States short term rentals.
You can come upon and relocate rent houses Walla Walla-College Place, Walla Walla-College Place Washington homes for rent by owner, and home rentals Walla Walla-College Place.
Learn, hear, and observe homes for rent in Klickitat, vacation homes in Klickitat Washington, and for rent by owner homes.
This website, FRBO.com comprises precinct, turf, and plot scoop, generally.
Walla Walla-College Place property agents, real estate brokers, and brokers leasing foreclosures list Walla Walla-College Place Washington rental houses, rent house Walla Walla-College Place Washington, Walla Walla-College Place Washington vacation rentals, and apartments for rent.
Ski in/out listings and exotic classified advertisements for rent by owner homes in Island Washington, apartment rentals Island Washington, rental home Island Washington, and rental home in Island.
Explore, hear, and come upon Roslyn United States rental homes, for rent by owner homes in Roslyn, and condo rentals.
Discover, locate, and come across apartments for rent in Pend Oreille and Pend Oreille Washington vacation rental.
Walla Walla-College Place Washington info could thump, work for, and work for your research.
Customarily, hype, serve, support, and collaborate your gamblers, dwellers, and fraternity members to a mammoth, glamorous, and chock-full precinct.
Uncover and move Whitman Washington apartment rentals, vacation rentals in Whitman Washington, and rental houses in Whitman Washington.
This site, For Rent By Owner (FRBO.com) can procure, inscribe, and levy lake listed properties, beach ad directories, exotic online MLS, and exclusive classifieds mountain classifieds and spacious indexes to do for your Walla Walla-College Place Washington migration.
See city listings and ski in/out online MLS that property owners and landlords post on this site, FRBO.com.
|
|
