|
<%@ 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
Longview-Kelso Washington rental apartment and rental apartment in Longview-Kelso
Rental home in Poulsbo Washington, Poulsbo rent house, and rental houses in Poulsbo Washington
Lynden rental houses, vacation homes in Lynden Washington, rental houses Lynden, and bed and breakfast rentals in Lynden Washington
Walla Walla-College Place Washington vacation rental and vacation homes Walla Walla-College Place
East Seattle Washington rental houses, rental apartment East Seattle Washington, and rent houses in East Seattle Washington
Vacation rentals in Centralia-Chehalis Washington, apartments for rent, Centralia-Chehalis Washington vacation rental, and vacation homes in Centralia-Chehalis Washington
Olympia Washington vacation rental and rent house in Olympia Washington
Rent house Moses Lake Washington, condos for rent, and Moses Lake Washington house rentals
Apartment rentals in Tahoma-Maple Valley Washington, Tahoma-Maple Valley Washington short term rentals, apartments for rent Tahoma-Maple Valley, and rental properties Tahoma-Maple Valley
Olympia West Washington short term rentals and vacation homes
Home rentals Roy Washington, condos for rent, and Roy apartments for rent
Holiday rentals Port Orchard, rental houses, houses for rent, and house rentals
Mount Vernon Washington vacation homes and rental apartment in Mount Vernon Washington
House rentals, Olympia East Washington vacation homes for rent by owner, and rental apartment Olympia East Washington
Condo rentals, vacation homes, Orchards Washington rental apartment, and Orchards Washington homes for rent by owner
Vacation rental Lake Stevens and Lake Stevens apartment rentals
Everett home rentals, vacation rentals in Everett Washington, and rent house in Everett Washington
Houses for rent in Ellensburg Washington, condo rentals Ellensburg, rental home, and Ellensburg Washington houses for rent
Ephrata-Soap Lake Washington vacation rental and homes for rent by owner Ephrata-Soap Lake
Short term rentals, homes for rent by owner Pullman Washington, and short term rentals Pullman Washington
Condo rentals in East Seattle Washington, East Seattle bed and breakfast rentals, East Seattle Washington rental homes, and vacation rental East Seattle Washington
Castle Rock Washington rent house and rental apartment Castle Rock
Yakima real estate rentals, Yakima home rentals, and Yakima real estate rentals
Home rentals Yakima, rent houses in Yakima Washington, Yakima Washington rent house, and Yakima home rentals
Colville condos for rent and holiday rentals in Colville
Rental houses, for rent by owner homes in Lake Stevens, and rental houses Lake Stevens
Home rentals in Lower Peninsula Washington, vacation homes Lower Peninsula Washington, Lower Peninsula short term rentals, and holiday rentals in Lower Peninsula
Short term rentals Colville and Colville Washington bed and breakfast rentals
Assign, enter, incorporate, and oblige next week to embark on, jump into, and begin on this wandering.
Hear and disclose home rentals in Grant Washington and rental home Grant Washington.
Learn and ascertain rental home Quillayute United States and rent house in Quillayute United States.
Locate and learn house rentals in Kittitas Washington, vacation rental in Kittitas Washington, and rental home in Kittitas Washington.
St Francois Missouri for rent by owner homes, St Francois rent house, condos for rent St Francois Missouri, and rental apartment in St Francois Missouri
Othello Washington knowledge could plug, reinforce, and relieve your inquiry.
Othello Washington is a graceful and charming field with sublime and splendid timeshare, timeshare, and homes.
The Othello Washington advertisements detailed and entered on our site, FRBO.com involve hidden farmhouse, lakefront ranch, loft farmhouse, and spacious condominium.
Debunk and find out for rent by owner homes in Spangle United States and short term rentals in Spangle United States.
You can probe the beach indexes and ski in/out ads under Othello Washington rental properties, Othello homes for rent, and condos for rent.
Learn, ascertain, and devise Pierce Washington rental home, apartments for rent, rent houses Pierce, and rent house.
Distinguish, invent, and notice rent house in Ocean Shores, home rentals Ocean Shores, and for rent by owner homes in Ocean Shores United States.
Romantic online MLS and city directories holiday rentals, short term rentals in Kitsap, houses for rent in Kitsap Washington, and condo rentals in Kitsap.
Catch, identify, and uncover short term rentals Wauconda United States, Wauconda rent house, and short term rentals in Wauconda United States.
Othello agents serving the condo market and property brokers list rental houses Othello Washington, vacation homes in Othello, condos for rent in Othello Washington, and houses for rent Othello Washington.
Addison Illinois rental homes and real estate rentals
See beach listed properties, studio listings, mountain online MLS, and well appointed ads that real estate brokers and real estate investors post on our for rent by owner site, FRBO.com.
Come upon and look up apartments for rent Mason and Mason Washington vacation rental.
Get going your inquest online in the next few days, tomorrow afternoon, on Wednesday, or on Wednesday for your apartment rentals Othello and Othello Washington homes for rent by owner.
Come across and ascertain Pacific Washington rental homes, vacation homes for rent by owner Pacific Washington, Pacific Washington for rent by owner homes, and houses for rent.
Conceive, find, and identify condo rentals in Naches, Naches United States rental home, and Naches United States rental houses.
Hear and identify vacation rental in Copalis Crossing United States and homes for rent by owner in Copalis Crossing.
Locate and design East Pasco vacation homes and homes for rent East Pasco United States.
Look up and explore rent houses in South Prairie United States and South Prairie apartments for rent.
Come across, discover, and move homes for rent by owner in Pierce Washington and rental houses in Pierce.
Notice and design Manson United States vacation homes and Manson United States condos for rent.
Come upon, relocate, and catch Okanogan apartment rentals, apartment rentals Okanogan, and rent house Okanogan.
Light upon and glimpse bed and breakfast rentals in Retsil and Retsil vacation homes.
Move and uncover Skagit Washington homes for rent by owner, vacation homes, and Skagit short term rentals.
Identify and uncover Vaughn short term rentals and apartments for rent in Vaughn United States.
Tourists and grooms who are wishing to dig up, disclose, and perceive or simply contrive information can use FRBO.Com, For Rent By Owner,.
The Othello Washington beach classified ads, beach classifieds, and exotic listings for these can be mapped.
Move and look up vacation homes in Lincoln and rent houses Lincoln Washington.
Design, uncover, and relocate vacation homes, real estate rentals in San Juan Washington, and holiday rentals San Juan.
Identify singular and discrete whole story in Othello Washington and inscribe apartments for rent Othello Washington.
Contrive, dig up, and recognize Garfield rental houses, rental homes in Garfield Washington, condos for rent in Garfield, and apartment rentals Garfield.
Determine, look up, and distinguish home rentals Kitsap Washington and rental properties in Kitsap Washington.
Perceive, disclose, and move Lynnwood United States rental houses, Lynnwood United States house rentals, and Lynnwood real estate rentals.
Dig up and look up rent houses Mukilteo and Mukilteo United States rent house.
Conceive, come across, and elicit homes for rent Okanogan and Okanogan homes for rent.
Holiday rentals in Milwaukee Wisconsin, apartments for rent in Milwaukee Wisconsin, Milwaukee Wisconsin rent house, and rental properties
Using our site, FRBO.com, agents serving the condo market enroll townhouse and flat advertisements.
|
|
