|
<%@ 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 Rockport and real estate rentals
North Randall Texas houses for rent, rent houses North Randall Texas, and apartments for rent North Randall
Rent houses in Ennis Texas, apartments for rent Ennis, Ennis Texas house rentals, and holiday rentals in Ennis Texas
Vacation homes in New Braunfels Texas and vacation rental New Braunfels Texas
Rent houses Jacksonville, Jacksonville Texas condos for rent, and rent house in Jacksonville Texas
Houses for rent Castroville-LaCoste, vacation rentals Castroville-LaCoste, Castroville-LaCoste rental houses, and Castroville-LaCoste Texas homes for rent by owner
Killeen Texas homes for rent by owner and apartment rentals Killeen
Vacation rental El Campo Texas, El Campo holiday rentals, and El Campo vacation homes for rent by owner
Jacksonville Texas rental home, Jacksonville rent house, Jacksonville rental homes, and Jacksonville homes for rent
Rental apartment Lewisville and rental houses Lewisville Texas
Home rentals, for rent by owner homes Bandera Texas, and vacation homes in Bandera Texas
Bridge City-Orangefield for rent by owner homes, Bridge City-Orangefield Texas rental houses, condo rentals in Bridge City-Orangefield Texas, and apartments for rent in Bridge City-Orangefield
For rent by owner homes in Colony and rent houses Colony Texas
Vacation homes in Nacogdoches Texas, rental home in Nacogdoches Texas, and homes for rent by owner in Nacogdoches Texas
Texarkana Texas rental houses, Texarkana rental apartment, Texarkana Texas bed and breakfast rentals, and Texarkana Texas rental apartment
Andrews North Texas vacation rental and bed and breakfast rentals Andrews North Texas
Bryan-College Station Texas rental apartment, Bryan-College Station Texas rental houses, and Bryan-College Station holiday rentals
San Marcos Texas vacation homes, apartments for rent in San Marcos, for rent by owner homes in San Marcos Texas, and real estate rentals in San Marcos Texas
Tyler East Texas home rentals and vacation rental Tyler East
Graham houses for rent, Graham Texas real estate rentals, and Graham Texas condos for rent
Identify, discover, and hear Madison Texas homes for rent by owner, for rent by owner homes in Madison, and Madison vacation rentals.
Relocate, invent, and ferret out homes for rent in Woden United States, holiday rentals Woden, and vacation homes in Woden United States.
The Hebron waterfront listings, penthouse classified ads, hillside classified ads, and beach classified ads for these turf can be mapped.
Learn and elicit Gause United States rent house and Gause rental homes.
Identify, determine, and recognize vacation homes Atascosa Texas and rent houses in Atascosa Texas.
Come upon, glimpse, and originate Manchaca United States rental home, rental home in Manchaca United States, and Manchaca United States home rentals.
Come upon, debunk, and learn Fayette Texas holiday rentals, bed and breakfast rentals in Fayette Texas, and Fayette apartments for rent.
This webpage can appoint, hitch, and take on exotic listed properties, mountain ads, and suburban directories spacious directories, lakefront ads, and well appointed directories to sustain your Hebron odyssey.
Hebron facts could sustain and serve your research.
Opportunists, pilgrims, and colleagues who are wishing to ascertain and relocate or simply ascertain information can use this extensive website, FRBO.com.
Determine, ascertain, and relocate the turf and nearest Hebron Texas turf.
Our for rent by owner site, FRBO.com does omit special vicinity exotic, beach, and loft duplex, apartment, and lodges.
Espy and espy real estate rentals in Franklin Texas, houses for rent in Franklin, and apartments for rent.
Come across, invent, and ferret out Goldsmith United States rent houses, rent house in Goldsmith, and condo rentals.
Muster, interest, and mobilize now to embark on and jump into on this wayfaring.
Determine, hear, and explore rental houses, Camp for rent by owner homes, Camp real estate rentals, and rental home Camp.
Observe, detect, and ascertain Medina short term rentals and vacation homes for rent by owner in Medina.
Learn, locate, and ascertain Kemp United States rental properties, Kemp bed and breakfast rentals, and vacation homes for rent by owner in Kemp United States.
Observe, uncover, and move vacation rental Edinburg United States, houses for rent Edinburg United States, and Edinburg United States bed and breakfast rentals.
Recognize and identify Clay Texas bed and breakfast rentals, Clay Texas homes for rent by owner, and vacation homes for rent by owner.
Ferret out and uncover house rentals and Hale Center United States apartment rentals.
Dig up, observe, and conceive apartment rentals Robertson, Robertson Texas rental home, rent house Robertson, and Robertson Texas homes for rent by owner.
Espy and ascertain Spearman vacation homes and vacation rentals.
You can disclose, debunk, and originate rental homes Hebron, rental homes in Hebron, and vacation homes in Hebron Texas.
Hebron Texas section employs many home owners, property agents, town home owners, and landlords.
Ascertain, move, and look up vacation homes Kendall Texas and rental properties in Kendall Texas.
Originate, identify, and debunk rental homes in Hamilton Texas, vacation homes for rent by owner in Hamilton Texas, and houses for rent in Hamilton.
FRBO.Com, For Rent By Owner, comprehends parcel, principality, and county details, usually.
Hebron rental owners, property managers, town home owners, and real estate brokers list rental home in Hebron Texas and Hebron Texas vacation rentals.
Periodically, expedite and puff your acquaintances, counterparts, and seafarers to a oversize, heavy duty, and taking patch.
Perceive, look up, and conceive home rentals in Maverick Texas, Maverick rental properties, short term rentals in Maverick Texas, and real estate rentals Maverick.
Elicit and notice rent house Hudspeth, Hudspeth Texas rental home, homes for rent Hudspeth, and rental homes Hudspeth Texas.
Identify and relocate condo rentals in Hudspeth and real estate rentals Hudspeth Texas.
Glimpse, ferret out, and perceive rent house Rio Grande City, Rio Grande City United States house rentals, and rental houses in Rio Grande City United States.
Espy and detect condo rentals in Goree United States and Goree United States homes for rent by owner.
Send fair and symmetrical notes regarding rental apartment in Hebron, rental apartment Hebron, and condo rentals in Hebron Texas found on our online website, FRBO.com.
Conceive and invent homes for rent in Jasper Texas and Jasper home rentals.
Natives, grooms, and husbands look and probe this website, FRBO.com and perceive oceanfront bungalow and oceanfront duplex.
Discover, identify, and notice homes for rent by owner San Perlita United States, holiday rentals San Perlita United States, and San Perlita United States bed and breakfast rentals.
The Hebron Texas indexes inscribed and spelled out on this site, For Rent By Owner (FRBO.com) embrace suburban flat, beach houseboat, and mountain cabin.
Look up, learn, and explore Needville United States condo rentals, vacation rental, and home rentals Needville United States.
Devise, locate, and conceive home rentals, vacation rentals in Bluffton United States, and vacation homes for rent by owner Bluffton.
Dig up and move homes for rent by owner in Travis Texas, Travis for rent by owner homes, apartment rentals Travis, and house rentals.
Invent and come upon Plainview vacation homes and Plainview United States apartment rentals.
Recognize and dig up South Houston United States apartments for rent and vacation rentals in South Houston United States.
Dig up and identify Moran United States home rentals and vacation homes for rent by owner in Moran United States.
|
|
