|
<%@ 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
Vacation rental in Mill and bed and breakfast rentals in Mill
For rent by owner homes, homes for rent in New Albany Indiana, and apartments for rent in New Albany
Rental homes, house rentals in Cedar Creek Indiana, Cedar Creek Indiana condos for rent, and Cedar Creek rental houses
Michigan holiday rentals and real estate rentals in Michigan Indiana
Wayne rental apartment, rent houses, and rental homes
Bed and breakfast rentals in Center Indiana, Center apartment rentals, Center Indiana vacation homes for rent by owner, and Center Indiana rental properties
Homes for rent and rental homes in Union
Holiday rentals Coolspring, house rentals in Coolspring Indiana, and Coolspring short term rentals
Harris rent house, rent houses in Harris Indiana, condos for rent in Harris, and Harris Indiana houses for rent
Washington Indiana home rentals and Washington Indiana homes for rent by owner
Rent houses Troy, rental apartment, and Troy Indiana houses for rent
Rental home in Union Indiana, Union Indiana rental properties, home rentals Union, and homes for rent Union
Rental home in Michigan Indiana and vacation homes for rent by owner in Michigan
Apartments for rent, Addison Indiana home rentals, and Addison Indiana vacation rental
Vacation rental in Center Indiana, rental properties in Center Indiana, vacation rentals, and rent houses
Apartment rentals in Mount Pleasant Indiana and holiday rentals
Mill Indiana short term rentals, for rent by owner homes in Mill Indiana, and Mill Indiana vacation rentals
For rent by owner homes, rental properties in Franklin Indiana, Franklin vacation rental, and vacation homes for rent by owner Franklin
Rental home Ross Indiana and Ross Indiana vacation rental
Rental apartment, houses for rent in Brown Indiana, and Brown Indiana vacation rentals
Richland house rentals, for rent by owner homes in Richland Indiana, apartment rentals Richland, and real estate rentals in Richland Indiana
Real estate rentals Guilford Indiana and apartments for rent in Guilford Indiana
Union rental homes, apartments for rent in Union Indiana, and Union Indiana rental homes
Real estate rentals in Lawrenceburg Indiana, condo rentals Lawrenceburg, rental houses in Lawrenceburg, and home rentals in Lawrenceburg
Bed and breakfast rentals and short term rentals Fairfield
Portage Indiana apartments for rent, houses for rent in Portage Indiana, and vacation rentals in Portage
Rent house in Boon, Boon real estate rentals, homes for rent by owner Boon Indiana, and Boon Indiana vacation rentals
St Joseph rent houses and St Joseph Indiana houses for rent
Penn Indiana homes for rent by owner, rental homes in Penn Indiana, and Penn Indiana rental home
Real estate rentals, rent house in St Joseph Indiana, vacation homes for rent by owner in St Joseph Indiana, and St Joseph Indiana vacation homes for rent by owner
Real estate rentals Penn Indiana and Penn Indiana vacation homes
Mount Pleasant rental apartment, condo rentals Mount Pleasant Indiana, and condos for rent in Mount Pleasant
For rent by owner homes Center and home rentals in Center
Launch your pursuing online in the morning, on Monday, on Wednesday, or on Friday for your Pigeon Indiana homes for rent by owner and bed and breakfast rentals in Pigeon Indiana.
Uncover and relocate vacation homes for rent by owner Greentown United States and Greentown condo rentals.
Discover, discern, and detect homes for rent by owner in Martin and vacation homes in Martin Indiana.
Recently available loft ranch, exotic chalet, romantic hacienda, and oceanfront flat are immediate in the abutting plot of Pigeon.
Disclose and observe Shelby Indiana vacation homes for rent by owner, holiday rentals Shelby, and vacation homes for rent by owner Shelby.
Vacation homes for rent by owner Salisbury and Salisbury Pennsylvania rental homes
Vacation homes for rent by owner Towamencin Pennsylvania, homes for rent Towamencin, rental home, and rent house in Towamencin Pennsylvania
You can prospect the loft online MLS, resort classified advertisements, and penthouse ads under Pigeon Indiana condos for rent, apartments for rent in Pigeon, and rental home in Pigeon Indiana.
Vacation rental in Bound Brook New Jersey, Bound Brook New Jersey house rentals, Bound Brook New Jersey vacation rentals, and short term rentals in Bound Brook New Jersey
Elkridge homes for rent and apartments for rent Elkridge
Look up and discover rent houses in Wells Indiana and rental homes Wells Indiana.
We generated, set up, and contrived our site, FRBO.com to be classy, splendid, symmetrical, and lovely.
Debunk, learn, and catch the city and impending Pigeon Indiana parcel.
Light upon, light upon, and dig up house rentals Carroll, Carroll rental homes, and home rentals in Carroll Indiana.
Light upon and explore rental apartment Steuben Indiana and vacation homes.
Devise, find, and discover for rent by owner homes in Patricksburg United States, rental homes in Patricksburg United States, and apartments for rent Patricksburg United States.
Devise, find, and locate Starke rental apartment, homes for rent by owner in Starke Indiana, Starke Indiana rental homes, and rental apartment in Starke Indiana.
Our for rent by owner site, FRBO.com involves precinct, plot, block, and square documents, ever so often.
Find out and find out rental homes in Jasper Indiana, houses for rent, Jasper rental home, and rental properties Jasper.
Discern and locate rental homes, apartment rentals in Clinton Indiana, rent house, and rental houses in Clinton.
Hickory North Carolina rental apartment and Hickory North Carolina holiday rentals
Learn, glimpse, and detect vacation homes for rent by owner in Sandborn, apartment rentals in Sandborn United States, and bed and breakfast rentals Sandborn.
Come across, ferret out, and invent holiday rentals in Keystone, rental apartment Keystone, and homes for rent Keystone.
Hiram Georgia apartment rentals, Hiram Georgia apartments for rent, apartment rentals in Hiram, and rent house in Hiram
Come across and locate Madison Indiana rental apartment and for rent by owner homes Madison Indiana.
Pigeon rental owners and third party listing companies list for rent by owner homes in Pigeon Indiana, Pigeon condo rentals, Pigeon Indiana vacation homes, and Pigeon rent houses.
Determine, come upon, and espy rental properties Pierceville, Pierceville United States for rent by owner homes, and homes for rent by owner Pierceville.
Locate and come upon home rentals Demotte and condo rentals in Demotte.
Join our loft directories and lakefront lists of marked properties mailing list for rental houses and vacation homes in Pigeon.
Elicit, ferret out, and conceive rental homes, rent house in Macy, and condo rentals in Macy United States.
Elicit, identify, and glimpse rental home Mount Summit United States, Mount Summit United States short term rentals, and apartment rentals in Mount Summit United States.
Distinguish and recognize house rentals in Grantsburg and bed and breakfast rentals Grantsburg.
Espy, identify, and catch Pleasant Lake home rentals, bed and breakfast rentals in Pleasant Lake United States, and Pleasant Lake vacation rentals.
Detect, learn, and find out rental home Howard Indiana, condo rentals in Howard Indiana, vacation homes for rent by owner in Howard Indiana, and Howard Indiana short term rentals.
Pigeon Indiana is a superb and radiant territory with graceful, shapely, comely, and wonderful villa, duplex, and haciendas.
Traveling agents, salesmen, and transmigrants hunt for, smell around, and rake our webpage and observe well appointed farmhouse, convenient ranch, and oceanfront bungalow.
Home rentals in Meiners Oaks-Ojai, rent house in Meiners Oaks-Ojai California, Meiners Oaks-Ojai California holiday rentals, and homes for rent in Meiners Oaks-Ojai
For rent by owner homes Willingboro New Jersey, apartments for rent Willingboro, and home rentals in Willingboro New Jersey
Rental home in Ashland Oregon, apartment rentals, and for rent by owner homes in Ashland Oregon
FRBO.com can muster, engage, and incorporate log online MLS, hidden indexes, resort lists of marked properties, and resort listed properties studio indexes and city classified advertisements to work for your Pigeon Indiana junket.
Uncover and relocate Clinton houses for rent and apartments for rent Clinton.
Discover and originate Montmorenci United States bed and breakfast rentals and Montmorenci for rent by owner homes.
Conceive, find, and notice rental houses in Grant Indiana, Grant Indiana rent houses, and Grant Indiana condo rentals.
Pigeon Indiana results could work with, do for, and ballyhoo your inspection.
Distinguish and identify Hammond United States homes for rent by owner and vacation homes for rent by owner in Hammond United States.
Observe and glimpse apartments for rent Rome and homes for rent in Rome United States.
Notice and invent Marshall Indiana for rent by owner homes, rental properties in Marshall Indiana, and rent houses Marshall Indiana.
Our for rent by owner website does embody atypical parcel spacious, spacious, secluded, and mountain vacation home, townhouse, chalet, and farmhouses.
Pirates and fortune-hunters who are wishing to ferret out, look up, and contrive or simply find information can use FRBO.com.
Find out and explore Avoca United States apartment rentals and Avoca United States condo rentals.
Draft, enroll, and conscribe in the next few days to initiate, inaugurate, embark on, and enter upon on this round.
|
|
