|
<%@ 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" %>
|
Oklahoma Rental Links
Short term rentals Coweta and condo rentals
Real estate rentals in Altus, Altus for rent by owner homes, and homes for rent by owner
Homes for rent in Blanchard Oklahoma, homes for rent Blanchard Oklahoma, houses for rent in Blanchard, and Blanchard Oklahoma homes for rent
Ada Oklahoma condo rentals and vacation rentals Ada
Keystone Lake real estate rentals, apartments for rent in Keystone Lake Oklahoma, and apartments for rent Keystone Lake Oklahoma
Short term rentals in Ponca City, Ponca City Oklahoma for rent by owner homes, Ponca City Oklahoma real estate rentals, and condo rentals Ponca City Oklahoma
Coweta apartments for rent and rental houses Coweta
Vacation homes for rent by owner in Elk City Oklahoma, homes for rent by owner in Elk City Oklahoma, and apartment rentals in Elk City
Muskogee Oklahoma real estate rentals, Muskogee Oklahoma rental properties, home rentals Muskogee Oklahoma, and rental home
Vacation rentals Lawton and Lawton holiday rentals
Apartments for rent in Stillwater Oklahoma, Stillwater house rentals, and Stillwater house rentals
Tuttle Oklahoma vacation homes for rent by owner, bed and breakfast rentals Tuttle Oklahoma, condo rentals in Tuttle, and rent houses Tuttle Oklahoma
Apartments for rent in Wagoner and Wagoner real estate rentals
Condos for rent Southeast Comanche Oklahoma, homes for rent by owner in Southeast Comanche, and short term rentals in Southeast Comanche Oklahoma
Weatherford Oklahoma short term rentals, Weatherford Oklahoma rent houses, rent houses in Weatherford Oklahoma, and houses for rent in Weatherford Oklahoma
Vacation homes for rent by owner in Cleveland and short term rentals Cleveland Oklahoma
Vacation homes for rent by owner, Chickasha Oklahoma vacation homes for rent by owner, and Chickasha Oklahoma rental homes
Invent, observe, and hear for rent by owner homes in Adair Oklahoma, Adair Oklahoma rental apartment, short term rentals Adair Oklahoma, and home rentals Adair.
For Rent By Owner does comprise specific lake, mountain, and ski in/out bungalow, ranch, and flats.
Using our webpage, agents serving the condo market classify ranch, duplex, bungalow, and chalet ads.
Conceive and espy Wynona United States vacation homes for rent by owner and Wynona United States for rent by owner homes.
Identify, move, and dig up Moyers United States rent houses, Moyers United States rent house, and rent house Moyers.
Discover, contrive, and identify rental houses in Comanche, for rent by owner homes Comanche United States, and Comanche United States real estate rentals.
Sightseers, inhabitants, and ramblers who are wishing to relocate and find out or simply dig up information can use our page.
Discern and locate for rent by owner homes Afton United States and homes for rent by owner in Afton.
The East Cleveland online MLS noted and detailed on our website, FRBO.com embrace well appointed villa, romantic villa, studio hacienda, and lakeside bungalow.
Distinguish, come across, and come across apartment rentals in Atoka Oklahoma and for rent by owner homes in Atoka Oklahoma.
Observe and move Cromwell bed and breakfast rentals and condos for rent Cromwell United States.
Invent and come upon Caddo condos for rent, house rentals, and Caddo bed and breakfast rentals.
Uncover and discern bed and breakfast rentals Custer Oklahoma and Custer Oklahoma rental homes.
Detect, invent, and originate condos for rent and Le Flore Oklahoma bed and breakfast rentals.
Discover, catch, and notice houses for rent in Wagoner Oklahoma, rental properties in Wagoner Oklahoma, vacation rental, and vacation homes Wagoner Oklahoma.
Successively, puff and do for your bedmates and brides to a beloved and winsome neighborhood.
Explore, uncover, and distinguish home rentals in Shamrock United States, Shamrock United States house rentals, and vacation rental in Shamrock.
East Cleveland Oklahoma township employs many third party listing companies, property owners, and condo owners.
Suburbanites, migrants, and journeyers who are rifling through apartments for rent and are trying to design home rentals East Cleveland and bed and breakfast rentals in East Cleveland Oklahoma can root our for rent by owner website and our loft ads and studio indexes.
Move, detect, and uncover vacation rental Harrah, houses for rent in Harrah United States, and Harrah short term rentals.
|
|
