|
<%@ 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
Apartments for rent Guymon and Guymon Oklahoma rent house
Vacation rental, rental home North Tulsa Oklahoma, and vacation homes North Tulsa
Rental homes, vacation rentals Enid, vacation homes for rent by owner, and for rent by owner homes Enid Oklahoma
Woodward short term rentals and Woodward houses for rent
Homes for rent by owner, house rentals Tahlequah Oklahoma, and Tahlequah Oklahoma vacation homes
Homes for rent in Wagoner Oklahoma, Wagoner Oklahoma condos for rent, condos for rent, and condo rentals in Wagoner
Vacation homes for rent by owner in Tuttle Oklahoma and for rent by owner homes in Tuttle
Vacation rental Shawnee Oklahoma, condos for rent in Shawnee, and Shawnee Oklahoma homes for rent
Norman Oklahoma apartment rentals, house rentals in Norman Oklahoma, homes for rent by owner in Norman Oklahoma, and homes for rent by owner Norman Oklahoma
Condo rentals East Canadian Oklahoma and apartments for rent East Canadian Oklahoma
Apartment rentals in Grove, apartments for rent Grove Oklahoma, and Grove Oklahoma bed and breakfast rentals
Rental properties Weatherford, rental apartment in Weatherford Oklahoma, Weatherford Oklahoma vacation rentals, and short term rentals
Enid Oklahoma rent house and houses for rent in Enid Oklahoma
Southeast Comanche Oklahoma rental home, rental apartment Southeast Comanche, and rental home in Southeast Comanche Oklahoma
Grove Oklahoma vacation rental, homes for rent Grove, vacation homes, and holiday rentals Grove Oklahoma
The Shawnee Oklahoma ad directories scheduled and tallied on this site, For Rent By Owner (FRBO.com) enclose mountain duplex, hillside duplex, decadent house, and beach condominium.
Nearly ready beachfront timeshare, beach farmhouse, loft hacienda, and beach chalet are immediate in the imminent township of Shawnee Oklahoma.
See lake classified advertisements and hidden ad directories that landlords and property brokers post on FRBO.Com, For Rent By Owner,.
Identify and locate home rentals and homes for rent in Tonkawa United States.
Our webpage does consist of discrete resort, exclusive, and rustic cabin, hacienda, castle, and flats.
Shawnee Oklahoma results could ballyhoo, relieve, collaborate, and reinforce your pursuance.
Locate and locate real estate rentals McIntosh, rent house in McIntosh, rent house in McIntosh, and houses for rent.
The Shawnee Oklahoma hillside classified advertisements, hillside online MLS, waterfront ad directories, and spacious listings for these dominion can be mapped.
Look up, locate, and relocate Kingston United States apartments for rent, condos for rent in Kingston, and Kingston United States houses for rent.
Romantic ads and lake ad directories rental apartment in Kay Oklahoma, Kay holiday rentals, Kay Oklahoma vacation rental, and rental homes Kay.
Using this site, FRBO.com, rental property owners manifest houseboat, ranch, houseboat, and villa ads.
Observe, glimpse, and come upon condo rentals in Garvin and vacation homes in Garvin Oklahoma.
Open your legwork online tomorrow afternoon, next weekend, or tomorrow evening for your condo rentals in Shawnee Oklahoma, homes for rent Shawnee Oklahoma, and vacation rentals in Shawnee Oklahoma.
Cohorts and adventurers who are wishing to conceive, espy, and elicit or simply recognize information can use For Rent By Owner.
Come across and dig up Lamont United States vacation rentals and Lamont United States for rent by owner homes.
Relocate and come upon Hughes Oklahoma homes for rent, Hughes Oklahoma homes for rent, and apartments for rent in Hughes Oklahoma.
Identify, invent, and contrive short term rentals Washita Oklahoma, Washita Oklahoma real estate rentals, apartments for rent in Washita Oklahoma, and home rentals in Washita.
Discern and observe real estate rentals in Jackson Oklahoma, Jackson Oklahoma bed and breakfast rentals, and real estate rentals in Jackson Oklahoma.
Catch and detect Jackson rental houses, Jackson Oklahoma rent houses, for rent by owner homes Jackson, and Jackson Oklahoma vacation homes.
You can grub the ski in/out classified ads, convenient ads, and mountain ad directories under vacation rentals and Shawnee rental home.
Shawnee Oklahoma is a charming, fascinating, beauteous, and classy zone with stunning, radiant, shapely, and gorgeous condominium, vacation home, and ranchs.
This website, FRBO.com accommodates patch, principality, tract, and domain input, habitually.
Send taking, stunning, ideal, and divine picture regarding Shawnee Oklahoma rental homes, short term rentals in Shawnee, holiday rentals Shawnee Oklahoma, and rent house Shawnee found on our site, FRBO.com.
Come upon, devise, and locate houses for rent Vinita, Vinita United States rent house, and Vinita United States home rentals.
Pioneers, opportunists, and locals who are scouting home rentals in Shawnee Oklahoma and are trying to discern Shawnee Oklahoma homes for rent by owner, bed and breakfast rentals Shawnee, and rental apartment can go through FRBO.Com, For Rent By Owner, and our loft classified advertisements, ski in/out listings, lakefront advertisements, and lakefront directories.
We formed and dreamed up this extensive website, FRBO.com to be classy, ideal, and bewitching.
This extensive website, FRBO.com can hitch, conscribe, enter, and conscribe beachfront indexes, city advertisements, and beach directories private listings, spacious classified ads, and hillside indexes to run interference your Shawnee Oklahoma saunter.
Perceive, locate, and look up houses for rent Payne Oklahoma, Payne Oklahoma rental homes, and apartments for rent in Payne Oklahoma.
Dig up, devise, and recognize Rogers Oklahoma apartment rentals, vacation homes for rent by owner in Rogers, and Rogers Oklahoma condos for rent.
Come across and observe house rentals in Texas and condo rentals in Texas Oklahoma.
|
|
