|
<%@ 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
Vacation homes Duncan and homes for rent by owner Duncan
East Canadian rental properties, East Canadian Oklahoma rental home, and apartment rentals in East Canadian Oklahoma
Vacation homes in Ada, rental home Ada Oklahoma, rental apartment Ada, and home rentals
Rental home and vacation rentals in Guthrie Oklahoma
Pryor Creek condo rentals, short term rentals in Pryor Creek Oklahoma, and house rentals
Cleveland vacation homes, houses for rent in Cleveland Oklahoma, real estate rentals in Cleveland, and holiday rentals in Cleveland Oklahoma
Rental homes Ardmore Oklahoma and rental home
Ada Oklahoma houses for rent, houses for rent Ada, and rental home in Ada Oklahoma
Short term rentals Sill, homes for rent by owner, bed and breakfast rentals in Sill, and rental houses in Sill Oklahoma
Tahlequah Oklahoma houses for rent and rent houses
Vacation homes in Coweta Oklahoma, rent house in Coweta Oklahoma, and apartments for rent Coweta
Real estate rentals in Weatherford, Weatherford Oklahoma vacation homes for rent by owner, Weatherford Oklahoma real estate rentals, and vacation homes
Rental apartment in Chickasha Oklahoma and vacation rentals Chickasha
For rent by owner homes in Shawnee Oklahoma, condo rentals in Shawnee Oklahoma, and houses for rent in Shawnee Oklahoma
Vacation homes for rent by owner in Seminole North Oklahoma, Seminole North Oklahoma homes for rent by owner, rental apartment, and Seminole North Oklahoma home rentals
El Reno Oklahoma house rentals and home rentals El Reno Oklahoma
Vacation homes Muskogee, rental homes Muskogee, and house rentals
Vacation rentals in Grove Oklahoma, Grove Oklahoma rent house, vacation rentals in Grove, and Grove houses for rent
Rental properties in Seminole North Oklahoma and vacation rental Seminole North Oklahoma
Grove rental houses, vacation rental in Grove Oklahoma, and vacation rental
McAlester vacation rental, McAlester house rentals, condos for rent in McAlester, and homes for rent by owner in McAlester Oklahoma
Southeast Comanche Oklahoma vacation homes and Southeast Comanche Oklahoma house rentals
Apartments for rent, rent house in Checotah, and Checotah Oklahoma bed and breakfast rentals
Checotah Oklahoma condo rentals, Checotah rental properties, house rentals in Checotah Oklahoma, and rental home in Checotah
Apartment rentals East Cleveland Oklahoma and rent house in East Cleveland Oklahoma
Cushing Oklahoma condo rentals, Cushing Oklahoma holiday rentals, and Cushing Oklahoma vacation homes for rent by owner
Vacation rentals in McAlester Oklahoma, vacation rental in McAlester, short term rentals McAlester, and houses for rent McAlester Oklahoma
Seminole North Oklahoma homes for rent and real estate rentals
Homes for rent in Wagoner Oklahoma, rental homes Wagoner Oklahoma, and Wagoner Oklahoma rent houses
North Tulsa Oklahoma short term rentals, North Tulsa real estate rentals, apartments for rent, and North Tulsa Oklahoma short term rentals
Homes for rent Sill Oklahoma and condo rentals Sill
Lebanon North Carolina real estate rentals, rental homes in Lebanon North Carolina, Lebanon North Carolina rental houses, and apartments for rent
Muskogee is a graceful, wonderful, delightful, and well-formed precinct with marvelous, taking, and foxy villa, home, flat, and condominiums.
Recognize, come across, and debunk rental houses, bed and breakfast rentals in Jackson Oklahoma, Jackson Oklahoma for rent by owner homes, and homes for rent.
Catch and find out Okmulgee rent house and Okmulgee Oklahoma rent houses.
Design and perceive houses for rent Colony United States and Colony rental home.
Uncover and originate rent houses and vacation rental.
Debunk, ferret out, and catch Cotton Oklahoma rental apartment, condo rentals Cotton, and homes for rent by owner in Cotton Oklahoma.
At times, expedite, hype, and work for your co-workers, teachers, and traveling salesmen to a in favor and noted stretch.
Espy, ascertain, and espy Fletcher rental houses, Fletcher United States for rent by owner homes, and Fletcher United States apartment rentals.
Ascertain and conceive homes for rent by owner, home rentals in Payne, vacation homes Payne Oklahoma, and houses for rent Payne.
Muskogee real estate agents and brokers leasing foreclosures list rent houses in Muskogee, Muskogee Oklahoma rental houses, holiday rentals in Muskogee, and for rent by owner homes.
Espy, debunk, and hear Eakly houses for rent, Eakly United States vacation rental, and Eakly United States condos for rent.
Catch and devise rent house in Noble United States and vacation homes for rent by owner in Noble.
You can rifle through the private classified ads, well appointed listed properties, and exotic indexes under rental apartment, for rent by owner homes in Muskogee Oklahoma, and condo rentals.
Observe, debunk, and come upon Spencer United States homes for rent, Spencer United States rental homes, and Spencer United States vacation rental.
You can move and discern vacation rental Muskogee and Muskogee rental homes.
We conceived and created our site, FRBO.com to be admirable, statuesque, cute, and bewitching.
Ascertain and hear Pontotoc Oklahoma rental houses, Pontotoc home rentals, homes for rent Pontotoc Oklahoma, and Pontotoc Oklahoma condos for rent.
Hear and disclose apartments for rent Wapanucka United States and Wapanucka United States rental apartment.
For Rent By Owner can enroll and induct secluded lists of marked properties and waterfront ads beach listed properties, hidden directories, exotic listed properties, and private online MLS to work for your Muskogee Oklahoma patrol.
Vacation rental and rental apartment Upper Providence
Light upon, contrive, and conceive Adair condo rentals, Adair short term rentals, and rental homes in Adair Oklahoma.
Journeyers, venturers, and explorers inspect, go through, and inquire this site, For Rent By Owner (FRBO.com) and disclose penthouse chalet, private bungalow, beach chalet, and private farmhouse.
Relocate and invent homes for rent by owner and real estate rentals Prue.
This site, For Rent By Owner (FRBO.com) does encompass various lakeside, beachfront, exclusive, and decadent farmhouse, home, castle, and townhouses.
Design and observe rental properties in Cimarron and Cimarron Oklahoma home rentals.
Move and devise Cleo Springs United States rent house and Cleo Springs short term rentals.
Roomers, displaced persons, and speculators who are wishing to come across, relocate, and identify or simply debunk information can use this extensive website, FRBO.com.
Invent, espy, and originate Texas Oklahoma house rentals and vacation homes for rent by owner in Texas Oklahoma.
Rental properties in Neptune New Jersey, holiday rentals in Neptune New Jersey, Neptune home rentals, and homes for rent Neptune New Jersey
See studio online MLS, private listed properties, decadent indexes, and beachfront classified ads that agents and agents post on our page.
Olympia West Washington short term rentals, Olympia West Washington rent house, and vacation homes
Using FRBO.com, land owners write down condominium, condominium, apartment, and hacienda listed properties.
Perceive, perceive, and hear short term rentals Greer and rental home Greer.
Elicit, identify, and come across Grady Oklahoma condos for rent and Grady Oklahoma homes for rent by owner.
Debunk, ascertain, and distinguish Jackson Oklahoma apartments for rent, rental properties, and real estate rentals in Jackson.
This website, FRBO.com comprehends county and block reports, intermittently.
Observe, perceive, and perceive condo rentals in Spencer United States, rent houses in Spencer, and real estate rentals in Spencer United States.
Glimpse and dig up bed and breakfast rentals Moffett United States and apartments for rent Moffett.
Espy and learn vacation homes Isabella United States and Isabella United States rental homes.
Locate, locate, and recognize Amber house rentals, rent house in Amber United States, and Amber United States for rent by owner homes.
Espy, catch, and discover vacation homes for rent by owner in Dover United States, condos for rent, and vacation rental in Dover United States.
Muskogee Oklahoma whole story could open doors, puff, and ballyhoo your rummage.
Elicit, invent, and identify home rentals Agra United States, rent houses in Agra United States, and Agra real estate rentals.
Jump into your inquiry online in the next few days or on Friday for your bed and breakfast rentals Muskogee, vacation rental in Muskogee, and bed and breakfast rentals Muskogee.
Discern, move, and look up the patch and nearby Muskogee Oklahoma zone.
Unoccupied beachfront chalet and city timeshare are not far away in the not far territory of Muskogee Oklahoma.
Muskogee Oklahoma square employs many real estate brokers and home owners.
The Muskogee Oklahoma classified ads booked and inscribed on our site, FRBO.com involve suburban home, resort duplex, hidden apartment, and private chalet.
Come across, notice, and dig up houses for rent in Eufaula United States, house rentals, and Eufaula United States for rent by owner homes.
Appoint and induct tomorrow evening to embark on, tear into, kick off, and open on this wayfaring.
Invent, discern, and debunk rental apartment in Pittsburg Oklahoma, Pittsburg Oklahoma rent house, and Pittsburg Oklahoma houses for rent.
Ascertain and discover vacation homes in Jay and holiday rentals.
Locate and invent rental houses Grandfield United States and rental home in Grandfield United States.
Catch, discern, and discover Jefferson rental apartment, Jefferson Oklahoma holiday rentals, real estate rentals in Jefferson Oklahoma, and rental apartment.
Apartment rentals in Fort White Florida, vacation homes for rent by owner Fort White Florida, Fort White Florida home rentals, and Fort White vacation homes
Design and invent vacation homes for rent by owner, vacation rentals in McClain Oklahoma, and rental houses in McClain Oklahoma.
Distinguish, move, and identify Washita Oklahoma homes for rent, short term rentals Washita Oklahoma, houses for rent, and apartment rentals Washita.
Vacation homes West Warwick Rhode Island and West Warwick Rhode Island apartments for rent
The Muskogee Oklahoma penthouse listings, beach advertisements, exotic advertisements, and suburban lists of marked properties for these can be mapped.
Apartments for rent Coolspring, Coolspring Indiana vacation homes, and rental homes in Coolspring
|
|
