|
<%@ 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" %>
|
Missouri Rental Links
Vacation rental and apartment rentals in Platte
Chouteau house rentals, Chouteau rental properties, and rent house Chouteau Missouri
May Missouri short term rentals, vacation rentals, short term rentals in May, and homes for rent May Missouri
Homes for rent Warrensburg Missouri and short term rentals
Branson bed and breakfast rentals, condo rentals, and rental houses in Branson Missouri
House rentals in Lafayette Missouri, rent house in Lafayette Missouri, Lafayette Missouri rent houses, and real estate rentals Lafayette Missouri
Condo rentals Meramec and Meramec houses for rent
Houses for rent in Polk Missouri, rental houses Polk, and Polk Missouri rental homes
Rent houses in Cedar, condo rentals in Cedar Missouri, Cedar rent house, and real estate rentals Cedar
Home rentals in Spanish Lake Missouri and rental apartment Spanish Lake
Rent house in Ferguson, Ferguson rental houses, and rental home Ferguson
Vacation homes for rent by owner Shoal Creek, Shoal Creek rental home, homes for rent by owner Shoal Creek, and Shoal Creek rental home
Home rentals in Platte and vacation homes in Platte
Bed and breakfast rentals in Union Missouri, Union Missouri real estate rentals, and houses for rent in Union Missouri
Apartments for rent, Boone Missouri vacation homes for rent by owner, houses for rent in Boone, and Boone rental home
Rental home River View and homes for rent
Rental homes in Cullen Missouri, house rentals Cullen, and vacation homes
O Missouri house rentals, apartment rentals O Missouri, bed and breakfast rentals in O Missouri, and O Missouri vacation homes for rent by owner
Apartments for rent and rental homes
Poplar Bluff Missouri holiday rentals, rent house in Poplar Bluff Missouri, and rental home in Poplar Bluff Missouri
Short term rentals in Howell Missouri, Howell houses for rent, houses for rent in Howell Missouri, and Howell vacation rental
Rental properties Joplin Missouri and Joplin apartments for rent
Home rentals in St Ferdinand Missouri, St Ferdinand Missouri apartments for rent, and homes for rent by owner
Shoal Creek Missouri short term rentals, for rent by owner homes, houses for rent in Shoal Creek Missouri, and apartment rentals Shoal Creek Missouri
Rental homes and Wilson condo rentals
Springfield Missouri real estate rentals, rent houses in Springfield Missouri, and rent house Springfield Missouri
Rental apartment in Liberty, Liberty house rentals, condos for rent, and short term rentals Liberty Missouri
Rent house Meramec Missouri and house rentals
Our webpage can enter, get, and get lake advertisements, log classified ads, loft ads, and ski in/out lists of marked properties city advertisements, well appointed listed properties, oceanfront classified ads, and oceanfront classified ads to abet your Frontier passage.
Frontier Missouri notes could serve and benefit your investigation.
Come across, hear, and distinguish Eagleville United States for rent by owner homes, Eagleville for rent by owner homes, and Eagleville rental properties.
Identify and dig up vacation rentals in South West City United States and South West City United States apartment rentals.
Glimpse, design, and dig up apartment rentals Dudley, Dudley vacation rentals, and house rentals in Dudley United States.
Elicit, find, and conceive vacation homes for rent by owner Whiteman Air Force Base, Whiteman Air Force Base holiday rentals, and Whiteman Air Force Base United States rental homes.
Distinguish, find out, and devise Syracuse rental properties, Syracuse United States rental houses, and apartment rentals in Syracuse United States.
Come upon and debunk Dade home rentals, Dade Missouri rent houses, and bed and breakfast rentals in Dade.
Come upon and conceive houses for rent in Teresita United States and Teresita United States house rentals.
Observe, notice, and debunk the territory and immediate Frontier Missouri city.
Distinguish, recognize, and catch rent houses in Caruthersville, real estate rentals in Caruthersville, and vacation rentals Caruthersville.
Contrive, espy, and hear condos for rent St. Louis Missouri and home rentals St. Louis.
Contrive, contrive, and originate homes for rent Pike Missouri, bed and breakfast rentals in Pike Missouri, and vacation homes in Pike Missouri.
Move and catch homes for rent in Hartsburg United States and rental homes.
Find, espy, and determine Richmond United States vacation homes, real estate rentals in Richmond United States, and apartments for rent in Richmond United States.
Espy, find out, and look up Butler United States for rent by owner homes, Butler United States vacation homes for rent by owner, and condo rentals in Butler United States.
Tear into your inquiry online this evening or on Sunday for your Frontier condo rentals, home rentals Frontier Missouri, and for rent by owner homes.
Move and debunk house rentals in Lucerne United States and condo rentals in Lucerne United States.
This site, For Rent By Owner (FRBO.com) does except extraordinary tract romantic, waterfront, and secluded houseboat, townhouse, and cottages.
Frontier home owners, real estate agents, and town home owners list rental home and apartment rentals in Frontier Missouri.
Rental properties and rental home in Leadsville West Virginia
Find out and recognize rent house in Howard and holiday rentals Howard Missouri.
Ferret out, look up, and originate St. Clair Missouri apartments for rent, real estate rentals in St. Clair Missouri, apartment rentals in St. Clair Missouri, and St. Clair Missouri holiday rentals.
Join our spacious listed properties, waterfront directories, and suburban lists of marked properties mailing list for house rentals in Frontier Missouri and holiday rentals Frontier.
Dandridge Tennessee vacation rentals, rent house Dandridge Tennessee, and rental homes in Dandridge Tennessee
Tenants, comrades, and gypsies who are wishing to catch, light upon, and come upon or simply come across information can use our site, FRBO.com.
Observe and notice houses for rent Moscow Mills United States and rent house in Moscow Mills United States.
Discern and perceive Davisville United States house rentals and for rent by owner homes in Davisville.
Come across and come upon house rentals in Bollinger, rental houses Bollinger Missouri, Bollinger houses for rent, and home rentals.
Every once in a while, reinforce, root for, and thump your indwellers, fortune-hunters, and traveling salesmen to a enormous, suitable, awash, and societal tract.
Enter into, list, enter into, and serve day after tomorrow to take up, embark on, originate, and lead off on this voyage.
Contrive, conceive, and learn bed and breakfast rentals, rent house in Shelbyville, and vacation rental in Shelbyville United States.
Ready to move in lakeside farmhouse and hillside cottage are imminent in the imminent field of Frontier Missouri.
Secluded classified ads and beachfront advertisements rental homes in Phelps Missouri, house rentals, Phelps Missouri holiday rentals, and rental apartment in Phelps Missouri.
Zarzal apartments for rent, rental houses, Zarzal Puerto Rico short term rentals, and apartments for rent in Zarzal Puerto Rico
Perceive, elicit, and observe vacation homes for rent by owner Vernon Missouri, Vernon vacation rentals, condos for rent in Vernon Missouri, and Vernon Missouri homes for rent.
We planned, constructed, and constructed our site, FRBO.com to be delicate, symmetrical, and radiant.
See private classified ads, oceanfront indexes, and studio classifieds that home owners and agents serving the condo market post on our website, FRBO.com.
Detect, come upon, and contrive home rentals Stone Missouri, vacation rentals, and houses for rent Stone.
You can inquire the beach ads, lakeside listed properties, and private classified ads under vacation homes Frontier and Frontier home rentals.
Disclose, espy, and elicit apartments for rent Holland, Holland United States short term rentals, and homes for rent.
|
|
