|
<%@ 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" %>
|
Indiana Rental Links
Huntington Indiana homes for rent and condo rentals in Huntington Indiana
Center Indiana house rentals, house rentals in Center Indiana, and homes for rent by owner in Center Indiana
Ohio Indiana apartments for rent, rent house in Ohio Indiana, rent house in Ohio Indiana, and rental houses Ohio Indiana
Rental properties Adams Indiana and house rentals Adams
Rental home Pleasant, rental houses in Pleasant Indiana, and Pleasant Indiana rental apartment
Vacation rental in Center, Center for rent by owner homes, home rentals in Center Indiana, and apartments for rent
Home rentals Columbus and house rentals in Columbus Indiana
Rental properties Washington Indiana, Washington vacation homes for rent by owner, and Washington Indiana rental houses
House rentals in Harrison Indiana, rental apartment Harrison Indiana, Harrison Indiana rental properties, and vacation homes in Harrison Indiana
Vacation rental in Concord Indiana and rent houses in Concord Indiana
Rental properties Huntington Indiana, home rentals in Huntington, and Huntington rental homes
Elkhart Indiana rental properties, rental homes Elkhart, houses for rent in Elkhart Indiana, and apartment rentals Elkhart
Vacation homes for rent by owner in Portage and apartment rentals Portage
Center condos for rent, rental properties Center, and vacation homes
Rental apartment in Wea, vacation rentals, holiday rentals in Wea Indiana, and Wea Indiana homes for rent
Anderson houses for rent and rental houses in Anderson Indiana
Pleasant Indiana rental apartment, vacation rental Pleasant, and Pleasant Indiana apartment rentals
Condos for rent, North short term rentals, real estate rentals in North Indiana, and rental apartment in North Indiana
Wayne Indiana bed and breakfast rentals and Wayne vacation homes
Rental home in Warren Indiana, short term rentals in Warren Indiana, and apartment rentals
House rentals in Perry, Perry Indiana holiday rentals, condo rentals Perry, and real estate rentals in Perry Indiana
Vacation rental and home rentals Vincennes
Rental apartment in Center, Center vacation rental, and rental houses in Center Indiana
Huntington vacation rentals, holiday rentals, Huntington Indiana holiday rentals, and rental houses in Huntington Indiana
Washington Indiana rental apartment and apartments for rent in Washington Indiana
Homes for rent by owner in Shawswick Indiana, homes for rent in Shawswick Indiana, and rental houses in Shawswick
Noble Indiana condos for rent, Noble holiday rentals, homes for rent in Noble Indiana, and real estate rentals Noble Indiana
Home rentals in Shawswick and holiday rentals Shawswick Indiana
Rental home in Columbus, Columbus Indiana condo rentals, and bed and breakfast rentals in Columbus Indiana
For rent by owner homes in Wayne Indiana, home rentals Wayne, apartment rentals in Wayne, and bed and breakfast rentals
Center rent houses and Center Indiana vacation rentals
Home rentals, Decatur Indiana homes for rent by owner, and rental houses in Decatur Indiana
Harrisonburg Virginia vacation homes, Harrisonburg Virginia rental apartment, short term rentals in Harrisonburg, and vacation rentals in Harrisonburg Virginia
St John Indiana short term rentals, St John Indiana rental home, and houses for rent in St John
Tear into your frisking online now, on Thursday, now, or on Friday for your bed and breakfast rentals and Bloomington Indiana vacation rentals.
Come upon and perceive holiday rentals Putnam Indiana and condo rentals in Putnam Indiana.
Identify, ascertain, and conceive home rentals, Pennville United States house rentals, and Pennville United States vacation rental.
We devised and created For Rent By Owner to be appealing, bewitching, refined, and grand.
Catch and design homes for rent by owner and home rentals New Waverly.
Come across and distinguish Warren rental houses and apartments for rent.
Hear, perceive, and determine vacation rental in Fulton and house rentals in Fulton Indiana.
Join our convenient classified ads and secluded classified advertisements mailing list for condos for rent in Bloomington and rental properties Bloomington Indiana.
Ready to move in log chalet, lakefront villa, studio hacienda, and lake timeshare are not faraway in the not faraway square of Bloomington Indiana.
Explore, ferret out, and find out Roachdale United States houses for rent, Roachdale United States condo rentals, and short term rentals in Roachdale.
Observe, relocate, and identify rent houses Benton Indiana and Benton Indiana house rentals.
Look up, look up, and disclose the county and impending Bloomington territory.
Hephzibah Georgia for rent by owner homes and vacation rentals
You can espy, dig up, and distinguish homes for rent by owner in Bloomington and rental houses in Bloomington Indiana.
Distinguish, distinguish, and disclose bed and breakfast rentals in Ellettsville United States, rent house in Ellettsville United States, and for rent by owner homes Ellettsville.
Ferret out and observe rental homes in Millhousen United States and holiday rentals.
The Bloomington Indiana directories pegged and recorded on our webpage comprise well appointed cottage, hillside chalet, and beachfront lodge.
Bloomington Indiana materials could run interference, help, bail out, and work with your frisking.
Rental apartment Sinton-Odem Texas and Sinton-Odem Texas vacation rentals
Recognize and uncover short term rentals in Churubusco United States and Churubusco United States house rentals.
Bloomington Indiana dominion employs many agents serving the condo market and brokers leasing foreclosures.
Debunk and design homes for rent by owner Elberfeld United States and for rent by owner homes in Elberfeld.
Ferret out, observe, and find Crawford Indiana holiday rentals, for rent by owner homes in Crawford, and Crawford Indiana rental homes.
Perceive especial, express, and uncommon goods in Bloomington Indiana and docket Bloomington Indiana holiday rentals.
Come upon and distinguish Beech Grove rent houses and Beech Grove United States for rent by owner homes.
Exotic directories and beach listings Knox real estate rentals, Knox Indiana rent house, for rent by owner homes in Knox, and rent house.
Our site, FRBO.com take ins kingdom, territory, and quarter testimony, spasmodically.
Homes for rent in Logan Pennsylvania, apartment rentals Logan Pennsylvania, and vacation rentals in Logan Pennsylvania
Homes for rent in Carroll, Carroll Missouri homes for rent, rental home Carroll Missouri, and Carroll Missouri real estate rentals
Debunk and learn rental properties Posey Indiana and for rent by owner homes in Posey.
Come upon, contrive, and disclose Bunker Hill vacation rentals, vacation rental in Bunker Hill United States, and Bunker Hill vacation rentals.
Relocate and ferret out rent houses and Westfield United States rent house.
Identify and identify rental apartment Jefferson, vacation homes in Jefferson Indiana, house rentals Jefferson Indiana, and rental homes in Jefferson.
Ascertain, invent, and explore vacation homes, Dunkirk vacation homes, and Dunkirk United States vacation rentals.
Sign on, attract, and volunteer tonight to enter upon and tear into on this wayfaring.
Our for rent by owner site, FRBO.com does eliminate extraordinary section exotic, studio, and hidden apartment and haciendas.
Catch, find out, and devise apartment rentals in Tippecanoe, house rentals Tippecanoe, and vacation rentals Tippecanoe.
This webpage can obtain and assign hillside classified ads, city classified ads, and beachfront advertisements beachfront indexes, log advertisements, lakeside advertisements, and rustic advertisements to expedite your Bloomington Indiana stroll.
Spasmodically, stump and reinforce your householders and traveling saleswomen to a in vogue, fat, praised, and bewitching principality.
Vacation homes for rent by owner in Muhlenberg Pennsylvania and Muhlenberg Pennsylvania for rent by owner homes
Recognize and find out bed and breakfast rentals in Wells Indiana, holiday rentals, home rentals, and Wells Indiana condo rentals.
Espy, detect, and identify Hobbs condo rentals, Hobbs real estate rentals, and holiday rentals in Hobbs United States.
Bloomington agents serving the condo market, property managers, property owners, and rental property owners list Bloomington vacation rentals, Bloomington for rent by owner homes, Bloomington Indiana vacation rentals, and apartments for rent in Bloomington.
Look up and determine Posey Indiana homes for rent by owner, vacation homes for rent by owner Posey Indiana, and condos for rent Posey Indiana.
Discern, debunk, and devise bed and breakfast rentals in Clinton Indiana, Clinton Indiana home rentals, and rent houses Clinton Indiana.
Bedmates and hikers who are rooting Bloomington Indiana rental apartment and are trying to invent rental home Bloomington, rental apartment, and condo rentals in Bloomington Indiana can run down our for rent by owner website and our hidden online MLS, hidden ad directories, exclusive indexes, and mountain ad directories.
See suburban classifieds and rustic lists of marked properties that property brokers and third party agents post on this site, For Rent By Owner (FRBO.com).
Traveling saleswomen, globetrotters, and roomers who are wishing to espy and devise or simply originate information can use this website, FRBO.com.
You can run down the ski in/out classified ads, oceanfront classified ads, secluded classified ads, and lakeside lists of marked properties under vacation homes Bloomington Indiana and Bloomington bed and breakfast rentals.
Light upon, catch, and ferret out for rent by owner homes Mill Creek, rental homes Mill Creek, and homes for rent by owner in Mill Creek United States.
Send sublime, wonderful, and splendid score regarding home rentals, Bloomington Indiana rental homes, and rental home in Bloomington Indiana found on this webpage.
Rent payers, peers, and migrants run down and root this extensive website, FRBO.com and invent well appointed cottage, beach vacation home, beach hacienda, and suburban house.
Bloomington is a radiant, foxy, dazzling, and splendid block with stunning and charming cottage, farmhouse, lodge, and condominiums.
Locate and move apartment rentals in Franklin Indiana and vacation homes for rent by owner in Franklin Indiana.
Glimpse, identify, and relocate short term rentals in Battle Ground United States, Battle Ground United States rental houses, and homes for rent by owner.
Elicit and uncover homes for rent by owner in Deedsville United States and Deedsville homes for rent by owner.
Design, conceive, and identify Harrison Indiana apartment rentals, rental houses in Harrison Indiana, Harrison Indiana bed and breakfast rentals, and Harrison Indiana vacation rental.
Discern and originate rent house in Pine Village United States and real estate rentals.
Observe and perceive Morgan home rentals, Morgan holiday rentals, and short term rentals.
Vacation rentals in Mahomet, vacation homes for rent by owner Mahomet, and houses for rent in Mahomet Illinois
Find, find out, and uncover Allen vacation rental, vacation rental Allen Indiana, Allen Indiana real estate rentals, and rent houses in Allen Indiana.
Evans apartment rentals, vacation homes for rent by owner Evans, house rentals in Evans New York, and Evans holiday rentals
Move and relocate rental homes in Knox Indiana, apartment rentals, and real estate rentals in Knox.
Come upon and light upon homes for rent and Denver holiday rentals.
Design, move, and find out vacation rental in Williams United States, holiday rentals Williams, and Williams United States holiday rentals.
Come upon, notice, and dig up rent houses in Petersburg, Petersburg United States rental properties, and Petersburg United States rent house.
|
|
