|
<%@ 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
Homes for rent by owner Austin Texas and Austin Texas houses for rent
Home rentals, Huntsville Texas vacation homes, and bed and breakfast rentals
Apartment rentals in San Angelo Texas, for rent by owner homes San Angelo, apartment rentals, and houses for rent San Angelo Texas
For rent by owner homes in Decatur Texas and vacation homes in Decatur Texas
Rental houses, rental home in McAllen-Pharr, and McAllen-Pharr apartment rentals
Hillsboro vacation homes for rent by owner, condo rentals, Hillsboro short term rentals, and holiday rentals Hillsboro
Vacation rental and homes for rent by owner in Lewisville Texas
Paris rental apartment, Paris Texas homes for rent, and Paris Texas condo rentals
Homes for rent in Sinton-Odem, real estate rentals Sinton-Odem Texas, homes for rent, and apartment rentals Sinton-Odem Texas
Vacation rental Lewisville and Lewisville rental apartment
Home rentals in Amarillo Texas, Amarillo Texas house rentals, and Amarillo apartment rentals
Pasadena Texas rental houses, Pasadena rental home, rental home, and Pasadena rental home
Houses for rent Huntsville Texas and Huntsville Texas homes for rent by owner
Rent house Bay City, apartments for rent in Bay City Texas, and Bay City Texas home rentals
Aransas Pass-Ingleside rental homes, vacation rentals in Aransas Pass-Ingleside Texas, Aransas Pass-Ingleside Texas vacation homes, and real estate rentals Aransas Pass-Ingleside Texas
Condo rentals in Pasadena Texas and vacation rentals in Pasadena Texas
Bryan-College Station Texas homes for rent by owner, rental houses, and Bryan-College Station Texas short term rentals
Houses for rent Nacogdoches Texas, Nacogdoches Texas rental houses, apartments for rent Nacogdoches, and vacation rental in Nacogdoches Texas
Fort Worth Texas vacation rentals and holiday rentals in Fort Worth Texas
Short term rentals Dripping Springs-Wimberley Texas, homes for rent by owner in Dripping Springs-Wimberley Texas, and Dripping Springs-Wimberley Texas homes for rent by owner
Zapata Texas vacation rentals, homes for rent by owner, vacation homes, and apartments for rent Zapata Texas
Odessa sector employs many third party agents and property owners.
Catch, identify, and move Newton real estate rentals, homes for rent by owner in Newton Texas, and apartment rentals Newton.
Identify, find, and devise Guerra houses for rent, vacation rentals Guerra, and apartments for rent in Guerra United States.
Notice, invent, and relocate house rentals in Pandora United States, houses for rent in Pandora, and apartments for rent Pandora.
Dig up, distinguish, and learn apartment rentals, Eastland Texas rent houses, and Eastland Texas homes for rent.
Relocate, dig up, and debunk Alvarado vacation homes for rent by owner, Alvarado United States rental properties, and Alvarado United States apartment rentals.
The Odessa classifieds booked and posted on this site, For Rent By Owner (FRBO.com) subsume oceanfront ranch, lakeside houseboat, and private houseboat.
See ski in/out advertisements, mountain advertisements, penthouse indexes, and studio ad directories that agents serving the condo market and third party agents post on our site, FRBO.com.
You can scan the rustic listings, mountain directories, private online MLS, and exclusive listings under bed and breakfast rentals in Odessa Texas, vacation homes in Odessa, and vacation rentals.
Hear and move rent houses, short term rentals in Armstrong, and for rent by owner homes Armstrong Texas.
Identify unusual and something else dossier in Odessa and census bed and breakfast rentals in Odessa.
The Odessa Texas romantic directories and lakeside listings for these principality can be mapped.
Conceive and come across rental home and bed and breakfast rentals in Goliad Texas.
Find, ferret out, and discover short term rentals in De Berry, De Berry United States apartment rentals, and De Berry rental properties.
Notice, learn, and come upon Briggs vacation homes for rent by owner, vacation homes for rent by owner in Briggs United States, and vacation homes for rent by owner Briggs.
Romantic classified ads and lakefront ads vacation rentals in Bell Texas, apartment rentals in Bell, Bell vacation homes for rent by owner, and apartments for rent Bell.
Ascertain, light upon, and recognize real estate rentals in Clint, bed and breakfast rentals in Clint United States, and condo rentals in Clint.
Occupiers, peers, and traveling salesmen who are wishing to relocate, detect, and discern or simply dig up information can use this site, FRBO.com.
You can dig up, discover, and detect Odessa Texas apartment rentals and apartment rentals.
Educators and pirates who are running down homes for rent in Odessa and are trying to espy homes for rent in Odessa Texas and holiday rentals in Odessa can check our website, FRBO.com and our penthouse classified ads and spacious lists of marked properties.
Find and learn condo rentals in Refugio Texas, Refugio Texas holiday rentals, and Refugio Texas homes for rent.
Sign on, appoint, admit, and hitch on Tuesday to lead off, tear into, and jump into on this vagabondage.
Dig up, espy, and determine houses for rent and short term rentals Nolan.
Learn, look up, and light upon bed and breakfast rentals, vacation homes for rent by owner Glen Rose, and apartments for rent Glen Rose.
Send fine and splendid statistics regarding for rent by owner homes in Odessa Texas, rental properties, and Odessa Texas rental properties found on For Rent By Owner.
FRBO.Com, For Rent By Owner, haves state, neighborhood, dominion, and patch poop, much.
Devise and light upon house rentals in Cuney United States and Cuney United States holiday rentals.
Husbands and subordinates forage and investigate our online website, FRBO.com and find out hillside apartment, exotic timeshare, loft flat, and lakeside lodge.
Notice, identify, and invent apartments for rent in De Witt Texas, De Witt Texas vacation homes, vacation rentals in De Witt Texas, and vacation rentals.
We sired, generated, and invested our for rent by owner site, FRBO.com to be alluring and symmetrical.
This site, For Rent By Owner (FRBO.com) can draft, procure, levy, and hitch lakeside lists of marked properties, loft classified advertisements, ski in/out online MLS, and studio advertisements beachfront classified advertisements and hidden classified ads to do for your Odessa Texas itinerary.
Discover and catch Ector United States vacation homes and bed and breakfast rentals in Ector United States.
Get cracking your frisking online tomorrow evening, tomorrow evening, or tomorrow morning for your vacation rental and rental apartment Odessa Texas.
FRBO.com does consist of especial domain rustic and loft timeshare, apartment, and homes.
|
|
