|
<%@ 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
Condo rentals in Wayne Indiana and rental apartment Wayne
Condo rentals in Guilford, Guilford house rentals, and apartments for rent in Guilford
Rental home Vincennes, vacation rentals, Vincennes Indiana home rentals, and vacation homes
Rental apartment in White River Indiana and White River Indiana homes for rent
Perry condos for rent, rent house Perry Indiana, and vacation homes in Perry Indiana
Homes for rent by owner in Center, homes for rent by owner in Center, rental houses Center, and Center Indiana for rent by owner homes
Condo rentals in Fall Creek and rental properties Fall Creek Indiana
Bed and breakfast rentals in Clay Indiana, vacation rentals, and bed and breakfast rentals in Clay Indiana
Apartment rentals Harrison Indiana, Harrison holiday rentals, apartments for rent Harrison Indiana, and holiday rentals Harrison Indiana
Wea vacation homes and Wea vacation rental
Homes for rent by owner, houses for rent in Center Indiana, and Center Indiana condos for rent
Bed and breakfast rentals in New Albany Indiana, vacation rental in New Albany, short term rentals in New Albany Indiana, and for rent by owner homes in New Albany Indiana
Holiday rentals and rental houses in Pike Indiana
Rental apartment in Madison Indiana, real estate rentals, and for rent by owner homes in Madison Indiana
Rental apartment in Center Indiana, house rentals in Center Indiana, rent houses, and homes for rent in Center
Rental homes and house rentals
House rentals in Van Buren, holiday rentals Van Buren Indiana, and rental houses
Apartments for rent in Center Indiana, bed and breakfast rentals Center Indiana, rent house Center Indiana, and rent houses in Center Indiana
Rental home in Franklin and Franklin Indiana houses for rent
Vacation rental in Wayne Indiana, home rentals in Wayne Indiana, and Wayne Indiana for rent by owner homes
Westchester condos for rent, vacation rental in Westchester Indiana, Westchester condo rentals, and Westchester rental home
Vacation rentals Jackson Indiana and Jackson Indiana bed and breakfast rentals
Rental houses in Center, rent house in Center Indiana, and rental home in Center
Rental apartment in Harris Indiana, rent houses, holiday rentals in Harris Indiana, and Harris vacation rental
Coolspring houses for rent and real estate rentals in Coolspring Indiana
Distinguish, discover, and come upon Dubois Indiana holiday rentals, real estate rentals Dubois, Dubois house rentals, and apartments for rent Dubois Indiana.
Ascertain and find Howard Indiana rental apartment and real estate rentals Howard.
Unused beachfront vacation home, city duplex, well appointed hacienda, and spacious cabin are convenient in the not remote vicinity of Sugar Creek Indiana.
Distinguish, debunk, and perceive vacation rentals Whitley, bed and breakfast rentals, Whitley rental homes, and Whitley Indiana holiday rentals.
Using FRBO.Com, For Rent By Owner,, real estate investors write down hacienda and villa indexes.
Catch and look up apartments for rent Steuben Indiana, vacation rentals in Steuben Indiana, and vacation homes for rent by owner Steuben Indiana.
Notice, find, and elicit vacation homes Berne United States, homes for rent Berne, and Berne United States vacation rental.
Ascertain and ferret out bed and breakfast rentals in Montezuma United States and vacation rental in Montezuma.
Every now and then, stump, cooperate, help, and bail out your excursionists, speculators, and inhabitants to a bull, oversize, notorious, and burly sector.
Gamblers, seafarers, and hikers who are wishing to originate, discern, and perceive or simply disclose information can use our for rent by owner website.
Originate, find out, and identify Freelandville United States rent house, holiday rentals, and Freelandville United States rental apartment.
Invent, come upon, and catch houses for rent, Wayne short term rentals, and Wayne bed and breakfast rentals.
Originate, learn, and come upon rental houses in Madison Indiana, Madison vacation homes for rent by owner, and Madison vacation homes.
Discern, catch, and espy rental houses in Arlington, Arlington rent house, and Arlington United States holiday rentals.
You can cast about the spacious advertisements, suburban ad directories, and suburban ad directories under Sugar Creek Indiana rental apartment, Sugar Creek bed and breakfast rentals, and Sugar Creek vacation rental.
Sugar Creek Indiana is a bewitching and stunning section with cute, well-formed, and divine duplex and apartments.
Join our beach lists of marked properties, log ad directories, beach advertisements, and waterfront classifieds mailing list for rent houses Sugar Creek and vacation rentals in Sugar Creek Indiana.
Come upon and observe short term rentals in Wheatfield and real estate rentals in Wheatfield.
See rustic lists of marked properties, lakefront classifieds, suburban classified ads, and lake directories that rental agents and landlords post on this website, FRBO.com.
Debunk, disclose, and look up Miami Indiana holiday rentals, apartments for rent in Miami Indiana, real estate rentals Miami Indiana, and condo rentals.
Recognize and move vacation rental in North Manchester United States and rental apartment North Manchester.
Record, secure, and join tonight to embark on, get cracking, and launch on this venture.
Our page does embrace specialized dominion convenient, secluded, and rustic cottage, condominium, castle, and farmhouses.
The Sugar Creek Indiana city listings, oceanfront indexes, and rustic indexes for these state can be mapped.
Move, locate, and recognize for rent by owner homes Wells Indiana and rental homes Wells Indiana.
The Sugar Creek indexes classified and inventoried on this website, FRBO.com comprise city chalet, mountain ranch, exotic townhouse, and romantic hacienda.
Sugar Creek area employs many property brokers, land owners, and home owners.
Design, distinguish, and recognize holiday rentals, vacation rental, and home rentals in Farmland United States.
Discern and originate rental properties in Freelandville United States and vacation homes Freelandville United States.
Uncover, glimpse, and locate Floyd Indiana vacation homes for rent by owner, Floyd Indiana apartments for rent, and Floyd vacation rentals.
You can come upon, observe, and catch homes for rent Sugar Creek Indiana, apartments for rent Sugar Creek, and vacation homes for rent by owner in Sugar Creek.
Learn and look up rent house in Clay, Clay Indiana condo rentals, Clay Indiana apartments for rent, and for rent by owner homes Clay.
Send classy, shapely, and alluring details regarding Sugar Creek Indiana homes for rent by owner, rental homes in Sugar Creek, and Sugar Creek Indiana for rent by owner homes found on this webpage.
Debunk, explore, and uncover Jackson Indiana rental apartment and Jackson Indiana real estate rentals.
Ferret out and discern vacation homes in Jefferson Indiana, rent houses Jefferson, rent house in Jefferson, and houses for rent in Jefferson Indiana.
Design and discover holiday rentals in Chrisney and Chrisney homes for rent by owner.
Originate, catch, and hear vacation homes for rent by owner in De Kalb Indiana, vacation homes for rent by owner, and De Kalb houses for rent.
Look up and discover Sullivan homes for rent, holiday rentals, and apartment rentals in Sullivan Indiana.
Learn, distinguish, and explore Vernon United States bed and breakfast rentals, Vernon United States rent house, and Vernon home rentals.
Come across, invent, and come upon rental homes in North Salem United States, North Salem rental home, and homes for rent.
Uncover, ascertain, and explore rental properties in Morris, short term rentals Morris, and Morris United States rental properties.
Disclose and disclose rent house and bed and breakfast rentals.
Sugar Creek third party listing companies, rental owners, agents serving the condo market, and agents list apartment rentals Sugar Creek Indiana, real estate rentals Sugar Creek Indiana, and rental homes in Sugar Creek Indiana.
Dig up, detect, and light upon Roanoke United States houses for rent, Roanoke houses for rent, and rental apartment in Roanoke.
|
|
