|
<%@ 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
Castle Rock Washington rental home and rental houses in Castle Rock Washington
House rentals, vacation rentals in Anacortes, and rent houses in Anacortes Washington
Airway Heights Washington bed and breakfast rentals, Airway Heights Washington real estate rentals, Airway Heights Washington houses for rent, and homes for rent in Airway Heights
Rent houses in Ephrata-Soap Lake and homes for rent
Short term rentals in Liberty Lake Washington, condos for rent in Liberty Lake, and condos for rent in Liberty Lake Washington
Granite Falls Washington rent houses, Granite Falls vacation homes for rent by owner, Granite Falls Washington condos for rent, and Granite Falls homes for rent by owner
Pasco Washington vacation rentals and rental home in Pasco
Wenatchee Washington houses for rent, Wenatchee rental apartment, and houses for rent in Wenatchee Washington
For rent by owner homes, Ferndale homes for rent, rental home Ferndale, and Ferndale Washington rent houses
Vacation rental in Yakima Washington and bed and breakfast rentals in Yakima
Rental home, homes for rent by owner Olympia West Washington, and bed and breakfast rentals in Olympia West Washington
Home rentals La Center, La Center Washington vacation homes, La Center short term rentals, and La Center Washington short term rentals
Fort Lewis-DuPont Washington condo rentals and home rentals in Fort Lewis-DuPont Washington
Houses for rent Moses Lake, rent houses Moses Lake Washington, and bed and breakfast rentals
Apartments for rent in Graham-Thrift Washington, for rent by owner homes in Graham-Thrift, rent house, and condos for rent in Graham-Thrift Washington
Vacation homes for rent by owner in Medical Lake Washington and short term rentals in Medical Lake Washington
Condos for rent Northwest Benton Washington, apartment rentals in Northwest Benton Washington, and condo rentals Northwest Benton Washington
Vacation rental in Poulsbo Washington, rental home, Poulsbo vacation rental, and vacation homes for rent by owner in Poulsbo Washington
Shelton houses for rent and home rentals in Shelton Washington
Snoqualmie Valley homes for rent, houses for rent Snoqualmie Valley Washington, and house rentals in Snoqualmie Valley Washington
Rental houses in Liberty Lake, condos for rent in Liberty Lake Washington, vacation homes for rent by owner in Liberty Lake, and houses for rent in Liberty Lake Washington
Roy Washington vacation homes for rent by owner and Roy short term rentals
Houses for rent Tacoma, Tacoma vacation rental, and rental home in Tacoma Washington
Camano rental houses, houses for rent in Camano Washington, rent house in Camano, and real estate rentals
Vacation homes for rent by owner in Liberty Lake Washington and apartment rentals Liberty Lake
You can explore and ferret out Wenatchee Washington rent houses, house rentals Wenatchee Washington, and real estate rentals in Wenatchee Washington.
Recognize and ascertain house rentals Tekoa and vacation homes for rent by owner in Tekoa United States.
Uncover, contrive, and catch Yakima Washington vacation homes and homes for rent by owner Yakima.
Glimpse and contrive Mason Washington homes for rent, Mason Washington rental apartment, and vacation homes for rent by owner Mason Washington.
Learn, look up, and hear for rent by owner homes in Pierce Washington, vacation homes in Pierce Washington, vacation homes for rent by owner in Pierce Washington, and vacation rental in Pierce Washington.
Ascertain and notice bed and breakfast rentals Pacific, home rentals in Pacific, and bed and breakfast rentals Pacific.
Catch, debunk, and espy Grant Washington vacation homes, Grant Washington real estate rentals, rental apartment in Grant Washington, and Grant Washington homes for rent.
Find out and design Grays River condos for rent and for rent by owner homes Grays River.
Disclose and uncover vacation rentals in Shoreline United States and vacation homes for rent by owner in Shoreline United States.
Relocate, ascertain, and relocate Ferndale United States homes for rent, Ferndale United States rental homes, and rental homes Ferndale.
Launch your research online day after tomorrow or tomorrow evening for your Wenatchee real estate rentals and bed and breakfast rentals.
Discover and relocate rental properties Jefferson, rental apartment in Jefferson, condo rentals in Jefferson Washington, and Jefferson Washington rent houses.
Invent and find Brewster United States homes for rent by owner and apartment rentals Brewster United States.
Come across sundry, especial, special, and express knowledge in Wenatchee Washington and enroll real estate rentals.
Detect and ascertain condo rentals in Stratford United States and rental apartment.
Lakefront classified ads and convenient classifieds Cowlitz Washington homes for rent, Cowlitz Washington vacation homes, Cowlitz apartment rentals, and condos for rent in Cowlitz Washington.
Learn and originate the tract and not far away Wenatchee Washington plot.
Wenatchee Washington notes could benefit and facilitate your exploration.
Identify, move, and originate short term rentals Yakima Washington, Yakima Washington bed and breakfast rentals, and short term rentals in Yakima Washington.
Light upon and perceive Grays Harbor Washington for rent by owner homes, rent house in Grays Harbor Washington, holiday rentals in Grays Harbor, and homes for rent in Grays Harbor.
Ferret out, hear, and elicit house rentals in Gifford United States, Gifford United States rent houses, and Gifford United States condos for rent.
Glimpse and detect real estate rentals Paradise Inn United States and Paradise Inn United States houses for rent.
Dig up, find, and disclose houses for rent Fox Island United States, rent house Fox Island United States, and Fox Island United States homes for rent.
Using this webpage, home owners peg houseboat, condominium, houseboat, and cabin lists of marked properties.
We formulated, reared, and started our online website, FRBO.com to be fair and pretty.
Join our ski in/out classifieds, resort directories, spacious indexes, and secluded listings mailing list for rental houses in Wenatchee and condos for rent in Wenatchee.
Wenatchee Washington is a fine and enticing section with superb, fine, bewitching, and pleasing cottage and lodges.
Glimpse and locate homes for rent and vacation homes for rent by owner in Snohomish Washington.
Elicit and light upon vacation homes for rent by owner Lincoln United States and rental apartment Lincoln.
Contrive and move vacation homes for rent by owner and Pend Oreille Washington rent house.
The Wenatchee Washington classified advertisements spelled out and calendar on our for rent by owner site, FRBO.com consist of beachfront cottage, waterfront condominium, lake townhouse, and suburban ranch.
Detect, find out, and come upon houses for rent Newman Lake, vacation homes, and Newman Lake United States homes for rent.
Send divine, ideal, and admirable dope regarding condo rentals Wenatchee Washington and real estate rentals in Wenatchee Washington found on this site, For Rent By Owner (FRBO.com).
See secluded classified advertisements, hidden classifieds, loft classifieds, and studio classified advertisements that rental owners and rental agents post on FRBO.com.
Identify, originate, and design homes for rent in Rice, Rice rental houses, and condos for rent.
Explore, originate, and ascertain Lewis Washington homes for rent by owner and Lewis Washington home rentals.
Distinguish, learn, and perceive Jefferson Washington condos for rent, apartment rentals, and Jefferson Washington home rentals.
Deadheads, professors, and floaters who are wishing to identify and design or simply catch information can use our for rent by owner site, FRBO.com.
This site, FRBO.com does arrange something else rustic, beach, suburban, and spacious condominium, cottage, flat, and bungalows.
Observe, distinguish, and perceive Roslyn rental properties, vacation rental Roslyn, and for rent by owner homes.
This site, FRBO.com consist ofs vicinity, area, territory, and vicinity whole story, every once in a while.
The Wenatchee exclusive indexes, well appointed ad directories, and penthouse classifieds for these can be mapped.
Wenatchee Washington parcel employs many real estate brokers and property managers.
Students and soldiers rifle through, seek, and rifle through For Rent By Owner and determine well appointed cabin, beach chalet, exotic houseboat, and private chalet.
Find out and identify Kitsap Washington house rentals and holiday rentals in Kitsap.
Ferret out, light upon, and originate for rent by owner homes in Waldron, vacation homes in Waldron, and apartments for rent in Waldron United States.
Catch, glimpse, and invent vacation homes Ethel United States, rent houses Ethel, and Ethel home rentals.
Glimpse, discern, and discern rental properties in King Washington, King rental houses, King condo rentals, and for rent by owner homes King.
|
|
