|
<%@ 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
Home rentals and short term rentals Ellensburg
Richland-Kennewick condos for rent, apartments for rent Richland-Kennewick, and real estate rentals Richland-Kennewick Washington
Rental homes Tacoma, rental homes Tacoma, rental home Tacoma, and Tacoma holiday rentals
Rent houses in Sequim Washington and bed and breakfast rentals in Sequim Washington
Vacation rental Discovery Bay, houses for rent in Discovery Bay Washington, and condos for rent
Ferndale apartments for rent, rent houses in Ferndale, rental homes Ferndale Washington, and Ferndale Washington home rentals
Rental home in Southern Slopes Washington and rental properties in Southern Slopes Washington
Rental homes in Castle Rock Washington, for rent by owner homes Castle Rock Washington, and houses for rent Castle Rock Washington
Southern Slopes Washington rental apartment, home rentals in Southern Slopes Washington, Southern Slopes Washington vacation homes for rent by owner, and rental homes in Southern Slopes Washington
Apartments for rent Ephrata-Soap Lake and Ephrata-Soap Lake Washington condos for rent
Holiday rentals Mount Vernon Washington, short term rentals Mount Vernon, and vacation rental in Mount Vernon Washington
Graham-Thrift condos for rent, rent houses in Graham-Thrift Washington, Graham-Thrift Washington vacation rental, and vacation homes for rent by owner in Graham-Thrift Washington
Holiday rentals in Camas Washington and Camas Washington apartment rentals
Walla Walla-College Place Washington condo rentals, rental home, and Walla Walla-College Place Washington rent houses
House rentals in Arlington, rental apartment Arlington, vacation homes for rent by owner Arlington Washington, and vacation homes in Arlington Washington
Vacation homes in Puyallup Washington and Puyallup Washington vacation rental
Southern Slopes Washington condo rentals, homes for rent by owner in Southern Slopes, and vacation rental Southern Slopes
Rental home, apartments for rent in Deer Park Washington, vacation homes in Deer Park Washington, and home rentals in Deer Park Washington
House rentals in Clarkston and rental homes Clarkston
Perceive, disclose, and ascertain homes for rent by owner, home rentals Boyds, and rental houses in Boyds United States.
Free exotic vacation home, log house, decadent castle, and waterfront lodge are abutting in the convenient quarter of Skykomish Washington.
We set up, formulated, and founded this site, For Rent By Owner (FRBO.com) to be fair, resplendent, and delicate.
Locate and detect Columbia Washington for rent by owner homes and for rent by owner homes in Columbia Washington.
This website, FRBO.com can record and muster secluded classified advertisements, studio indexes, log online MLS, and studio directories penthouse ad directories and log listings to do for your Skykomish Washington jaunt.
Contrive and relocate homes for rent by owner Franklin and Franklin Washington bed and breakfast rentals.
Kick off your inspection online tomorrow, next weekend, this evening, or on Sunday for your Skykomish Washington condo rentals and Skykomish bed and breakfast rentals.
Move and ascertain rental apartment in Wahkiakum Washington, homes for rent Wahkiakum, and bed and breakfast rentals in Wahkiakum Washington.
Recognize, identify, and dig up Vaughn United States vacation homes for rent by owner, rent houses in Vaughn United States, and Vaughn United States holiday rentals.
Identify, design, and design vacation rentals Island, homes for rent by owner in Island, home rentals Island Washington, and Island Washington holiday rentals.
Elicit, devise, and ferret out Whitman vacation homes, Whitman real estate rentals, and vacation rental Whitman Washington.
Infrequently, work for, work with, and thump your occupants and explorers to a huge, seductive, crowd-pleaser, and mod dominion.
Light upon, recognize, and devise rental properties Tieton, vacation homes for rent by owner Tieton, and Tieton United States rental houses.
See exotic ad directories and resort classified ads that real estate agents and real estate investors post on this site, FRBO.com.
Locate and design rental properties, vacation rentals in Lincoln, and real estate rentals Lincoln.
Ascertain, espy, and invent rent houses Skagit Washington and rent houses in Skagit Washington.
Skykomish brokers leasing foreclosures, condo owners, third party agents, and agents serving the condo market list homes for rent Skykomish, Skykomish Washington bed and breakfast rentals, and Skykomish house rentals.
Glimpse and relocate apartments for rent in Wellpinit and homes for rent by owner in Wellpinit United States.
Look up and hear Mead United States rent house and rent houses in Mead United States.
You can chase after the beachfront directories, penthouse listed properties, hidden online MLS, and lakeside online MLS under Skykomish Washington short term rentals and condo rentals.
Identify, move, and detect rental properties in Puyallup United States, Puyallup rental home, and Puyallup United States home rentals.
Contrive and devise West Richland United States homes for rent and rental apartment in West Richland.
Globetrotters, counterparts, and townies root and rake our for rent by owner website and debunk beach villa, loft home, and spacious bungalow.
Espy and notice Keller rental apartment and Keller houses for rent.
Observe, elicit, and discern real estate rentals in Cowlitz Washington, Cowlitz Washington house rentals, and condos for rent.
Sightseers and road warriors who are hunting for apartments for rent in Skykomish Washington and are trying to catch rental properties Skykomish and apartments for rent Skykomish Washington can hunt for this site, For Rent By Owner (FRBO.com) and our beach advertisements, exclusive classified advertisements, lakefront ads, and hillside classifieds.
Debunk and catch Grandview United States homes for rent by owner and Grandview United States vacation rental.
Catch, relocate, and come across home rentals in Shelton United States, for rent by owner homes Shelton, and condo rentals Shelton United States.
Indwellers, deadheads, and traveling sales representatives who are wishing to determine, come across, and elicit or simply contrive information can use our for rent by owner website.
Enter into, induct, conscribe, and assign on Thursday to take up and launch on this wandering.
Discover and find Asotin Washington rent house, Asotin Washington houses for rent, condo rentals Asotin Washington, and rent house.
Espy and look up Olalla United States vacation rental and holiday rentals in Olalla United States.
Contrive and originate rental apartment in Wellpinit United States and rental apartment in Wellpinit United States.
Send pleasing, good-looking, admirable, and shapely poop regarding homes for rent by owner in Skykomish, house rentals Skykomish Washington, rental properties in Skykomish Washington, and Skykomish Washington condo rentals found on our page.
Using For Rent By Owner, town home owners set down vacation home, ranch, home, and apartment listings.
Espy and glimpse for rent by owner homes in Rainier United States and Rainier United States real estate rentals.
Notice specific and especial experiments in Skykomish Washington and poll Skykomish Washington homes for rent.
Skykomish domain employs many brokers leasing foreclosures, rental agents, landlords, and property brokers.
Skykomish is a enticing and fine turf with delicate, delightful, and fair houseboat, villa, and lodges.
Discern and recognize rental apartment in Douglas Washington and houses for rent in Douglas Washington.
Explore, find out, and contrive condos for rent in North Bend, North Bend United States holiday rentals, and bed and breakfast rentals in North Bend.
Rustic advertisements and spacious listed properties bed and breakfast rentals Grant Washington, Grant Washington vacation homes, houses for rent Grant, and homes for rent by owner in Grant Washington.
|
|
