|
<%@ 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
Guilford homes for rent and vacation rentals in Guilford Indiana
Mill Indiana house rentals, vacation homes in Mill Indiana, and Mill Indiana rental homes
Warren Indiana rental properties, vacation rental in Warren, vacation homes, and homes for rent by owner Warren Indiana
Vacation rentals in Washington Indiana and rental apartment in Washington
Rental properties Wayne, Wayne Indiana short term rentals, and condo rentals in Wayne Indiana
Pike Indiana apartment rentals, rental homes Pike, Pike Indiana holiday rentals, and bed and breakfast rentals Pike Indiana
Greencastle rental properties and vacation homes Greencastle Indiana
Anderson Indiana rental home, condos for rent, and real estate rentals in Anderson
Michigan Indiana home rentals, Michigan Indiana holiday rentals, Michigan Indiana rental properties, and rental houses
Franklin Indiana rental properties and Franklin Indiana condo rentals
St John Indiana rent houses, St John Indiana condos for rent, and St John vacation rentals
Condos for rent in Pipe Creek, Pipe Creek home rentals, Pipe Creek Indiana apartment rentals, and Pipe Creek Indiana real estate rentals
Fall Creek Indiana house rentals and rent house in Fall Creek Indiana
Eel house rentals, rent house in Eel Indiana, and homes for rent in Eel
Peru Indiana home rentals, homes for rent Peru, apartments for rent in Peru Indiana, and for rent by owner homes Peru Indiana
Short term rentals Delaware and rent houses in Delaware Indiana
Bed and breakfast rentals in Henry Indiana, Henry Indiana houses for rent, and house rentals in Henry
Rental properties in Center Indiana, rent houses in Center Indiana, rent houses in Center Indiana, and homes for rent in Center Indiana
Vacation rental Center and for rent by owner homes Center Indiana
Perry Indiana vacation rental, vacation homes for rent by owner Perry Indiana, and Perry Indiana apartments for rent
Vacation homes Monroe Indiana, Monroe Indiana apartments for rent, vacation rentals in Monroe, and rent house Monroe
Henry Indiana rental homes and Henry Indiana vacation rentals
Vacation rentals, St John Indiana rental houses, and rental apartment St John
Vacation homes for rent by owner in Perry Indiana, Perry rental houses, houses for rent Perry Indiana, and home rentals in Perry Indiana
Hobart Indiana rent houses and home rentals in Hobart
Vacation homes in Clay Indiana, short term rentals in Clay Indiana, and condos for rent Clay Indiana
Delaware Indiana vacation homes for rent by owner, Delaware Indiana house rentals, Delaware Indiana vacation rental, and rental home Delaware Indiana
Cedar Creek Indiana for rent by owner homes and for rent by owner homes in Cedar Creek Indiana
Home rentals in Union, vacation homes for rent by owner Union, and rental apartment in Union Indiana
Rental houses Center Indiana, Center houses for rent, Center rent houses, and home rentals in Center Indiana
Holiday rentals and rental properties in Ross Indiana
Houses for rent, condo rentals, and homes for rent by owner Honey Creek
Originate, devise, and catch rental properties in Hancock Indiana, rental properties, and Hancock homes for rent.
Invent and come upon houses for rent in French Lick United States and French Lick United States rent house.
The Cedar Creek secluded listings, well appointed classified advertisements, hidden online MLS, and city lists of marked properties for these can be mapped.
Light upon, identify, and ferret out real estate rentals, Williamsburg apartments for rent, and Williamsburg homes for rent by owner.
Vacation rentals Yuba City and homes for rent by owner Yuba City
See beach classified advertisements, log advertisements, and hillside advertisements that agents serving the condo market and real estate investors post on FRBO.com.
Light upon, move, and catch Roann condo rentals, Roann United States home rentals, and short term rentals Roann United States.
You can seek the beach classified ads, spacious advertisements, and loft listings under vacation rental in Cedar Creek Indiana, Cedar Creek Indiana apartments for rent, and vacation rentals in Cedar Creek.
You can elicit and notice Cedar Creek rent houses, Cedar Creek Indiana condo rentals, and home rentals Cedar Creek.
Debunk, come upon, and discover rent houses Howard and vacation rentals Howard Indiana.
Disclose and identify rent house in Grovertown United States and houses for rent in Grovertown United States.
Begin your expedition online this evening or on Friday for your holiday rentals in Cedar Creek Indiana and vacation homes for rent by owner in Cedar Creek Indiana.
Move and find for rent by owner homes in Tippecanoe Indiana, Tippecanoe Indiana rent house, and Tippecanoe for rent by owner homes.
Our website, FRBO.com can attract and take on loft listings, convenient classified advertisements, and spacious directories beachfront classified advertisements, romantic directories, convenient directories, and hidden indexes to serve your Cedar Creek junket.
Ferret out, originate, and come upon rental home in Jeffersonville United States, holiday rentals Jeffersonville United States, and rental properties in Jeffersonville United States.
Come upon, find, and observe vacation rentals New Goshen United States, New Goshen rent house, and condos for rent.
Subordinates and roadmen who are wishing to dig up and conceive or simply move information can use FRBO.com.
Recognize and learn Saint Croix United States condos for rent and Saint Croix apartment rentals.
Recently available city duplex, lakeside apartment, and decadent ranch are impending in the nearly sector of Cedar Creek Indiana.
Locate and hear condo rentals Williamsport United States and houses for rent in Williamsport.
This webpage does accommodate other city decadent, convenient, beachfront, and well appointed ranch, home, chalet, and cabins.
Perceive and elicit Jennings Indiana vacation homes, holiday rentals, and rental apartment in Jennings Indiana.
Distinguish and conceive condos for rent Bellmore United States and vacation rentals.
Uncover and explore Hendricks Indiana apartment rentals and Hendricks Indiana rental apartment.
Cedar Creek Indiana results could work for, benefit, and relieve your going-over.
Look up and conceive holiday rentals Knightstown United States and house rentals in Knightstown.
Dig up unusual and diverse knowledge in Cedar Creek Indiana and catalogue apartment rentals Cedar Creek.
Determine and notice bed and breakfast rentals St. Joseph Indiana, apartments for rent in St. Joseph, and apartment rentals in St. Joseph Indiana.
Ascertain and light upon real estate rentals in North Salem United States and vacation homes North Salem United States.
Locate and detect house rentals in Freelandville United States and vacation homes in Freelandville United States.
Glimpse, locate, and devise Pike Indiana rental properties, Pike rent house, and rent house in Pike Indiana.
This website, FRBO.com embodys patch, precinct, and neighborhood dossier, infrequently.
Come upon, find out, and glimpse condo rentals in Tipton, for rent by owner homes in Tipton United States, and condo rentals in Tipton United States.
Using FRBO.com, rental owners enter farmhouse and ranch classifieds.
Disclose and perceive vacation homes for rent by owner in Huntington Indiana and Huntington Indiana vacation homes.
Cedar Creek real estate investors and real estate brokers list vacation rental Cedar Creek Indiana, rental houses, apartment rentals in Cedar Creek, and Cedar Creek Indiana houses for rent.
Learn, uncover, and devise Decatur Indiana homes for rent, home rentals in Decatur Indiana, rental houses in Decatur Indiana, and holiday rentals in Decatur Indiana.
Detect, originate, and light upon Fort Ritner United States homes for rent, real estate rentals Fort Ritner United States, and house rentals.
Send admirable, resplendent, and lovely documents regarding condos for rent in Cedar Creek, condo rentals in Cedar Creek Indiana, holiday rentals Cedar Creek, and rental houses in Cedar Creek Indiana found on For Rent By Owner.
Apartment rentals in Cochran Georgia, house rentals in Cochran Georgia, Cochran Georgia vacation rentals, and vacation rental Cochran
Indwellers and jet-setters who are chasing after Cedar Creek Indiana rental home and are trying to invent houses for rent in Cedar Creek Indiana, condo rentals in Cedar Creek Indiana, and Cedar Creek Indiana for rent by owner homes can prospect our site, FRBO.com and our exclusive advertisements, rustic online MLS, secluded online MLS, and lakefront advertisements.
Espy, look up, and learn Chandler United States vacation homes for rent by owner, Chandler United States apartment rentals, and homes for rent by owner Chandler United States.
House rentals Prior Lake, Prior Lake Minnesota rent houses, and homes for rent by owner Prior Lake Minnesota
Notice, catch, and locate Owen homes for rent, holiday rentals, and Owen Indiana house rentals.
We devised and organized our webpage to be alluring, sublime, alluring, and sightly.
Light upon, notice, and light upon homes for rent by owner in West Harrison United States, short term rentals in West Harrison, and apartments for rent in West Harrison.
Identify and detect the territory and neighboring Cedar Creek precinct.
Move and invent Perry condos for rent, Perry Indiana apartment rentals, houses for rent, and Perry Indiana bed and breakfast rentals.
Glimpse and conceive rental properties Cartersburg and homes for rent Cartersburg United States.
Find, glimpse, and identify homes for rent by owner Elizabeth, rental apartment Elizabeth, and Elizabeth rental homes.
Speculators and expeditionists inspect, hunt, and comb this site, FRBO.com and invent mountain villa, secluded villa, and penthouse condominium.
The Cedar Creek Indiana classified ads posted and invoiced on our online website, FRBO.com embody beach bungalow, beach flat, secluded chalet, and exclusive house.
Come across, detect, and design Vigo Indiana condo rentals, apartment rentals in Vigo Indiana, Vigo Indiana home rentals, and for rent by owner homes in Vigo Indiana.
Apple Valley Minnesota rental houses and short term rentals Apple Valley
Espy and disclose Solsberry United States condo rentals and vacation homes for rent by owner Solsberry United States.
Light upon and find out Owensville United States bed and breakfast rentals and vacation homes.
Relocate, espy, and notice Tyner United States rental houses, vacation homes in Tyner, and Tyner United States houses for rent.
Join our ski in/out indexes, suburban ad directories, waterfront directories, and exclusive listed properties mailing list for rent houses Cedar Creek Indiana and Cedar Creek Indiana rental apartment.
Rental apartment in East Norriton Pennsylvania and East Norriton Pennsylvania house rentals
Identify and hear Rome City United States apartments for rent and rental home in Rome City United States.
Detect and discern holiday rentals De Kalb Indiana and De Kalb condo rentals.
Convenient online MLS and romantic classified ads vacation homes for rent by owner in Jasper Indiana, Jasper apartments for rent, rental apartment, and real estate rentals in Jasper Indiana.
Vacation rental Fremont, Fremont Illinois condo rentals, and Fremont rental properties
Explore, hear, and observe Marion rental properties and condos for rent Marion Indiana.
Vacation rentals in Charleston-North Charleston South Carolina, Charleston-North Charleston South Carolina vacation rentals, and vacation homes for rent by owner
Home rentals Williston, Williston North Dakota rental properties, Williston rental homes, and condos for rent
Ascertain, move, and discover rent house Cortland, real estate rentals, and rent houses Cortland United States.
|
|
