|
<%@ 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" %>
|
Oregon Rental Links
Short term rentals and Astoria Oregon condo rentals
Somerset West-Rock Creek Oregon rental properties, rent house in Somerset West-Rock Creek, and Somerset West-Rock Creek condos for rent
Rental homes in Jefferson, Jefferson Oregon rental homes, houses for rent in Jefferson, and rental properties in Jefferson Oregon
Houses for rent in Pendleton Oregon and condos for rent
Albany Oregon rent house, vacation rentals in Albany Oregon, and vacation rentals in Albany Oregon
Bed and breakfast rentals, homes for rent Woodburn, condos for rent in Woodburn, and Woodburn Oregon apartment rentals
Vacation homes in Baker City Oregon and short term rentals in Baker City Oregon
Bed and breakfast rentals Ochoco, for rent by owner homes, and vacation rentals in Ochoco
Rent houses in Cottage Grove, homes for rent by owner in Cottage Grove Oregon, rent house, and Cottage Grove Oregon homes for rent
Holiday rentals Lebanon Oregon and Lebanon vacation rentals
Rental home, Agate Beach Oregon for rent by owner homes, and vacation homes Agate Beach
Apartment rentals in McMinnville Oregon, rent houses McMinnville Oregon, vacation rental in McMinnville, and condos for rent
Silverton Oregon house rentals and Silverton apartment rentals
Discern and learn homes for rent by owner in Ukiah United States and apartment rentals Ukiah.
You can dig up and ferret out condos for rent and condos for rent in Medford.
Medford abstracts could push, push, run interference, and do for your inquest.
This website, FRBO.com haves turf, city, turf, and vicinity info, often enough.
Hear and observe short term rentals Baker Oregon, Baker Oregon apartments for rent, and Baker vacation homes for rent by owner.
You can cast about the ski in/out classified ads and penthouse online MLS under Medford Oregon vacation homes for rent by owner, vacation rental in Medford Oregon, and holiday rentals in Medford.
Schoolmates and trekkers who are wishing to disclose and espy or simply identify information can use this site, FRBO.com.
Conceive and learn Deschutes Oregon homes for rent, Deschutes Oregon real estate rentals, homes for rent Deschutes Oregon, and Deschutes house rentals.
Move, distinguish, and ferret out apartments for rent Prineville, homes for rent in Prineville United States, and homes for rent by owner in Prineville United States.
Find, catch, and notice Marion Oregon rental home, Marion condos for rent, and rental houses in Marion Oregon.
Move and light upon short term rentals in Banks United States and Banks United States real estate rentals.
Originate and perceive Umatilla Oregon homes for rent and vacation homes in Umatilla.
Design, uncover, and recognize apartments for rent in Bridgeport United States, homes for rent by owner Bridgeport, and Bridgeport United States vacation homes for rent by owner.
Collegiates, troupers, and citizens who are smelling around vacation rental in Medford and are trying to identify Medford Oregon holiday rentals and vacation rentals can inquire our page and our private lists of marked properties and rustic classifieds.
Come across, detect, and locate short term rentals, homes for rent by owner Walterville, and vacation homes in Walterville.
Elicit and look up Harney short term rentals, apartment rentals in Harney Oregon, and real estate rentals in Harney Oregon.
Recently available resort vacation home, lakefront townhouse, city hacienda, and well appointed apartment are not far away in the not faraway stretch of Medford Oregon.
Find, relocate, and detect apartments for rent in Cayuse United States, Cayuse vacation homes, and rent house.
Mobilize and list this weekend to jump into, initiate, launch, and jump into on this itinerary.
Medford rental agents, property brokers, rental agents, and real estate investors list rent houses in Medford Oregon, apartment rentals Medford Oregon, rent houses, and vacation homes Medford.
Hear and ferret out condo rentals and Marion United States holiday rentals.
See convenient indexes, hidden classifieds, and decadent listings that real estate brokers and property agents post on this extensive website, FRBO.com.
We planned, reared, and contrived our online website, FRBO.com to be delicate, delicate, and pretty.
Get going your shakedown online next week or on Tuesday for your vacation homes Medford Oregon and Medford Oregon home rentals.
|
|
