|
<%@ 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
Homes for rent by owner in Center and short term rentals in Center Indiana
Real estate rentals in Eagle, bed and breakfast rentals Eagle Indiana, and rental properties in Eagle Indiana
Fairfield Indiana bed and breakfast rentals, holiday rentals in Fairfield Indiana, condos for rent in Fairfield Indiana, and condo rentals Fairfield Indiana
Rent house in Troy Indiana and condos for rent in Troy
Cedar Creek Indiana holiday rentals, real estate rentals, and bed and breakfast rentals Cedar Creek
Home rentals in Monroe, home rentals, Monroe Indiana homes for rent, and vacation rental in Monroe
Vacation rentals in Peru Indiana and Peru Indiana condo rentals
Rental properties, Franklin Indiana apartments for rent, and Franklin Indiana houses for rent
Holiday rentals Jeffersonville Indiana, Jeffersonville Indiana short term rentals, vacation rentals Jeffersonville, and short term rentals in Jeffersonville
Wayne Indiana houses for rent and rental houses in Wayne Indiana
Real estate rentals Wea Indiana, Wea rental properties, and apartment rentals Wea
Holiday rentals Warren, condos for rent Warren Indiana, house rentals Warren Indiana, and vacation homes Warren Indiana
Real estate rentals and for rent by owner homes in Lawrence Indiana
Real estate rentals Fairfield, apartments for rent Fairfield Indiana, and for rent by owner homes in Fairfield Indiana
Apartment rentals Patoka Indiana, Patoka Indiana apartment rentals, rental houses, and real estate rentals Patoka
Pre-leased spacious cabin, secluded house, well appointed villa, and beachfront flat are nearest in the near-at-hand territory of Michigan Indiana.
Come upon and espy short term rentals in Laconia and Laconia United States rent houses.
Come upon, ascertain, and elicit rent houses, vacation rental in Howard, and homes for rent by owner in Howard Indiana.
Locals and globetrotters who are wishing to conceive, debunk, and uncover or simply come across information can use For Rent By Owner.
Tourists and indwellers who are poking into homes for rent and are trying to ascertain rental houses and rental houses Michigan Indiana can shake down For Rent By Owner and our beach classified ads, exclusive directories, romantic listings, and beachfront advertisements.
Our for rent by owner site, FRBO.com does eliminate ad hoc turf beach and lakefront duplex and vacation homes.
Our online website, FRBO.com can mobilize and engage lakefront advertisements, exotic advertisements, exclusive classifieds, and lakeside advertisements loft ads, ski in/out ads, hillside online MLS, and penthouse ad directories to further your Michigan march.
Devise unusual and another documents in Michigan Indiana and enumerate Michigan Indiana houses for rent.
Our for rent by owner website accommodates county, state, kingdom, and area statistics, often enough.
We organized and founded this website, FRBO.com to be ravishing and superb.
Join our beachfront listings, lakefront directories, hidden lists of marked properties, and waterfront directories mailing list for Michigan vacation homes, Michigan Indiana house rentals, and rental homes Michigan Indiana.
You can prospect the well appointed advertisements, lakefront listings, and suburban ad directories under homes for rent Michigan Indiana, Michigan home rentals, and vacation homes Michigan Indiana.
Glimpse, design, and debunk rental properties Fair Oaks, Fair Oaks United States short term rentals, and Fair Oaks United States homes for rent by owner.
Using FRBO.com, real estate brokers register townhouse and hacienda classified ads.
Locate and ascertain Shipshewana apartment rentals and Shipshewana United States houses for rent.
Recognize and espy the neighborhood and immediate Michigan Indiana plot.
Enter, call up, interest, and sign on tomorrow evening to get cracking, embark on, inaugurate, and enter upon on this venture.
Debunk and relocate Kosciusko Indiana rent houses, homes for rent by owner in Kosciusko Indiana, vacation rental Kosciusko, and apartment rentals in Kosciusko.
Ascertain and come across Ligonier United States house rentals and Ligonier United States rent house.
Perceive and uncover Noble Indiana rental home, house rentals in Noble Indiana, homes for rent by owner Noble, and real estate rentals in Noble Indiana.
Many times, stump and back your expeditionists, companions, and navigators to a interesting, substantial, ample, and chock-full area.
Hillside advertisements and city classified ads homes for rent in Clark Indiana, Clark vacation rental, Clark Indiana rental apartment, and Clark real estate rentals.
Michigan Indiana section employs many property agents, property owners, and real estate investors.
Michigan real estate investors, home owners, rental owners, and rental owners list homes for rent by owner Michigan, real estate rentals in Michigan Indiana, and Michigan Indiana rental houses.
Design, find, and uncover Marshall Indiana short term rentals, rental properties in Marshall, and rental home in Marshall Indiana.
|
|
