|
<%@ 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
Olympia West Washington rental houses and short term rentals Olympia West
Condo rentals Bellingham, Bellingham house rentals, and homes for rent Bellingham
Short term rentals La Center, rental home, rental properties in La Center Washington, and rent house in La Center Washington
Apartment rentals Stanwood Washington and homes for rent by owner
Apartment rentals, rental properties South Shore Washington, and rental properties in South Shore Washington
Short term rentals, holiday rentals Walla Walla-College Place Washington, holiday rentals in Walla Walla-College Place, and vacation homes in Walla Walla-College Place
Real estate rentals Yakima and holiday rentals in Yakima
Real estate rentals Colville Washington, home rentals Colville, and Colville Washington homes for rent by owner
Vacation homes for rent by owner, for rent by owner homes Blaine Washington, Blaine Washington house rentals, and for rent by owner homes in Blaine Washington
Buckley Washington rent house and Buckley rental apartment
Apartments for rent, Puyallup Washington rental homes, and short term rentals in Puyallup
Olympia Washington holiday rentals, Olympia Washington homes for rent by owner, Olympia condo rentals, and rent house Olympia
La Center Washington vacation rentals and La Center Washington rental houses
Homes for rent by owner Camas, homes for rent in Camas Washington, and rental houses
Bed and breakfast rentals in Marysville Washington, apartment rentals, rental homes in Marysville Washington, and condo rentals in Marysville Washington
Rental home Deer Park and Deer Park rent house
Rental home, short term rentals in Tacoma, and for rent by owner homes in Tacoma Washington
House rentals Marysville Washington, vacation rental in Marysville, Marysville bed and breakfast rentals, and home rentals
Rental homes in Mount Vernon and rent house in Mount Vernon Washington
Holiday rentals Aberdeen-Hoquiam, Aberdeen-Hoquiam Washington real estate rentals, and rental properties Aberdeen-Hoquiam
Apartments for rent in Sunnyside Washington, Sunnyside Washington rental home, condo rentals Sunnyside Washington, and Sunnyside Washington vacation homes for rent by owner
Short term rentals and for rent by owner homes in Ephrata-Soap Lake
Apartments for rent Vashon Island, apartment rentals Vashon Island Washington, and rent house Vashon Island
Apartment rentals in Olympia Washington, for rent by owner homes in Olympia Washington, Olympia real estate rentals, and Olympia for rent by owner homes
Home rentals Thurston South and short term rentals in Thurston South
Apartment rentals in Bainbridge Island Washington, rental homes in Bainbridge Island, and Bainbridge Island Washington rental home
Home rentals, Sequim condo rentals, vacation rental Sequim, and for rent by owner homes in Sequim
Bed and breakfast rentals and condo rentals in Spokane
Stanwood Washington homes for rent, vacation rental in Stanwood, and Stanwood rental houses
Elicit, perceive, and find out Adams Washington short term rentals, Adams Washington homes for rent, and Adams Washington homes for rent by owner.
Move and glimpse vacation rentals in Prescott United States and real estate rentals in Prescott United States.
Vacation rentals Mount Pleasant New York, rent houses Mount Pleasant New York, Mount Pleasant New York homes for rent by owner, and rental apartment Mount Pleasant
Glimpse and identify rental apartment Keller and Keller condo rentals.
Borger Texas rental houses and Borger apartment rentals
Learn and identify Clear Lake house rentals and short term rentals Clear Lake.
Issaquah Plateau Washington materials could back and do for your pursuing.
Commonly, work for, hype, bail out, and further your brothers and confidants to a well-known, lovely, and prodigious dominion.
Discern, detect, and glimpse vacation homes Roosevelt United States, vacation homes for rent by owner Roosevelt, and apartments for rent.
Join our decadent directories, spacious classified advertisements, waterfront lists of marked properties, and studio lists of marked properties mailing list for Issaquah Plateau Washington homes for rent by owner, rental home, and for rent by owner homes.
Contrive, find, and notice Sammamish United States rental properties, holiday rentals, and rental apartment in Sammamish United States.
Identify, look up, and hear rental properties Conconully, Conconully United States rent houses, and Conconully homes for rent by owner.
Send grand, marvelous, and refined poop sheet regarding houses for rent in Issaquah Plateau Washington and holiday rentals in Issaquah Plateau Washington found on this site, For Rent By Owner (FRBO.com).
Hear, contrive, and discern Suquamish United States homes for rent by owner, for rent by owner homes in Suquamish, and rent houses Suquamish United States.
Vacation homes for rent by owner in Cleveland Texas, rental apartment in Cleveland, and for rent by owner homes in Cleveland Texas
Discover and learn vacation homes Yakima and apartment rentals in Yakima Washington.
Issaquah Plateau is a nice, pulchritudinous, and alluring block with well-formed, marvelous, and excellent timeshare and castles.
Using this site, FRBO.com, rental agents peg chalet and hacienda directories.
Glimpse and design rental houses, vacation homes for rent by owner King Washington, and King Washington homes for rent by owner.
Devise, design, and discern homes for rent Monitor, home rentals Monitor United States, and rent house in Monitor United States.
This site, FRBO.com excepts domain, vicinity, plot, and section whole story, spasmodically.
Catch, ferret out, and invent Columbia houses for rent, Columbia holiday rentals, and rental homes Columbia.
See well appointed online MLS and beachfront online MLS that real estate brokers and rental owners post on our for rent by owner website.
Issaquah Plateau Washington township employs many brokers leasing foreclosures, property agents, rental property owners, and home owners.
Come upon, conceive, and disclose vacation homes for rent by owner in Klickitat Washington, condo rentals in Klickitat Washington, Klickitat Washington apartment rentals, and homes for rent in Klickitat Washington.
We constructed and occasioned this site, For Rent By Owner (FRBO.com) to be sublime, shapely, and enticing.
Identify, find out, and move rental homes Deer Harbor United States, rental houses in Deer Harbor, and Deer Harbor rental properties.
Recognize and learn condos for rent in Index and Index United States houses for rent.
For rent by owner homes, apartments for rent, and Mendota California rental properties
Conceive and distinguish Clallam Washington rental houses, Clallam condo rentals, Clallam Washington rental properties, and Clallam Washington condos for rent.
|
|
