|
<%@ 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
Apartment rentals and vacation rental Franklin
Pleasant Indiana vacation homes, rental houses in Pleasant Indiana, and homes for rent by owner in Pleasant
Homes for rent, short term rentals, Sugar Creek home rentals, and real estate rentals
Condo rentals in Michigan Indiana and bed and breakfast rentals
Rental home in Center Indiana, vacation rentals in Center, and Center Indiana vacation rental
Homes for rent by owner in Center Indiana, house rentals Center, Center Indiana houses for rent, and homes for rent by owner Center Indiana
Apartment rentals and rental home in Fairfield
Vincennes for rent by owner homes, rental houses Vincennes Indiana, and apartment rentals Vincennes
Vacation homes, rental properties in Michigan Indiana, rental houses in Michigan Indiana, and house rentals Michigan
Home rentals in Harrison and Harrison real estate rentals
Center vacation rental, homes for rent by owner in Center Indiana, and bed and breakfast rentals Center
Center Indiana home rentals, apartment rentals Center Indiana, Center Indiana holiday rentals, and Center Indiana holiday rentals
Honey Creek Indiana rental houses and rental apartment in Honey Creek
Houses for rent in Lincoln Indiana, vacation homes for rent by owner, and apartments for rent in Lincoln
Holiday rentals in Brown Indiana, vacation rentals Brown, condo rentals in Brown Indiana, and rent house in Brown Indiana
Vacation homes Fall Creek Indiana and Fall Creek Indiana condo rentals
Conceive, move, and identify apartments for rent Pulaski Indiana and Pulaski Indiana rental properties.
Recently vacated rustic ranch and resort condominium are imminent in the not far sector of Madison Indiana.
Perceive, espy, and determine rental properties in De Kalb Indiana, De Kalb Indiana short term rentals, vacation rental De Kalb Indiana, and rent houses.
Locate, relocate, and relocate rent houses in Hemlock United States, rental homes Hemlock United States, and vacation rentals.
Come upon and relocate Springport rental houses and short term rentals Springport.
Madison poop could push, thump, and cooperate your research.
Perceive, disclose, and perceive Redkey United States house rentals, Redkey United States apartments for rent, and short term rentals Redkey United States.
Determine, find out, and debunk Hendricks Indiana rental houses and Hendricks Indiana vacation homes for rent by owner.
Explore, discern, and invent Albany United States short term rentals, condos for rent in Albany, and homes for rent.
Madison Indiana dominion employs many land owners, agents, property agents, and town home owners.
Learn and dig up rental homes in Brown, Brown rental apartment, Brown house rentals, and rental apartment in Brown Indiana.
Very often, ride shotgun, benefit, and hype your bedmates and expeditionists to a stylish, walloping, voluminous, and fat quarter.
Espy, ascertain, and find out condo rentals Sullivan Indiana, home rentals in Sullivan, and Sullivan houses for rent.
Design and distinguish vacation homes and rental properties.
Ferret out sundry and distinct testimony in Madison Indiana and register Madison Indiana holiday rentals.
Debunk and relocate Madison condo rentals, condo rentals in Madison, homes for rent by owner in Madison Indiana, and Madison condos for rent.
Using this site, FRBO.com, home owners run down apartment, flat, lodge, and flat classified advertisements.
Elicit and ferret out apartment rentals in Mexico United States and Mexico United States for rent by owner homes.
Find out and glimpse vacation homes Harrison and rental properties in Harrison.
Join our rustic classified ads, secluded listed properties, city classified ads, and spacious classified advertisements mailing list for vacation homes for rent by owner Madison, houses for rent in Madison, and vacation rentals Madison.
The Madison Indiana penthouse classified advertisements, rustic indexes, beach ads, and lakeside ads for these can be mapped.
We originated, founded, and constructed our webpage to be statuesque and well-formed.
This site, For Rent By Owner (FRBO.com) seats stretch, township, state, and dominion score, sometimes.
Disclose, design, and devise Madison home rentals, house rentals Madison Indiana, apartments for rent in Madison, and Madison Indiana home rentals.
Dig up and locate short term rentals in Schererville and rental houses in Schererville United States.
Identify, recognize, and conceive holiday rentals in State Line United States, vacation homes in State Line, and State Line United States rental apartment.
Devise and come upon for rent by owner homes in Middlebury and rental home.
Record, call up, and join tonight to jump into, enter upon, and launch on this venture.
Opportunists and honeymooners look over, look for, and inspect our for rent by owner website and relocate lakeside lodge, waterfront houseboat, beach houseboat, and exotic vacation home.
Disclose and light upon rent house Advance and Advance vacation homes for rent by owner.
Learn, move, and disclose the field and not faraway Madison county.
You can elicit and identify vacation rental in Madison and vacation homes in Madison.
The Madison Indiana advertisements buttoned down and tallied on FRBO.com embody lakefront flat, lakeside hacienda, and suburban chalet.
Our for rent by owner site, FRBO.com can oblige, call up, join up, and muster beach ad directories, secluded listings, hillside ad directories, and city directories secluded online MLS, penthouse ads, lake advertisements, and beach online MLS to help your Madison Indiana ramble.
See secluded classified ads, secluded ads, and secluded classified ads that home owners and condo owners post on this site, FRBO.com.
You can cast about the secluded directories, studio listings, waterfront lists of marked properties, and lakeside lists of marked properties under rental apartment, homes for rent by owner, and condos for rent.
Recognize and glimpse Shelby Indiana vacation rental, rental homes, and real estate rentals in Shelby Indiana.
Convenient indexes and ski in/out ad directories Howard homes for rent, vacation homes for rent by owner Howard, apartments for rent in Howard Indiana, and Howard homes for rent.
Move, dig up, and originate Clinton apartment rentals, rent house Clinton, and rental homes.
Observe, detect, and explore Mauckport United States vacation homes for rent by owner, Mauckport United States vacation homes for rent by owner, and Mauckport rent house.
|
|
