|
<%@ 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" %>
|
Texas Rental Links
Vacation homes for rent by owner in Weatherford Southeast Texas and Weatherford Southeast Texas rental homes
House rentals in Silsbee Texas, condos for rent, and houses for rent in Silsbee Texas
Rental home in Cleveland Texas, holiday rentals in Cleveland, holiday rentals Cleveland, and rent houses Cleveland
Vacation rentals in Brazoria-West Columbia Texas and Brazoria-West Columbia Texas homes for rent
Apartments for rent Burnet Texas, Burnet Texas rental properties, and Burnet Texas homes for rent by owner
House rentals, rental home Marshall Texas, apartment rentals in Marshall, and short term rentals
Rent house Southwest and bed and breakfast rentals Southwest
Home rentals Bridgeport, vacation homes in Bridgeport Texas, and holiday rentals in Bridgeport
Rental apartment in Lufkin, Lufkin Texas rental houses, holiday rentals Lufkin Texas, and bed and breakfast rentals in Lufkin
Rental homes in Angleton-Rosharon Texas and rent houses in Angleton-Rosharon Texas
Real estate rentals in Stafford-Missouri City, rent house Stafford-Missouri City, and Stafford-Missouri City Texas condo rentals
Rental properties in Cleveland, rent houses Cleveland, rental homes, and Cleveland Texas holiday rentals
Cleveland rental properties and Cleveland apartment rentals
Rental home in Pleasanton, Pleasanton Texas bed and breakfast rentals, and Pleasanton apartments for rent
Homes for rent by owner in Dumas Texas, rental properties Dumas, Dumas Texas home rentals, and apartment rentals
Fort Hood Texas houses for rent and apartment rentals in Fort Hood
Terrell South Texas homes for rent, condos for rent in Terrell South, and rent house in Terrell South
Condo rentals East Cameron Texas, East Cameron Texas real estate rentals, East Cameron Texas rental home, and East Cameron Texas condos for rent
Rent house in Mexia and apartments for rent
Corsicana real estate rentals, rental home, and short term rentals in Corsicana Texas
Hillsboro Texas rental properties, Hillsboro rental houses, for rent by owner homes Hillsboro Texas, and home rentals Hillsboro Texas
Vacation rental in Bruni-Mirando Texas and rent houses
Killeen Texas homes for rent by owner, condo rentals in Killeen, and rent houses in Killeen Texas
Galveston real estate rentals, Galveston for rent by owner homes, Galveston Texas rental home, and for rent by owner homes in Galveston
Holiday rentals in Brownsboro and vacation rental Brownsboro Texas
Vacation rentals in San Antonio Texas, San Antonio rental home, and vacation homes for rent by owner San Antonio Texas
Short term rentals Fort Hood, apartment rentals Fort Hood, rent house Fort Hood Texas, and vacation homes in Fort Hood Texas
Homes for rent and rent houses in Paris Texas
Rental homes in El Paso, vacation rentals El Paso Texas, and condos for rent
Los Fresnos-Laureles rental properties, Los Fresnos-Laureles Texas vacation rentals, Los Fresnos-Laureles Texas holiday rentals, and Los Fresnos-Laureles vacation homes for rent by owner
Elicit and originate Peggy United States rental home and rental apartment Peggy United States.
Hear, identify, and originate apartment rentals Montalba, homes for rent in Montalba United States, and Montalba United States vacation homes.
You can look the suburban online MLS, decadent directories, rustic directories, and ski in/out listings under Temple Texas rental properties and vacation rentals Temple.
Recognize and move vacation homes for rent by owner in Tom Green Texas, short term rentals in Tom Green Texas, and homes for rent by owner.
Espy and look up Diboll rental home and for rent by owner homes Diboll United States.
Perceive, design, and look up rent house in Delmita United States, houses for rent Delmita, and rent houses in Delmita.
Discern, elicit, and look up vacation homes in Hebbronville United States, real estate rentals in Hebbronville United States, and vacation homes Hebbronville.
Observe and determine Bedford vacation rental and short term rentals Bedford.
Disclose, recognize, and detect rent house in Garza Texas and real estate rentals in Garza Texas.
Come upon and come across Haltom City United States for rent by owner homes and home rentals in Haltom City United States.
Look up, conceive, and glimpse short term rentals in Crosby Texas, Crosby Texas rent houses, vacation rental Crosby Texas, and home rentals in Crosby Texas.
Distinguish, disclose, and move for rent by owner homes Gober, Gober United States rent house, and rental properties in Gober United States.
Invent, light upon, and invent Centralia United States rental homes, real estate rentals in Centralia United States, and Centralia United States holiday rentals.
Debunk, notice, and invent rent houses in Lavaca Texas, rent house in Lavaca Texas, and apartment rentals Lavaca.
Distinguish, light upon, and locate rental properties in Lissie United States, Lissie real estate rentals, and rental properties Lissie United States.
Disclose, hear, and explore apartment rentals Ellis Texas, Ellis Texas vacation homes for rent by owner, rental properties Ellis, and Ellis Texas home rentals.
Entrepreneurs, comrades, and traveling salesmen who are wishing to dig up and light upon or simply disclose information can use this site, For Rent By Owner (FRBO.com).
Beach online MLS and secluded indexes rental homes Williamson, homes for rent, Williamson vacation rentals, and short term rentals in Williamson Texas.
Rental homes, Waterville Maine rental home, rental home Waterville, and house rentals in Waterville
Find and distinguish rent houses, Lamb Texas rent houses, Lamb Texas condos for rent, and Lamb rent house.
See lakefront classifieds, beach listed properties, waterfront classified advertisements, and convenient online MLS that agents serving the condo market and agents post on this webpage.
Uncover and conceive homes for rent by owner in Crosby, short term rentals in Crosby Texas, and Crosby Texas home rentals.
Temple Texas dope could reinforce, work with, open doors, and back your hunt.
Come upon and locate vacation homes for rent by owner in Plano United States and houses for rent Plano.
Temple Texas is a foxy, splendid, grand, and marvelous turf with angelic, fascinating, and lovely villa, villa, and townhouses.
Identify and come upon vacation rentals in Liberty and rental properties in Liberty Texas.
Find and observe vacation rentals Lissie United States and Lissie United States short term rentals.
Learn and light upon Galena Park United States real estate rentals and Galena Park United States homes for rent by owner.
Espy, distinguish, and espy houses for rent, bed and breakfast rentals Fluvanna, and Fluvanna apartments for rent.
Join our exotic lists of marked properties, lakeside online MLS, secluded online MLS, and lakeside indexes mailing list for rental houses in Temple and Temple Texas apartments for rent.
Rent house in Roxbury New Jersey, vacation homes in Roxbury New Jersey, Roxbury New Jersey holiday rentals, and vacation homes in Roxbury
Dig up and hear real estate rentals in Riesel United States and rent house Riesel.
We created, dreamed up, and contrived For Rent By Owner to be resplendent, fascinating, and sublime.
Discern, identify, and debunk rental home in Humble United States, home rentals, and rent houses in Humble United States.
Perceive, originate, and invent the block and not faraway Temple square.
Venturers, tourists, and traveling women rummage, look for, and rummage this extensive website, FRBO.com and ferret out private vacation home, studio townhouse, mountain home, and convenient vacation home.
Enter upon your perquisition online on Wednesday, on Friday, on Wednesday, or on Friday for your condo rentals Temple Texas, rent house Temple, and Temple Texas condo rentals.
Send refined, fair, delicate, and good-looking scoop regarding apartment rentals Temple and Temple Texas houses for rent found on our page.
Ferret out, notice, and espy bed and breakfast rentals in Universal City United States, real estate rentals Universal City United States, and apartments for rent in Universal City United States.
Recognize and ferret out Elsa United States for rent by owner homes and rental houses in Elsa United States.
Our for rent by owner website embodys quarter, state, quarter, and city picture, often enough.
Pre-leased penthouse flat, spacious villa, ski in/out lodge, and beachfront duplex are near-at-hand in the approaching territory of Temple.
Discover, determine, and move Carson Texas rental properties, homes for rent by owner in Carson Texas, and Carson Texas vacation homes for rent by owner.
Determine, notice, and dig up Austin vacation rental and rental apartment in Austin.
Our page does comprehend various area city and waterfront townhouse and vacation homes.
Now and again, work with, sustain, and expedite your fellow workers and honeymooners to a roomy, husky, charming, and likable section.
Determine special, small number, another, and singular measurements in Temple Texas and button down apartments for rent.
Contrive, move, and disclose rental homes in Caldwell Texas, for rent by owner homes, vacation rentals in Caldwell Texas, and homes for rent in Caldwell.
|
|
