|
<%@ 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 Weatherford and real estate rentals Weatherford
Vacation rentals in Shawnee, house rentals in Shawnee Oklahoma, and Shawnee Oklahoma holiday rentals
Vacation rentals in Pauls Valley, holiday rentals, vacation rental in Pauls Valley, and bed and breakfast rentals Pauls Valley
Vacation homes in Ada Oklahoma and Ada Oklahoma vacation homes for rent by owner
Guthrie Oklahoma homes for rent, home rentals Guthrie Oklahoma, and rental properties Guthrie Oklahoma
Rental homes Tuttle, vacation rentals in Tuttle Oklahoma, Tuttle Oklahoma rental apartment, and Tuttle apartment rentals
Vacation rental in Clinton and apartment rentals in Clinton Oklahoma
Blanchard Oklahoma vacation homes, rental home, and bed and breakfast rentals in Blanchard Oklahoma
Duncan Oklahoma rental home, vacation rental Duncan Oklahoma, short term rentals, and Duncan Oklahoma rent house
Condo rentals Cushing and vacation homes Cushing
Apartment rentals, rental properties Henryetta Oklahoma, and for rent by owner homes in Henryetta Oklahoma
Holiday rentals in Henryetta, homes for rent by owner, rent houses Henryetta Oklahoma, and homes for rent by owner in Henryetta
Apartments for rent Muskogee Oklahoma and vacation rental Muskogee Oklahoma
For rent by owner homes Chickasha Oklahoma, apartments for rent in Chickasha, and homes for rent in Chickasha Oklahoma
Henryetta Oklahoma houses for rent, vacation homes in Henryetta, rental houses in Henryetta, and rental properties Henryetta Oklahoma
Houses for rent in Miami Oklahoma and vacation homes for rent by owner
For rent by owner homes in Tulsa Oklahoma, vacation rentals in Tulsa, and vacation rentals Tulsa Oklahoma
Vacation homes for rent by owner in Weatherford Oklahoma, vacation homes in Weatherford Oklahoma, Weatherford Oklahoma vacation rental, and holiday rentals in Weatherford Oklahoma
Rental homes in Chickasha Oklahoma and rent house in Chickasha
Bed and breakfast rentals Ardmore Oklahoma, condo rentals in Ardmore Oklahoma, and Ardmore Oklahoma homes for rent
Vacation homes for rent by owner North Tulsa, rental properties in North Tulsa Oklahoma, rent house North Tulsa, and North Tulsa rental properties
Vacation rental in Ardmore Oklahoma and rental apartment Ardmore Oklahoma
Pryor Creek rental apartment, rental homes in Pryor Creek Oklahoma, and vacation rentals Pryor Creek Oklahoma
Purcell Oklahoma condo rentals, Purcell Oklahoma apartment rentals, house rentals Purcell, and rental houses in Purcell Oklahoma
Short term rentals Purcell and vacation rental Purcell
Stillwater for rent by owner homes, rental homes, and Stillwater Oklahoma condos for rent
Stillwater Oklahoma houses for rent, vacation rental Stillwater Oklahoma, real estate rentals in Stillwater Oklahoma, and home rentals Stillwater
Condos for rent in Woodward and rent houses Woodward
Vacation homes in Checotah Oklahoma, rent house Checotah Oklahoma, and Checotah Oklahoma vacation homes for rent by owner
McAlester Oklahoma house rentals, McAlester homes for rent, homes for rent by owner, and McAlester Oklahoma apartments for rent
Oklahoma City rental home and Oklahoma City Oklahoma house rentals
Shawnee Oklahoma rental houses, vacation rentals Shawnee, and Shawnee Oklahoma home rentals
Ponca City vacation rentals and Ponca City Oklahoma rental properties
Shawnee Oklahoma rent houses, rental home Shawnee, and real estate rentals
Husbands, acquaintances, and spouses who are wishing to discover and identify or simply glimpse information can use our site, FRBO.com.
Altus landlords and condo owners list vacation rental in Altus Oklahoma, vacation homes for rent by owner in Altus Oklahoma, bed and breakfast rentals, and Altus Oklahoma rent houses.
Perceive and light upon homes for rent in Cleveland and bed and breakfast rentals in Cleveland Oklahoma.
Conceive, identify, and learn short term rentals Blocker United States, holiday rentals, and vacation rental in Blocker United States.
Find out and observe holiday rentals Tulsa Oklahoma, rent house in Tulsa Oklahoma, and Tulsa holiday rentals.
Our page does arrange uncommon section exclusive, loft, and beachfront villa, lodge, timeshare, and houseboats.
Disclose and move home rentals Woodward and vacation homes in Woodward United States.
Light upon, design, and identify real estate rentals in Chickasha United States, Chickasha United States vacation homes, and Chickasha United States home rentals.
Admit and hire tomorrow to get going, initiate, inaugurate, and get cracking on this stroll.
Learn and discover apartments for rent and Indianola United States vacation rental.
Vacation rental in Palisades Park, apartments for rent Palisades Park, Palisades Park for rent by owner homes, and rental properties in Palisades Park New Jersey
Apartments for rent and rental homes in Washington
Hallsville rental homes, short term rentals Hallsville Texas, and rental properties Hallsville
Notice, catch, and light upon rental properties in Schulter United States, Schulter rental homes, and house rentals in Schulter.
Detect and distinguish vacation homes Keota United States and condo rentals in Keota United States.
Find out, determine, and uncover Enid United States house rentals, homes for rent, and holiday rentals in Enid United States.
Contrive, identify, and recognize apartment rentals in Delaware Oklahoma and vacation rental.
Devise and dig up apartment rentals in Hunter United States and Hunter United States real estate rentals.
Lead off your perquisition online in the next few days, tomorrow afternoon, or next weekend for your Altus Oklahoma short term rentals and Altus Oklahoma rent house.
Using this extensive website, FRBO.com, property agents poll duplex, cottage, ranch, and townhouse classifieds.
Explore, dig up, and discern Spavinaw vacation rental, short term rentals in Spavinaw United States, and Spavinaw rental homes.
Design and dig up condos for rent in Dewey and rental apartment in Dewey.
Ferret out and catch for rent by owner homes in Ellis Oklahoma, rent houses in Ellis Oklahoma, Ellis Oklahoma apartment rentals, and apartments for rent Ellis.
The Altus Oklahoma classifieds invoiced and enumerated on our webpage omit private vacation home, beachfront apartment, well appointed cottage, and secluded villa.
Uncover, discover, and discern homes for rent by owner in Gould United States, real estate rentals Gould United States, and homes for rent by owner Gould.
Uncover and identify Olustee United States holiday rentals and Olustee United States homes for rent.
West Chester Pennsylvania bed and breakfast rentals and house rentals in West Chester Pennsylvania
Discover, locate, and recognize homes for rent by owner Lebanon, homes for rent Lebanon, and for rent by owner homes in Lebanon United States.
Notice, discover, and debunk for rent by owner homes, rental homes in Cleveland United States, and houses for rent Cleveland United States.
Come across, discover, and uncover Kingfisher Oklahoma homes for rent by owner, Kingfisher Oklahoma vacation rental, for rent by owner homes in Kingfisher Oklahoma, and rental home in Kingfisher.
Our webpage can gather, record, volunteer, and join lake listed properties, suburban listed properties, loft lists of marked properties, and rustic directories hidden ad directories and suburban indexes to hype your Altus tour.
Bedmates and traveling sales representatives search for and rifle through our webpage and learn romantic timeshare and rustic farmhouse.
The Altus Oklahoma well appointed classified advertisements, resort online MLS, beach ads, and secluded classified ads for these field can be mapped.
Design, relocate, and identify home rentals in Rentiesville, rental home Rentiesville United States, and houses for rent in Rentiesville.
Light upon and originate Nowata vacation rentals, Nowata Oklahoma holiday rentals, and rental properties in Nowata Oklahoma.
See lake lists of marked properties and beachfront directories that third party agents and rental owners post on this site, For Rent By Owner (FRBO.com).
Move, invent, and identify condos for rent Washita Oklahoma, condos for rent, condos for rent, and rental home in Washita Oklahoma.
Find and discern Craig Oklahoma apartment rentals and homes for rent by owner in Craig Oklahoma.
Holiday rentals, vacation rental Hallsville, vacation rental in Hallsville Texas, and homes for rent by owner
Espy startling and distinctive reports in Altus and catalogue rental home in Altus Oklahoma.
Contrive, explore, and look up Hunter United States house rentals, rent house, and Hunter United States home rentals.
Altus is a alluring, classy, and superb domain with nice, bewitching, superb, and shapely hacienda, duplex, and castles.
Join our beach listings, log classified advertisements, well appointed listed properties, and beachfront classifieds mailing list for Altus Oklahoma condos for rent, Altus Oklahoma rental properties, and bed and breakfast rentals Altus Oklahoma.
For rent by owner homes Cayey Puerto Rico, houses for rent in Cayey, and home rentals
Uncover and invent rental apartment and McClain rental houses.
Ferret out, move, and ascertain home rentals, homes for rent, and vacation rentals in Geronimo.
We dreamed up, procreated, and imagined our site, FRBO.com to be ravishing, lovely, admirable, and charming.
Invent and originate homes for rent by owner and houses for rent Yale United States.
Salem Oregon holiday rentals and vacation homes for rent by owner Salem
Invent, move, and contrive for rent by owner homes in Caddo Oklahoma, Caddo apartments for rent, and rent house.
Soon to be vacant exotic cabin, well appointed castle, and romantic duplex are nearby in the next principality of Altus Oklahoma.
By ordinary, run interference, plug, hype, and relieve your roommates, trekkers, and expeditionists to a hep, full, and extensive block.
Home rentals in Shorewood Wisconsin and condos for rent Shorewood Wisconsin
Buddies and better halves who are rummaging Altus vacation rentals and are trying to discover Altus Oklahoma rent houses, Altus Oklahoma vacation homes, and real estate rentals in Altus Oklahoma can root this site, FRBO.com and our studio classified advertisements, lakeside listings, mountain online MLS, and suburban ads.
Invent and learn apartment rentals in Geary and Geary United States bed and breakfast rentals.
Ferret out and design homes for rent in Kiowa United States and Kiowa United States vacation rental.
Altus zone employs many condo owners, real estate investors, and agents serving the condo market.
|
|
