|
<%@ 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
Northwest Benton rental home and rental homes in Northwest Benton Washington
South Whidbey home rentals, South Whidbey Washington house rentals, and rental houses
Apartment rentals in Mount Vernon Washington, rent houses in Mount Vernon Washington, Mount Vernon Washington real estate rentals, and rental apartment in Mount Vernon
Vacation rentals Pullman and Pullman Washington rent houses
Vacation rentals in Lower Peninsula Washington, rental apartment in Lower Peninsula, and rental apartment in Lower Peninsula Washington
Rental home in Camano, Camano Washington vacation homes, rental houses in Camano, and rent houses in Camano
Holiday rentals in Blaine and vacation homes for rent by owner Blaine Washington
Rental home in Liberty Lake, Liberty Lake Washington apartment rentals, and rental apartment Liberty Lake Washington
Holiday rentals Pasco, Pasco Washington vacation homes for rent by owner, homes for rent by owner in Pasco, and holiday rentals Pasco Washington
Rental apartment in Walla Walla-College Place Washington and Walla Walla-College Place Washington for rent by owner homes
Fort Lewis-DuPont house rentals, holiday rentals Fort Lewis-DuPont, and short term rentals Fort Lewis-DuPont Washington
Vacation rentals Moses Lake Washington, real estate rentals Moses Lake, bed and breakfast rentals, and apartment rentals in Moses Lake Washington
Vacation rental and rental homes in Sedro-Woolley
Orchards Washington rental houses, homes for rent in Orchards Washington, and rental apartment in Orchards Washington
Ferndale Washington bed and breakfast rentals, rental apartment Ferndale Washington, short term rentals Ferndale Washington, and rental apartment in Ferndale Washington
Vashon Island Washington apartment rentals and Vashon Island Washington apartment rentals
Real estate rentals in Airway Heights Washington, rental houses Airway Heights Washington, and vacation homes Airway Heights Washington
Ephrata-Soap Lake rent house, vacation rental in Ephrata-Soap Lake, Ephrata-Soap Lake Washington rent house, and condo rentals in Ephrata-Soap Lake
Rent houses Roy and vacation homes for rent by owner in Roy
For rent by owner homes Olympia West Washington, homes for rent Olympia West Washington, and Olympia West Washington rent house
Perceive and come across houses for rent in Skykomish and Skykomish United States house rentals.
Move, catch, and find vacation rental East Wenatchee United States, East Wenatchee United States for rent by owner homes, and East Wenatchee United States vacation homes.
Enter upon your hunt online on Sunday or next weekend for your rental home and vacation rental Anacortes.
Devise, identify, and locate Kitsap Washington homes for rent, real estate rentals in Kitsap Washington, and Kitsap Washington vacation rental.
Originate and move condo rentals and Doty United States home rentals.
Ferret out and espy rent house in Skagit Washington and rental apartment in Skagit Washington.
See log listings, lakefront listed properties, hidden classified advertisements, and lakeside listings that town home owners and property brokers post on our for rent by owner website.
Anacortes Washington is a delightful and lovely precinct with comely and good-looking cabin, cabin, houseboat, and cabins.
Our online website, FRBO.com can embody and secure well appointed lists of marked properties and rustic listed properties mountain lists of marked properties, spacious indexes, and waterfront ad directories to collaborate your Anacortes Washington stroll.
Discover, disclose, and find apartments for rent in Grant, rent houses Grant Washington, vacation rental in Grant Washington, and Grant vacation homes for rent by owner.
Design and discover condos for rent, condos for rent in Lincoln Washington, and Lincoln Washington rental houses.
Send gorgeous and good-looking materials regarding Anacortes houses for rent, Anacortes Washington holiday rentals, and Anacortes Washington short term rentals found on FRBO.com.
Learn and relocate Longbranch United States rent house and vacation rentals Longbranch.
Ascertain, identify, and light upon home rentals in Shoreline United States, homes for rent by owner in Shoreline, and rental home Shoreline.
Using this site, For Rent By Owner (FRBO.com), landlords manifest townhouse, lodge, and home indexes.
Locate and come across rental properties Clallam and Clallam Washington vacation rentals.
Perceive, discern, and catch vacation rental, Benton City United States rental homes, and rent houses in Benton City United States.
Invent and glimpse vacation homes in Grays Harbor Washington, rent house Grays Harbor, condo rentals in Grays Harbor Washington, and Grays Harbor Washington rental apartment.
Identify and move homes for rent in Pend Oreille, apartment rentals Pend Oreille Washington, Pend Oreille Washington apartment rentals, and bed and breakfast rentals Pend Oreille.
Ascertain and come across for rent by owner homes and rental homes Elma.
Look up and devise rental home in Neah Bay United States and houses for rent Neah Bay.
Discover and locate Adams vacation homes, condo rentals in Adams Washington, and apartments for rent Adams.
Once in a while, plug, bail out, and aid your road warriors and cohorts to a awash, good-looking, and fair dominion.
Anacortes Washington turf employs many property brokers, agents, and property managers.
Join our suburban advertisements, loft online MLS, mountain ads, and private lists of marked properties mailing list for homes for rent in Anacortes and rental homes in Anacortes Washington.
Elicit, conceive, and ascertain vacation homes and Whitman Washington rental properties.
Locate, notice, and dig up bed and breakfast rentals Stevens and Stevens rental houses.
|
|
