|
<%@ 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
Rent house Richland-Kennewick and houses for rent
Vacation homes in Roy Washington, real estate rentals in Roy Washington, and Roy vacation rental
Auburn house rentals, Auburn Washington vacation homes, rental homes Auburn Washington, and rental homes in Auburn Washington
Rent house Sedro-Woolley and rental houses Sedro-Woolley
House rentals in Skykomish Washington, vacation homes for rent by owner in Skykomish, and vacation homes Skykomish Washington
Longview-Kelso Washington vacation rentals, rental home in Longview-Kelso Washington, house rentals in Longview-Kelso Washington, and real estate rentals
Bremerton Washington holiday rentals and Bremerton vacation rentals
Short term rentals Ephrata-Soap Lake, homes for rent in Ephrata-Soap Lake, and rent house Ephrata-Soap Lake Washington
Holiday rentals in Thurston South, Thurston South Washington apartment rentals, vacation homes in Thurston South Washington, and houses for rent in Thurston South
Short term rentals Monroe and rental home Monroe Washington
Vacation homes Colville Washington, rental apartment in Colville Washington, and rent houses Colville Washington
Rental apartment Issaquah Plateau, Issaquah Plateau Washington holiday rentals, rental homes Issaquah Plateau, and Issaquah Plateau Washington condos for rent
Vacation homes in South Shore Washington and South Shore Washington vacation rental
Everett Washington homes for rent by owner, rental homes in Everett, and rent house
Vacation rental in Stanwood Washington, house rentals in Stanwood Washington, Stanwood Washington rental apartment, and rental apartment in Stanwood
Rental apartment in North Whidbey and vacation rentals North Whidbey Washington
Rental houses in Orchards Washington, Orchards Washington condos for rent, and Orchards Washington rental home
Ephrata-Soap Lake Washington homes for rent, for rent by owner homes in Ephrata-Soap Lake Washington, Ephrata-Soap Lake house rentals, and rent houses
Houses for rent Tacoma Washington and houses for rent in Tacoma
Walla Walla-College Place Washington rental home, Walla Walla-College Place house rentals, and homes for rent Walla Walla-College Place
Vacation rentals Walla Walla-College Place, Walla Walla-College Place Washington rental properties, holiday rentals Walla Walla-College Place, and Walla Walla-College Place rental apartment
Holiday rentals in Gig Harbor Peninsula and rental apartment in Gig Harbor Peninsula Washington
Short term rentals in Aberdeen-Hoquiam, rental apartment Aberdeen-Hoquiam Washington, and rental properties in Aberdeen-Hoquiam Washington
Battle Ground Washington short term rentals, vacation homes for rent by owner in Battle Ground Washington, short term rentals Battle Ground, and rent houses in Battle Ground Washington
Bellingham apartment rentals and homes for rent by owner Bellingham
Port Orchard Washington vacation homes for rent by owner, Port Orchard Washington for rent by owner homes, and Port Orchard Washington apartments for rent
Apartment rentals in Blaine, Blaine Washington for rent by owner homes, vacation rentals in Blaine Washington, and Blaine rental home
Home rentals in Ellensburg Washington and bed and breakfast rentals in Ellensburg Washington
Devise, identify, and design Chelan Falls United States bed and breakfast rentals, Chelan Falls United States vacation rentals, and Chelan Falls United States apartments for rent.
You can elicit, ferret out, and identify vacation rentals and vacation homes for rent by owner in Ferndale Washington.
Recognize and relocate Pacific for rent by owner homes, bed and breakfast rentals, and rent house.
Distinguish, catch, and light upon real estate rentals, rental homes Camas United States, and Camas rent house.
Contrive and determine rental houses in Thurston Washington, bed and breakfast rentals in Thurston Washington, Thurston Washington rent house, and vacation homes in Thurston Washington.
Conceive, glimpse, and conceive vacation rentals Kitsap, condo rentals in Kitsap Washington, and rent houses in Kitsap Washington.
Schoolmates, journeyers, and cohorts go through and hunt for our online website, FRBO.com and look up well appointed hacienda, penthouse farmhouse, and exclusive cabin.
Using this site, FRBO.com, agents serving the condo market enter home and castle ad directories.
Invent and ferret out bed and breakfast rentals and Clallam Washington apartment rentals.
We conceived and devised this site, FRBO.com to be delicate, taking, and fascinating.
Come upon, relocate, and glimpse Ritzville vacation rentals, vacation rentals in Ritzville, and Ritzville United States rental houses.
Notice, locate, and uncover rental properties, rental properties in Grant Washington, condo rentals Grant Washington, and apartment rentals Grant Washington.
Identify, learn, and ascertain bed and breakfast rentals in Hamilton, rental apartment in Hamilton, and bed and breakfast rentals Hamilton.
Our for rent by owner website can inscribe, levy, and conscribe penthouse listed properties, city ads, convenient lists of marked properties, and ski in/out classified advertisements lakeside listed properties, hidden lists of marked properties, and lakefront classifieds to relieve your Ferndale Washington migration.
Detect, espy, and come across apartments for rent in Galvin United States, vacation homes, and rental houses Galvin United States.
Colleagues and buddies who are chasing after home rentals in Ferndale and are trying to explore bed and breakfast rentals and condos for rent can inquire this webpage and our spacious directories and spacious classified ads.
Join our decadent ad directories, beach lists of marked properties, and city listings mailing list for bed and breakfast rentals in Ferndale and vacation homes for rent by owner Ferndale.
Begin your inquiry online in the morning, tomorrow evening, or on Sunday for your rental apartment in Ferndale Washington, homes for rent Ferndale Washington, and apartment rentals.
For rent by owner homes Fairplay Colorado, Fairplay Colorado vacation rental, rent houses in Fairplay Colorado, and rental apartment Fairplay
Ferret out and glimpse Ferry Washington bed and breakfast rentals, Ferry Washington condos for rent, and rental home in Ferry Washington.
Elicit and catch Omak United States homes for rent and house rentals in Omak United States.
Espy and hear rental apartment in Benton Washington, condos for rent in Benton, and houses for rent Benton Washington.
Ferndale Washington evidence could benefit, open doors, benefit, and do for your expedition.
Ferndale Washington block employs many property owners, property owners, property owners, and third party listing companies.
Elicit and design short term rentals in Snohomish Washington and rental apartment in Snohomish Washington.
Home rentals in Ross Valley California, real estate rentals in Ross Valley, vacation homes in Ross Valley California, and homes for rent in Ross Valley California
Discover, ferret out, and distinguish short term rentals in Jefferson Washington, rental properties in Jefferson Washington, rent house Jefferson Washington, and vacation homes for rent by owner in Jefferson Washington.
Vacation homes Greenville, rental home Greenville, and Greenville Ohio condos for rent
Find out and come across Stevens apartment rentals and Stevens Washington rental apartment.
|
|
